Retour calendrier
PARTAGER
France 17 / CHARENTE-MARITIME
Stage départemental Jeune multisport - Charente-Maritime (FRA) - 2018
26/10/2018
Photo © M LE GALL
Ouvert à tous les jeunes de 6 à 20 ans, en situation de handicap moteur et sensoriel, sur inscription préalable
Contact
COMITE DEPARTEMENTAL HANDISPORT DE CHARENTE-MARITIME
Mélanie LE GALL
cd17@handisport.org
0662860208
https://www.facebook.com/Comité-Départemental-Handisport-Charente-Maritime
Ajouter à votre calendrier 26/10/2018 26/10/2018 Europe/Paris Stage départemental Jeune multisport - Charente-Maritime (FRA) - 2018 Ouvert à tous les jeunes de 6 à 20 ans, en situation de handicap moteur et sensoriel, sur inscription préalable 17300 ROCHEFORT true DD/MM/YYYY


Haut de page
Activité(s) proposée(s)
Sarbacane
Boccia
Athlétisme
Cyclisme
Tir à l'arc
Tennis de table
Foot à 5
Basket-ball Fauteuil
Torball
Haut de page
Organisateur(s)
COMITE DEPARTEMENTAL HANDISPORT DE CHARENTE-MARITIME
Haut de page
Document(s)
Haut de page
Participants
Fauteuils électriques
Fauteuils manuels
Mal-marchants
Marchants
Déficients visuels
Sourds et mal-entendants

Sexe Mixte,
Age min : 6
Payant : 3 €
Age max : 21
Haut de page
Spectateurs
Ouvert au public
Capacité max : 100
Haut de page
Lieu(x) & Accès
Lieu principal
gymnase du polygône
boulevard Edouard Pouzet
17300 ROCHEFORT
accés google map
(production) 25 queries took 4 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1BEGIN000
2INSERT INTO `ExtranetFFH`.`events_connections` (`event_id`, `user_id`, `created`) VALUES (12553, 0, '2020-06-03 02:16:02')110
3COMMIT000
4SELECT `Event`.`id`, `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`.`debut`, `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_taille_teeshirt`, `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`, (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` = 12553 ORDER BY `Event`.`debut` DESC LIMIT 1111
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` = (12553)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` = (12553)991
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` = '33'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` = '5'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` = '1'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` = '200'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` = '39'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` = '38'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` = '8'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` = '42'110
16SELECT `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` = (12553)110
17SELECT `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` = (12553)110
18SELECT `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` = (12553)111
19SELECT `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`, (`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` = 18111
20SELECT `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` = 12553 AND `EventsHandicap`.`handicap_id` = `Handicap`.`id`) 660
21SELECT `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` = 12553 AND `EventsGenre`.`genre_id` = `Genre`.`id`) 110
22SELECT `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` = 12553 AND `EventsTypesLicence`.`types_licence_id` = `TypesLicence`.`id`) 000
23SELECT `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` = 12553 AND `categorie` = 0 AND `published` = 1110
24SELECT `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` = 12553 AND `categorie` = 1 AND `published` = 1000
25SELECT `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` = 12553 AND `name` = 'lieu principal' LIMIT 1110