MySQL: Unable to execute
SQL: SELECT DISTINCT YEAR(FROM_UNIXTIME(idate)) AS year FROM news WHERE TRIM(name_ru)<>'' AND is_active='1' ORDER BY idate DESC
Error (3065): Expression #1 of ORDER BY clause is not in SELECT list, references column 'mirbis_01.news.idate' which is not in SELECT list; this is incompatible with DISTINCT