Erreur SQL :
SELECT `commerces_liste`.`id_commercant` AS `id_commercant`, `commerces_liste`.`com_raison` AS `com_raison`, `commerces_liste`.`com_cat1` AS `com_cat1`, `commerces_liste`.`com_gps_latitude` AS `com_gps_latitude`, `commerces_liste`.`com_gps_longitude` AS `com_gps_longitude`, `commerces_liste`.`com_gps_precision` AS `com_gps_precision`, `commerces_liste`.`com_activite` AS `com_activite`, `commerces_liste`.`com_adresse` AS `com_adresse`, `commerces_liste`.`com_adresse2` AS `com_adresse2`, `annuaire_communes`.`id` AS `id`, `annuaire_communes`.`ville` AS `ville`, `annuaire_communes`.`villeRewrite` AS `villeRewrite`, `annuaire_communes`.`codepostal` AS `codepostal`, `commerces_liste`.`offre` AS `offre`, `commerces_liste`.`com_telephone` AS `com_telephone`, `commerces_liste`.`com_email` AS `com_email`, `vitrine`.`vitrine_url` AS `vitrine_url`, `commerces_categories`.`catRewrite` AS `catRewrite` FROM `commerces_liste` LEFT JOIN `commerces_premium` ON(`commerces_liste`.`id_commercant` = `commerces_premium`.`PremComID`) LEFT JOIN `vitrine` ON(`commerces_liste`.`id_commercant` = `vitrine`.`id_com`) JOIN `annuaire_communes` JOIN `commerces_categories` WHERE `annuaire_communes`.`id` = `commerces_liste`.`com_ville` AND `commerces_categories`.`id_categorie` = `commerces_liste`.`com_cat1` AND `commerces_liste`.com_actif='o' AND CONCAT(CONCAT(',',REPLACE(com_motscles,', ',',')),',') LIKE '%,parfums d'ambiance,%' ORDER BY offre DESC, vitrine_echeance DESC, echeance_abonnement DESC, com_raison ASC
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 'ambiance,%' ORDER BY offre DESC, vitrine_echeance DESC, echeance_abonnement DESC' at line 28