https://www.beer-coasters.eu/coasters/lievre-4.jpgcoasters/ coasters/lievre-4.jpg https://www.beer-coasters.eu/coasters/lievre-5.jpgcoasters/ coasters/lievre-5.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='Lievre' ORDER BY brewery, state, city, beer, shape, serie, p_serie LIMIT 0, 1 https://www.beer-coasters.eu/coasters/lievre-3.jpgcoasters/ coasters/lievre-3.jpg![Bierdeckellievre-1](https://www.beer-coasters.eu/coasters/lievre-1.jpg) https://www.beer-coasters.eu/coasters/lievre-1.jpg | |