Expression #1 of ORDER BY clause is not in SELECT list, references column 'eknk.web_news.d_date' which is not in SELECT list; this is incompatible with DISTINCT

The query was:SELECT distinct year(d_date) as year, month(d_date) as month FROM web_news WHERE d_type = '0' and d_status = '0' and lang = 'est' ORDER BY d_date desc

Üritused - Eesti Kristlik Nelipühi Kirik