SQL Error:
Expression #1 of ORDER BY clause is not in SELECT list, references column 'pocauhk1_pocawhk.news.news_sort_id' which is not in SELECT list; this is incompatible with DISTINCT
SELECT DISTINCT YEAR
(news_dt
) AS year, MONTH
(news_dt
) as month
FROM news
WHERE news_lang
= 'tc'
AND news_nc_id
= 21
AND news_show
= 'Y'
ORDER BY news_sort_id, news_dt DESC
