SELECT YEAR(FROM_UNIXTIME(publish_date)) AS year FROM fw_catalog WHERE status='1' GROUP BY year ORDER BY publish_date DESC
Query failed!
MySQL answer: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'cluster.fw_catalog.publish_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Back