https://www.beer-coasters.eu/coasters/kremer-2.jpgcoasters/kremer-2-zadek.jpg coasters/kremer-2.jpg https://www.beer-coasters.eu/coasters/kremer-2-zadek.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='Kremer' ORDER BY brewery, state, city, beer, shape, serie, p_serie LIMIT 0, 0 ![Beer coaster kremer-1](https://www.beer-coasters.eu/coasters/kremer-1-small.jpg) https://www.beer-coasters.eu/coasters/kremer-1.jpg | ![Beer coaster kremer-1-zadek](https://www.beer-coasters.eu/coasters/kremer-1-zadek-small.jpg) https://www.beer-coasters.eu/coasters/kremer-1-zadek.jpg |