SELECT s.idStage,
               s.remuneration,     p.annee,    p.libelle,
               ela.lat,            ela.lon,    ela.pays,
               ca.lat,             ca.lon,     ca.pays,
               ena.lat,            ena.lon,    ena.pays
           FROM Stage as s
           LEFT JOIN (Eleve as el, Adresse as ela) ON (el.idEleve = s.idEleve AND ela.idAdresse = el.idADresse)
           LEFT JOIN (Entreprise as en, Adresse as ena) ON (en.idEntreprise = s.idEntreprise AND ena.idAdresse = en.idAdresse)

           LEFT JOIN (Appartient, Promo as p, Campus, Adresse as ca) ON (
               Appartient.idEleve = el.idEleve AND p.id = Appartient.idPromo AND p.annee = s.annee
               AND Campus.idCampus = p.idCampus AND ca.idAdresse = Campus.idAdresse
           )