DB function failed with error number 1064
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 c.published=1 GROUP BY c.id' at line 6 SQL=SELECT c.*, count(e.cat_id) AS events FROM mos_ecal_categories AS c LEFT JOIN mos_ecal_events AS e ON c.id=e.cat_id AND e.published=1 AND e.publish_down >='2012-02-04' AND (e.eventdate >='2012-02-04' OR e.eventdate='0000-00-00') WHERE c.parent= AND c.published=1 GROUP BY c.id