The Company Seiffener Volkskunst eG was founded in 1958 by artisans of Seiffen. In 1959 they started with the production of original Erzgebirge crafts. They carved, turned, spanning trees were stung, items painted and mounted to Erzgebirge wood art figures. The range has been extended again and again in the following years. They manufactured not only nutcrackers, also different types of smokers, light figures Angel and Miner, pyramids and small arches and the later known Striezel children. Since 1992, the Seiffener Volkskunst eG is presented at numerous trade fairs. Apart from the traditional and original items, numerous new collections were created. The Seiffener Volkskunst eG is also member of the Association of Erzgebirge craftsman and toy manufacturers eV.
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 = 7 order by Artikel.Sortierung, Artikel.ID