From the latin ARS – the ART and TIN – (pewter) stems the name of the Company. Craftsmanship made of pewter. This is the claim of the company: Traditional craftsmanship combined with the classic material tin. In 1974, the company was founded in Kirchham, Austria. For 40 years they have been engaged in objects of art, design, casting, procedure - everything around the subject pewter and its processing. ARTINA is the world´s only producer, who has mastered all kinds of manufacturing and processing methods for pewter, while developing engravings that are unmatched in terms of depth and quality. Today ARTINA is the leading manufacturer of pewter and in possession of a priceless collection of moulds from decades of development and revitalization of originals. Experience and love for the material and craft create special and unique items with character.
sql: select Artikel.ID as ID, Produktgruppe.ID as GID, Artikel.Artikelnr as Artikelnr, Artikel.Name_e as Name, Artikel.Preis as Preis, Artikel.Beschreibung_kurz_e as Beschreibung_kurz, Artikel.Bildpfadgr as Bildpfadgr, Produktgruppe.Produktgruppe_e as Produktgruppe, Produktgruppe.Beschreibung_e as Produktgruppe_Beschreibung, Bestand, Beschaffungszeit_e, UVP, Artikel.Video as Video, Lieferzeit from Artikel INNER JOIN Produktgruppe ON Artikel.Produktgruppe = Produktgruppe.ID INNER JOIN Produktgruppe ProduktgruppeShop on Produktgruppe.id = ProduktgruppeShop.Sortierung_Startseite left outer join Produktgruppe Produktgruppe2Shop on Artikel.Produktgruppe2 = Produktgruppe2Shop.Sortierung_Startseite where ProduktgruppeShop.Aktiv=1 and Artikel.Aktiv=1 and Artikel.SID=10 and Produktgruppeshop.Aktiv = 1 and Produktgruppeshop.SID = 26 and Hersteller = 42 order by Artikel.Sortierung, Artikel.ID