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 YEAR(p.start_date)=) OR (MONTH(p.end_date)= AND YEAR(p.end_date)=)) ORDER BY' at line 7
SELECT p.product_id, p.type, p.start_date, p.end_date, EXTRACT(DAY FROM p.start_date) AS day_event, EXTRACT(MONTH FROM p.start_date) AS month_event, EXTRACT(YEAR FROM p.start_date) AS year_event, TO_DAYS(p.start_date) AS days_start, TO_DAYS(p.end_date) AS days_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 = 'culturel' AND ((MONTH(p.start_date)= AND YEAR(p.start_date)=) OR (MONTH(p.end_date)= AND YEAR(p.end_date)=)) ORDER BY p.start_date DESC