Hibás lekérdezés:
SELECT su.id, su.suggest_id, su.user_id, su.text, s.name, s.url, c.name AS city, COUNT(c.id) AS cityNumber, cs.name AS category, cs.url AS categoryUrl FROM suggest_user AS su JOIN suggest AS s ON s.id = su.suggest_id AND s.status =1 LEFT JOIN suggest_city_other AS o ON o.sid = s.id LEFT JOIN city AS c ON c.id = o.cid JOIN category_sub AS cs ON cs.id = s.category_id WHERE su.status = 1 GROUP BY s.id ORDER BY su.id DESC LIMIT 3
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ajanlato_ajanlatokhu.su.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by