Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'nim_2015.blog.created' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in this syntax SELECT COUNT(*), DATE_FORMAT(created, '%Y') FROM blog WHERE status = '0' GROUP BY YEAR(created) ORDER BY created DESC