The company AMS was founded in 1841 by Andreas Mayer in Schönenbach in the Black Forest. 1954 AMS released the first music clock with four dancing figures. The company now employs 20 people and has a plant area of 2500 square meters for manufacturing, as well as a high-bay warehouse with 1400 square meters.
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 = 34 order by Artikel.Sortierung, Artikel.ID
The company AMS was founded in 1841 by Andreas Mayer in Schönenbach in the Black Forest. 1954 AMS released the first music clock with four dancing figures. The company now employs 20 people and has a plant area of 2500 square meters for manufacturing, as well as a high-bay warehouse with 1400 square meters.
