Warning: Invalid argument supplied for foreach() in /var/www/solvimo.com/montpellier-sud/gerer.php on line 42

Warning: Division by zero in /var/www/solvimo.com/montpellier-sud/gerer.php on line 84
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.`status` = '12' AND c.`28`='Location' AND c.`date_compro` BET' at line 8 - SELECT c.`products_id`, c.`27`,c.`122`,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.`manufacturers_id` = AND c.`status` = '12' AND c.`28`='Location' 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', '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 limit 0,8 Une erreur bloquante s'est produite.
Si le problème persiste, merci de nous contacter au EDITEUR_TEL