RECHERCHER

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




ÉVÉNEMENTS DU MOIS
02 Juin Journée sportive
Randonnée Joëlette Mont Saint Michel (FRA) 2018
Randonnée - Joëlette
35
03 Juin Journée sportive
Randonnée Joëlette Mont Saint Michel (FRA) 2018
Randonnée - Joëlette
35
05 Juin Journée sportive
Sensibilisation à la notion de handicap - TAP - THORIGNE FOUILLARD - 2018
Basket-ball Fauteuil, Sarbacane, Boccia, Torball THORIGNE FOUILLARD
35
05 Juin Journée sportive
Ecole de sport DV RENNES (FRA) 2018
Goalball, Foot à 5 DV, Athlétisme
35
06 Juin Journée sportive
Centre d'Initiation Handisport - RENNES (FRA) 2018
Sarbacane, Boccia, Foot fauteuil électrique, Tir
à l'arc, Athlétisme, Voile
35
06 Juin Journée sportive
Créneau Futsal - RENNES - 2018
Foot à 5 en salle
35
07 Juin Journée sportive
Découverte Centres de Rééducation - Canoë Kayak - ST GREGOIRE (FRA) 2018
Canoë-kayak - Pirogue ST GREGOIRE
35
12 Juin Journée sportive
Encadrement sportif Boccia / Sarbacane - BRUZ (FRA) - 2018
Boccia, Sarbacane
35
12 Juin Journée sportive
Sensibilisation à la notion de handicap - TAP - THORIGNE FOUILLARD - 2018
Basket-ball Fauteuil, Sarbacane, Boccia, Torball
35
12 Juin Journée sportive
Ecole de sport DV RENNES (FRA) 2018
Goalball, Foot à 5 DV, Athlétisme
35
13 Juin Challenge
Gand Prix Départemental Jeunes - Sport de Nature -RENNES (FRA) - 2018
Aviron RENNES
35
16 Juin Journée sportive
Randonnée Joëlette GENETS (FRA) 2018
Randonnée - Joëlette GENETS
35
19 Juin Journée sportive
Ecole de sport DV RENNES (FRA) 2018
Goalball, Foot à 5 DV, Athlétisme
35
19 Juin Réunion
Orientation handisport Centre de rééducation - RENNES (FRA) - 2018
35
19 Juin Journée sportive
Sensibilisation à la notion de handicap - TAP - THORIGNE FOUILLARD - 2018
Basket-ball Fauteuil, Sarbacane, Boccia, Torball
35
20 Juin Journée sportive
Centre d'Initiation Handisport - RENNES (FRA) 2018
Sarbacane, Boccia, Foot fauteuil électrique, Tir
à l'arc, Athlétisme, Voile
35
20 Juin Journée sportive
Créneau Futsal - RENNES - 2018
Foot à 5 en salle
35
24 Juin Journée sportive
Randonnée Joëlette DINARD (FRA) 2018
Randonnée - Joëlette DINARD
35
25 29 Juin Séjour
Voile et joélette avec des jeunes de 12/15 ans licenciés à l'AS à Saint Malo (56)
Voile, Randonnée - Joëlette ST MALO
35
26 Juin Journée sportive
Ecole de sport DV RENNES (FRA) 2018
Goalball, Foot à 5 DV, Athlétisme
35
26 Juin Journée sportive
Encadrement sportif Boccia / Sarbacane - BRUZ (FRA) - 2018
Boccia, Sarbacane
35
26 Juin Journée sportive
Sensibilisation à la notion de handicap - TAP - THORIGNE FOUILLARD - 2018
Basket-ball Fauteuil, Sarbacane, Boccia, Torball
35
27 Juin Journée sportive
Centre d'Initiation Handisport - RENNES (FRA) 2018
Sarbacane, Boccia, Foot fauteuil électrique, Tir
à l'arc, Athlétisme, Voile
35
27 Juin Réunion
Orientation handisport Centre de rééducation - RENNES (FRA) - 2018
35
27 Juin Journée sportive
Créneau Futsal - RENNES - 2018
Foot à 5 en salle
35
29 Juin Réunion
Orientation handisport Centre de rééducation - RENNES (FRA) - 2018
35
Voir les événements suivants de ce mois

05 Juil Journée sportive
Découverte Centres de Rééducation - SURF - ST MALO (FRA) 2018
Surf ST MALO
35
Voir les événements suivants de ce mois

24 26 août Séjour
Séjour Sport de Nature DINARD 2018
Canoë-kayak - Pirogue, Voile, Ski nautique DINARD
35
31 août Journée sportive
BREIZH RUNNER - RENNES(FRA) - 2018
Athlétisme, Basket-ball Fauteuil, Cyclisme
Handcycle
RENNES
35
31 août Colloque/conférence
Colloque Athlétisme Lame de Course - RENNES (FRA) - 2018
RENNES
35
Voir les événements suivants de ce mois

12 sep Réunion
Portes Ouvertes pour les jeunes au Handisport Rennes Club - RENNES 2018
RENNES
35
13 sep Réunion
Réunion de rentrée du CDH35 - RENNES 2018
RENNES
35
13 sep Journée sportive
Sensibilisation à la notion de handicap - Université RENNES 1 - RENNES 2018
Basket-ball Fauteuil, Athlétisme, Boccia RENNES
35
19 sep Journée sportive
Centre d'Initiation Handisport - RENNES 2018
Course d'orientation RENNES
35
26 sep Journée sportive
Centre d'Initiation Handisport - RENNES 2018
Course d'orientation
35
28 sep Journée sportive
Sensibilisation à la notion de handicap - INSA RENNES - 2018
Basket-ball Fauteuil, Sarbacane, Athlétisme RENNES
35
Voir les événements suivants de ce mois

03 oct Journée sportive
Centre d'Initiation Handisport - RENNES 2018
Course d'orientation
35
04 oct Journée sportive
Sensibilisation à la notion de handicap - Lycée de la Salle - RENNES 2018
Basket-ball Fauteuil RENNES
35
04 oct Journée sportive
Sensibilisation à la notion de handicap - RENNES 2018
Boccia, Sarbacane RENNES
35
10 oct Journée sportive
Grand Prix Départemental Jeunes Sport de Nature - RENNES 2018
Aviron RENNES
35
Voir les événements suivants de ce mois

06 nov Colloque/conférence
Sensibilisation à la notion de handicap - Ecole des Hautes Etudes en Santé Publique - RENNES 2018
RENNES
35
07 nov Journée sportive
Test de classification pour les jeunes - RENNES 2018
Boccia RENNES
35
12 nov Formation
Information sur le Handisport - Formation service civique - RENNES 2018
RENNES
35
14 nov Journée sportive
Centre d'Initiation Handisport - RENNES 2018
Badminton, Boccia RENNES
35
21 nov Journée sportive
Centre d'Initiation Handisport - RENNES 2018
Badminton, Boccia
35
27 nov Assemblée générale
Assemblée Générale du CDH 35 - RENNES 2018
RENNES
35
28 nov Journée sportive
Grand Prix Départemental Jeunes Duel - QUEDILLAC 2018
Badminton, Boccia, Escrime QUEDILLAC
35
Voir les événements suivants de ce mois

05 déc Journée sportive
Centre d'Initiation Handisport - RENNES 2018
Badminton, Boccia
35
12 déc Journée sportive
Centre d'Initiation Handisport - RENNES 2018
Badminton, Boccia
35
Voir les événements suivants de ce mois

09 Janv 09 Janv 19 Journée sportive
Centre d'Initiation Handisport - RENNES 2019
Sarbacane, Boccia, Tir à l'arc, Slalom, Parcours
moteur
35
16 Janv 16 Janv 19 Journée sportive
Centre d'Initiation Handisport - RENNES 2019
Sarbacane, Boccia, Tir à l'arc, Slalom, Parcours
moteur
35
23 Janv 23 Janv 19 Journée sportive
Centre d'Initiation Handisport - RENNES 2019
Sarbacane, Boccia, Tir à l'arc, Slalom, Parcours
moteur
35
30 Janv 30 Janv 19 Journée sportive
Centre d'Initiation Handisport - RENNES 2019
Sarbacane, Boccia, Tir à l'arc, Slalom, Parcours
moteur
35
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) 140 queries took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Departement`.`NCCENR`, `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `id` = '050350035' 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` ASC23230
3SELECT `Structure`.`StructureCodeRegion` FROM `ExtranetFFH`.`structures` AS `Structure` WHERE `StructureCode` = '050350035' LIMIT 1110
4SELECT `EventsSport`.`id`, `EventsSport`.`sport_id` FROM `ExtranetFFH`.`events_sports` AS `EventsSport` WHERE 1 = 1 GROUP BY sport_id99990
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', '47', '48', '49', '50', '51', '52', '53', '54', '55', '58', '59', '60', '61', '62', '63', '64', '65', '66', '68', '69', '70', '71', '72', '73', '74', '75', '76', '79', '80', '82', '85', '86', '89', '90', '91', '92', '93', '95', '98', '99', '101', '104', '106', '108', '109', '110', '111', '112', '113', '114', '115', '116', '117', '200', '995', '996', '999') ORDER BY `name` ASC98980
6SELECT `Event`.`id`, `Event`.`types_event_id` FROM `ExtranetFFH`.`events` AS `Event` WHERE `published` = 1 AND `Event`.`departement_id` = '050350035' GROUP BY `Event`.`types_event_id` ORDER BY `Event`.`debut` DESC18180
7SELECT `TypesEvent`.`id`, `TypesEvent`.`name` FROM `ExtranetFFH`.`types_events` AS `TypesEvent` WHERE `id` IN (117, 13, 136, 38, 81, 50, 41, 122, 72, 107, 1, 43, 14, 66, 110, 12, 137, 112) ORDER BY `TypesEvent`.`name` ASC18180
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`.`user_id`, `Event`.`user_structure_id`, `Event`.`name2`, `Event`.`name`, `Event`.`short_name`, `Event`.`created`, `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`.`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`.`participant_doc_admin`, `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_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`, (MONTH(`Event`.`debut`)) AS `Event__monthDebut`, (YEAR(`Event`.`debut`)) AS `Event__yearDebut`, (MONTH(`Event`.`fin`)) AS `Event__monthFin`, (YEAR(`Event`.`fin`)) AS `Event__yearFin`, (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 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` = '050350035'000
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` ASC23230
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` = '050350035' AND `published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2018') AND (MONTH(`Event`.`debut`) = '06'))) OR (((YEAR(`Event`.`debut2`) = '2018') AND (MONTH(`Event`.`debut2`) = '06')))) ORDER BY `Event`.`debut` ASC LIMIT 10026260
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 (11398, 11399, 10516, 10491, 9148, 10490, 10524, 10501, 10520, 10494, 10530, 11400, 10496, 10510, 10521, 10500, 10493, 11401, 11360, 10497, 10503, 10522, 10502, 10519, 10495, 10514)61610
12SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
13SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
14SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '20'110
15SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '39'110
16SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
17SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '45'110
18SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '19'110
19SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '21'110
20SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '116'110
21SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
22SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '19'110
23SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '21'110
24SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '116'110
25SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
26SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '19'110
27SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '21'110
28SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '116'110
29SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
30SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '21'110
31SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '116'110
32SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
33SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
34SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
35SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '20'110
36SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '39'110
37SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
38SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '45'110
39SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
40SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
41SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
42SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
43SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '20'110
44SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '39'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` = '45'110
47SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
48SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
49SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'110
50SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
51SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
52SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '42'110
53SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'110
54SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
55SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
56SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '42'110
57SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'110
58SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
59SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
60SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '42'110
61SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'110
62SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
63SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
64SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '42'110
65SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '7'110
66SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '2'110
67SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '45'110
68SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '25'110
69SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '25'110
70SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '25'110
71SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '25'110
72SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '25'110
73SELECT `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` = '050350035' AND `published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2018') AND (MONTH(`Event`.`debut`) = '07'))) OR (((YEAR(`Event`.`debut2`) = '2018') AND (MONTH(`Event`.`debut2`) = '07')))) ORDER BY `Event`.`debut` ASC LIMIT 100110
74SELECT `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` = (10525)110
75SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '98'110
76SELECT `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` = '050350035' AND `published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2018') AND (MONTH(`Event`.`debut`) = '08'))) OR (((YEAR(`Event`.`debut2`) = '2018') AND (MONTH(`Event`.`debut2`) = '08')))) ORDER BY `Event`.`debut` ASC LIMIT 100330
77SELECT `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 (10433, 11536, 11537)660
78SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '7'110
79SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '45'110
80SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '35'110
81SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
82SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'110
83SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '24'110
84SELECT `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` = '050350035' AND `published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2018') AND (MONTH(`Event`.`debut`) = '09'))) OR (((YEAR(`Event`.`debut2`) = '2018') AND (MONTH(`Event`.`debut2`) = '09')))) ORDER BY `Event`.`debut` ASC LIMIT 100660
85SELECT `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 (11787, 11785, 11786, 11788, 11789, 11790)880
86SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'110
87SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
88SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
89SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '10'110
90SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '10'110
91SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'110
92SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
93SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
94SELECT `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` = '050350035' AND `published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2018') AND (MONTH(`Event`.`debut`) = '10'))) OR (((YEAR(`Event`.`debut2`) = '2018') AND (MONTH(`Event`.`debut2`) = '10')))) ORDER BY `Event`.`debut` ASC LIMIT 100440
95SELECT `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 (11791, 11793, 11794, 11795)550
96SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '10'110
97SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'110
98SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
99SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
100SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '2'110
101SELECT `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` = '050350035' AND `published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2018') AND (MONTH(`Event`.`debut`) = '11'))) OR (((YEAR(`Event`.`debut2`) = '2018') AND (MONTH(`Event`.`debut2`) = '11')))) ORDER BY `Event`.`debut` ASC LIMIT 100770
102SELECT `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 (11796, 11797, 11798, 11799, 11800, 11801, 11802)880
103SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
104SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '104'110
105SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
106SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '104'110
107SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
108SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '104'110
109SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
110SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '17'110
111SELECT `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` = '050350035' AND `published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2018') AND (MONTH(`Event`.`debut`) = '12'))) OR (((YEAR(`Event`.`debut2`) = '2018') AND (MONTH(`Event`.`debut2`) = '12')))) ORDER BY `Event`.`debut` ASC LIMIT 100220
112SELECT `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 (11803, 11804)440
113SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '104'110
114SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
115SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '104'110
116SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
117SELECT `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` = '050350035' AND `published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2019') AND (MONTH(`Event`.`debut`) = '01'))) OR (((YEAR(`Event`.`debut2`) = '2019') AND (MONTH(`Event`.`debut2`) = '01')))) ORDER BY `Event`.`debut` ASC LIMIT 100440
118SELECT `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 (11805, 11806, 11807, 11808)20200
119SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
120SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
121SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '39'110
122SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '996'110
123SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '995'110
124SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
125SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
126SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '39'110
127SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '996'110
128SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '995'110
129SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
130SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
131SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '39'110
132SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '996'110
133SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '995'110
134SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
135SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
136SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '39'110
137SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '996'110
138SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '995'110
139SELECT `FamillesEvent`.`id`, `FamillesEvent`.`name` FROM `ExtranetFFH`.`familles_events` AS `FamillesEvent` WHERE 1 = 1 ORDER BY `name` ASC10100
140SELECT `Handicap`.`id`, `Handicap`.`name` FROM `ExtranetFFH`.`handicaps` AS `Handicap` WHERE 1 = 1 ORDER BY `name` ASC770