https://www.beer-coasters.eu/coasters/veb-bierhof-brau-zittau-2-oboje.jpgcoasters/veb-bierhof-brau-zittau-2-oboje.jpg coasters/veb-bierhof-brau-zittau-2-oboje.jpgSELECT t.predek_large,t.zadek_large,t.beer, t.serie, t.p_serie, s.en_nazev FROM p_tacky t, staty s WHERE s.id = t.state AND brewery='VEB Bierhof-Brau Zittau' ORDER BY brewery, state, city, beer, shape, serie, p_serie LIMIT 0, 0 https://www.beer-coasters.eu/coasters/veb-bierhof-brau-zittau-1.jpg | https://www.beer-coasters.eu/coasters/veb-bierhof-brau-zittau-1-zadek.jpg |