MySQL ERROR:

Error Number: 3065

Description: Expression #1 of ORDER BY clause is not in SELECT list, references column 'incrediw_vanhash.exp_weblog_titles.entry_date' which is not in SELECT list; this is incompatible with DISTINCT

Query: SELECT DISTINCT year(FROM_UNIXTIME(entry_date - 28800)) AS year, MONTH(FROM_UNIXTIME(entry_date - 28800)) AS month FROM exp_weblog_titles WHERE entry_id != '' AND site_id IN ('1') AND exp_weblog_titles.entry_date < 1596514486 AND (exp_weblog_titles.expiration_date = 0 OR exp_weblog_titles.expiration_date > 1596514486) AND weblog_id = '1' AND status = 'open' ORDER BY entry_date desc