The Engstler company is located in Villingen-Schwenningen in the Black Forest. The company is family owned and manufactures clocks over many generations. Through the combination of tradition and innovative technology Engstler manufactures not only mechanical cuckoo clocks, they als manufacture the newest quartz cuckoo clocks. Engstler focuses on quality, meticulous craftsmanship and attention to detail.
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 = 35 order by Artikel.Sortierung, Artikel.ID
The Engstler company is located in Villingen-Schwenningen in the Black Forest. The company is family owned and manufactures clocks over many generations. Through the combination of tradition and innovative technology Engstler manufactures not only mechanical cuckoo clocks, they als manufacture the newest quartz cuckoo clocks. Engstler focuses on quality, meticulous craftsmanship and attention to detail.
