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(ap.end_cours)>=) AND (YEAR(ap.start_cours)<=) AND (YEAR(ap.end_cour' at line 6
SELECT cp.*, ap.start_cours, ap.end_cours, (SELECT dp.dates FROM (iqq_dates_product AS dp) WHERE dp.dates_product_id=cp.dates_product_id) AS dates, EXTRACT(DAY FROM ap.start_cours) AS day_start, EXTRACT(MONTH FROM ap.start_cours) AS month_start, EXTRACT(YEAR FROM ap.start_cours) AS year_start, EXTRACT(DAY FROM ap.end_cours) AS day_end, EXTRACT(MONTH FROM ap.end_cours) AS month_end, EXTRACT(YEAR FROM ap.end_cours) AS year_end FROM (iqq_calendar_product AS cp) JOIN iqq_address_professor AS ap ON (cp.address_product_id=ap.address_product_id AND cp.professor_product_id=ap.professor_product_id) WHERE (SELECT p.active FROM (product AS p) WHERE p.product_id=cp.product_id)= 1 AND (SELECT p.type FROM (product AS p) WHERE p.product_id=cp.product_id) IN ('cours','class_tries') AND ((MONTH(ap.start_cours)<=) AND (MONTH(ap.end_cours)>=) AND (YEAR(ap.start_cours)<=) AND (YEAR(ap.end_cours) >= )) GROUP BY address_product_id, professor_product_id, dates_product_id