Новости

Mysql error: Unknown column 'YEAR(Date)' in 'where clause'

Error code: 1054

Query: SELECT DATE_FORMAT(Date, '%c') as month, COUNT(*) as num FROM news WHERE news.Hide = ? AND (news.Date IS NULL OR news.Date < NOW()) AND FIND_IN_SET('1', news.CatID) AND `YEAR(Date)` = ? GROUP BY month ORDER BY month ASC