MySQL Error!
------------------------

The Error returned was:
Expression #14 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hentaichan.b.dcount' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Error Number:
1055

SELECT a.id, a.xfields, a.category, a.alt_name, a.title, a.short_story, a.series_id, a.tags, a.autor, a.vote_num, a.news_read, a.date, a.full_story, b.dcount,(select count(id) FROM `hentai_files` WHERE news_id = a.id) as ep_cnt FROM `hentai_post` a INNER JOIN `hentai_files` b ON a.id = b.news_id WHERE (category = 9) AND approve GROUP BY a.id ORDER BY b.dcount desc LIMIT 940, 20