La requête ressemble plus à ça: SELECT s.rowid, s.nom as name, s.name_alias, s.ref_ext, s.barcode, s.address, s.town, s.zip, s.datec, s.code_client, s.code_fournisseur, s.logo, s.entity, st.libelle as stcomm, st.picto as stcomm_picto, s.fk_stcomm as stcomm_id, s.fk_prospectlevel, s.prefix_comm, s.client, s.fournisseur, s.canvas, s.status as status, s.note_private, s.note_public, s.email, s.phone, s.phone_mobile, s.fax, s.url, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4 as idprof4, s.idprof5 as idprof5, s.idprof6 as idprof6, s.tva_intra, s.fk_pays, s.ip, s.tms as date_modification, s.datec as date_creation, s.import_key, s.code_compta, s.code_compta_fournisseur, s.parent as fk_parent,s.price_level, s2.nom as name2, typent.code as typent_code, staff.code as staff_code, s.fk_forme_juridique as legalform_code, country.code as country_code, country.label as country_label, state.code_departement as state_code, state.nom as state_name, region.code_region as region_code, region.nom as region_name, ef.height as options_height, ef.weight as options_weight, ef.prof as options_prof, ef.birthdate as options_birthdate, ef.stripeaccount as options_stripeaccount, ef.checkboxnonprofitorga as options_checkboxnonprofitorga FROM llx_societe as s LEFT JOIN llx_societe as s2 ON s.parent = s2.rowid LEFT JOIN llx_societe_extrafields as ef on (s.rowid = ef.fk_object) LEFT JOIN llx_c_country as country on (country.rowid = s.fk_pays) LEFT JOIN llx_c_typent as typent on (typent.id = s.fk_typent) LEFT JOIN llx_c_effectif as staff on (staff.id = s.fk_effectif) LEFT JOIN llx_c_departements as state on (state.rowid = s.fk_departement) LEFT JOIN llx_c_regions as region on (region.code_region = state.fk_region) LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id WHERE s.entity IN (1) AND (s.status IN (1)) ORDER BY country.code_iso ASC LIMIT 26
On y voit bien le ORDER BY country.code_iso à la fin
.
.
