The company Anton Schrenk & Sohn GmbH was founded in 1920 by Anton Schrenk. The clocks are offered under the brand Zeitpunkt. The company manufactures wall clocks, table clocks, style clocks, home clocks, kitchen clocks, regulators, wall clocks with quartz movement, promotional clocks, radio clocks and clock cabinets in wood and plastic. 18 employees produce on modern computer-controlled machines in Villingen-Schwenningen in Germany.
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 = 10 order by Artikel.Sortierung, Artikel.ID
The company Anton Schrenk & Sohn GmbH was founded in 1920 by Anton Schrenk. The clocks are offered under the brand Zeitpunkt. The company manufactures wall clocks, table clocks, style clocks, home clocks, kitchen clocks, regulators, wall clocks with quartz movement, promotional clocks, radio clocks and clock cabinets in wood and plastic. 18 employees produce on modern computer-controlled machines in Villingen-Schwenningen in Germany.
