- INNER JOIN profile_education_degree AS d ON (e.id = d.eduid)
- LEFT JOIN geoloc_pays AS g ON (e.country = g.a2)
- ORDER BY g.pays, e.name");
+ INNER JOIN profile_education_degree AS d ON (e.id = d.eduid)
+ INNER JOIN geoloc_countries AS gc ON (e.country = gc.iso_3166_1_a2)
+ ORDER BY gc.countryFR, e.name");