mysqlYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY asc' at line 1 1064 SELECT as id, i.codelocuteur as locuteur,e.enquete as enquete,r.pays as pays,r.regions as region, as zone,i.type as type,i.transcription as transcription,i.xmin as xmin,i.xmax as xmax,i.age as loc_age,i.sexe as loc_sexe,i.naissance as loc_naissance,loc.lieu_naissance as loc_lieu_naissance,loc.domicile as loc_domicile,p.profession_desc as loc_profession,loc.professions_anciennes as loc_professions_anciennes,loc.age_etude as loc_etudes,a.activite_desc as loc_activite,loc.statut as loc_etatcivil,loc.enfants as loc_enfants,loc.etudes as loc_etudes,loc.langues as loc_langues,loc.mere_langues as loc_mere_langues,loc.pere_langues as loc_pere_langues,loc.conjoint_langues as loc_conjoint_langues FROM intervalles i LEFT JOIN enquetes e ON `i`.`codeenquete` = `e`.`cleenquete` LEFT JOIN locuteurs loc ON `i`.`codelocuteur`=`loc`.`codelocuteur` LEFT JOIN professions p ON `p`.`cle`=`i`.`profession` LEFT JOIN regions r ON `r`.`cleregions`=`i`.`region` LEFT JOIN activite a ON `a`.`id`=`i`.`activite` WHERE IN () ORDER BY asc