query result error No: 1055 Msg: Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cwdb2020.img.filename' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SQL: SELECT ba.newsid, ba.title, ba.shortdesc, ba.newsdate, ba.author_name, ba.newsdateend, ba.author_name, img.filename, img.description, plinks.permalink, plinks.friendlytitle, sc.categoryname
FROM news ba
JOIN newscategory sc ON ba.categoryid = sc.categoryid
LEFT JOIN cmsimages img ON img.typeid = ba.newsid
AND img.type = 'news'
AND img.imageorder = 1
LEFT JOIN permalinks plinks ON plinks.typeid = ba.newsid
AND plinks.type = 'news'
WHERE (ba.newsdateend < NOW() OR ba.newsdateend IS NOT NULL)
GROUP BY ba.newsid
ORDER BY
ba.newsdate DESC,
ba.newsid DESC
LIMIT 0,6
query result error No: 1055 Msg: Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cwdb2020.img.filename' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SQL: SELECT ba.newsid, ba.title, ba.shortdesc, ba.author_name, ba.newsdate, ba.newsdateend, ba.author_name, img.filename, img.description, plinks.permalink, plinks.friendlytitle, sc.categoryname
FROM news ba
JOIN newscategory sc ON ba.categoryid = sc.categoryid
LEFT JOIN cmsimages img ON img.typeid = ba.newsid
AND img.type = 'news'
AND img.imageorder = 1
LEFT JOIN permalinks plinks ON plinks.typeid = ba.newsid
AND plinks.type = 'news'
WHERE (ba.newsdateend < NOW() OR ba.newsdateend IS NOT NULL)
AND ba.newsdateend < NOW()
GROUP BY ba.newsid
ORDER BY
ba.newsdate DESC,
ba.newsid DESC