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 6,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