- Choix de l'établissement SELECT distinct idEtab, nomEtab, count.nbcandidat FROM etablissements e LEFT JOIN candidats c on e.idEtab = c.idetablissements LEFT JOIN (SELECT idetablissements, count(nom) as nbcandidat FROM candidats GROUP BY idetablissements) as count on count.idetablissements = c.idetablissements WHERE nbcandidat > 1 ORDER BY nomEtab ** ETABLISSEMENT TEST ** (8) CAP de Bordeaux (11) ESAT Audenge (17) ESAT Hors Mur (5) ESAT La Paillerie (12) ESAT Le Haut-Mexant (9) ESAT Les Massiots (8) ESAT Métropole Pessac Alouette (9) ESAT Métropole site Blanquefort (9) ESAT Métropole site Blanquefort - Messidor (4) ESAT Pessac Magellan (8) ESAT Villambis (11) FAM/SAD Bègles (4) FH Bassin d'Arcachon (4) FO La Réole (18) FO/FAM Gujan-Mestras (11) FO/FAM Saint-Michel-de-Rieufret (5) FO/FH Martignas-sur-Jalle (16) IME Alouette (5) IME Blaye (11) IME d'Aquitaine Les massiots (5) IME Médoc (9) IME Taussat (8) LF Saint-Denis-de-Pile (4) MAS Biganos (6) MAS Saint-Denis-de-Pile (10) STP Audenge (10) STP La Paillerie (3) STP Métropole (5) STP Mongauzy (2) STP Villambis (3) UH Blanquefort (8) UH Blaye (4) UH Bois-Joly (15)