Erreur lors de votre requĂȘte SQL ( SELECT ent.ID_entrepot, ent.Libelle_entrepot, ent.Nom_entrepot, ent.Adresse_entrepot, ent.CP_entrepot, ent.Ville_entrepot, ent.Page_classique_entrepot, ent.Code_entrepot,(select count(*) from unit box1 where box1.siteid = box.siteid and box1.physicalsize = box.physicalsize) as dispo_corebox, box.physicalsize as value_gamme, MIN(box.newmonthrate) as tarifweb_corebox ,MIN(box.newmonthrate) * 1.25 as tarifmag_corebox, box.physicalsize as size FROM entrepot ent , unit box, Site sit WHERE box.siteid = sit.siteid and sit.sitecode = ent.Code_entrepot AND box.physicalsize < 4.5 AND box.physicalsize >= 1 AND ent.ID_entrepot IN () AND box.description like 'Box%' AND box.newmonthrate > 0 GROUP BY ID_entrepot, Libelle_entrepot, Nom_entrepot, Adresse_entrepot, CP_entrepot, Ville_entrepot, Page_classique_entrepot, Code_entrepot, dispo_corebox, value_gamme ORDER BY tarifweb_corebox ASC, value_gamme ASC LIMIT 1 ) : SQLSTATE[42000]: Syntax error or access violation: 1064 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 box.description like 'Box%' AND box.newmonthrate > 0 ' at line 12