SELECT a.title, a.id, a.owner, a.added, u.user_name, u.user_id, AVG(n.note) AS srednia, n.type FROM ".$prefix."_articles AS a LEFT JOIN ".$prefix."_users AS u ON a.owner=u.user_id LEFT JOIN ".$prefix."_notes AS n ON n.text_id=a.id WHERE ".$_whereAccept." AND n.type='A' ORDER BY srednia DESC LIMIT 5
I zwraca mi taki błąd
Cytat
Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Zapytanie wkładam do pętli while z góry dziękuje za odpowiedz