Nem hajtható végre a lekérdezés

[SELECT DISTINCT(DATE_FORMAT(NEWS_DATE, '%Y-%m')) AS ARCHIVE FROM PC7_NEWS WHERE ISVALID = 'Y' ORDER BY NEWS_DATE DESC] - Expression #1 of ORDER BY clause is not in SELECT list, references column 'arakossze9_pc9.PC7_NEWS.NEWS_DATE' which is not in SELECT list; this is incompatible with DISTINCT -
- error in file news.php on line # 63 : executeQuery