https://www.beer-coasters.eu/coasters/schornstein-6.jpgcoasters/schornstein-6-zadek.jpg coasters/schornstein-6.jpg https://www.beer-coasters.eu/coasters/schornstein-6-zadek.jpg https://www.beer-coasters.eu/coasters/schornstein-8.jpgcoasters/schornstein-8-zadek.jpg coasters/schornstein-8.jpg https://www.beer-coasters.eu/coasters/schornstein-8-zadek.jpg https://www.beer-coasters.eu/coasters/schornstein-9.jpgcoasters/schornstein-9-zadek.jpg coasters/schornstein-9.jpg https://www.beer-coasters.eu/coasters/schornstein-9-zadek.jpgSELECT t.predek_large,t.zadek_large,t.beer, t.serie, t.p_serie, s.de_nazev FROM p_tacky t, staty s WHERE s.id = t.state AND brewery='Schornstein' ORDER BY brewery, state, city, beer, shape, serie, p_serie LIMIT 0, 5 https://www.beer-coasters.eu/coasters/schornstein-1.jpgcoasters/ coasters/schornstein-1.jpg https://www.beer-coasters.eu/coasters/schornstein-2.jpgcoasters/ coasters/schornstein-2.jpg https://www.beer-coasters.eu/coasters/schornstein-3.jpgcoasters/ coasters/schornstein-3.jpg https://www.beer-coasters.eu/coasters/schornstein-4.jpgcoasters/ coasters/schornstein-4.jpg https://www.beer-coasters.eu/coasters/schornstein-5.jpgcoasters/ coasters/schornstein-5.jpg![Bierdeckelschornstein-7](https://www.beer-coasters.eu/coasters/schornstein-7-small.jpg) https://www.beer-coasters.eu/coasters/schornstein-7.jpg | ![Bierdeckelschornstein-7-zadek](https://www.beer-coasters.eu/coasters/schornstein-7-zadek-small.jpg) https://www.beer-coasters.eu/coasters/schornstein-7-zadek.jpg |