Logo de la structure
FRANCE > CRH ILE-DE-FRANCE > CDH HAUTS-DE-SEINE (92)
COMITE DEPARTEMENTAL HANDISPORT DES HAUTS-DE-SEINE
Président : M. CHRISTIAN BOSTNAVARON
Adresse :
4 AVENUE PIERRE BROSSOLETTE
92350 LE PLESSIS ROBINSON
Tél : 01 46 32 34 34 -
34 Structures affiliées dans ce département
TYPE LIBELLE AFFILIE EN LABEL CLUB
SECTION ADRIKART 2017/2018
SECTION ANTONY SPORT TENNIS DE TABLE 2017/2018
CLUB ANTONY SPORTS HANDI-CLUB 2017/2018 Label Club handisport - 1 étoile
CLUB ASHP GARCHES 2017/2018
CLUB ASLHPVV VAUCRESSON 2017/2018
CLUB ASS SPORT DE L'AERIMC 2017/2018
CLUB ASSOCIATION IMC DE NEUILLY 2017/2018
CLUB ASSOCIATION SPORTIVE DU LEA JEAN MONNET 2017/2018
SECTION ATHLETIC CLUB DE BOULOGNE BILLANCOURT 2017/2018 Label Club handisport - 1 étoile
SECTION C.S. CLICHY 92 NATATION 2017/2018 Label Club handisport - 1 étoile
CLUB C.S.L.S. BOURG LA REINE 2017/2018
SECTION CERCLE D'ESCRIME CHATILLON ESTOC ET TAILLE 2017/2018
SECTION CERCLE D'ESCRIME DE CHAVILLE 2017/2018 Label Club handisport - 1 étoile
SECTION CERCLE D'ESCRIME DE RUEIL MALMAISON 2017/2018
SECTION CLICHY ESCRIME 2017/2018
SECTION CLUB OLYMPIQUE DE SEVRES 2017/2018 Label Club handisport - 1 étoile
SECTION CLUB SPORTIF CLICHY TENNIS 2017/2018 Label Club handisport - 1 étoile
CLUB COLOMBES HANDISPORT OLYMPIQUE 2017/2018
SECTION COMMUNIQUER ET VIVRE LE HANDICAP A GENNEVILLIERS - ATHLETISME 2017/2018
CLUB COMMUNIQUER ET VIVRE LE HANDICAP A GENNEVILLIERS - BASKET 2017/2018
SECTION COMMUNIQUER ET VIVRE LE HANDICAP A GENNEVILLIERS - PLONGEE 2017/2018
SECTION COURBEVOIE ESCRIME 2017/2018 Label Club handisport - 1 étoile
SECTION CSM VILLENEUVE LA GARENNE - AVG CYCLISME 2017/2018
SECTION ENTENTE PONGISTE ISSEENNE 2017/2018
CLUB H@NDI-@LTITUDE 2017/2018
CLUB HANDISPORT PLUS ASNIERES 2017/2018
SECTION LEVALLOIS SPORTING CLUB 2017/2018
CLUB LUTECE CLUB HANDISPORT 2017/2018 Label Club handisport - 1 étoile
SECTION NANTERRE ATHLETIC CLUB 2017/2018
CLUB NANTERRE HANDISPORT 2017/2018
SECTION RCF ISSY AVIA 2017/2018 Label Club handisport - 1 étoile
CLUB SPORT CULTURE EXPRESSION EQUILIBRE EVENEMENT 2017/2018
SECTION STADE DE VANVES 2017/2018
CLUB UPSILON - CHATENAY MALABRY 2017/2018 Label Club handisport - 3 étoiles Label Club handisport - 3 étoiles Label Club handisport - 3 étoiles
(production) 8 queries took 22 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT MAX(`labels`.`Label`) as MaxLabel, `Structure`.`StructureCodeRegion`, `Structure`.`StructureType`, `Structure`.`StructureNom`, `Affiliation`.`structure_id`, `Affiliation`.`SaisonAnnee`, `Adresse`.`AdresseCompA`, `Adresse`.`AdresseCodePostalFR`, `Adresse`.`AdresseCommune`, `Structure`.`StructureNomCourt` FROM `ExtranetFFH`.`affiliations` AS `Affiliation` LEFT JOIN `ExtranetFFH`.`adresses` AS `Adresse` ON (`Affiliation`.`structure_id` = `Adresse`.`id`) LEFT JOIN `ExtranetFFH`.`instances` AS `Instance` ON (`Affiliation`.`structure_id` = `Instance`.`id`) LEFT JOIN `ExtranetFFH`.`public_accueils` AS `Public_accueil` ON (`Affiliation`.`structure_id` = `Public_accueil`.`id`) LEFT JOIN `ExtranetFFH`.`structures` AS `Structure` ON (`Affiliation`.`structure_id` = `Structure`.`id`) LEFT JOIN `ExtranetFFH`.`labels` ON (`labels`.`id` = `Affiliation`.`structure_id` AND `labels`.`SaisonAnnee` >= -2) WHERE `Structure`.`StructureType` IN ('SEC', 'CLU') AND `Structure`.`StructureIdParent` = 93 GROUP BY `Affiliation`.`structure_id` ORDER BY `Structure`.`StructureNom` ASC LIMIT 100343412
2SELECT COUNT(*) AS `count` FROM `ExtranetFFH`.`affiliations` AS `Affiliation` LEFT JOIN `ExtranetFFH`.`adresses` AS `Adresse` ON (`Affiliation`.`structure_id` = `Adresse`.`id`) LEFT JOIN `ExtranetFFH`.`instances` AS `Instance` ON (`Affiliation`.`structure_id` = `Instance`.`id`) LEFT JOIN `ExtranetFFH`.`public_accueils` AS `Public_accueil` ON (`Affiliation`.`structure_id` = `Public_accueil`.`id`) LEFT JOIN `ExtranetFFH`.`structures` AS `Structure` ON (`Affiliation`.`structure_id` = `Structure`.`id`) WHERE `Structure`.`StructureIdParent` = 93 AND `Structure`.`StructureType` IN ('SEC', 'CLU') GROUP BY `Affiliation`.`structure_id`34347
3SELECT `Affiliation`.`SaisonAnnee`, `Affiliation`.`structure_id`, `Affiliation`.`AffilEtat`, `Affiliation`.`AffilDate`, `Affiliation`.`AffilCode`, `Adresse`.`AdresseId`, `Adresse`.`PersonneId`, `Adresse`.`id`, `Adresse`.`AdresseCompA`, `Adresse`.`AdresseCompB`, `Adresse`.`AdresseCompC`, `Adresse`.`AdresseCodePostalFR`, `Adresse`.`AdresseCodePostalET`, `Adresse`.`AdresseCommune`, `Adresse`.`AdressePays`, `Adresse`.`AdresseMail`, `Adresse`.`AdresseTel`, `Adresse`.`AdresseFax`, `Adresse`.`AdresseGsm`, `Adresse`.`AdresseWeb`, `Adresse`.`AdresseDiffusion`, `Adresse`.`Region`, `Adresse`.`Departement`, `Adresse`.`AdresseType`, `Instance`.`InstanceId`, `Instance`.`PersonneId`, `Instance`.`SaisonAnnee`, `Instance`.`id`, `Instance`.`InstanceCodeTypeFonction`, `Instance`.`InstanceCodeEchelon`, `Instance`.`PersonneNom`, `Instance`.`PersonnePrenom`, `Public_accueil`.`id`, `Public_accueil`.`StructureAttFederation`, `Public_accueil`.`StructureHandicapPhysD`, `Public_accueil`.`StructureHandicapPhysFM`, `Public_accueil`.`StructureHandicapPhysFE`, `Public_accueil`.`StructureHandicapSensDV`, `Public_accueil`.`StructureHandicapSensDA`, `Structure`.`id`, `Structure`.`StructureNomCourt`, `Structure`.`StructureNom`, `Structure`.`StructureEtat`, `Structure`.`StructureCode`, `Structure`.`StructureCodeRegion`, `Structure`.`StructureCodeDepartement`, `Structure`.`StructureIdParent`, `Structure`.`StructureType`, `Structure`.`StructureLogo`, `Structure`.`NCCENR`, `Structure`.`AdresseCompA`, `Structure`.`AdresseCompB`, `Structure`.`AdresseCompC`, `Structure`.`AdresseCodePostalFR`, `Structure`.`AdresseCommune`, `Structure`.`AdresseType`, `Structure`.`AdresseGsm`, `Structure`.`AdresseMail`, `Structure`.`AdresseTel`, `Structure`.`StructureResidentEtab`, `Structure`.`AdresseWeb`, `Structure`.`StructureAnnuairePartenaire`, (`Structure`.`NCCENR`) AS `Structure__Region2`, (SELECT name FROM regions where `regions`.`id` = `Structure`.`StructureCode`) AS `Structure__Region`, (SELECT DEP FROM departements where `departements`.`id` = `Structure`.`StructureCodeDepartement`) AS `Structure__Departement`, (SELECT CONCAT(DEP," - ",name) FROM departements where `departements`.`id` = `Structure`.`StructureCodeDepartement`) AS `Structure__Depname`, (SELECT GROUP_CONCAT(DisciplineLibelle) FROM StructureDiscipline SD where `SD`.`StructureId` = `Structure`.`id` and `SD`.`DisciplineCode` != 998) AS `Structure__sports` FROM `ExtranetFFH`.`affiliations` AS `Affiliation` LEFT JOIN `ExtranetFFH`.`adresses` AS `Adresse` ON (`Affiliation`.`structure_id` = `Adresse`.`id`) LEFT JOIN `ExtranetFFH`.`instances` AS `Instance` ON (`Affiliation`.`structure_id` = `Instance`.`id`) LEFT JOIN `ExtranetFFH`.`public_accueils` AS `Public_accueil` ON (`Affiliation`.`structure_id` = `Public_accueil`.`id`) LEFT JOIN `ExtranetFFH`.`structures` AS `Structure` ON (`Affiliation`.`structure_id` = `Structure`.`id`) WHERE `structure_id` = 93 LIMIT 1112
4SELECT `Structure`.`id`, `Structure`.`StructureNomCourt`, `Structure`.`StructureNom`, `Structure`.`StructureEtat`, `Structure`.`StructureCode`, `Structure`.`StructureCodeRegion`, `Structure`.`StructureCodeDepartement`, `Structure`.`StructureIdParent`, `Structure`.`StructureType`, `Structure`.`StructureLogo`, `Structure`.`NCCENR`, `Structure`.`AdresseCompA`, `Structure`.`AdresseCompB`, `Structure`.`AdresseCompC`, `Structure`.`AdresseCodePostalFR`, `Structure`.`AdresseCommune`, `Structure`.`AdresseType`, `Structure`.`AdresseGsm`, `Structure`.`AdresseMail`, `Structure`.`AdresseTel`, `Structure`.`StructureResidentEtab`, `Structure`.`AdresseWeb`, `Structure`.`StructureAnnuairePartenaire`, (`Structure`.`NCCENR`) AS `Structure__Region2`, (SELECT name FROM regions where `regions`.`id` = `Structure`.`StructureCode`) AS `Structure__Region`, (SELECT DEP FROM departements where `departements`.`id` = `Structure`.`StructureCodeDepartement`) AS `Structure__Departement`, (SELECT CONCAT(DEP," - ",name) FROM departements where `departements`.`id` = `Structure`.`StructureCodeDepartement`) AS `Structure__Depname`, (SELECT GROUP_CONCAT(DisciplineLibelle) FROM StructureDiscipline SD where `SD`.`StructureId` = `Structure`.`id` and `SD`.`DisciplineCode` != 998) AS `Structure__sports` FROM `ExtranetFFH`.`structures` AS `Structure` WHERE `Structure`.`id` = 93 LIMIT 1111
5SELECT `Instance`.`InstanceId`, `Instance`.`PersonneId`, `Instance`.`SaisonAnnee`, `Instance`.`id`, `Instance`.`InstanceCodeTypeFonction`, `Instance`.`InstanceCodeEchelon`, `Instance`.`PersonneNom`, `Instance`.`PersonnePrenom` FROM `ExtranetFFH`.`instances` AS `Instance` WHERE `id` = 93 AND `InstanceCodeTypeFonction` = 'PR' ORDER BY `SaisonAnnee` Desc LIMIT 1110
6SELECT `Personne`.`NF`, `Personne`.`id`, `Personne`.`PersonneCivilite`, `Personne`.`PersonneNom`, `Personne`.`PersonnePrenom`, `Personne`.`PersonneSexe`, `Personne`.`PersonneDdn`, `Personne`.`AdresseMail`, `Personne`.`AdresseTel`, `Personne`.`AdresseCompA`, `Personne`.`AdresseCompB`, `Personne`.`AdresseCompC`, `Personne`.`AdressePays`, `Personne`.`AdresseGsm`, `Personne`.`AdresseCommune`, `Personne`.`PersonneNationalite`, `Personne`.`PersonneDdnLieu`, `Personne`.`AdresseCodePostalFR`, (CONCAT(`Personne`.`PersonnePrenom`, " ", `Personne`.`PersonneNom`)) AS `Personne__FN` FROM `ExtranetFFH`.`personnes` AS `Personne` WHERE `id` = 73603 ORDER BY `Personne`.`PersonneNom` ASC LIMIT 1110
7SELECT `Affiliation`.`SaisonAnnee`, `Affiliation`.`structure_id`, `Affiliation`.`AffilEtat`, `Affiliation`.`AffilDate`, `Affiliation`.`AffilCode`, `Adresse`.`AdresseId`, `Adresse`.`PersonneId`, `Adresse`.`id`, `Adresse`.`AdresseCompA`, `Adresse`.`AdresseCompB`, `Adresse`.`AdresseCompC`, `Adresse`.`AdresseCodePostalFR`, `Adresse`.`AdresseCodePostalET`, `Adresse`.`AdresseCommune`, `Adresse`.`AdressePays`, `Adresse`.`AdresseMail`, `Adresse`.`AdresseTel`, `Adresse`.`AdresseFax`, `Adresse`.`AdresseGsm`, `Adresse`.`AdresseWeb`, `Adresse`.`AdresseDiffusion`, `Adresse`.`Region`, `Adresse`.`Departement`, `Adresse`.`AdresseType`, `Instance`.`InstanceId`, `Instance`.`PersonneId`, `Instance`.`SaisonAnnee`, `Instance`.`id`, `Instance`.`InstanceCodeTypeFonction`, `Instance`.`InstanceCodeEchelon`, `Instance`.`PersonneNom`, `Instance`.`PersonnePrenom`, `Public_accueil`.`id`, `Public_accueil`.`StructureAttFederation`, `Public_accueil`.`StructureHandicapPhysD`, `Public_accueil`.`StructureHandicapPhysFM`, `Public_accueil`.`StructureHandicapPhysFE`, `Public_accueil`.`StructureHandicapSensDV`, `Public_accueil`.`StructureHandicapSensDA`, `Structure`.`id`, `Structure`.`StructureNomCourt`, `Structure`.`StructureNom`, `Structure`.`StructureEtat`, `Structure`.`StructureCode`, `Structure`.`StructureCodeRegion`, `Structure`.`StructureCodeDepartement`, `Structure`.`StructureIdParent`, `Structure`.`StructureType`, `Structure`.`StructureLogo`, `Structure`.`NCCENR`, `Structure`.`AdresseCompA`, `Structure`.`AdresseCompB`, `Structure`.`AdresseCompC`, `Structure`.`AdresseCodePostalFR`, `Structure`.`AdresseCommune`, `Structure`.`AdresseType`, `Structure`.`AdresseGsm`, `Structure`.`AdresseMail`, `Structure`.`AdresseTel`, `Structure`.`StructureResidentEtab`, `Structure`.`AdresseWeb`, `Structure`.`StructureAnnuairePartenaire`, (`Structure`.`NCCENR`) AS `Structure__Region2`, (SELECT name FROM regions where `regions`.`id` = `Structure`.`StructureCode`) AS `Structure__Region`, (SELECT DEP FROM departements where `departements`.`id` = `Structure`.`StructureCodeDepartement`) AS `Structure__Departement`, (SELECT CONCAT(DEP," - ",name) FROM departements where `departements`.`id` = `Structure`.`StructureCodeDepartement`) AS `Structure__Depname`, (SELECT GROUP_CONCAT(DisciplineLibelle) FROM StructureDiscipline SD where `SD`.`StructureId` = `Structure`.`id` and `SD`.`DisciplineCode` != 998) AS `Structure__sports` FROM `ExtranetFFH`.`affiliations` AS `Affiliation` LEFT JOIN `ExtranetFFH`.`adresses` AS `Adresse` ON (`Affiliation`.`structure_id` = `Adresse`.`id`) LEFT JOIN `ExtranetFFH`.`instances` AS `Instance` ON (`Affiliation`.`structure_id` = `Instance`.`id`) LEFT JOIN `ExtranetFFH`.`public_accueils` AS `Public_accueil` ON (`Affiliation`.`structure_id` = `Public_accueil`.`id`) LEFT JOIN `ExtranetFFH`.`structures` AS `Structure` ON (`Affiliation`.`structure_id` = `Structure`.`id`) WHERE `structure_id` = 111 LIMIT 1110
8SELECT `Affiliation`.`SaisonAnnee`, `Affiliation`.`structure_id`, `Affiliation`.`AffilEtat`, `Affiliation`.`AffilDate`, `Affiliation`.`AffilCode`, `Adresse`.`AdresseId`, `Adresse`.`PersonneId`, `Adresse`.`id`, `Adresse`.`AdresseCompA`, `Adresse`.`AdresseCompB`, `Adresse`.`AdresseCompC`, `Adresse`.`AdresseCodePostalFR`, `Adresse`.`AdresseCodePostalET`, `Adresse`.`AdresseCommune`, `Adresse`.`AdressePays`, `Adresse`.`AdresseMail`, `Adresse`.`AdresseTel`, `Adresse`.`AdresseFax`, `Adresse`.`AdresseGsm`, `Adresse`.`AdresseWeb`, `Adresse`.`AdresseDiffusion`, `Adresse`.`Region`, `Adresse`.`Departement`, `Adresse`.`AdresseType`, `Instance`.`InstanceId`, `Instance`.`PersonneId`, `Instance`.`SaisonAnnee`, `Instance`.`id`, `Instance`.`InstanceCodeTypeFonction`, `Instance`.`InstanceCodeEchelon`, `Instance`.`PersonneNom`, `Instance`.`PersonnePrenom`, `Public_accueil`.`id`, `Public_accueil`.`StructureAttFederation`, `Public_accueil`.`StructureHandicapPhysD`, `Public_accueil`.`StructureHandicapPhysFM`, `Public_accueil`.`StructureHandicapPhysFE`, `Public_accueil`.`StructureHandicapSensDV`, `Public_accueil`.`StructureHandicapSensDA`, `Structure`.`id`, `Structure`.`StructureNomCourt`, `Structure`.`StructureNom`, `Structure`.`StructureEtat`, `Structure`.`StructureCode`, `Structure`.`StructureCodeRegion`, `Structure`.`StructureCodeDepartement`, `Structure`.`StructureIdParent`, `Structure`.`StructureType`, `Structure`.`StructureLogo`, `Structure`.`NCCENR`, `Structure`.`AdresseCompA`, `Structure`.`AdresseCompB`, `Structure`.`AdresseCompC`, `Structure`.`AdresseCodePostalFR`, `Structure`.`AdresseCommune`, `Structure`.`AdresseType`, `Structure`.`AdresseGsm`, `Structure`.`AdresseMail`, `Structure`.`AdresseTel`, `Structure`.`StructureResidentEtab`, `Structure`.`AdresseWeb`, `Structure`.`StructureAnnuairePartenaire`, (`Structure`.`NCCENR`) AS `Structure__Region2`, (SELECT name FROM regions where `regions`.`id` = `Structure`.`StructureCode`) AS `Structure__Region`, (SELECT DEP FROM departements where `departements`.`id` = `Structure`.`StructureCodeDepartement`) AS `Structure__Departement`, (SELECT CONCAT(DEP," - ",name) FROM departements where `departements`.`id` = `Structure`.`StructureCodeDepartement`) AS `Structure__Depname`, (SELECT GROUP_CONCAT(DisciplineLibelle) FROM StructureDiscipline SD where `SD`.`StructureId` = `Structure`.`id` and `SD`.`DisciplineCode` != 998) AS `Structure__sports` FROM `ExtranetFFH`.`affiliations` AS `Affiliation` LEFT JOIN `ExtranetFFH`.`adresses` AS `Adresse` ON (`Affiliation`.`structure_id` = `Adresse`.`id`) LEFT JOIN `ExtranetFFH`.`instances` AS `Instance` ON (`Affiliation`.`structure_id` = `Instance`.`id`) LEFT JOIN `ExtranetFFH`.`public_accueils` AS `Public_accueil` ON (`Affiliation`.`structure_id` = `Public_accueil`.`id`) LEFT JOIN `ExtranetFFH`.`structures` AS `Structure` ON (`Affiliation`.`structure_id` = `Structure`.`id`) WHERE `structure_id` = 111 LIMIT 1110