SELECT
beers.id,
beers.alias AS "beer_alias",
beers.name,
beers.abv,
beers.og,
beers.ibu,
beers_styles.name AS "style",
breweries.alias AS "brewery_alias",
breweries.name AS "brewery",
breweries.country,
beers.description,
bars_beer_menu.id AS "bbm_id",
bars_beer_menu.vol,
bars_beer_menu.price
FROM bars_beer_menu 
INNER JOIN beers ON beers.id = bars_beer_menu.beer_id
INNER JOIN beers_styles ON beers_styles.id = beers.style_id
INNER JOIN breweries ON breweries.id = beers.brew_id
WHERE bars_beer_menu.is_bottle = 0 AND bar_id =  AND bars_beer_menu.active = 1
ORDER BY bars_beer_menu.price ASC, bars_beer_menu.id DESC
LIMIT 0, 24