The family owndes company Zoeller & Born GmbH was founded in 1956 by Alois Zoeller and Werner Born. It employs 50 people. The company ships its Beer Steins and Beer Mugs worldwide. Made in Germany is here an obligation. Zoeller & Born provides as German manufacturer of classic souvenirs a high quality fro its Beer Steins. The entire development and production of each Beer Stein model - from design - artistic design to hand-painted design - takes place in the house Zoeller & Born.
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 = 32 order by Artikel.Sortierung, Artikel.ID
The family owndes company Zoeller & Born GmbH was founded in 1956 by Alois Zoeller and Werner Born. It employs 50 people. The company ships its Beer Steins and Beer Mugs worldwide. Made in Germany is here an obligation. Zoeller & Born provides as German manufacturer of classic souvenirs a high quality fro its Beer Steins. The entire development and production of each Beer Stein model - from design - artistic design to hand-painted design - takes place in the house Zoeller & Born.
