The Company Trenkle clocks is manufacturing for more than 40 years now Black Forest Cuckoo Clocks, Black Forest Clocks and weather houses in Simonswald in the Black Forest. Everything from the clock case to the mechanism and the assembly is done in their factory. In the modern carpentry shop the Screen printed wooden boards are sawed and processed further so that all parts of the case are carefully assembled. The mechanism among other parts is stamped by Hand in brass Sheets, wheels and retaining springs are assembled in precise detailed work and then fitted into various cases. Every clock is meticulously tested and inspected before the clock is sent to the customer.
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 = 5 order by Artikel.Sortierung, Artikel.ID