Wa Ying College

SQL Error:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND MONTH(news_dt) >= 9 ORDER BY 1 DESC' at line 1

SELECT DISTINCT(YEAR(news_dt)) AS distYr
FROM news
WHERE news_lang = 'en' AND news_nc_id = AND MONTH(news_dt) >= 9
ORDER BY 1 DESC

SQL Error:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND news_dt BETWEEN '2024-09-01' AND '2025-08-31' AND news_show = 'Y' ORDER BY' at line 1

SELECT *
FROM news
WHERE news_lang = 'en' AND news_nc_id = AND news_dt BETWEEN '2024-09-01' AND '2025-08-31' AND news_show = 'Y'
ORDER BY news_dt DESC , news_sort_id
LIMIT 0 , 9