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 event.event_date>DATE_SUB(CURDATE(), INTERVAL 1 DAY) ORDER BY event.event_da' at line 1