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 '%,garde d'enfants,%' 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 'enfants,%' ORDER BY offre DESC, vitrine_echeance DESC, echeance_abonnement DESC,' at line 28