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 (`mc_calendar`.`type` =1) AND (`mc_calendar`.`data` BETWEEN '-01-01' AND ' at line 6