Notice (8): compact(): Undefined variable: adresse [APP/Controller/EventsController.php, line 1572]
Calendrier des événements handisport:
Retour calendrier
PARTAGER
France 11 / AUDE
Jeux Régionaux de L'avenir - PORT LA NOUVELLE (FRA) - 2025
23/04/2025 au 25/04/2025
Photo ©
4° Jeux Régionaux de l'Avenir Handisport Occitanie
Contact
COMITE REGIONAL HANDISPORT OCCITANIE
Anthony RIBES
anthony.ribes@handisportoccitanie.org
06 28 76 44 88
Inscriptions
Du 13/01/2025 au 23/03/2025
Ajouter à votre calendrier 23/04/2025 25/04/2025 Europe/Paris Jeux Régionaux de L'avenir - PORT LA NOUVELLE (FRA) - 2025 4° Jeux Régionaux de l'Avenir Handisport Occitanie 11210 PORT LA NOUVELLE true DD/MM/YYYY


Haut de page
Activité(s) proposée(s)
Foot à 5 DV
Foot à 5
Escrime
Boccia
Sarbacane
Natation
Tennis de table
Basket-ball Fauteuil
Parcours moteur
Athlétisme
Haut de page
Organisateur(s)
COMITE REGIONAL HANDISPORT OCCITANIE
COMITE DEPARTEMENTAL HANDISPORT DE L'AUDE
Haut de page
Document(s)
Haut de page
Participants
Fauteuils électriques
Fauteuils manuels
Mal-marchants
Marchants
Déficients visuels
Sourds et mal-entendants
Valide

Sexe Mixte, Femme, Homme,
Age min : 8
Payant : 150 €
Age max : 18
Licence FFH Licence Etablissement, Licence PassSport, Licence Cadre, Licence Compétition, Licence Loisir,
Haut de page
Spectateurs
Ouvert au public
Haut de page
Lieu(x) & Accès
Lieu principal
Gymnase, stade de foot, piste d'athlétisme
rue alain colas
11210 PORT LA NOUVELLE
accés google map
Natation
Piscine
Avenue du Général de Gaule
11210 Port la Nouvelle
accés google map
(production) 27 queries took 13 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1BEGIN000
2INSERT INTO `ExtranetFFH`.`events_connections` (`event_id`, `user_id`, `created`) VALUES (30297, 0, '2025-05-23 05:44:54')111
3COMMIT000
4SELECT `Event`.`id`, `Event`.`season`, `Event`.`debut`, `Event`.`user_id`, `Event`.`user_structure_id`, `Event`.`name2`, `Event`.`name`, `Event`.`short_name`, `Event`.`created`, `Event`.`user_modify_id`, `Event`.`modified`, `Event`.`sport`, `Event`.`competition`, `Event`.`types_event_id`, `Event`.`type_complement`, `Event`.`activite`, `Event`.`activite_id`, `Event`.`titre`, `Event`.`region_id`, `Event`.`departement_id`, `Event`.`departement_id3`, `Event`.`description`, `Event`.`resume`, `Event`.`begin_published`, `Event`.`end_published`, `Event`.`published`, `Event`.`date_published`, `Event`.`calendar_ffh_published`, `Event`.`une_ffh_published`, `Event`.`une_cr_published`, `Event`.`une_cd_published`, `Event`.`niveau`, `Event`.`web_site`, `Event`.`facebook_page`, `Event`.`galerie_photo`, `Event`.`resultats_page`, `Event`.`fin`, `Event`.`report`, `Event`.`report_user_id`, `Event`.`report_details`, `Event`.`debut2`, `Event`.`fin2`, `Event`.`code_postal`, `Event`.`commune`, `Event`.`stop_event`, `Event`.`stop_event_user_id`, `Event`.`stop_event_date`, `Event`.`stop_event_details`, `Event`.`age_min`, `Event`.`ddn_min`, `Event`.`age_max`, `Event`.`ddn_max`, `Event`.`licence_ffh`, `Event`.`type_licence_ffh`, `Event`.`ouvert_valide_participant`, `Event`.`gratuit_participant`, `Event`.`price_participant`, `Event`.`open_public`, `Event`.`gratuit_public`, `Event`.`price_public`, `Event`.`country_id`, `Event`.`format`, `Event`.`format_nb_jours`, `Event`.`contact_structure`, `Event`.`contact_interlocuteur`, `Event`.`contact_email`, `Event`.`contact_tel`, `Event`.`capacite_public`, `Event`.`genre`, `Event`.`photo_thumb`, `Event`.`photo_une`, `Event`.`photo_view`, `Event`.`credit_photo`, `Event`.`end_inscription`, `Event`.`begin_inscription`, `Event`.`annulation`, `Event`.`annulation_categorie`, `Event`.`annulation_details`, `Event`.`annulation_user_id`, `Event`.`representant_ffh_id`, `Event`.`representant_ffh_fonction_id`, `Event`.`search_orga`, `Event`.`periode_cible`, `Event`.`precisions_search_orga`, `Event`.`autres_informations`, `Event`.`module_hn`, `Event`.`cdc`, `Event`.`exalto_ManifId`, `Event`.`mds_urlPdf`, `Event`.`mdsevent_id`, `Event`.`insert_by_multiple`, `Event`.`import_du_debut`, `Event`.`mode_gestion`, `Event`.`engagement_individuel`, `Event`.`open_intentions`, `Event`.`end_intentions`, `Event`.`go_intentions`, `Event`.`delegation_precree`, `Event`.`open_engagements`, `Event`.`end_engagements`, `Event`.`end_hebergement`, `Event`.`end_restauration`, `Event`.`go_engagements`, `Event`.`user_gestion_id`, `Event`.`tel_gestion`, `Event`.`email_gestion`, `Event`.`preambule`, `Event`.`delegation_doc_admin`, `Event`.`participant_doc_admin`, `Event`.`epreuves_by_participant`, `Event`.`nb_epreuves_by_participant`, `Event`.`tarif_by_participant`, `Event`.`tarif_by_epreuve_participant`, `Event`.`panier_repas`, `Event`.`tarif_panier_repas`, `Event`.`order_cheque`, `Event`.`adresse_envoi_cheque`, `Event`.`type_engagement`, `Event`.`nb_max_pratiquants_by_delegation`, `Event`.`step_intention`, `Event`.`step_engagement`, `Event`.`etoiles`, `Event`.`nb_participants_moins_20ans`, `Event`.`orga_support_etoiles`, `Event`.`tab_active`, `Event`.`qualification`, `Event`.`num_edition`, `Event`.`dossard`, `Event`.`prerequis_licence_encadrant`, `Event`.`prerequis_licence`, `Event`.`prerequis_licence_sport`, `Event`.`type_prestation`, `Event`.`prestations_by_delegation`, `Event`.`prestations_by_participant`, `Event`.`delegation_heb_cond`, `Event`.`participant_heb_cond`, `Event`.`participant_list_taille_teeshirt`, `Event`.`participant_diffusion`, `Event`.`participant_diffusion_next_jnh`, `Event`.`participant_niveau_lsf`, `Event`.`participant_accompagnateur`, `Event`.`participant_taille_teeshirt`, `Event`.`participant_indice_mobility`, `Event`.`participant_testing`, `Event`.`participant_deficience_sensorielle`, `Event`.`participant_by_selection`, `Event`.`payment_by_delegation`, `Event`.`payment_by_participant`, `Event`.`frais_techniques_by_participant`, `Event`.`montant_frais_techniques_by_participant`, `Event`.`temps_add_epreuve_by_participant`, `Event`.`billet_congres`, `Event`.`iban`, `Event`.`siret`, `Event`.`prefixe_num_facture`, `Event`.`logo_facture`, `Event`.`width_logo_facture`, `Event`.`sites_transport`, `Event`.`nb_plannings`, `Event`.`montant_promotion_prestation_by_participant`, `Event`.`hello_asso_form`, `Event`.`frais_passport`, `Event`.`montant_frais_navette`, (MONTH(`Event`.`debut`)) AS `Event__monthDebut`, (YEAR(`Event`.`debut`)) AS `Event__yearDebut`, (MONTH(`Event`.`fin`)) AS `Event__monthFin`, (YEAR(`Event`.`fin`)) AS `Event__yearFin`, (CONCAT(`Event`.`name`," • ",date_format(`Event`.`debut`, '%d/%m/%Y')," au ",date_format(`Event`.`fin`, '%d/%m/%Y'))) AS `Event__eventDates`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Event`.`user_id`) AS `Event__UCR`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Event`.`user_modify_id`) AS `Event__UMR`, (SELECT DEP FROM departements D where `D`.`id` = `Event`.`departement_id`) AS `Event__DEP`, `Country`.`id`, `Country`.`code`, `Country`.`alpha2`, `Country`.`alpha3`, `Country`.`cio`, `Country`.`nom_en_gb`, `Country`.`name`, (CONCAT(`Country`.`name`, " (", cio, ")")) AS `Country__name2`, `Departement`.`REGION`, `Departement`.`DEP`, `Departement`.`DEP2`, `Departement`.`CHEFLIEU`, `Departement`.`TNCC`, `Departement`.`name`, `Departement`.`NCCENR`, `Departement`.`id`, `Departement`.`StructureRegion`, `Departement`.`StructureIdRegion`, `Departement`.`StructureIdDepartement`, `Departement`.`highmap_code`, (CONCAT(`Departement`.`DEP`, " / ", `Departement`.`name`)) AS `Departement__numName` FROM `ExtranetFFH`.`events` AS `Event` LEFT JOIN `ExtranetFFH`.`countries` AS `Country` ON (`Event`.`country_id` = `Country`.`id`) LEFT JOIN `ExtranetFFH`.`departements` AS `Departement` ON (`Event`.`departement_id` = `Departement`.`id`) WHERE `Event`.`id` = 30297 ORDER BY `Event`.`debut` DESC LIMIT 1113
5SELECT `EventsDate`.`id`, `EventsDate`.`user_id`, `EventsDate`.`event_id`, `EventsDate`.`name`, `EventsDate`.`detail`, `EventsDate`.`debut`, `EventsDate`.`debutHr`, `EventsDate`.`fin`, `EventsDate`.`finHr`, `EventsDate`.`created`, `EventsDate`.`modified`, `EventsDate`.`first` FROM `ExtranetFFH`.`events_dates` AS `EventsDate` WHERE `EventsDate`.`event_id` = (30297)000
6SELECT `EventsSport`.`id`, `EventsSport`.`user_id`, `EventsSport`.`event_id`, `EventsSport`.`sport_id`, `EventsSport`.`detail`, `EventsSport`.`created`, `EventsSport`.`modified`, (SELECT name FROM sports S where `S`.`id` = `EventsSport`.`sport_id`) AS `EventsSport__sport` FROM `ExtranetFFH`.`events_sports` AS `EventsSport` WHERE `EventsSport`.`event_id` = (30297)10101
7SELECT `Sport`.`id`, `Sport`.`active_ressources`, `Sport`.`active`, `Sport`.`name`, `Sport`.`order`, `Sport`.`DisciplineEtat`, `Sport`.`DisciplineEstCompetion`, `Sport`.`DisciplineLabel`, `Sport`.`DisciplineElh`, `Sport`.`DisciplineSportCo`, `Sport`.`DisciplineAdversaire`, `Sport`.`DisciplineRecord`, `Sport`.`DisciplineCategorie`, `Sport`.`DisciplineRegate`, `Sport`.`DisciplineParalympique`, `Sport`.`LibelleAide`, `Sport`.`LibelleHautNiveau`, `Sport`.`cms`, `Sport`.`cms_priority`, `Sport`.`created`, `Sport`.`modified`, `Sport`.`acred_jp`, `Sport`.`ipc_name`, `Sport`.`ipc_code`, `Sport`.`sport_nature` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '116'110
8SELECT `Sport`.`id`, `Sport`.`active_ressources`, `Sport`.`active`, `Sport`.`name`, `Sport`.`order`, `Sport`.`DisciplineEtat`, `Sport`.`DisciplineEstCompetion`, `Sport`.`DisciplineLabel`, `Sport`.`DisciplineElh`, `Sport`.`DisciplineSportCo`, `Sport`.`DisciplineAdversaire`, `Sport`.`DisciplineRecord`, `Sport`.`DisciplineCategorie`, `Sport`.`DisciplineRegate`, `Sport`.`DisciplineParalympique`, `Sport`.`LibelleAide`, `Sport`.`LibelleHautNiveau`, `Sport`.`cms`, `Sport`.`cms_priority`, `Sport`.`created`, `Sport`.`modified`, `Sport`.`acred_jp`, `Sport`.`ipc_name`, `Sport`.`ipc_code`, `Sport`.`sport_nature` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '8'110
9SELECT `Sport`.`id`, `Sport`.`active_ressources`, `Sport`.`active`, `Sport`.`name`, `Sport`.`order`, `Sport`.`DisciplineEtat`, `Sport`.`DisciplineEstCompetion`, `Sport`.`DisciplineLabel`, `Sport`.`DisciplineElh`, `Sport`.`DisciplineSportCo`, `Sport`.`DisciplineAdversaire`, `Sport`.`DisciplineRecord`, `Sport`.`DisciplineCategorie`, `Sport`.`DisciplineRegate`, `Sport`.`DisciplineParalympique`, `Sport`.`LibelleAide`, `Sport`.`LibelleHautNiveau`, `Sport`.`cms`, `Sport`.`cms_priority`, `Sport`.`created`, `Sport`.`modified`, `Sport`.`acred_jp`, `Sport`.`ipc_name`, `Sport`.`ipc_code`, `Sport`.`sport_nature` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '17'110
10SELECT `Sport`.`id`, `Sport`.`active_ressources`, `Sport`.`active`, `Sport`.`name`, `Sport`.`order`, `Sport`.`DisciplineEtat`, `Sport`.`DisciplineEstCompetion`, `Sport`.`DisciplineLabel`, `Sport`.`DisciplineElh`, `Sport`.`DisciplineSportCo`, `Sport`.`DisciplineAdversaire`, `Sport`.`DisciplineRecord`, `Sport`.`DisciplineCategorie`, `Sport`.`DisciplineRegate`, `Sport`.`DisciplineParalympique`, `Sport`.`LibelleAide`, `Sport`.`LibelleHautNiveau`, `Sport`.`cms`, `Sport`.`cms_priority`, `Sport`.`created`, `Sport`.`modified`, `Sport`.`acred_jp`, `Sport`.`ipc_name`, `Sport`.`ipc_code`, `Sport`.`sport_nature` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
11SELECT `Sport`.`id`, `Sport`.`active_ressources`, `Sport`.`active`, `Sport`.`name`, `Sport`.`order`, `Sport`.`DisciplineEtat`, `Sport`.`DisciplineEstCompetion`, `Sport`.`DisciplineLabel`, `Sport`.`DisciplineElh`, `Sport`.`DisciplineSportCo`, `Sport`.`DisciplineAdversaire`, `Sport`.`DisciplineRecord`, `Sport`.`DisciplineCategorie`, `Sport`.`DisciplineRegate`, `Sport`.`DisciplineParalympique`, `Sport`.`LibelleAide`, `Sport`.`LibelleHautNiveau`, `Sport`.`cms`, `Sport`.`cms_priority`, `Sport`.`created`, `Sport`.`modified`, `Sport`.`acred_jp`, `Sport`.`ipc_name`, `Sport`.`ipc_code`, `Sport`.`sport_nature` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
12SELECT `Sport`.`id`, `Sport`.`active_ressources`, `Sport`.`active`, `Sport`.`name`, `Sport`.`order`, `Sport`.`DisciplineEtat`, `Sport`.`DisciplineEstCompetion`, `Sport`.`DisciplineLabel`, `Sport`.`DisciplineElh`, `Sport`.`DisciplineSportCo`, `Sport`.`DisciplineAdversaire`, `Sport`.`DisciplineRecord`, `Sport`.`DisciplineCategorie`, `Sport`.`DisciplineRegate`, `Sport`.`DisciplineParalympique`, `Sport`.`LibelleAide`, `Sport`.`LibelleHautNiveau`, `Sport`.`cms`, `Sport`.`cms_priority`, `Sport`.`created`, `Sport`.`modified`, `Sport`.`acred_jp`, `Sport`.`ipc_name`, `Sport`.`ipc_code`, `Sport`.`sport_nature` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '28'110
13SELECT `Sport`.`id`, `Sport`.`active_ressources`, `Sport`.`active`, `Sport`.`name`, `Sport`.`order`, `Sport`.`DisciplineEtat`, `Sport`.`DisciplineEstCompetion`, `Sport`.`DisciplineLabel`, `Sport`.`DisciplineElh`, `Sport`.`DisciplineSportCo`, `Sport`.`DisciplineAdversaire`, `Sport`.`DisciplineRecord`, `Sport`.`DisciplineCategorie`, `Sport`.`DisciplineRegate`, `Sport`.`DisciplineParalympique`, `Sport`.`LibelleAide`, `Sport`.`LibelleHautNiveau`, `Sport`.`cms`, `Sport`.`cms_priority`, `Sport`.`created`, `Sport`.`modified`, `Sport`.`acred_jp`, `Sport`.`ipc_name`, `Sport`.`ipc_code`, `Sport`.`sport_nature` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '38'110
14SELECT `Sport`.`id`, `Sport`.`active_ressources`, `Sport`.`active`, `Sport`.`name`, `Sport`.`order`, `Sport`.`DisciplineEtat`, `Sport`.`DisciplineEstCompetion`, `Sport`.`DisciplineLabel`, `Sport`.`DisciplineElh`, `Sport`.`DisciplineSportCo`, `Sport`.`DisciplineAdversaire`, `Sport`.`DisciplineRecord`, `Sport`.`DisciplineCategorie`, `Sport`.`DisciplineRegate`, `Sport`.`DisciplineParalympique`, `Sport`.`LibelleAide`, `Sport`.`LibelleHautNiveau`, `Sport`.`cms`, `Sport`.`cms_priority`, `Sport`.`created`, `Sport`.`modified`, `Sport`.`acred_jp`, `Sport`.`ipc_name`, `Sport`.`ipc_code`, `Sport`.`sport_nature` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'110
15SELECT `Sport`.`id`, `Sport`.`active_ressources`, `Sport`.`active`, `Sport`.`name`, `Sport`.`order`, `Sport`.`DisciplineEtat`, `Sport`.`DisciplineEstCompetion`, `Sport`.`DisciplineLabel`, `Sport`.`DisciplineElh`, `Sport`.`DisciplineSportCo`, `Sport`.`DisciplineAdversaire`, `Sport`.`DisciplineRecord`, `Sport`.`DisciplineCategorie`, `Sport`.`DisciplineRegate`, `Sport`.`DisciplineParalympique`, `Sport`.`LibelleAide`, `Sport`.`LibelleHautNiveau`, `Sport`.`cms`, `Sport`.`cms_priority`, `Sport`.`created`, `Sport`.`modified`, `Sport`.`acred_jp`, `Sport`.`ipc_name`, `Sport`.`ipc_code`, `Sport`.`sport_nature` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '995'110
16SELECT `Sport`.`id`, `Sport`.`active_ressources`, `Sport`.`active`, `Sport`.`name`, `Sport`.`order`, `Sport`.`DisciplineEtat`, `Sport`.`DisciplineEstCompetion`, `Sport`.`DisciplineLabel`, `Sport`.`DisciplineElh`, `Sport`.`DisciplineSportCo`, `Sport`.`DisciplineAdversaire`, `Sport`.`DisciplineRecord`, `Sport`.`DisciplineCategorie`, `Sport`.`DisciplineRegate`, `Sport`.`DisciplineParalympique`, `Sport`.`LibelleAide`, `Sport`.`LibelleHautNiveau`, `Sport`.`cms`, `Sport`.`cms_priority`, `Sport`.`created`, `Sport`.`modified`, `Sport`.`acred_jp`, `Sport`.`ipc_name`, `Sport`.`ipc_code`, `Sport`.`sport_nature` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
17SELECT `EventsDoc`.`id`, `EventsDoc`.`user_id`, `EventsDoc`.`event_id`, `EventsDoc`.`type`, `EventsDoc`.`categorie`, `EventsDoc`.`name`, `EventsDoc`.`url`, `EventsDoc`.`url_key`, `EventsDoc`.`created`, `EventsDoc`.`modified`, `EventsDoc`.`description`, `EventsDoc`.`published`, `EventsDoc`.`delegation`, `EventsDoc`.`admin_delegation`, `EventsDoc`.`lancement_intention`, `EventsDoc`.`lancement_engagement`, `EventsDoc`.`participant`, `EventsDoc`.`encadrant`, `EventsDoc`.`participant_visible` FROM `ExtranetFFH`.`events_docs` AS `EventsDoc` WHERE `EventsDoc`.`event_id` = (30297)440
18SELECT `EventsSite`.`id`, `EventsSite`.`first`, `EventsSite`.`user_id`, `EventsSite`.`event_id`, `EventsSite`.`name`, `EventsSite`.`etranger`, `EventsSite`.`adresse_ligne1`, `EventsSite`.`adresse_ligne2`, `EventsSite`.`adresse_ligne3`, `EventsSite`.`adresse_ligne4`, `EventsSite`.`code_postal`, `EventsSite`.`commune`, `EventsSite`.`adresse_etranger`, `EventsSite`.`lat`, `EventsSite`.`long`, `EventsSite`.`created`, `EventsSite`.`modified`, `EventsSite`.`published`, `EventsSite`.`commentaires`, `EventsSite`.`change` FROM `ExtranetFFH`.`events_sites` AS `EventsSite` WHERE `EventsSite`.`event_id` = (30297)220
19SELECT `EventsOrga`.`id`, `EventsOrga`.`event_id`, `EventsOrga`.`user_id`, `EventsOrga`.`structure_id`, `EventsOrga`.`created`, `EventsOrga`.`modified`, `EventsOrga`.`reference`, `EventsOrga`.`ffh`, `EventsOrga`.`structure_hors_ffh`, (SELECT StructureNom FROM structures S where `S`.`id` = `EventsOrga`.`structure_id`) AS `EventsOrga__structure` FROM `ExtranetFFH`.`events_orgas` AS `EventsOrga` WHERE `EventsOrga`.`event_id` = (30297)223
20SELECT `Structure`.`id`, `Structure`.`StructureNomCourt`, `Structure`.`StructureNom`, `Structure`.`StructureEtat`, `Structure`.`StructureCode`, `Structure`.`StructureCodeRegion`, `Structure`.`StructureCodeDepartement`, `Structure`.`StructureIdParent`, `Structure`.`StructureType`, `Structure`.`StructureLogo`, `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`, `Structure`.`tombola_code`, `Structure`.`token`, `Structure`.`club_solidarity`, `Structure`.`club_solidarity_at`, (SELECT name FROM regions where `regions`.`id` = `Structure`.`StructureCode`) AS `Structure__Region`, (SELECT NCCENR FROM regions where `regions`.`id` = `Structure`.`StructureCode`) AS `Structure__Region2`, (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` = 4960112
21SELECT `Structure`.`id`, `Structure`.`StructureNomCourt`, `Structure`.`StructureNom`, `Structure`.`StructureEtat`, `Structure`.`StructureCode`, `Structure`.`StructureCodeRegion`, `Structure`.`StructureCodeDepartement`, `Structure`.`StructureIdParent`, `Structure`.`StructureType`, `Structure`.`StructureLogo`, `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`, `Structure`.`tombola_code`, `Structure`.`token`, `Structure`.`club_solidarity`, `Structure`.`club_solidarity_at`, (SELECT name FROM regions where `regions`.`id` = `Structure`.`StructureCode`) AS `Structure__Region`, (SELECT NCCENR FROM regions where `regions`.`id` = `Structure`.`StructureCode`) AS `Structure__Region2`, (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` = 12110
22SELECT `Handicap`.`id`, `Handicap`.`name`, `Handicap`.`active`, `Handicap`.`created`, `Handicap`.`modified`, `EventsHandicap`.`id`, `EventsHandicap`.`event_id`, `EventsHandicap`.`handicap_id` FROM `ExtranetFFH`.`handicaps` AS `Handicap` JOIN `ExtranetFFH`.`events_handicaps` AS `EventsHandicap` ON (`EventsHandicap`.`event_id` = 30297 AND `EventsHandicap`.`handicap_id` = `Handicap`.`id`) 771
23SELECT `Genre`.`id`, `Genre`.`name`, `EventsGenre`.`genre_id`, `EventsGenre`.`event_id`, `EventsGenre`.`id` FROM `ExtranetFFH`.`genres` AS `Genre` JOIN `ExtranetFFH`.`events_genres` AS `EventsGenre` ON (`EventsGenre`.`event_id` = 30297 AND `EventsGenre`.`genre_id` = `Genre`.`id`) 331
24SELECT `TypesLicence`.`id`, `TypesLicence`.`name`, `EventsTypesLicence`.`types_licence_id`, `EventsTypesLicence`.`event_id`, `EventsTypesLicence`.`id` FROM `ExtranetFFH`.`types_licences` AS `TypesLicence` JOIN `ExtranetFFH`.`events_types_licences` AS `EventsTypesLicence` ON (`EventsTypesLicence`.`event_id` = 30297 AND `EventsTypesLicence`.`types_licence_id` = `TypesLicence`.`id`) 551
25SELECT `EventsDoc`.`id`, `EventsDoc`.`user_id`, `EventsDoc`.`event_id`, `EventsDoc`.`type`, `EventsDoc`.`categorie`, `EventsDoc`.`name`, `EventsDoc`.`url`, `EventsDoc`.`url_key`, `EventsDoc`.`created`, `EventsDoc`.`modified`, `EventsDoc`.`description`, `EventsDoc`.`published`, `EventsDoc`.`delegation`, `EventsDoc`.`admin_delegation`, `EventsDoc`.`lancement_intention`, `EventsDoc`.`lancement_engagement`, `EventsDoc`.`participant`, `EventsDoc`.`encadrant`, `EventsDoc`.`participant_visible` FROM `ExtranetFFH`.`events_docs` AS `EventsDoc` WHERE `event_id` = 30297 AND `categorie` = 0 AND `published` = 1330
26SELECT `EventsDoc`.`id`, `EventsDoc`.`user_id`, `EventsDoc`.`event_id`, `EventsDoc`.`type`, `EventsDoc`.`categorie`, `EventsDoc`.`name`, `EventsDoc`.`url`, `EventsDoc`.`url_key`, `EventsDoc`.`created`, `EventsDoc`.`modified`, `EventsDoc`.`description`, `EventsDoc`.`published`, `EventsDoc`.`delegation`, `EventsDoc`.`admin_delegation`, `EventsDoc`.`lancement_intention`, `EventsDoc`.`lancement_engagement`, `EventsDoc`.`participant`, `EventsDoc`.`encadrant`, `EventsDoc`.`participant_visible` FROM `ExtranetFFH`.`events_docs` AS `EventsDoc` WHERE `event_id` = 30297 AND `categorie` = 1 AND `published` = 1000
27SELECT `EventsSite`.`id`, `EventsSite`.`first`, `EventsSite`.`user_id`, `EventsSite`.`event_id`, `EventsSite`.`name`, `EventsSite`.`etranger`, `EventsSite`.`adresse_ligne1`, `EventsSite`.`adresse_ligne2`, `EventsSite`.`adresse_ligne3`, `EventsSite`.`adresse_ligne4`, `EventsSite`.`code_postal`, `EventsSite`.`commune`, `EventsSite`.`adresse_etranger`, `EventsSite`.`lat`, `EventsSite`.`long`, `EventsSite`.`created`, `EventsSite`.`modified`, `EventsSite`.`published`, `EventsSite`.`commentaires`, `EventsSite`.`change` FROM `ExtranetFFH`.`events_sites` AS `EventsSite` WHERE `event_id` = 30297 AND `name` = 'lieu principal' LIMIT 1110