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 Une erreur bloquante s'est produite.
Si le probl�me persiste, merci de nous contacter au EDITEUR_TEL