select r.epreuve, r.ffbnum, r.resultat, r.nbepreuves, r.classement, f.Nom as nom1, f.Prenom as prenom1, g.Nom as nom2, g.Prenom as prenom2 from `bridgeresultats_coteazur`.`coteazur_challengeclubs_resultats` as r left join eq57401.ffb as f on f.Licence = substring(r.ffbnum, 1, 8) left join eq57401.ffb as g on g.Licence = substring(r.ffbnum, 9, 8) where r.epreuve = 1011 and r.saison = 20 order by resultat desc