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, 7 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 https://www.beer-coasters.eu/coasters/schornstein-7.jpgcoasters/schornstein-7-zadek.jpg coasters/schornstein-7.jpg https://www.beer-coasters.eu/coasters/schornstein-7-zadek.jpg 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![Bierdeckelschornstein-8](https://www.beer-coasters.eu/coasters/schornstein-8-small.jpg) https://www.beer-coasters.eu/coasters/schornstein-8.jpg | ![Bierdeckelschornstein-8-zadek](https://www.beer-coasters.eu/coasters/schornstein-8-zadek-small.jpg) https://www.beer-coasters.eu/coasters/schornstein-8-zadek.jpg |