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