После обновления MySQL на хостинге с 5.0 до 5.1 движок местами не показывает контент из базы. Необходимо исправить.


Пишет You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND a.start_date <= NOW() ORDER BY a.start_date DESC LIMIT 3) ' at line 1


Запрос такой


$res = $this->dbh->query("


(SELECT 1 AS news_type, a.news_id, a.zagolovok, a.anons, a.add_date, DATE_FORMAT(a.add_date, '%e %M, в %h:%i') AS add_date2, 0 AS company_id FROM cms_news a WHERE a.news_id != $news_id AND a.category_id = $news_category_id AND a.start_date <= NOW() ORDER BY a.start_date DESC LIMIT 3)


UNION


(SELECT 2 AS news_type, a.company_news_id, a.zagolovok, a.anons, a.add_date, DATE_FORMAT(a.add_date, '%e %M, в %h:%i') AS add_date2, a.company_id FROM cms_company_news a WHERE a.category_id = $news_category_id ORDER BY add_date DESC LIMIT 3)


ORDER BY add_date DESC LIMIT 6");