An Error Was Encountered

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 (MONTH(p.end_date)>=) AND (YEAR(p.start_date)<=) AND (YEAR(p.end_date) >= ' at line 8

SELECT p.product_id, p.type, p.start_date, p.end_date, EXTRACT(DAY FROM p.start_date) AS day_start, EXTRACT(DAY FROM p.end_date) AS day_end, (DATE_FORMAT(p.start_date, "%d-%m-%Y")) AS date_start, (DATE_FORMAT(p.end_date, "%d-%m-%Y")) AS date_end FROM (product AS p) JOIN product_detail AS pd ON p.product_id=pd.product_id WHERE pd.lang = 'fr' AND p.active = 1 AND p.type IN ('seminaire','atelier') AND (SELECT COUNT(cp.id) FROM (iqq_calendar_product AS cp) WHERE cp.product_id=p.product_id) > 0 AND ((MONTH(p.start_date)<=) AND (MONTH(p.end_date)>=) AND (YEAR(p.start_date)<=) AND (YEAR(p.end_date) >= )) ORDER BY p.start_date DESC