Error 1055: Error in query "SELECT  news_date, year(news_date) as news_year  FROM news group by year(news_date) order by news_date desc" Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'belovabg_tata.news.news_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by