| select A.*, T.fr as aff_T, C.fr as aff_C, S.fr as aff_S, R.fr as aff_R, E.fr as aff_E, P.fr as aff_P from vac_annonces as A left join vac_types as T on A.type=T.id left join vac_classements as C on A.classement=C.id left join vac_stations as S on A.station=S.id left join vac_massif as R on A.region=R.id left join vac_etats as E on A.etat=E.id left join vac_personnes as P on A.capacite=P.id where A.id=$$ |