Hej,
Mam taki problem z posortowaniem danych w zapytaniu zawierającym grupowania i łączenie tabel:
Zapytanie jest takie:
SELECT shop.ID as id, shop.NAME as name, shop.SLUG as slug, shop.IMAGE as image, shop.DESCRIPTION as description, COUNT(shop_opinion.ID) AS nb_comments, AVG(shop_opinion.VOTE) AS vote
FROM shop
LEFT JOIN shop_opinion ON shop.ID = shop_opinion.SHOP_ID
WHERE shop.IS_ACTIVATED = 1
GROUP BY shop.ID
ORDER BY shop_opinion.VOTE DESC
Niestety nie sortuje kolumny Vote z tabeli shop_opinion. Co jest źle?