RECHERCHER

Période du
au




ÉVÉNEMENTS DU MOIS
02 Juin Stage
REGROUPEMENT / ENTRAINEMENT 2018 athlétisme:boccia;sarbacanne; parcours moteurs SAINTE MARIE
Athlétisme, Natation, Slalom STE MARIE
974
03 Juin Championnat - Phase(s) finale(s)
Championnat de France Semi-Marathon - Athlétisme - SAINT PAUL LES ROMANS (FRA) - 2018
Athlétisme
26
03 Juin Journée sportive
JOURNEE RECREATIVE MULTISPORTS DE LA VILLE DE L ENTRE DEUX A LA REUNION 2018
Athlétisme, Sports de Boules - Pétanque, Foot à
11, Boccia, Cyclisme tricycle
ENTRE DEUX DE LA REUNION
REU
07 Juin Journée sportive
Challenge régional Inter-structures - ANCENIS (FRA) - 2018
Athlétisme, Boccia, Sarbacane, Fléchette
pendulaire, Tennis de table, Goalball, Futsall,
Basket-ball Fauteuil
ANCENIS
44
09 Juin Championnat - Phase(s) finale(s)
Championnat de France Interclubs - Athlétisme - PARTHENAY (FRA) - 2018
Athlétisme PARTHENAY
79
10 Juin Challenge
Challenge POLITIQUE DE LA VILLE DU TAMPON - LE TAMPON (FRA) - 2018
Sports de Boules - Pétanque, Boccia, Athlétisme,
Goalball
LE TAMPON
974
12 Juin 01 Janv 70 Journée sportive
Journée APF - Multisports - Pont du Chateau - 2018
Athlétisme PONT DU CHATEAU
63
13 Juin Journée sportive
Journée régionale - 2018m athlétisme - Zuydcoote - 2018
Athlétisme ZUYDCOOTE
59
14 15 Juin Championnat - Phase(s) finale(s)
Handisport Open Paris - Athlétisme - PARIS CHARLETY (FRA) - 2018
Athlétisme PARIS
75
19 Juin Journée sportive
Journée APF - Multisports - Pont du Chateau - 2018
Athlétisme
63
22 23 Juin Championnat - Phase(s) finale(s)
Championnat de France Elite - Athlétisme - BELFORT (FRA) - 2018
Athlétisme BELFORT
90
23 Juin Journée sportive
Sport et mobilité de pleine nature/ APAJH Rocroi/ 2018
Athlétisme, Randonnée - Joëlette, Cyclisme
Handcycle
ROCROI
08
23 Juin Journée sportive
HandicapSport 32 - Multisport - Auch (FRA) - 23 Juin 2018
Athlétisme, Basket-ball Fauteuil, Boccia,
Cyclisme Handcycle, Foot fauteuil électrique,
Sarbacane, Tennis de table, Tir sportif
AUCH
32
23 Juin Journée sportive
Encadrements ULIS - Multiactivités - BEAUVAIS (FRA) - 2018
Basket-ball Fauteuil, Handball, Athlétisme
60
24 Juin Course
Course COURSE DUO FAMILLE ET ESPOIRE - Athlétisme - 974 (FRA) - 2018
Athlétisme L ETANG SALE
974
30 Juin Journée sportive
Kermesse au CRFME de Warnécourt 2018
Cyclisme Handcycle, Athlétisme, Randonnée -
Joëlette
WARNECOURT
08
30 Juin Journée sportive
Encadrements ULIS - Multiactivités - BEAUVAIS (FRA) - 2018
Basket-ball Fauteuil, Handball, Athlétisme
60
Voir les événements suivants de ce mois

07 Juil Journée sportive
Encadrements ULIS - Multiactivités - BEAUVAIS (FRA) - 2018
Basket-ball Fauteuil, Handball, Athlétisme
60
07 Juil Stage
ECOLE DU SPORT JUILLET 2018 POITIERS
Athlétisme, Tir à l'arc, Tennis de table, Judo,
Taekwondo/Taichi Chuan, Tir sportif, Boccia,
Sarbacane
POITIERS
86
10 Juil Journée sportive
Journée Découverte Handisport Cérébrolésés - MUTLISPORT - Niort (FRA) - 2018
Basket-ball Fauteuil, Sarbacane, Boccia, Tir à
l'arc, Tir sportif, Athlétisme, Cyclisme,
Cyclisme tricycle, Taekwondo/Taichi Chuan, Tennis
de table
NIORT
79
15 Juil Course
Course MARATHON MAURICE - Athlétisme - ST DENIS (FRA) - 2018
Athlétisme
MUS
Voir les événements suivants de ce mois

05 août Course
Course MARATHON DE LA CORNICHE - Athlétisme - ST DENIS (FRA) - 2018
Athlétisme ST DENIS
974
20 26 août Championnat - Phase(s) finale(s)
Championnat d'Europe World Para Athletics - BERLIN (GER) - 2018
Athlétisme
DEU
26 août Journée sportive
Journée ASPHT Boccia Pétanque, Athlétisme
Boccia, Sports de Boules - Pétanque, Athlétisme LE TAMPON
974
31 août Journée sportive
BREIZH RUNNER - RENNES(FRA) - 2018
Athlétisme, Basket-ball Fauteuil, Cyclisme
Handcycle
RENNES
35
Voir les événements suivants de ce mois

08 sep Course
SOLIDARUN COURSE 10KM - Athlétisme - ST PIERRE (FRA) - 2018
Athlétisme ST PIERRE
974
Voir les événements suivants de ce mois

07 oct Concours
MULTI SPORTS JOURNEE HANDISTRACTION BENEDICTINE - ST BENOIT RUN- 2018
Boccia, Basket-ball Fauteuil, Sports de Boules -
Pétanque, Athlétisme
ST BENOIT
REU
18 21 oct Raid
Raid GRAND RAID DE LA REUNION - Athlétisme - ST DENIS (FRA) - 2018
Athlétisme ST DENIS
REU
25 28 oct Stage
Stage Régional handisport jeunes-DIJON-2018
Boccia, Natation, Tir à l'arc, Basket-ball
Fauteuil, Athlétisme, Tennis de table, Sarbacane,
Foot à 5
DIJON
21
26 28 oct Séjour
Séjour multisport-Andrézieux Bouthéon (Loire) du 26 au 28 octobre
Canoë-kayak - Pirogue, Basket-ball Fauteuil,
Escrime, Handball, Equitation, Athlétisme,
Cyclisme
42
Voir les événements suivants de ce mois

03 nov Course
ODYSSEA DE LA REUNION -10KM COURSE NATURE - - L ETANG SALE (FRA) - 2018
Athlétisme L ETANG SALE
974
18 nov Challenge
Challenge JOURNEE REGIONAL ASSOCIATION LIAISON - LE PORT (FRA) - 2018
Boccia, Sports de Boules - Pétanque, Basket-ball
Fauteuil, Athlétisme, Foot à 11, Escrime
LE PORT
974
Voir les événements suivants de ce mois

01 déc Course
Course FOULEES NOCTURNE HANDISPORT DE SAINT DENIS - Athlétisme - ST DENIS (FRA) - 2018
Athlétisme ST DENIS
REU
Voir les événements suivants de ce mois



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

EVENEMENTS COUP DE COEUR
S'ABONNER
Vous souhaitez être informé, lorsqu'un nouvel événement que vous aimez, est ajouté ? Abonnez-vous en renseignant vos critères et votre adresse email.

AUTRES CALENDRIERS
ACCÉDER
Vous souhaitez vous rendre sur le calendrier national multisport ? Pour celà cliquer, ci-dessous, sur le lien de votre choix.



(production) 133 queries took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT SUBSTR(StructureNomCourt,7) as SPORT, `Structure`.`id` FROM `ExtranetFFH`.`structures` AS `Structure` WHERE `StructureCode` = '000000201' 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 `Departement`.`id`, (CONCAT(`Departement`.`DEP`, " / ", `Departement`.`name`)) AS `Departement__numName` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE 1 = 1 ORDER BY (CONCAT(`Departement`.`DEP`, " / ", `Departement`.`name`)) ASC1051050
4SELECT `EventsSport`.`sport_id`, `Sport`.`name` FROM `ExtranetFFH`.`events_sports` AS `EventsSport` LEFT JOIN `ExtranetFFH`.`sports` AS `Sport` ON (`EventsSport`.`sport_id` = `Sport`.`id`) LEFT JOIN `ExtranetFFH`.`events` AS `Event` ON (`EventsSport`.`event_id` = `Event`.`id`) WHERE 1 = 116742167421
5SELECT `Event`.`types_event_id`, `TypesEvent`.`name` FROM `ExtranetFFH`.`events` AS `Event` LEFT JOIN `ExtranetFFH`.`types_events` AS `TypesEvent` ON (`Event`.`types_event_id` = `TypesEvent`.`id`) WHERE `published` = 1 GROUP BY `Event`.`types_event_id` ORDER BY `Event`.`debut` DESC32320
6SELECT `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` = '000000201'000
7SELECT `EventsSport`.`id`, `EventsSport`.`event_id` FROM `ExtranetFFH`.`events_sports` AS `EventsSport` LEFT JOIN `ExtranetFFH`.`sports` AS `Sport` ON (`EventsSport`.`sport_id` = `Sport`.`id`) WHERE `Sport`.`cms` = 2028038030
8SELECT `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
9SELECT `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`.`id` IN (42, 54, 61, 100, 101, 143, 150, 167, 187, 189, 297, 341, 371, 392, 407, 440, 448, 466, 470, 514, 528, 535, 550, 592, 822, 823, 824, 825, 930, 931, 933, 934, 935, 936, 937, 938, 939, 940, 941, 1008, 1105, 1107, 1108, 1137, 1138, 1221, 1231, 1232, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1605, 1645, 1646, 1707, 1708, 1709, 1710, 1711, 1714, 1715, 1716, 1717, 1718, 1721, 1722, 1913, 1914, 1915, 2054, 2069, 2070, 2071, 2072, 2073, 2074, 2075, 2076, 2077, 2079, 2081, 2109, 2110, 2158, 2159, 2160, 2161, 2163, 2164, 2165, 2166, 2167, 2168, 2181, 2502, 2544, 2715, 2731, 2742, 2761, 2763, 2770, 2785, 2794, 2834, 2842, 2844, 2851, 2861, 2901, 2966, 2967, 2971, 2985, 2991, 3003, 3004, 3145, 3182, 3266, 3278, 3310, 3319, 3323, 3423, 3426, 3489, 3490, 3496, 3642, 3686, 3689, 3710, 3716, 3720, 3733, 3518, 3786, 3307, 3993, 4001, 4002, 4003, 4004, 4006, 4008, 4030, 4032, 4038, 4039, 4040, 4162, 4272, 4274, 4304, 4310, 4312, 4482, 4483, 4484, 4489, 4496, 4498, 4502, 4503, 4513, 4506, 4500, 4488, 4486, 4511, 4512, 4507, 4524, 4525, 4549, 4563, 4603, 4490, 4675, 4700, 4701, 4692, 4704, 4724, 4744, 4770, 4789, 4790, 4791, 4792, 4793, 4794, 4795, 4796, 4797, 4798, 4799, 4800, 4809, 4810, 4811, 4812, 4813, 4814, 4851, 4852, 4902, 4907, 4920, 4923, 4933, 4952, 4967, 4972, 4976, 4973, 4996, 4997, 5000, 5003, 5028, 5037, 5043, 5044, 5078, 5085, 5095, 5141, 5162, 3852, 5205, 5206, 5211, 5212, 5218, 5219, 5223, 5224, 5243, 5247, 5249, 5254, 5256, 5293, 5282, 5279, 5294, 5307, 5313, 5314, 5315, 5316, 5363, 4470, 5369, 5375, 5376, 5377, 5383, 5391, 5397, 5408, 5446, 5463, 5490, 5517, 5518, 5551, 5552, 5559, 5575, 5578, 5590, 5592, 5595, 5597, 5627, 5631, 5655, 5704, 5705, 5736, 5738, 5740, 5741, 5761, 5763, 5765, 5770, 5772, 5794, 5809, 5851, 5961, 5962, 6011, 6018, 6021, 6035, 6037, 6038, 6039, 6042, 6119, 6153, 6159, 6260, 6261, 6262, 6263, 6266, 6267, 6268, 6269, 6270, 6271, 6272, 6273, 6274, 6275, 6276, 6277, 6278, 6279, 6280, 6281, 6282, 6283, 6284, 6285, 6286, 6287, 6288, 6289, 6301, 6349, 6382, 6383, 6389, 6404, 6443, 6477, 6581, 6583, 6588, 6624, 6625, 6651, 6654, 6660, 6310, 6674, 6675, 6676, 6677, 6678, 6679, 6680, 6681, 6682, 6683, 6684, 6685, 6686, 6687, 6688, 6689, 6690, 6691, 6692, 6693, 6694, 6695, 6696, 6697, 6698, 6699, 6700, 6701, 6702, 6715, 6724, 5747, 6752, 6760, 6791, 6830, 6831, 6832, 6253, 6837, 6930, 6932, 7001, 7014, 7015, 7073, 7074, 7105, 7142, 7148, 7149, 7150, 7154, 7200, 7201, 7209, 7212, 7217, 7256, 7264, 7276, 7278, 7294, 7298, 7299, 7300, 7309, 7391, 7414, 7438, 7457, 7471, 7474, 7477, 7499, 7500, 7501, 7503, 7517, 7535, 7537, 7540, 7543, 7558, 7560, 7562, 7564, 7566, 7568, 7569, 7570, 7579, 7687, 7699, 7860, 7904, 7907, 7911, 7940, 7980, 7998, 7992, 7997, 7996, 7995, 7993, 7999, 8001, 8002, 8025, 8028, 8038, 8039, 8040, 8044, 8045, 8047, 8076, 8077, 8078, 8080, 8082, 8091, 8098, 8105, 8138, 3829, 8145, 8147, 8148, 5021, 8178, 8200, 8205, 8213, 8224, 8241, 8246, 8250, 8251, 8261, 8262, 8266, 8290, 8302, 8364, 8453, 8471, 8473, 8490, 8493, 8515, 8516, 8521, 7710, 8552, 8557, 8562, 8603, 8604, 8605, 8609, 8612, 8613, 8620, 8623, 8635, 8643, 8646, 8648, 8656, 8675, 8700, 8710, 8711, 8716, 8724, 8739, 8819, 8821, 8824, 8879, 8886, 8894, 8900, 8928, 8940, 9030, 9031, 9032, 9033, 9034, 9037, 9040, 9062, 9087, 9109, 9111, 9113, 9115, 9124, 9128, 9129, 9130, 9131, 9132, 9133, 9134, 9135, 9136, 9137, 9138, 9139, 9140, 9141, 9142, 9143, 9144, 9145, 9146, 9147, 9148, 9159, 9173, 9220, 9270, 9435, 9442, 9443, 9455, 9462, 9475, 9481, 9497, 9525, 9526, 9542, 9555, 9557, 9569, 9570, 9577, 9589, 9591, 9620, 9623, 9630, 9652, 9676, 9680, 9725, 9730, 4171, 9737, 9764, 9860, 9865, 9867, 9871, 9874, 9890, 9891, 9892, 9896, 9950, 9951, 9953, 9954, 10049, 10073, 10217, 10224, 10228, 10230, 10238, 10259, 10274, 10310, 10311, 10313, 10352, 10329, 10332, 10333, 10335, 10342, 10343, 10359, 10366, 10399, 10416, 10417, 10418, 10419, 10432, 10443, 10454, 10457, 10459, 10461, 10462, 10463, 10470, 10474, 10476, 10477, 10479, 10480, 10482, 10485, 10487, 10489, 10491, 10494, 10496, 10497, 10500, 10502, 10529, 10552, 10673, 10680, 10681, 10682, 10683, 10686, 10688, 10692, 10737, 10738, 10739, 10740, 10741, 10761, 10773, 10776, 10777, 10786, 10795, 10810, 10833, 10835, 10839, 10846, 10850, 10246, 10856, 10857, 10865, 10867, 10899, 10900, 10915, 10923, 10924, 10956, 10959, 10981, 11002, 11005, 11007, 11021, 11022, 11023, 11024, 11026, 11027, 11030, 11031, 11032, 11072, 11073, 11074, 11075, 11076, 11080, 11090, 11095, 11110, 11117, 11125, 11163, 11166, 11188, 11196, 11197, 11198, 11199, 10186, 11221, 11222, 11223, 11243, 11281, 11285, 11287, 11297, 11302, 11303, 11310, 11320, 11324, 11339, 11353, 11371, 11372, 11377, 11407, 11419, 11426, 11443, 11468, 11484, 11489, 11492, 11493, 11498, 11490, 11536, 11548, 11553, 11569, 11571, 11702, 11703, 11704, 11705, 11706, 11707, 11708, 11709, 11710, 11711, 11712, 11713, 11714, 11782, 11786, 11790, 11816, 11817, 11818, 11819, 11820) AND `published` = 1 AND `calendar_ffh_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 10017170
10SELECT `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 (11023, 11297, 11080, 11443, 9891, 11024, 11371, 11320, 10217, 11372, 10073, 11569, 9620, 11713, 11026, 11571, 11712)48480
11SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
12SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'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` = '24'110
15SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '20'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` = '38'110
18SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '41'110
19SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
20SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'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` = '1'110
23SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '28'110
24SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '996'110
25SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '6'110
26SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
27SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
28SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '21'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` = '1'110
31SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '6'110
32SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '53'110
33SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
34SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '108'110
35SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
36SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'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` = '1'110
39SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
40SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'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` = '69'110
43SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '38'110
44SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '21'110
45SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '109'110
46SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'110
47SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
48SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '25'110
49SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '24'110
50SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '24'110
51SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
52SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '25'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` = '74'110
55SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
56SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'110
57SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '74'110
58SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
59SELECT `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`.`id` IN (42, 54, 61, 100, 101, 143, 150, 167, 187, 189, 297, 341, 371, 392, 407, 440, 448, 466, 470, 514, 528, 535, 550, 592, 822, 823, 824, 825, 930, 931, 933, 934, 935, 936, 937, 938, 939, 940, 941, 1008, 1105, 1107, 1108, 1137, 1138, 1221, 1231, 1232, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1605, 1645, 1646, 1707, 1708, 1709, 1710, 1711, 1714, 1715, 1716, 1717, 1718, 1721, 1722, 1913, 1914, 1915, 2054, 2069, 2070, 2071, 2072, 2073, 2074, 2075, 2076, 2077, 2079, 2081, 2109, 2110, 2158, 2159, 2160, 2161, 2163, 2164, 2165, 2166, 2167, 2168, 2181, 2502, 2544, 2715, 2731, 2742, 2761, 2763, 2770, 2785, 2794, 2834, 2842, 2844, 2851, 2861, 2901, 2966, 2967, 2971, 2985, 2991, 3003, 3004, 3145, 3182, 3266, 3278, 3310, 3319, 3323, 3423, 3426, 3489, 3490, 3496, 3642, 3686, 3689, 3710, 3716, 3720, 3733, 3518, 3786, 3307, 3993, 4001, 4002, 4003, 4004, 4006, 4008, 4030, 4032, 4038, 4039, 4040, 4162, 4272, 4274, 4304, 4310, 4312, 4482, 4483, 4484, 4489, 4496, 4498, 4502, 4503, 4513, 4506, 4500, 4488, 4486, 4511, 4512, 4507, 4524, 4525, 4549, 4563, 4603, 4490, 4675, 4700, 4701, 4692, 4704, 4724, 4744, 4770, 4789, 4790, 4791, 4792, 4793, 4794, 4795, 4796, 4797, 4798, 4799, 4800, 4809, 4810, 4811, 4812, 4813, 4814, 4851, 4852, 4902, 4907, 4920, 4923, 4933, 4952, 4967, 4972, 4976, 4973, 4996, 4997, 5000, 5003, 5028, 5037, 5043, 5044, 5078, 5085, 5095, 5141, 5162, 3852, 5205, 5206, 5211, 5212, 5218, 5219, 5223, 5224, 5243, 5247, 5249, 5254, 5256, 5293, 5282, 5279, 5294, 5307, 5313, 5314, 5315, 5316, 5363, 4470, 5369, 5375, 5376, 5377, 5383, 5391, 5397, 5408, 5446, 5463, 5490, 5517, 5518, 5551, 5552, 5559, 5575, 5578, 5590, 5592, 5595, 5597, 5627, 5631, 5655, 5704, 5705, 5736, 5738, 5740, 5741, 5761, 5763, 5765, 5770, 5772, 5794, 5809, 5851, 5961, 5962, 6011, 6018, 6021, 6035, 6037, 6038, 6039, 6042, 6119, 6153, 6159, 6260, 6261, 6262, 6263, 6266, 6267, 6268, 6269, 6270, 6271, 6272, 6273, 6274, 6275, 6276, 6277, 6278, 6279, 6280, 6281, 6282, 6283, 6284, 6285, 6286, 6287, 6288, 6289, 6301, 6349, 6382, 6383, 6389, 6404, 6443, 6477, 6581, 6583, 6588, 6624, 6625, 6651, 6654, 6660, 6310, 6674, 6675, 6676, 6677, 6678, 6679, 6680, 6681, 6682, 6683, 6684, 6685, 6686, 6687, 6688, 6689, 6690, 6691, 6692, 6693, 6694, 6695, 6696, 6697, 6698, 6699, 6700, 6701, 6702, 6715, 6724, 5747, 6752, 6760, 6791, 6830, 6831, 6832, 6253, 6837, 6930, 6932, 7001, 7014, 7015, 7073, 7074, 7105, 7142, 7148, 7149, 7150, 7154, 7200, 7201, 7209, 7212, 7217, 7256, 7264, 7276, 7278, 7294, 7298, 7299, 7300, 7309, 7391, 7414, 7438, 7457, 7471, 7474, 7477, 7499, 7500, 7501, 7503, 7517, 7535, 7537, 7540, 7543, 7558, 7560, 7562, 7564, 7566, 7568, 7569, 7570, 7579, 7687, 7699, 7860, 7904, 7907, 7911, 7940, 7980, 7998, 7992, 7997, 7996, 7995, 7993, 7999, 8001, 8002, 8025, 8028, 8038, 8039, 8040, 8044, 8045, 8047, 8076, 8077, 8078, 8080, 8082, 8091, 8098, 8105, 8138, 3829, 8145, 8147, 8148, 5021, 8178, 8200, 8205, 8213, 8224, 8241, 8246, 8250, 8251, 8261, 8262, 8266, 8290, 8302, 8364, 8453, 8471, 8473, 8490, 8493, 8515, 8516, 8521, 7710, 8552, 8557, 8562, 8603, 8604, 8605, 8609, 8612, 8613, 8620, 8623, 8635, 8643, 8646, 8648, 8656, 8675, 8700, 8710, 8711, 8716, 8724, 8739, 8819, 8821, 8824, 8879, 8886, 8894, 8900, 8928, 8940, 9030, 9031, 9032, 9033, 9034, 9037, 9040, 9062, 9087, 9109, 9111, 9113, 9115, 9124, 9128, 9129, 9130, 9131, 9132, 9133, 9134, 9135, 9136, 9137, 9138, 9139, 9140, 9141, 9142, 9143, 9144, 9145, 9146, 9147, 9148, 9159, 9173, 9220, 9270, 9435, 9442, 9443, 9455, 9462, 9475, 9481, 9497, 9525, 9526, 9542, 9555, 9557, 9569, 9570, 9577, 9589, 9591, 9620, 9623, 9630, 9652, 9676, 9680, 9725, 9730, 4171, 9737, 9764, 9860, 9865, 9867, 9871, 9874, 9890, 9891, 9892, 9896, 9950, 9951, 9953, 9954, 10049, 10073, 10217, 10224, 10228, 10230, 10238, 10259, 10274, 10310, 10311, 10313, 10352, 10329, 10332, 10333, 10335, 10342, 10343, 10359, 10366, 10399, 10416, 10417, 10418, 10419, 10432, 10443, 10454, 10457, 10459, 10461, 10462, 10463, 10470, 10474, 10476, 10477, 10479, 10480, 10482, 10485, 10487, 10489, 10491, 10494, 10496, 10497, 10500, 10502, 10529, 10552, 10673, 10680, 10681, 10682, 10683, 10686, 10688, 10692, 10737, 10738, 10739, 10740, 10741, 10761, 10773, 10776, 10777, 10786, 10795, 10810, 10833, 10835, 10839, 10846, 10850, 10246, 10856, 10857, 10865, 10867, 10899, 10900, 10915, 10923, 10924, 10956, 10959, 10981, 11002, 11005, 11007, 11021, 11022, 11023, 11024, 11026, 11027, 11030, 11031, 11032, 11072, 11073, 11074, 11075, 11076, 11080, 11090, 11095, 11110, 11117, 11125, 11163, 11166, 11188, 11196, 11197, 11198, 11199, 10186, 11221, 11222, 11223, 11243, 11281, 11285, 11287, 11297, 11302, 11303, 11310, 11320, 11324, 11339, 11353, 11371, 11372, 11377, 11407, 11419, 11426, 11443, 11468, 11484, 11489, 11492, 11493, 11498, 11490, 11536, 11548, 11553, 11569, 11571, 11702, 11703, 11704, 11705, 11706, 11707, 11708, 11709, 11710, 11711, 11712, 11713, 11714, 11782, 11786, 11790, 11816, 11817, 11818, 11819, 11820) AND `published` = 1 AND `calendar_ffh_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 100440
60SELECT `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 (11711, 11468, 11553, 11027)22220
61SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'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` = '39'110
64SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '38'110
65SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '26'110
66SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '64'110
67SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '41'110
68SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
69SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
70SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'110
71SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
72SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
73SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '39'110
74SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '41'110
75SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
76SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '200'110
77SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '108'110
78SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '64'110
79SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '38'110
80SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'110
81SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '74'110
82SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
83SELECT `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`.`id` IN (42, 54, 61, 100, 101, 143, 150, 167, 187, 189, 297, 341, 371, 392, 407, 440, 448, 466, 470, 514, 528, 535, 550, 592, 822, 823, 824, 825, 930, 931, 933, 934, 935, 936, 937, 938, 939, 940, 941, 1008, 1105, 1107, 1108, 1137, 1138, 1221, 1231, 1232, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1605, 1645, 1646, 1707, 1708, 1709, 1710, 1711, 1714, 1715, 1716, 1717, 1718, 1721, 1722, 1913, 1914, 1915, 2054, 2069, 2070, 2071, 2072, 2073, 2074, 2075, 2076, 2077, 2079, 2081, 2109, 2110, 2158, 2159, 2160, 2161, 2163, 2164, 2165, 2166, 2167, 2168, 2181, 2502, 2544, 2715, 2731, 2742, 2761, 2763, 2770, 2785, 2794, 2834, 2842, 2844, 2851, 2861, 2901, 2966, 2967, 2971, 2985, 2991, 3003, 3004, 3145, 3182, 3266, 3278, 3310, 3319, 3323, 3423, 3426, 3489, 3490, 3496, 3642, 3686, 3689, 3710, 3716, 3720, 3733, 3518, 3786, 3307, 3993, 4001, 4002, 4003, 4004, 4006, 4008, 4030, 4032, 4038, 4039, 4040, 4162, 4272, 4274, 4304, 4310, 4312, 4482, 4483, 4484, 4489, 4496, 4498, 4502, 4503, 4513, 4506, 4500, 4488, 4486, 4511, 4512, 4507, 4524, 4525, 4549, 4563, 4603, 4490, 4675, 4700, 4701, 4692, 4704, 4724, 4744, 4770, 4789, 4790, 4791, 4792, 4793, 4794, 4795, 4796, 4797, 4798, 4799, 4800, 4809, 4810, 4811, 4812, 4813, 4814, 4851, 4852, 4902, 4907, 4920, 4923, 4933, 4952, 4967, 4972, 4976, 4973, 4996, 4997, 5000, 5003, 5028, 5037, 5043, 5044, 5078, 5085, 5095, 5141, 5162, 3852, 5205, 5206, 5211, 5212, 5218, 5219, 5223, 5224, 5243, 5247, 5249, 5254, 5256, 5293, 5282, 5279, 5294, 5307, 5313, 5314, 5315, 5316, 5363, 4470, 5369, 5375, 5376, 5377, 5383, 5391, 5397, 5408, 5446, 5463, 5490, 5517, 5518, 5551, 5552, 5559, 5575, 5578, 5590, 5592, 5595, 5597, 5627, 5631, 5655, 5704, 5705, 5736, 5738, 5740, 5741, 5761, 5763, 5765, 5770, 5772, 5794, 5809, 5851, 5961, 5962, 6011, 6018, 6021, 6035, 6037, 6038, 6039, 6042, 6119, 6153, 6159, 6260, 6261, 6262, 6263, 6266, 6267, 6268, 6269, 6270, 6271, 6272, 6273, 6274, 6275, 6276, 6277, 6278, 6279, 6280, 6281, 6282, 6283, 6284, 6285, 6286, 6287, 6288, 6289, 6301, 6349, 6382, 6383, 6389, 6404, 6443, 6477, 6581, 6583, 6588, 6624, 6625, 6651, 6654, 6660, 6310, 6674, 6675, 6676, 6677, 6678, 6679, 6680, 6681, 6682, 6683, 6684, 6685, 6686, 6687, 6688, 6689, 6690, 6691, 6692, 6693, 6694, 6695, 6696, 6697, 6698, 6699, 6700, 6701, 6702, 6715, 6724, 5747, 6752, 6760, 6791, 6830, 6831, 6832, 6253, 6837, 6930, 6932, 7001, 7014, 7015, 7073, 7074, 7105, 7142, 7148, 7149, 7150, 7154, 7200, 7201, 7209, 7212, 7217, 7256, 7264, 7276, 7278, 7294, 7298, 7299, 7300, 7309, 7391, 7414, 7438, 7457, 7471, 7474, 7477, 7499, 7500, 7501, 7503, 7517, 7535, 7537, 7540, 7543, 7558, 7560, 7562, 7564, 7566, 7568, 7569, 7570, 7579, 7687, 7699, 7860, 7904, 7907, 7911, 7940, 7980, 7998, 7992, 7997, 7996, 7995, 7993, 7999, 8001, 8002, 8025, 8028, 8038, 8039, 8040, 8044, 8045, 8047, 8076, 8077, 8078, 8080, 8082, 8091, 8098, 8105, 8138, 3829, 8145, 8147, 8148, 5021, 8178, 8200, 8205, 8213, 8224, 8241, 8246, 8250, 8251, 8261, 8262, 8266, 8290, 8302, 8364, 8453, 8471, 8473, 8490, 8493, 8515, 8516, 8521, 7710, 8552, 8557, 8562, 8603, 8604, 8605, 8609, 8612, 8613, 8620, 8623, 8635, 8643, 8646, 8648, 8656, 8675, 8700, 8710, 8711, 8716, 8724, 8739, 8819, 8821, 8824, 8879, 8886, 8894, 8900, 8928, 8940, 9030, 9031, 9032, 9033, 9034, 9037, 9040, 9062, 9087, 9109, 9111, 9113, 9115, 9124, 9128, 9129, 9130, 9131, 9132, 9133, 9134, 9135, 9136, 9137, 9138, 9139, 9140, 9141, 9142, 9143, 9144, 9145, 9146, 9147, 9148, 9159, 9173, 9220, 9270, 9435, 9442, 9443, 9455, 9462, 9475, 9481, 9497, 9525, 9526, 9542, 9555, 9557, 9569, 9570, 9577, 9589, 9591, 9620, 9623, 9630, 9652, 9676, 9680, 9725, 9730, 4171, 9737, 9764, 9860, 9865, 9867, 9871, 9874, 9890, 9891, 9892, 9896, 9950, 9951, 9953, 9954, 10049, 10073, 10217, 10224, 10228, 10230, 10238, 10259, 10274, 10310, 10311, 10313, 10352, 10329, 10332, 10333, 10335, 10342, 10343, 10359, 10366, 10399, 10416, 10417, 10418, 10419, 10432, 10443, 10454, 10457, 10459, 10461, 10462, 10463, 10470, 10474, 10476, 10477, 10479, 10480, 10482, 10485, 10487, 10489, 10491, 10494, 10496, 10497, 10500, 10502, 10529, 10552, 10673, 10680, 10681, 10682, 10683, 10686, 10688, 10692, 10737, 10738, 10739, 10740, 10741, 10761, 10773, 10776, 10777, 10786, 10795, 10810, 10833, 10835, 10839, 10846, 10850, 10246, 10856, 10857, 10865, 10867, 10899, 10900, 10915, 10923, 10924, 10956, 10959, 10981, 11002, 11005, 11007, 11021, 11022, 11023, 11024, 11026, 11027, 11030, 11031, 11032, 11072, 11073, 11074, 11075, 11076, 11080, 11090, 11095, 11110, 11117, 11125, 11163, 11166, 11188, 11196, 11197, 11198, 11199, 10186, 11221, 11222, 11223, 11243, 11281, 11285, 11287, 11297, 11302, 11303, 11310, 11320, 11324, 11339, 11353, 11371, 11372, 11377, 11407, 11419, 11426, 11443, 11468, 11484, 11489, 11492, 11493, 11498, 11490, 11536, 11548, 11553, 11569, 11571, 11702, 11703, 11704, 11705, 11706, 11707, 11708, 11709, 11710, 11711, 11712, 11713, 11714, 11782, 11786, 11790, 11816, 11817, 11818, 11819, 11820) AND `published` = 1 AND `calendar_ffh_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 100440
84SELECT `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 (11076, 11199, 11030, 11536)880
85SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
86SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '6'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` = '1'110
89SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
90SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'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` = '24'110
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`.`id` IN (42, 54, 61, 100, 101, 143, 150, 167, 187, 189, 297, 341, 371, 392, 407, 440, 448, 466, 470, 514, 528, 535, 550, 592, 822, 823, 824, 825, 930, 931, 933, 934, 935, 936, 937, 938, 939, 940, 941, 1008, 1105, 1107, 1108, 1137, 1138, 1221, 1231, 1232, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1605, 1645, 1646, 1707, 1708, 1709, 1710, 1711, 1714, 1715, 1716, 1717, 1718, 1721, 1722, 1913, 1914, 1915, 2054, 2069, 2070, 2071, 2072, 2073, 2074, 2075, 2076, 2077, 2079, 2081, 2109, 2110, 2158, 2159, 2160, 2161, 2163, 2164, 2165, 2166, 2167, 2168, 2181, 2502, 2544, 2715, 2731, 2742, 2761, 2763, 2770, 2785, 2794, 2834, 2842, 2844, 2851, 2861, 2901, 2966, 2967, 2971, 2985, 2991, 3003, 3004, 3145, 3182, 3266, 3278, 3310, 3319, 3323, 3423, 3426, 3489, 3490, 3496, 3642, 3686, 3689, 3710, 3716, 3720, 3733, 3518, 3786, 3307, 3993, 4001, 4002, 4003, 4004, 4006, 4008, 4030, 4032, 4038, 4039, 4040, 4162, 4272, 4274, 4304, 4310, 4312, 4482, 4483, 4484, 4489, 4496, 4498, 4502, 4503, 4513, 4506, 4500, 4488, 4486, 4511, 4512, 4507, 4524, 4525, 4549, 4563, 4603, 4490, 4675, 4700, 4701, 4692, 4704, 4724, 4744, 4770, 4789, 4790, 4791, 4792, 4793, 4794, 4795, 4796, 4797, 4798, 4799, 4800, 4809, 4810, 4811, 4812, 4813, 4814, 4851, 4852, 4902, 4907, 4920, 4923, 4933, 4952, 4967, 4972, 4976, 4973, 4996, 4997, 5000, 5003, 5028, 5037, 5043, 5044, 5078, 5085, 5095, 5141, 5162, 3852, 5205, 5206, 5211, 5212, 5218, 5219, 5223, 5224, 5243, 5247, 5249, 5254, 5256, 5293, 5282, 5279, 5294, 5307, 5313, 5314, 5315, 5316, 5363, 4470, 5369, 5375, 5376, 5377, 5383, 5391, 5397, 5408, 5446, 5463, 5490, 5517, 5518, 5551, 5552, 5559, 5575, 5578, 5590, 5592, 5595, 5597, 5627, 5631, 5655, 5704, 5705, 5736, 5738, 5740, 5741, 5761, 5763, 5765, 5770, 5772, 5794, 5809, 5851, 5961, 5962, 6011, 6018, 6021, 6035, 6037, 6038, 6039, 6042, 6119, 6153, 6159, 6260, 6261, 6262, 6263, 6266, 6267, 6268, 6269, 6270, 6271, 6272, 6273, 6274, 6275, 6276, 6277, 6278, 6279, 6280, 6281, 6282, 6283, 6284, 6285, 6286, 6287, 6288, 6289, 6301, 6349, 6382, 6383, 6389, 6404, 6443, 6477, 6581, 6583, 6588, 6624, 6625, 6651, 6654, 6660, 6310, 6674, 6675, 6676, 6677, 6678, 6679, 6680, 6681, 6682, 6683, 6684, 6685, 6686, 6687, 6688, 6689, 6690, 6691, 6692, 6693, 6694, 6695, 6696, 6697, 6698, 6699, 6700, 6701, 6702, 6715, 6724, 5747, 6752, 6760, 6791, 6830, 6831, 6832, 6253, 6837, 6930, 6932, 7001, 7014, 7015, 7073, 7074, 7105, 7142, 7148, 7149, 7150, 7154, 7200, 7201, 7209, 7212, 7217, 7256, 7264, 7276, 7278, 7294, 7298, 7299, 7300, 7309, 7391, 7414, 7438, 7457, 7471, 7474, 7477, 7499, 7500, 7501, 7503, 7517, 7535, 7537, 7540, 7543, 7558, 7560, 7562, 7564, 7566, 7568, 7569, 7570, 7579, 7687, 7699, 7860, 7904, 7907, 7911, 7940, 7980, 7998, 7992, 7997, 7996, 7995, 7993, 7999, 8001, 8002, 8025, 8028, 8038, 8039, 8040, 8044, 8045, 8047, 8076, 8077, 8078, 8080, 8082, 8091, 8098, 8105, 8138, 3829, 8145, 8147, 8148, 5021, 8178, 8200, 8205, 8213, 8224, 8241, 8246, 8250, 8251, 8261, 8262, 8266, 8290, 8302, 8364, 8453, 8471, 8473, 8490, 8493, 8515, 8516, 8521, 7710, 8552, 8557, 8562, 8603, 8604, 8605, 8609, 8612, 8613, 8620, 8623, 8635, 8643, 8646, 8648, 8656, 8675, 8700, 8710, 8711, 8716, 8724, 8739, 8819, 8821, 8824, 8879, 8886, 8894, 8900, 8928, 8940, 9030, 9031, 9032, 9033, 9034, 9037, 9040, 9062, 9087, 9109, 9111, 9113, 9115, 9124, 9128, 9129, 9130, 9131, 9132, 9133, 9134, 9135, 9136, 9137, 9138, 9139, 9140, 9141, 9142, 9143, 9144, 9145, 9146, 9147, 9148, 9159, 9173, 9220, 9270, 9435, 9442, 9443, 9455, 9462, 9475, 9481, 9497, 9525, 9526, 9542, 9555, 9557, 9569, 9570, 9577, 9589, 9591, 9620, 9623, 9630, 9652, 9676, 9680, 9725, 9730, 4171, 9737, 9764, 9860, 9865, 9867, 9871, 9874, 9890, 9891, 9892, 9896, 9950, 9951, 9953, 9954, 10049, 10073, 10217, 10224, 10228, 10230, 10238, 10259, 10274, 10310, 10311, 10313, 10352, 10329, 10332, 10333, 10335, 10342, 10343, 10359, 10366, 10399, 10416, 10417, 10418, 10419, 10432, 10443, 10454, 10457, 10459, 10461, 10462, 10463, 10470, 10474, 10476, 10477, 10479, 10480, 10482, 10485, 10487, 10489, 10491, 10494, 10496, 10497, 10500, 10502, 10529, 10552, 10673, 10680, 10681, 10682, 10683, 10686, 10688, 10692, 10737, 10738, 10739, 10740, 10741, 10761, 10773, 10776, 10777, 10786, 10795, 10810, 10833, 10835, 10839, 10846, 10850, 10246, 10856, 10857, 10865, 10867, 10899, 10900, 10915, 10923, 10924, 10956, 10959, 10981, 11002, 11005, 11007, 11021, 11022, 11023, 11024, 11026, 11027, 11030, 11031, 11032, 11072, 11073, 11074, 11075, 11076, 11080, 11090, 11095, 11110, 11117, 11125, 11163, 11166, 11188, 11196, 11197, 11198, 11199, 10186, 11221, 11222, 11223, 11243, 11281, 11285, 11287, 11297, 11302, 11303, 11310, 11320, 11324, 11339, 11353, 11371, 11372, 11377, 11407, 11419, 11426, 11443, 11468, 11484, 11489, 11492, 11493, 11498, 11490, 11536, 11548, 11553, 11569, 11571, 11702, 11703, 11704, 11705, 11706, 11707, 11708, 11709, 11710, 11711, 11712, 11713, 11714, 11782, 11786, 11790, 11816, 11817, 11818, 11819, 11820) AND `published` = 1 AND `calendar_ffh_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 100110
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` = (11031)110
95SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
96SELECT `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`.`id` IN (42, 54, 61, 100, 101, 143, 150, 167, 187, 189, 297, 341, 371, 392, 407, 440, 448, 466, 470, 514, 528, 535, 550, 592, 822, 823, 824, 825, 930, 931, 933, 934, 935, 936, 937, 938, 939, 940, 941, 1008, 1105, 1107, 1108, 1137, 1138, 1221, 1231, 1232, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1605, 1645, 1646, 1707, 1708, 1709, 1710, 1711, 1714, 1715, 1716, 1717, 1718, 1721, 1722, 1913, 1914, 1915, 2054, 2069, 2070, 2071, 2072, 2073, 2074, 2075, 2076, 2077, 2079, 2081, 2109, 2110, 2158, 2159, 2160, 2161, 2163, 2164, 2165, 2166, 2167, 2168, 2181, 2502, 2544, 2715, 2731, 2742, 2761, 2763, 2770, 2785, 2794, 2834, 2842, 2844, 2851, 2861, 2901, 2966, 2967, 2971, 2985, 2991, 3003, 3004, 3145, 3182, 3266, 3278, 3310, 3319, 3323, 3423, 3426, 3489, 3490, 3496, 3642, 3686, 3689, 3710, 3716, 3720, 3733, 3518, 3786, 3307, 3993, 4001, 4002, 4003, 4004, 4006, 4008, 4030, 4032, 4038, 4039, 4040, 4162, 4272, 4274, 4304, 4310, 4312, 4482, 4483, 4484, 4489, 4496, 4498, 4502, 4503, 4513, 4506, 4500, 4488, 4486, 4511, 4512, 4507, 4524, 4525, 4549, 4563, 4603, 4490, 4675, 4700, 4701, 4692, 4704, 4724, 4744, 4770, 4789, 4790, 4791, 4792, 4793, 4794, 4795, 4796, 4797, 4798, 4799, 4800, 4809, 4810, 4811, 4812, 4813, 4814, 4851, 4852, 4902, 4907, 4920, 4923, 4933, 4952, 4967, 4972, 4976, 4973, 4996, 4997, 5000, 5003, 5028, 5037, 5043, 5044, 5078, 5085, 5095, 5141, 5162, 3852, 5205, 5206, 5211, 5212, 5218, 5219, 5223, 5224, 5243, 5247, 5249, 5254, 5256, 5293, 5282, 5279, 5294, 5307, 5313, 5314, 5315, 5316, 5363, 4470, 5369, 5375, 5376, 5377, 5383, 5391, 5397, 5408, 5446, 5463, 5490, 5517, 5518, 5551, 5552, 5559, 5575, 5578, 5590, 5592, 5595, 5597, 5627, 5631, 5655, 5704, 5705, 5736, 5738, 5740, 5741, 5761, 5763, 5765, 5770, 5772, 5794, 5809, 5851, 5961, 5962, 6011, 6018, 6021, 6035, 6037, 6038, 6039, 6042, 6119, 6153, 6159, 6260, 6261, 6262, 6263, 6266, 6267, 6268, 6269, 6270, 6271, 6272, 6273, 6274, 6275, 6276, 6277, 6278, 6279, 6280, 6281, 6282, 6283, 6284, 6285, 6286, 6287, 6288, 6289, 6301, 6349, 6382, 6383, 6389, 6404, 6443, 6477, 6581, 6583, 6588, 6624, 6625, 6651, 6654, 6660, 6310, 6674, 6675, 6676, 6677, 6678, 6679, 6680, 6681, 6682, 6683, 6684, 6685, 6686, 6687, 6688, 6689, 6690, 6691, 6692, 6693, 6694, 6695, 6696, 6697, 6698, 6699, 6700, 6701, 6702, 6715, 6724, 5747, 6752, 6760, 6791, 6830, 6831, 6832, 6253, 6837, 6930, 6932, 7001, 7014, 7015, 7073, 7074, 7105, 7142, 7148, 7149, 7150, 7154, 7200, 7201, 7209, 7212, 7217, 7256, 7264, 7276, 7278, 7294, 7298, 7299, 7300, 7309, 7391, 7414, 7438, 7457, 7471, 7474, 7477, 7499, 7500, 7501, 7503, 7517, 7535, 7537, 7540, 7543, 7558, 7560, 7562, 7564, 7566, 7568, 7569, 7570, 7579, 7687, 7699, 7860, 7904, 7907, 7911, 7940, 7980, 7998, 7992, 7997, 7996, 7995, 7993, 7999, 8001, 8002, 8025, 8028, 8038, 8039, 8040, 8044, 8045, 8047, 8076, 8077, 8078, 8080, 8082, 8091, 8098, 8105, 8138, 3829, 8145, 8147, 8148, 5021, 8178, 8200, 8205, 8213, 8224, 8241, 8246, 8250, 8251, 8261, 8262, 8266, 8290, 8302, 8364, 8453, 8471, 8473, 8490, 8493, 8515, 8516, 8521, 7710, 8552, 8557, 8562, 8603, 8604, 8605, 8609, 8612, 8613, 8620, 8623, 8635, 8643, 8646, 8648, 8656, 8675, 8700, 8710, 8711, 8716, 8724, 8739, 8819, 8821, 8824, 8879, 8886, 8894, 8900, 8928, 8940, 9030, 9031, 9032, 9033, 9034, 9037, 9040, 9062, 9087, 9109, 9111, 9113, 9115, 9124, 9128, 9129, 9130, 9131, 9132, 9133, 9134, 9135, 9136, 9137, 9138, 9139, 9140, 9141, 9142, 9143, 9144, 9145, 9146, 9147, 9148, 9159, 9173, 9220, 9270, 9435, 9442, 9443, 9455, 9462, 9475, 9481, 9497, 9525, 9526, 9542, 9555, 9557, 9569, 9570, 9577, 9589, 9591, 9620, 9623, 9630, 9652, 9676, 9680, 9725, 9730, 4171, 9737, 9764, 9860, 9865, 9867, 9871, 9874, 9890, 9891, 9892, 9896, 9950, 9951, 9953, 9954, 10049, 10073, 10217, 10224, 10228, 10230, 10238, 10259, 10274, 10310, 10311, 10313, 10352, 10329, 10332, 10333, 10335, 10342, 10343, 10359, 10366, 10399, 10416, 10417, 10418, 10419, 10432, 10443, 10454, 10457, 10459, 10461, 10462, 10463, 10470, 10474, 10476, 10477, 10479, 10480, 10482, 10485, 10487, 10489, 10491, 10494, 10496, 10497, 10500, 10502, 10529, 10552, 10673, 10680, 10681, 10682, 10683, 10686, 10688, 10692, 10737, 10738, 10739, 10740, 10741, 10761, 10773, 10776, 10777, 10786, 10795, 10810, 10833, 10835, 10839, 10846, 10850, 10246, 10856, 10857, 10865, 10867, 10899, 10900, 10915, 10923, 10924, 10956, 10959, 10981, 11002, 11005, 11007, 11021, 11022, 11023, 11024, 11026, 11027, 11030, 11031, 11032, 11072, 11073, 11074, 11075, 11076, 11080, 11090, 11095, 11110, 11117, 11125, 11163, 11166, 11188, 11196, 11197, 11198, 11199, 10186, 11221, 11222, 11223, 11243, 11281, 11285, 11287, 11297, 11302, 11303, 11310, 11320, 11324, 11339, 11353, 11371, 11372, 11377, 11407, 11419, 11426, 11443, 11468, 11484, 11489, 11492, 11493, 11498, 11490, 11536, 11548, 11553, 11569, 11571, 11702, 11703, 11704, 11705, 11706, 11707, 11708, 11709, 11710, 11711, 11712, 11713, 11714, 11782, 11786, 11790, 11816, 11817, 11818, 11819, 11820) AND `published` = 1 AND `calendar_ffh_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
97SELECT `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 (11032, 11074, 11714, 11498)20200
98SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
99SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'110
100SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '6'110
101SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
102SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
103SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '7'110
104SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'110
105SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '17'110
106SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '74'110
107SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '15'110
108SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
109SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '200'110
110SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
111SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '28'110
112SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '39'110
113SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'110
114SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
115SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '38'110
116SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
117SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '8'110
118SELECT `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`.`id` IN (42, 54, 61, 100, 101, 143, 150, 167, 187, 189, 297, 341, 371, 392, 407, 440, 448, 466, 470, 514, 528, 535, 550, 592, 822, 823, 824, 825, 930, 931, 933, 934, 935, 936, 937, 938, 939, 940, 941, 1008, 1105, 1107, 1108, 1137, 1138, 1221, 1231, 1232, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1605, 1645, 1646, 1707, 1708, 1709, 1710, 1711, 1714, 1715, 1716, 1717, 1718, 1721, 1722, 1913, 1914, 1915, 2054, 2069, 2070, 2071, 2072, 2073, 2074, 2075, 2076, 2077, 2079, 2081, 2109, 2110, 2158, 2159, 2160, 2161, 2163, 2164, 2165, 2166, 2167, 2168, 2181, 2502, 2544, 2715, 2731, 2742, 2761, 2763, 2770, 2785, 2794, 2834, 2842, 2844, 2851, 2861, 2901, 2966, 2967, 2971, 2985, 2991, 3003, 3004, 3145, 3182, 3266, 3278, 3310, 3319, 3323, 3423, 3426, 3489, 3490, 3496, 3642, 3686, 3689, 3710, 3716, 3720, 3733, 3518, 3786, 3307, 3993, 4001, 4002, 4003, 4004, 4006, 4008, 4030, 4032, 4038, 4039, 4040, 4162, 4272, 4274, 4304, 4310, 4312, 4482, 4483, 4484, 4489, 4496, 4498, 4502, 4503, 4513, 4506, 4500, 4488, 4486, 4511, 4512, 4507, 4524, 4525, 4549, 4563, 4603, 4490, 4675, 4700, 4701, 4692, 4704, 4724, 4744, 4770, 4789, 4790, 4791, 4792, 4793, 4794, 4795, 4796, 4797, 4798, 4799, 4800, 4809, 4810, 4811, 4812, 4813, 4814, 4851, 4852, 4902, 4907, 4920, 4923, 4933, 4952, 4967, 4972, 4976, 4973, 4996, 4997, 5000, 5003, 5028, 5037, 5043, 5044, 5078, 5085, 5095, 5141, 5162, 3852, 5205, 5206, 5211, 5212, 5218, 5219, 5223, 5224, 5243, 5247, 5249, 5254, 5256, 5293, 5282, 5279, 5294, 5307, 5313, 5314, 5315, 5316, 5363, 4470, 5369, 5375, 5376, 5377, 5383, 5391, 5397, 5408, 5446, 5463, 5490, 5517, 5518, 5551, 5552, 5559, 5575, 5578, 5590, 5592, 5595, 5597, 5627, 5631, 5655, 5704, 5705, 5736, 5738, 5740, 5741, 5761, 5763, 5765, 5770, 5772, 5794, 5809, 5851, 5961, 5962, 6011, 6018, 6021, 6035, 6037, 6038, 6039, 6042, 6119, 6153, 6159, 6260, 6261, 6262, 6263, 6266, 6267, 6268, 6269, 6270, 6271, 6272, 6273, 6274, 6275, 6276, 6277, 6278, 6279, 6280, 6281, 6282, 6283, 6284, 6285, 6286, 6287, 6288, 6289, 6301, 6349, 6382, 6383, 6389, 6404, 6443, 6477, 6581, 6583, 6588, 6624, 6625, 6651, 6654, 6660, 6310, 6674, 6675, 6676, 6677, 6678, 6679, 6680, 6681, 6682, 6683, 6684, 6685, 6686, 6687, 6688, 6689, 6690, 6691, 6692, 6693, 6694, 6695, 6696, 6697, 6698, 6699, 6700, 6701, 6702, 6715, 6724, 5747, 6752, 6760, 6791, 6830, 6831, 6832, 6253, 6837, 6930, 6932, 7001, 7014, 7015, 7073, 7074, 7105, 7142, 7148, 7149, 7150, 7154, 7200, 7201, 7209, 7212, 7217, 7256, 7264, 7276, 7278, 7294, 7298, 7299, 7300, 7309, 7391, 7414, 7438, 7457, 7471, 7474, 7477, 7499, 7500, 7501, 7503, 7517, 7535, 7537, 7540, 7543, 7558, 7560, 7562, 7564, 7566, 7568, 7569, 7570, 7579, 7687, 7699, 7860, 7904, 7907, 7911, 7940, 7980, 7998, 7992, 7997, 7996, 7995, 7993, 7999, 8001, 8002, 8025, 8028, 8038, 8039, 8040, 8044, 8045, 8047, 8076, 8077, 8078, 8080, 8082, 8091, 8098, 8105, 8138, 3829, 8145, 8147, 8148, 5021, 8178, 8200, 8205, 8213, 8224, 8241, 8246, 8250, 8251, 8261, 8262, 8266, 8290, 8302, 8364, 8453, 8471, 8473, 8490, 8493, 8515, 8516, 8521, 7710, 8552, 8557, 8562, 8603, 8604, 8605, 8609, 8612, 8613, 8620, 8623, 8635, 8643, 8646, 8648, 8656, 8675, 8700, 8710, 8711, 8716, 8724, 8739, 8819, 8821, 8824, 8879, 8886, 8894, 8900, 8928, 8940, 9030, 9031, 9032, 9033, 9034, 9037, 9040, 9062, 9087, 9109, 9111, 9113, 9115, 9124, 9128, 9129, 9130, 9131, 9132, 9133, 9134, 9135, 9136, 9137, 9138, 9139, 9140, 9141, 9142, 9143, 9144, 9145, 9146, 9147, 9148, 9159, 9173, 9220, 9270, 9435, 9442, 9443, 9455, 9462, 9475, 9481, 9497, 9525, 9526, 9542, 9555, 9557, 9569, 9570, 9577, 9589, 9591, 9620, 9623, 9630, 9652, 9676, 9680, 9725, 9730, 4171, 9737, 9764, 9860, 9865, 9867, 9871, 9874, 9890, 9891, 9892, 9896, 9950, 9951, 9953, 9954, 10049, 10073, 10217, 10224, 10228, 10230, 10238, 10259, 10274, 10310, 10311, 10313, 10352, 10329, 10332, 10333, 10335, 10342, 10343, 10359, 10366, 10399, 10416, 10417, 10418, 10419, 10432, 10443, 10454, 10457, 10459, 10461, 10462, 10463, 10470, 10474, 10476, 10477, 10479, 10480, 10482, 10485, 10487, 10489, 10491, 10494, 10496, 10497, 10500, 10502, 10529, 10552, 10673, 10680, 10681, 10682, 10683, 10686, 10688, 10692, 10737, 10738, 10739, 10740, 10741, 10761, 10773, 10776, 10777, 10786, 10795, 10810, 10833, 10835, 10839, 10846, 10850, 10246, 10856, 10857, 10865, 10867, 10899, 10900, 10915, 10923, 10924, 10956, 10959, 10981, 11002, 11005, 11007, 11021, 11022, 11023, 11024, 11026, 11027, 11030, 11031, 11032, 11072, 11073, 11074, 11075, 11076, 11080, 11090, 11095, 11110, 11117, 11125, 11163, 11166, 11188, 11196, 11197, 11198, 11199, 10186, 11221, 11222, 11223, 11243, 11281, 11285, 11287, 11297, 11302, 11303, 11310, 11320, 11324, 11339, 11353, 11371, 11372, 11377, 11407, 11419, 11426, 11443, 11468, 11484, 11489, 11492, 11493, 11498, 11490, 11536, 11548, 11553, 11569, 11571, 11702, 11703, 11704, 11705, 11706, 11707, 11708, 11709, 11710, 11711, 11712, 11713, 11714, 11782, 11786, 11790, 11816, 11817, 11818, 11819, 11820) AND `published` = 1 AND `calendar_ffh_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 100220
119SELECT `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 (11075, 11072)770
120SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'110
121SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '6'110
122SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'110
123SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
124SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '53'110
125SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '17'110
126SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
127SELECT `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`.`id` IN (42, 54, 61, 100, 101, 143, 150, 167, 187, 189, 297, 341, 371, 392, 407, 440, 448, 466, 470, 514, 528, 535, 550, 592, 822, 823, 824, 825, 930, 931, 933, 934, 935, 936, 937, 938, 939, 940, 941, 1008, 1105, 1107, 1108, 1137, 1138, 1221, 1231, 1232, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1605, 1645, 1646, 1707, 1708, 1709, 1710, 1711, 1714, 1715, 1716, 1717, 1718, 1721, 1722, 1913, 1914, 1915, 2054, 2069, 2070, 2071, 2072, 2073, 2074, 2075, 2076, 2077, 2079, 2081, 2109, 2110, 2158, 2159, 2160, 2161, 2163, 2164, 2165, 2166, 2167, 2168, 2181, 2502, 2544, 2715, 2731, 2742, 2761, 2763, 2770, 2785, 2794, 2834, 2842, 2844, 2851, 2861, 2901, 2966, 2967, 2971, 2985, 2991, 3003, 3004, 3145, 3182, 3266, 3278, 3310, 3319, 3323, 3423, 3426, 3489, 3490, 3496, 3642, 3686, 3689, 3710, 3716, 3720, 3733, 3518, 3786, 3307, 3993, 4001, 4002, 4003, 4004, 4006, 4008, 4030, 4032, 4038, 4039, 4040, 4162, 4272, 4274, 4304, 4310, 4312, 4482, 4483, 4484, 4489, 4496, 4498, 4502, 4503, 4513, 4506, 4500, 4488, 4486, 4511, 4512, 4507, 4524, 4525, 4549, 4563, 4603, 4490, 4675, 4700, 4701, 4692, 4704, 4724, 4744, 4770, 4789, 4790, 4791, 4792, 4793, 4794, 4795, 4796, 4797, 4798, 4799, 4800, 4809, 4810, 4811, 4812, 4813, 4814, 4851, 4852, 4902, 4907, 4920, 4923, 4933, 4952, 4967, 4972, 4976, 4973, 4996, 4997, 5000, 5003, 5028, 5037, 5043, 5044, 5078, 5085, 5095, 5141, 5162, 3852, 5205, 5206, 5211, 5212, 5218, 5219, 5223, 5224, 5243, 5247, 5249, 5254, 5256, 5293, 5282, 5279, 5294, 5307, 5313, 5314, 5315, 5316, 5363, 4470, 5369, 5375, 5376, 5377, 5383, 5391, 5397, 5408, 5446, 5463, 5490, 5517, 5518, 5551, 5552, 5559, 5575, 5578, 5590, 5592, 5595, 5597, 5627, 5631, 5655, 5704, 5705, 5736, 5738, 5740, 5741, 5761, 5763, 5765, 5770, 5772, 5794, 5809, 5851, 5961, 5962, 6011, 6018, 6021, 6035, 6037, 6038, 6039, 6042, 6119, 6153, 6159, 6260, 6261, 6262, 6263, 6266, 6267, 6268, 6269, 6270, 6271, 6272, 6273, 6274, 6275, 6276, 6277, 6278, 6279, 6280, 6281, 6282, 6283, 6284, 6285, 6286, 6287, 6288, 6289, 6301, 6349, 6382, 6383, 6389, 6404, 6443, 6477, 6581, 6583, 6588, 6624, 6625, 6651, 6654, 6660, 6310, 6674, 6675, 6676, 6677, 6678, 6679, 6680, 6681, 6682, 6683, 6684, 6685, 6686, 6687, 6688, 6689, 6690, 6691, 6692, 6693, 6694, 6695, 6696, 6697, 6698, 6699, 6700, 6701, 6702, 6715, 6724, 5747, 6752, 6760, 6791, 6830, 6831, 6832, 6253, 6837, 6930, 6932, 7001, 7014, 7015, 7073, 7074, 7105, 7142, 7148, 7149, 7150, 7154, 7200, 7201, 7209, 7212, 7217, 7256, 7264, 7276, 7278, 7294, 7298, 7299, 7300, 7309, 7391, 7414, 7438, 7457, 7471, 7474, 7477, 7499, 7500, 7501, 7503, 7517, 7535, 7537, 7540, 7543, 7558, 7560, 7562, 7564, 7566, 7568, 7569, 7570, 7579, 7687, 7699, 7860, 7904, 7907, 7911, 7940, 7980, 7998, 7992, 7997, 7996, 7995, 7993, 7999, 8001, 8002, 8025, 8028, 8038, 8039, 8040, 8044, 8045, 8047, 8076, 8077, 8078, 8080, 8082, 8091, 8098, 8105, 8138, 3829, 8145, 8147, 8148, 5021, 8178, 8200, 8205, 8213, 8224, 8241, 8246, 8250, 8251, 8261, 8262, 8266, 8290, 8302, 8364, 8453, 8471, 8473, 8490, 8493, 8515, 8516, 8521, 7710, 8552, 8557, 8562, 8603, 8604, 8605, 8609, 8612, 8613, 8620, 8623, 8635, 8643, 8646, 8648, 8656, 8675, 8700, 8710, 8711, 8716, 8724, 8739, 8819, 8821, 8824, 8879, 8886, 8894, 8900, 8928, 8940, 9030, 9031, 9032, 9033, 9034, 9037, 9040, 9062, 9087, 9109, 9111, 9113, 9115, 9124, 9128, 9129, 9130, 9131, 9132, 9133, 9134, 9135, 9136, 9137, 9138, 9139, 9140, 9141, 9142, 9143, 9144, 9145, 9146, 9147, 9148, 9159, 9173, 9220, 9270, 9435, 9442, 9443, 9455, 9462, 9475, 9481, 9497, 9525, 9526, 9542, 9555, 9557, 9569, 9570, 9577, 9589, 9591, 9620, 9623, 9630, 9652, 9676, 9680, 9725, 9730, 4171, 9737, 9764, 9860, 9865, 9867, 9871, 9874, 9890, 9891, 9892, 9896, 9950, 9951, 9953, 9954, 10049, 10073, 10217, 10224, 10228, 10230, 10238, 10259, 10274, 10310, 10311, 10313, 10352, 10329, 10332, 10333, 10335, 10342, 10343, 10359, 10366, 10399, 10416, 10417, 10418, 10419, 10432, 10443, 10454, 10457, 10459, 10461, 10462, 10463, 10470, 10474, 10476, 10477, 10479, 10480, 10482, 10485, 10487, 10489, 10491, 10494, 10496, 10497, 10500, 10502, 10529, 10552, 10673, 10680, 10681, 10682, 10683, 10686, 10688, 10692, 10737, 10738, 10739, 10740, 10741, 10761, 10773, 10776, 10777, 10786, 10795, 10810, 10833, 10835, 10839, 10846, 10850, 10246, 10856, 10857, 10865, 10867, 10899, 10900, 10915, 10923, 10924, 10956, 10959, 10981, 11002, 11005, 11007, 11021, 11022, 11023, 11024, 11026, 11027, 11030, 11031, 11032, 11072, 11073, 11074, 11075, 11076, 11080, 11090, 11095, 11110, 11117, 11125, 11163, 11166, 11188, 11196, 11197, 11198, 11199, 10186, 11221, 11222, 11223, 11243, 11281, 11285, 11287, 11297, 11302, 11303, 11310, 11320, 11324, 11339, 11353, 11371, 11372, 11377, 11407, 11419, 11426, 11443, 11468, 11484, 11489, 11492, 11493, 11498, 11490, 11536, 11548, 11553, 11569, 11571, 11702, 11703, 11704, 11705, 11706, 11707, 11708, 11709, 11710, 11711, 11712, 11713, 11714, 11782, 11786, 11790, 11816, 11817, 11818, 11819, 11820) AND `published` = 1 AND `calendar_ffh_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 100110
128SELECT `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` = (11073)110
129SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'110
130SELECT `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`.`id` IN (42, 54, 61, 100, 101, 143, 150, 167, 187, 189, 297, 341, 371, 392, 407, 440, 448, 466, 470, 514, 528, 535, 550, 592, 822, 823, 824, 825, 930, 931, 933, 934, 935, 936, 937, 938, 939, 940, 941, 1008, 1105, 1107, 1108, 1137, 1138, 1221, 1231, 1232, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1605, 1645, 1646, 1707, 1708, 1709, 1710, 1711, 1714, 1715, 1716, 1717, 1718, 1721, 1722, 1913, 1914, 1915, 2054, 2069, 2070, 2071, 2072, 2073, 2074, 2075, 2076, 2077, 2079, 2081, 2109, 2110, 2158, 2159, 2160, 2161, 2163, 2164, 2165, 2166, 2167, 2168, 2181, 2502, 2544, 2715, 2731, 2742, 2761, 2763, 2770, 2785, 2794, 2834, 2842, 2844, 2851, 2861, 2901, 2966, 2967, 2971, 2985, 2991, 3003, 3004, 3145, 3182, 3266, 3278, 3310, 3319, 3323, 3423, 3426, 3489, 3490, 3496, 3642, 3686, 3689, 3710, 3716, 3720, 3733, 3518, 3786, 3307, 3993, 4001, 4002, 4003, 4004, 4006, 4008, 4030, 4032, 4038, 4039, 4040, 4162, 4272, 4274, 4304, 4310, 4312, 4482, 4483, 4484, 4489, 4496, 4498, 4502, 4503, 4513, 4506, 4500, 4488, 4486, 4511, 4512, 4507, 4524, 4525, 4549, 4563, 4603, 4490, 4675, 4700, 4701, 4692, 4704, 4724, 4744, 4770, 4789, 4790, 4791, 4792, 4793, 4794, 4795, 4796, 4797, 4798, 4799, 4800, 4809, 4810, 4811, 4812, 4813, 4814, 4851, 4852, 4902, 4907, 4920, 4923, 4933, 4952, 4967, 4972, 4976, 4973, 4996, 4997, 5000, 5003, 5028, 5037, 5043, 5044, 5078, 5085, 5095, 5141, 5162, 3852, 5205, 5206, 5211, 5212, 5218, 5219, 5223, 5224, 5243, 5247, 5249, 5254, 5256, 5293, 5282, 5279, 5294, 5307, 5313, 5314, 5315, 5316, 5363, 4470, 5369, 5375, 5376, 5377, 5383, 5391, 5397, 5408, 5446, 5463, 5490, 5517, 5518, 5551, 5552, 5559, 5575, 5578, 5590, 5592, 5595, 5597, 5627, 5631, 5655, 5704, 5705, 5736, 5738, 5740, 5741, 5761, 5763, 5765, 5770, 5772, 5794, 5809, 5851, 5961, 5962, 6011, 6018, 6021, 6035, 6037, 6038, 6039, 6042, 6119, 6153, 6159, 6260, 6261, 6262, 6263, 6266, 6267, 6268, 6269, 6270, 6271, 6272, 6273, 6274, 6275, 6276, 6277, 6278, 6279, 6280, 6281, 6282, 6283, 6284, 6285, 6286, 6287, 6288, 6289, 6301, 6349, 6382, 6383, 6389, 6404, 6443, 6477, 6581, 6583, 6588, 6624, 6625, 6651, 6654, 6660, 6310, 6674, 6675, 6676, 6677, 6678, 6679, 6680, 6681, 6682, 6683, 6684, 6685, 6686, 6687, 6688, 6689, 6690, 6691, 6692, 6693, 6694, 6695, 6696, 6697, 6698, 6699, 6700, 6701, 6702, 6715, 6724, 5747, 6752, 6760, 6791, 6830, 6831, 6832, 6253, 6837, 6930, 6932, 7001, 7014, 7015, 7073, 7074, 7105, 7142, 7148, 7149, 7150, 7154, 7200, 7201, 7209, 7212, 7217, 7256, 7264, 7276, 7278, 7294, 7298, 7299, 7300, 7309, 7391, 7414, 7438, 7457, 7471, 7474, 7477, 7499, 7500, 7501, 7503, 7517, 7535, 7537, 7540, 7543, 7558, 7560, 7562, 7564, 7566, 7568, 7569, 7570, 7579, 7687, 7699, 7860, 7904, 7907, 7911, 7940, 7980, 7998, 7992, 7997, 7996, 7995, 7993, 7999, 8001, 8002, 8025, 8028, 8038, 8039, 8040, 8044, 8045, 8047, 8076, 8077, 8078, 8080, 8082, 8091, 8098, 8105, 8138, 3829, 8145, 8147, 8148, 5021, 8178, 8200, 8205, 8213, 8224, 8241, 8246, 8250, 8251, 8261, 8262, 8266, 8290, 8302, 8364, 8453, 8471, 8473, 8490, 8493, 8515, 8516, 8521, 7710, 8552, 8557, 8562, 8603, 8604, 8605, 8609, 8612, 8613, 8620, 8623, 8635, 8643, 8646, 8648, 8656, 8675, 8700, 8710, 8711, 8716, 8724, 8739, 8819, 8821, 8824, 8879, 8886, 8894, 8900, 8928, 8940, 9030, 9031, 9032, 9033, 9034, 9037, 9040, 9062, 9087, 9109, 9111, 9113, 9115, 9124, 9128, 9129, 9130, 9131, 9132, 9133, 9134, 9135, 9136, 9137, 9138, 9139, 9140, 9141, 9142, 9143, 9144, 9145, 9146, 9147, 9148, 9159, 9173, 9220, 9270, 9435, 9442, 9443, 9455, 9462, 9475, 9481, 9497, 9525, 9526, 9542, 9555, 9557, 9569, 9570, 9577, 9589, 9591, 9620, 9623, 9630, 9652, 9676, 9680, 9725, 9730, 4171, 9737, 9764, 9860, 9865, 9867, 9871, 9874, 9890, 9891, 9892, 9896, 9950, 9951, 9953, 9954, 10049, 10073, 10217, 10224, 10228, 10230, 10238, 10259, 10274, 10310, 10311, 10313, 10352, 10329, 10332, 10333, 10335, 10342, 10343, 10359, 10366, 10399, 10416, 10417, 10418, 10419, 10432, 10443, 10454, 10457, 10459, 10461, 10462, 10463, 10470, 10474, 10476, 10477, 10479, 10480, 10482, 10485, 10487, 10489, 10491, 10494, 10496, 10497, 10500, 10502, 10529, 10552, 10673, 10680, 10681, 10682, 10683, 10686, 10688, 10692, 10737, 10738, 10739, 10740, 10741, 10761, 10773, 10776, 10777, 10786, 10795, 10810, 10833, 10835, 10839, 10846, 10850, 10246, 10856, 10857, 10865, 10867, 10899, 10900, 10915, 10923, 10924, 10956, 10959, 10981, 11002, 11005, 11007, 11021, 11022, 11023, 11024, 11026, 11027, 11030, 11031, 11032, 11072, 11073, 11074, 11075, 11076, 11080, 11090, 11095, 11110, 11117, 11125, 11163, 11166, 11188, 11196, 11197, 11198, 11199, 10186, 11221, 11222, 11223, 11243, 11281, 11285, 11287, 11297, 11302, 11303, 11310, 11320, 11324, 11339, 11353, 11371, 11372, 11377, 11407, 11419, 11426, 11443, 11468, 11484, 11489, 11492, 11493, 11498, 11490, 11536, 11548, 11553, 11569, 11571, 11702, 11703, 11704, 11705, 11706, 11707, 11708, 11709, 11710, 11711, 11712, 11713, 11714, 11782, 11786, 11790, 11816, 11817, 11818, 11819, 11820) AND `published` = 1 AND `calendar_ffh_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 100000
131SELECT `FamillesEvent`.`id`, `FamillesEvent`.`name` FROM `ExtranetFFH`.`familles_events` AS `FamillesEvent` WHERE 1 = 1 ORDER BY `name` ASC10100
132SELECT `Handicap`.`id`, `Handicap`.`name` FROM `ExtranetFFH`.`handicaps` AS `Handicap` WHERE 1 = 1 ORDER BY `name` ASC770
133SELECT `Region`.`id`, `Region`.`name` FROM `ExtranetFFH`.`regions` AS `Region` WHERE 1 = 1 ORDER BY `Region`.`name` ASC38380