A Database Error Occurred

Error Number: 3065

Expression #1 of ORDER BY clause is not in SELECT list, references column 'itadviso_db.t1.created_on' which is not in SELECT list; this is incompatible with DISTINCT

SELECT DISTINCT UNIX_TIMESTAMP(DATE_FORMAT(FROM_UNIXTIME(t1.created_on), "%Y-%m-02")) AS `date`, (SELECT count(id) FROM news t2 WHERE MONTH(FROM_UNIXTIME(t1.created_on)) = MONTH(FROM_UNIXTIME(t2.created_on)) AND YEAR(FROM_UNIXTIME(t1.created_on)) = YEAR(FROM_UNIXTIME(t2.created_on)) AND status = "live" AND created_on <= 1711667686 ) as article_count FROM (news t1) WHERE `status` = 'live' AND `created_on` <= 1711667686 HAVING article_count >0 ORDER BY t1.created_on DESC