Notice (8): compact(): Undefined variable: reg [APP/Controller/EventsController.php, line 302]
Calendrier des événements handisport:
RECHERCHER

Notice (8): Undefined variable: dep [APP/View/Elements/bloc_calendar_search.ctp, line 92]
Période du
au




ÉVÉNEMENTS DU MOIS
07 Mars Cycle / Evénement récurrent
PEP'S - Marseille - 2025
Sarbacane MARSEILLE
13
08 Mars Journée sportive
INITIATION BOCCIA MARIGNANE 2025
Boccia MARIGNANE
13
10 Mars Journée sportive
Sensibilisation Cécifoot - GARDANNE- 2025
Foot à 5 DV GARDANNE
13
11 Mars Journée sportive
Sensibilisation Handisport - Entreprise TALENTEO - MARSEILLE - 2025
Tennis de table, Boccia MARSEILLE
13
14 Mars Cycle / Evénement récurrent
PEP'S - Marseille - 2025
Sarbacane MARSEILLE
13
21 Mars Cycle / Evénement récurrent
PEP'S - Marseille - 2025
Sarbacane MARSEILLE
13
25 Mars Journée sportive
Journée Handicap et Sport - Tarascon - 2025
Boccia, Sarbacane, Volley-ball TARASCON
13
28 Mars Cycle / Evénement récurrent
PEP'S - Marseille - 2025
Sarbacane MARSEILLE
13
31 Mars 04 Avr Journée sportive
Tournée La Provence Terre de sports - MARSEILLE - 2025
Cyclisme Handcycle MARSEILLE
13
Voir les événements suivants de ce mois

07 09 Avr Stage
Stage multisports pour déficients visuels du 07 au 09 avril 2025
Athlétisme, Natation, Torball MARSEILLE
13
23 Avr Challenge
Challenge Sarbacane Handisport et Sport Adapté - MARSEILLE - 2025
Sarbacane MARSEILLE
13
29 Avr Journée sportive
Sensibilisation collège Izzo- MARSEILLE - 2025
Basket-ball Fauteuil, Boccia, Volley-ball,
Athlétisme, Torball, Escalade
MARSEILLE
13
Voir les événements suivants de ce mois

01 31 Mai Journée sportive
Activités Sportives - BOUCHES-DU-RHÔNE - 2025
Randonnée, Escalade, Showdown , Echecs, Foot à 5
DV, Musculation, Voile
MARSEILLE
13
07 Mai Journée sportive
Journée multi sport - MARSEILLE - 2025
Boccia, Basket-ball Fauteuil, Sarbacane,
Volley-ball, Athlétisme, Foot à 5, Foot fauteuil
électrique
MARSEILLE
13
07 Mai Challenge
Challenge - MARSEILLE (FRA) - 2025
Foot à 5 DV, Basket-ball Fauteuil, Boccia,
Volley-ball, Athlétisme
MARSEILLE
13
10 Mai Championnat - Phase(s) qualificative(s)
Championnat régional doublette féminin & masculin - - VITROLLES - 2025
Sports de Boules - Pétanque - sourd VITROLLES
13
11 Mai Course
Course Course courir ensemble - Athlétisme - MARSEILLE - 2025
Athlétisme MARSEILLE
13
12 13 Mai Journée sportive
Tournée Terre de Sport - SAINT-ETIENNE-DU-GRES - 2025
Cyclisme, Foot à 5 ST ETIENNE DU GRES
13
14 Mai Championnat - Phase(s) qualificative(s)
Compétition Départementale de Boccia BC - MARSEILLE - 2025
Boccia MARSEILLE
13
20 Mai Journée sportive
Handi Karting - MARTIGUES - 2025
Karting MARTIGUES
13
21 Mai Challenge
Challenge Multisport adulte - MARSEILLE (FRA) - 2025
Multisports MARSEILLE
13
28 Mai Journée sportive
Handi Karting - MARTIGUES - 2025
Karting MARTIGUES
13
Voir les événements suivants de ce mois

01 30 Juin Journée sportive
Activités Sportives - BOUCHES-DU-RHÔNE - 2025
Randonnée, Escalade, Showdown , Echecs, Foot à 5
DV, Musculation, Musculation
MARSEILLE
13
07 Juin Journée sportive
Hand Fauteuil - COUDOUX - 2025
Handball COUDOUX
13
07 Juin Tournoi
Tournoi - Sports de Boules - Pétanque - AUBAGNE - 2025
Sports de Boules - Pétanque AUBAGNE
13
10 Juin Journée sportive
Journée découverte escalade - MARSEILLE - 2025
Escalade MARSEILLE
13
10 Juin Journée sportive
Handi Karting - MARTIGUES - 2025
Karting MARTIGUES
13
12 Juin Journée sportive
Journée découverte escalade - MARSEILLE - 2025
Escalade MARSEILLE
13
14 15 Juin Championnat - Phase(s) finale(s)
Championnat de France 50m - Natation - AIX EN PROVENCE (FRA) - 2025
Natation AIX EN PROVENCE
13
14 15 Juin Challenge
Challenge MC Swim Challenge 7 - MARSEILLE - 2025
Natation MARSEILLE
13
17 Juin Journée sportive
Journée découverte joëlette - GEMENOS - 2025
Randonnée - Joëlette GEMENOS
13
21 22 Juin Circuit
Championnat de France Division 2 - Goalball - SAINT-MARTIN-DE-CRAU (FRA)
Goalball ST MARTIN DE CRAU
13
25 Juin Journée sportive
Handi Karting - MARTIGUES - 2025
Karting MARTIGUES
13
25 Juin Journée sportive
Handi fête journée sportive inclusive - AUBAGNE - 2025
Parcours moteur AUBAGNE
13
28 Juin Journée sportive
Journée sensibilisation au handicap - PLAN DU CUQUES - 2025
Parcours moteur PLAN DE CUQUES
13
Voir les événements suivants de ce mois

05 oct Course
Course Marathon, semi-marathon et 10km. - Athlétisme - SALON DE PROVENCE (FRA) - 2025
Athlétisme SALON DE PROVENCE
13
Voir les événements suivants de ce mois



SIGNALER
ÉVÉNEMENT OUBLIÉ !
Un événement n'apparait pas sur le calendrier ? Vous souhaitez nous en informer ? Remplissez le formulaire ci-dessous.

S'ABONNER
EVÉNÉMENTS COUPS DE COEUR
Vous souhaitez être informé, lorsqu'un nouvel événement que vous aimez, est ajouté ? Abonnez-vous et recevez vos alertes événements personnalisés !

CIBLER
VOTRE CALENDRIER THÉMATIQUE
Retrouvez votre calendrier personnalisé, par sport, région ou département, en cliquant sur la thématique de votre choix. Gardez-le en « favoris », ou créez un lien direct sur votre site !


(production) 98 queries took 168 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Departement`.`NCCENR`, `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `id` = '210130013' ORDER BY `Departement`.`DEP` ASC LIMIT 1110
2SELECT `Structure`.`StructureCode`, (SELECT name FROM regions where `regions`.`id` = `Structure`.`StructureCode`) AS `Structure__Region` FROM `ExtranetFFH`.`structures` AS `Structure` WHERE `StructureType` = 'LIG' AND `StructureEtat` = 'A' ORDER BY `StructureNomCourt` ASC22220
3SELECT `Structure`.`StructureCodeRegion` FROM `ExtranetFFH`.`structures` AS `Structure` WHERE `StructureCode` = '210130013' LIMIT 1112
4SELECT `EventsSport`.`id`, `EventsSport`.`sport_id` FROM `ExtranetFFH`.`events_sports` AS `EventsSport` WHERE 1 = 1 GROUP BY sport_id1101100
5SELECT `Sport`.`id`, `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `id` IN ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '26', '27', '28', '30', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '47', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '63', '64', '65', '66', '68', '69', '70', '71', '72', '73', '74', '75', '76', '78', '79', '80', '82', '83', '85', '86', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '99', '101', '104', '105', '106', '108', '109', '110', '111', '112', '113', '114', '115', '116', '117', '118', '200', '995', '996', '997', '998', '999') ORDER BY `name` ASC1091090
6SELECT `Event`.`id`, `Event`.`types_event_id` FROM `ExtranetFFH`.`events` AS `Event` WHERE `published` = 1 AND `Event`.`departement_id` = '210130013' GROUP BY `Event`.`types_event_id` ORDER BY `Event`.`debut` DESC242421
7SELECT `TypesEvent`.`id`, `TypesEvent`.`name` FROM `ExtranetFFH`.`types_events` AS `TypesEvent` WHERE `id` IN (100, 138, 55, 81, 99, 43, 0, 13, 38, 1, 117, 136, 63, 66, 20, 110, 134, 112, 41, 14, 12, 50, 122, 137) ORDER BY `TypesEvent`.`name` ASC23230
8SELECT `EventsUne`.`id`, `EventsUne`.`structure_id`, `EventsUne`.`event_id`, `EventsUne`.`active`, `EventsUne`.`created`, `EventsUne`.`modified`, `EventsUne`.`add_user_id`, `EventsUne`.`type_une`, `EventsUne`.`type_une_id`, `EventsUne`.`photo`, `EventsUne`.`credit_photo`, `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` FROM `ExtranetFFH`.`events_unes` AS `EventsUne` LEFT JOIN `ExtranetFFH`.`events` AS `Event` ON (`EventsUne`.`event_id` = `Event`.`id`) WHERE `type_une_id` = '210130013'002
9SELECT `Structure`.`StructureCode`, (SELECT name FROM regions where `regions`.`id` = `Structure`.`StructureCode`) AS `Structure__Region` FROM `ExtranetFFH`.`structures` AS `Structure` WHERE `StructureType` = 'LIG' AND `StructureEtat` = 'A' ORDER BY `StructureNomCourt` ASC22220
10SELECT `Event`.`name`, `Event`.`debut`, `Event`.`fin`, `Event`.`debut2`, `Event`.`fin2`, `Event`.`annulation`, `Event`.`country_id`, `Event`.`commune`, `Event`.`report`, `TypesEvent`.`id`, `TypesEvent`.`name`, `Country`.`id`, `Country`.`alpha3`, `Country`.`name`, `Departement`.`DEP`, `Departement`.`name`, `Departement`.`id`, `Event`.`id` FROM `ExtranetFFH`.`events` AS `Event` LEFT JOIN `ExtranetFFH`.`types_events` AS `TypesEvent` ON (`Event`.`types_event_id` = `TypesEvent`.`id`) 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`.`departement_id` = '210130013' AND `published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2025') AND (MONTH(`Event`.`debut`) = '03'))) OR (((YEAR(`Event`.`debut2`) = '2025') AND (MONTH(`Event`.`debut2`) = '03')))) ORDER BY `Event`.`debut` ASC LIMIT 2009920
11SELECT `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` IN (31138, 30826, 31149, 31147, 31139, 31141, 31140, 31142, 31143)12121
12SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
13SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
14SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
15SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
16SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
17SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '52'110
18SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
19SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
20SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '24'110
21SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '38'110
22SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
23SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '116'110
24SELECT `EventsSite`.`commune`, `EventsSite`.`event_id` FROM `ExtranetFFH`.`events_sites` AS `EventsSite` WHERE `first` = 1 AND `EventsSite`.`event_id` IN (31138, 30826, 31149, 31147, 31139, 31141, 31140, 31142, 31143)990
25SELECT `Event`.`name`, `Event`.`debut`, `Event`.`fin`, `Event`.`debut2`, `Event`.`fin2`, `Event`.`annulation`, `Event`.`country_id`, `Event`.`commune`, `Event`.`report`, `TypesEvent`.`id`, `TypesEvent`.`name`, `Country`.`id`, `Country`.`alpha3`, `Country`.`name`, `Departement`.`DEP`, `Departement`.`name`, `Departement`.`id`, `Event`.`id` FROM `ExtranetFFH`.`events` AS `Event` LEFT JOIN `ExtranetFFH`.`types_events` AS `TypesEvent` ON (`Event`.`types_event_id` = `TypesEvent`.`id`) 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`.`departement_id` = '210130013' AND `published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2025') AND (MONTH(`Event`.`debut`) = '04'))) OR (((YEAR(`Event`.`debut2`) = '2025') AND (MONTH(`Event`.`debut2`) = '04')))) ORDER BY `Event`.`debut` ASC LIMIT 2003317
26SELECT `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` IN (31240, 31145, 31146)10101
27SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
28SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'110
29SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
30SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '52'110
31SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
32SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '42'110
33SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '16'110
34SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
35SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '28'110
36SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '42'110
37SELECT `EventsSite`.`commune`, `EventsSite`.`event_id` FROM `ExtranetFFH`.`events_sites` AS `EventsSite` WHERE `first` = 1 AND `EventsSite`.`event_id` IN (31240, 31145, 31146)330
38SELECT `Event`.`name`, `Event`.`debut`, `Event`.`fin`, `Event`.`debut2`, `Event`.`fin2`, `Event`.`annulation`, `Event`.`country_id`, `Event`.`commune`, `Event`.`report`, `TypesEvent`.`id`, `TypesEvent`.`name`, `Country`.`id`, `Country`.`alpha3`, `Country`.`name`, `Departement`.`DEP`, `Departement`.`name`, `Departement`.`id`, `Event`.`id` FROM `ExtranetFFH`.`events` AS `Event` LEFT JOIN `ExtranetFFH`.`types_events` AS `TypesEvent` ON (`Event`.`types_event_id` = `TypesEvent`.`id`) 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`.`departement_id` = '210130013' AND `published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2025') AND (MONTH(`Event`.`debut`) = '05'))) OR (((YEAR(`Event`.`debut2`) = '2025') AND (MONTH(`Event`.`debut2`) = '05')))) ORDER BY `Event`.`debut` ASC LIMIT 200101017
39SELECT `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` IN (32081, 32082, 31616, 32084, 32088, 32089, 31148, 32093, 31617, 32090)27272
40SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
41SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '116'110
42SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'110
43SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
44SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '52'110
45SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
46SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '999'110
47SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '32'110
48SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '16'110
49SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '111'110
50SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '113'110
51SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '116'110
52SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '59'110
53SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '45'110
54SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
55SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'110
56SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
57SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '52'110
58SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
59SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '8'110
60SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '20'110
61SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '95'110
62SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
63SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '200'110
64SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '8'110
65SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '27'110
66SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '27'110
67SELECT `EventsSite`.`commune`, `EventsSite`.`event_id` FROM `ExtranetFFH`.`events_sites` AS `EventsSite` WHERE `first` = 1 AND `EventsSite`.`event_id` IN (32081, 32082, 31616, 32084, 32088, 32089, 31148, 32093, 31617, 32090)10100
68SELECT `Event`.`name`, `Event`.`debut`, `Event`.`fin`, `Event`.`debut2`, `Event`.`fin2`, `Event`.`annulation`, `Event`.`country_id`, `Event`.`commune`, `Event`.`report`, `TypesEvent`.`id`, `TypesEvent`.`name`, `Country`.`id`, `Country`.`alpha3`, `Country`.`name`, `Departement`.`DEP`, `Departement`.`name`, `Departement`.`id`, `Event`.`id` FROM `ExtranetFFH`.`events` AS `Event` LEFT JOIN `ExtranetFFH`.`types_events` AS `TypesEvent` ON (`Event`.`types_event_id` = `TypesEvent`.`id`) 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`.`departement_id` = '210130013' AND `published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2025') AND (MONTH(`Event`.`debut`) = '06'))) OR (((YEAR(`Event`.`debut2`) = '2025') AND (MONTH(`Event`.`debut2`) = '06')))) ORDER BY `Event`.`debut` ASC LIMIT 200131317
69SELECT `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` IN (32059, 32063, 32066, 32069, 32071, 32070, 29742, 32075, 32076, 32024, 32072, 32080, 32078)19191
70SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '28'110
71SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '21'110
72SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '32'110
73SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '16'110
74SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '111'110
75SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '113'110
76SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '116'110
77SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '59'110
78SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '59'110
79SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '74'110
80SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '6'110
81SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '16'110
82SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '16'110
83SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '27'110
84SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '27'110
85SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '28'110
86SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '25'110
87SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '995'110
88SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '995'110
89SELECT `EventsSite`.`commune`, `EventsSite`.`event_id` FROM `ExtranetFFH`.`events_sites` AS `EventsSite` WHERE `first` = 1 AND `EventsSite`.`event_id` IN (32059, 32063, 32066, 32069, 32071, 32070, 29742, 32075, 32076, 32024, 32072, 32080, 32078)13130
90SELECT `Event`.`name`, `Event`.`debut`, `Event`.`fin`, `Event`.`debut2`, `Event`.`fin2`, `Event`.`annulation`, `Event`.`country_id`, `Event`.`commune`, `Event`.`report`, `TypesEvent`.`id`, `TypesEvent`.`name`, `Country`.`id`, `Country`.`alpha3`, `Country`.`name`, `Departement`.`DEP`, `Departement`.`name`, `Departement`.`id`, `Event`.`id` FROM `ExtranetFFH`.`events` AS `Event` LEFT JOIN `ExtranetFFH`.`types_events` AS `TypesEvent` ON (`Event`.`types_event_id` = `TypesEvent`.`id`) 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`.`departement_id` = '210130013' AND `published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2025') AND (MONTH(`Event`.`debut`) = '07'))) OR (((YEAR(`Event`.`debut2`) = '2025') AND (MONTH(`Event`.`debut2`) = '07')))) ORDER BY `Event`.`debut` ASC LIMIT 2000017
91SELECT `Event`.`name`, `Event`.`debut`, `Event`.`fin`, `Event`.`debut2`, `Event`.`fin2`, `Event`.`annulation`, `Event`.`country_id`, `Event`.`commune`, `Event`.`report`, `TypesEvent`.`id`, `TypesEvent`.`name`, `Country`.`id`, `Country`.`alpha3`, `Country`.`name`, `Departement`.`DEP`, `Departement`.`name`, `Departement`.`id`, `Event`.`id` FROM `ExtranetFFH`.`events` AS `Event` LEFT JOIN `ExtranetFFH`.`types_events` AS `TypesEvent` ON (`Event`.`types_event_id` = `TypesEvent`.`id`) 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`.`departement_id` = '210130013' AND `published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2025') AND (MONTH(`Event`.`debut`) = '08'))) OR (((YEAR(`Event`.`debut2`) = '2025') AND (MONTH(`Event`.`debut2`) = '08')))) ORDER BY `Event`.`debut` ASC LIMIT 2000017
92SELECT `Event`.`name`, `Event`.`debut`, `Event`.`fin`, `Event`.`debut2`, `Event`.`fin2`, `Event`.`annulation`, `Event`.`country_id`, `Event`.`commune`, `Event`.`report`, `TypesEvent`.`id`, `TypesEvent`.`name`, `Country`.`id`, `Country`.`alpha3`, `Country`.`name`, `Departement`.`DEP`, `Departement`.`name`, `Departement`.`id`, `Event`.`id` FROM `ExtranetFFH`.`events` AS `Event` LEFT JOIN `ExtranetFFH`.`types_events` AS `TypesEvent` ON (`Event`.`types_event_id` = `TypesEvent`.`id`) 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`.`departement_id` = '210130013' AND `published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2025') AND (MONTH(`Event`.`debut`) = '09'))) OR (((YEAR(`Event`.`debut2`) = '2025') AND (MONTH(`Event`.`debut2`) = '09')))) ORDER BY `Event`.`debut` ASC LIMIT 2000017
93SELECT `Event`.`name`, `Event`.`debut`, `Event`.`fin`, `Event`.`debut2`, `Event`.`fin2`, `Event`.`annulation`, `Event`.`country_id`, `Event`.`commune`, `Event`.`report`, `TypesEvent`.`id`, `TypesEvent`.`name`, `Country`.`id`, `Country`.`alpha3`, `Country`.`name`, `Departement`.`DEP`, `Departement`.`name`, `Departement`.`id`, `Event`.`id` FROM `ExtranetFFH`.`events` AS `Event` LEFT JOIN `ExtranetFFH`.`types_events` AS `TypesEvent` ON (`Event`.`types_event_id` = `TypesEvent`.`id`) 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`.`departement_id` = '210130013' AND `published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2025') AND (MONTH(`Event`.`debut`) = '10'))) OR (((YEAR(`Event`.`debut2`) = '2025') AND (MONTH(`Event`.`debut2`) = '10')))) ORDER BY `Event`.`debut` ASC LIMIT 2001116
94SELECT `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` = (29895)110
95SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
96SELECT `EventsSite`.`commune`, `EventsSite`.`event_id` FROM `ExtranetFFH`.`events_sites` AS `EventsSite` WHERE `first` = 1 AND `EventsSite`.`event_id` = (29895)110
97SELECT `FamillesEvent`.`id`, `FamillesEvent`.`name` FROM `ExtranetFFH`.`familles_events` AS `FamillesEvent` WHERE 1 = 1 ORDER BY `name` ASC10100
98SELECT `Handicap`.`id`, `Handicap`.`name` FROM `ExtranetFFH`.`handicaps` AS `Handicap` WHERE 1 = 1 ORDER BY `name` ASC770