Erreur : 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 c.`28`='Vente' 
						AND c.`27`!='0' 
						AND c.`intercabinet`=0
						AN' at line 9   -  SELECT c.`products_id`, c.`27`,c.`122`,c.`124`,c.`33`,c.`34`, c.`65`,c.`163`,c.`date_compro`,c.`status`,DATEDIFF(c.`date_compro`, STR_TO_DATE(ct.`criteres_value`,'%d/%m/%Y')) as `Delai`
						from compromis c, products_criteres_text ct
						WHERE c.`prix_acq` != 0 
						AND ct.`products_id` = c.`products_id`
						AND ct.`criteres_id`=2171 
						AND c.`products_id` != 0 
						AND c.`status` = '4'
						AND c.`manufacturers_id` = 
						AND c.`28`='Vente' 
						AND c.`27`!='0' 
						AND c.`intercabinet`=0
						AND c.`date_compro` BETWEEN DATE_SUB(NOW(),INTERVAL 2 YEAR) AND NOW()
						AND c.`27` IN('1', 'Loft','2', '3', '16','17', '19', '20', '6', '21', '22', '25', '28', '30', '31', 'Ameau', 'Bergerie', 'Chateau','Gtrange', 'Hotel_Part', '7','8','10','18','24','26','Viticole','ExploitationAgricole')  
						GROUP BY c.products_id ORDER BY `Delai` ASC   <font color="#000000"><b>Une erreur bloquante s'est produite. <br> Si le probl�me persiste, merci de nous contacter au EDITEUR_TEL