SELECT mv.*, iv.*, iv.id AS mainID, iv.versionDate AS identite_versionDate FROM mandat_versions mv JOIN identite_versions iv ON iv.id = mv.idIdentite JOIN ( SELECT mv.idMandat, MAX(iv.versionDate) AS maxVersion FROM mandat_versions mv JOIN identite_versions iv ON iv.id = mv.idIdentite WHERE mv.idEntite = ? AND iv.versionDate <= ? GROUP BY mv.idMandat ) latest ON latest.idMandat = mv.idMandat AND latest.maxVersion = iv.versionDate WHERE mv.idEntite = ? ORDER BY mv.anneeEntreeUtilisee ASC; Base de données des élites suisses | Bossonnens