RECHERCHER

Période du
au




ÉVÉNEMENTS DU MOIS
17 Juin Challenge
Challenge Auvergne-Rhône-Alpes - Foot fauteuil électrique - Pont de Chéruy - 2020
Foot fauteuil électrique
Notice (8): Undefined index: EventsSite [APP/View/Elements/bloc_calendar_avenir.ctp, line 118]
38
27 28 Juin Championnat - Phase(s) finale(s)
Championnat de France DIVISION 1 - Foot fauteuil électrique - ROSIERES PRES TROYES (FRA) - 2020
Foot fauteuil électrique
Notice (8): Undefined index: EventsSite [APP/View/Elements/bloc_calendar_avenir.ctp, line 118]
10
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) 22 queries took 321 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT SUBSTR(StructureNomCourt,7) as SPORT, `Structure`.`id` FROM `ExtranetFFH`.`structures` AS `Structure` WHERE `StructureCode` = '000000216' LIMIT 1111
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` ASC24247
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 = 12454424544267
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` DESC333321
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`.`user_modify_id`, `Event`.`modified`, `Event`.`sport`, `Event`.`competition`, `Event`.`types_event_id`, `Event`.`type_complement`, `Event`.`activite`, `Event`.`activite_id`, `Event`.`titre`, `Event`.`region_id`, `Event`.`departement_id`, `Event`.`departement_id3`, `Event`.`description`, `Event`.`resume`, `Event`.`begin_published`, `Event`.`end_published`, `Event`.`published`, `Event`.`date_published`, `Event`.`calendar_ffh_published`, `Event`.`une_ffh_published`, `Event`.`une_cr_published`, `Event`.`une_cd_published`, `Event`.`niveau`, `Event`.`web_site`, `Event`.`facebook_page`, `Event`.`galerie_photo`, `Event`.`resultats_page`, `Event`.`debut`, `Event`.`fin`, `Event`.`report`, `Event`.`report_user_id`, `Event`.`report_details`, `Event`.`debut2`, `Event`.`fin2`, `Event`.`code_postal`, `Event`.`commune`, `Event`.`stop_event`, `Event`.`stop_event_user_id`, `Event`.`stop_event_date`, `Event`.`stop_event_details`, `Event`.`age_min`, `Event`.`ddn_min`, `Event`.`age_max`, `Event`.`ddn_max`, `Event`.`licence_ffh`, `Event`.`type_licence_ffh`, `Event`.`ouvert_valide_participant`, `Event`.`gratuit_participant`, `Event`.`price_participant`, `Event`.`open_public`, `Event`.`gratuit_public`, `Event`.`price_public`, `Event`.`country_id`, `Event`.`format`, `Event`.`format_nb_jours`, `Event`.`contact_structure`, `Event`.`contact_interlocuteur`, `Event`.`contact_email`, `Event`.`contact_tel`, `Event`.`capacite_public`, `Event`.`genre`, `Event`.`photo_thumb`, `Event`.`photo_une`, `Event`.`photo_view`, `Event`.`credit_photo`, `Event`.`end_inscription`, `Event`.`begin_inscription`, `Event`.`annulation`, `Event`.`annulation_categorie`, `Event`.`annulation_details`, `Event`.`annulation_user_id`, `Event`.`representant_ffh_id`, `Event`.`representant_ffh_fonction_id`, `Event`.`search_orga`, `Event`.`periode_cible`, `Event`.`precisions_search_orga`, `Event`.`autres_informations`, `Event`.`module_hn`, `Event`.`cdc`, `Event`.`exalto_ManifId`, `Event`.`mds_urlPdf`, `Event`.`mdsevent_id`, `Event`.`insert_by_multiple`, `Event`.`import_du_debut`, `Event`.`mode_gestion`, `Event`.`engagement_individuel`, `Event`.`open_intentions`, `Event`.`end_intentions`, `Event`.`go_intentions`, `Event`.`delegation_precree`, `Event`.`open_engagements`, `Event`.`end_engagements`, `Event`.`end_hebergement`, `Event`.`end_restauration`, `Event`.`go_engagements`, `Event`.`user_gestion_id`, `Event`.`tel_gestion`, `Event`.`email_gestion`, `Event`.`preambule`, `Event`.`delegation_doc_admin`, `Event`.`participant_doc_admin`, `Event`.`epreuves_by_participant`, `Event`.`nb_epreuves_by_participant`, `Event`.`tarif_by_participant`, `Event`.`tarif_by_epreuve_participant`, `Event`.`panier_repas`, `Event`.`tarif_panier_repas`, `Event`.`order_cheque`, `Event`.`adresse_envoi_cheque`, `Event`.`type_engagement`, `Event`.`nb_max_pratiquants_by_delegation`, `Event`.`step_intention`, `Event`.`step_engagement`, `Event`.`etoiles`, `Event`.`nb_participants_moins_20ans`, `Event`.`orga_support_etoiles`, `Event`.`tab_active`, `Event`.`qualification`, `Event`.`num_edition`, `Event`.`dossard`, `Event`.`prerequis_licence_encadrant`, `Event`.`prerequis_licence`, `Event`.`prerequis_licence_sport`, `Event`.`type_prestation`, `Event`.`prestations_by_delegation`, `Event`.`prestations_by_participant`, `Event`.`delegation_heb_cond`, `Event`.`participant_heb_cond`, `Event`.`participant_list_taille_teeshirt`, `Event`.`participant_taille_teeshirt`, `Event`.`participant_deficience_sensorielle`, `Event`.`participant_by_selection`, `Event`.`payment_by_delegation`, `Event`.`payment_by_participant`, `Event`.`frais_techniques_by_participant`, `Event`.`montant_frais_techniques_by_participant`, `Event`.`temps_add_epreuve_by_participant`, `Event`.`billet_congres`, `Event`.`iban`, `Event`.`siret`, `Event`.`prefixe_num_facture`, `Event`.`logo_facture`, `Event`.`width_logo_facture`, `Event`.`sites_transport`, `Event`.`nb_plannings`, `Event`.`montant_promotion_prestation_by_participant`, (MONTH(`Event`.`debut`)) AS `Event__monthDebut`, (YEAR(`Event`.`debut`)) AS `Event__yearDebut`, (MONTH(`Event`.`fin`)) AS `Event__monthFin`, (YEAR(`Event`.`fin`)) AS `Event__yearFin`, (CONCAT(`Event`.`name`," • ",date_format(`Event`.`debut`, '%d/%m/%Y')," au ",date_format(`Event`.`fin`, '%d/%m/%Y'))) AS `Event__eventDates`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Event`.`user_id`) AS `Event__UCR`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Event`.`user_modify_id`) AS `Event__UMR`, (SELECT DEP FROM departements D where `D`.`id` = `Event`.`departement_id`) AS `Event__DEP` FROM `ExtranetFFH`.`events_unes` AS `EventsUne` LEFT JOIN `ExtranetFFH`.`events` AS `Event` ON (`EventsUne`.`event_id` = `Event`.`id`) WHERE `type_une_id` = '000000216'001
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` = 2175825821
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` ASC24247
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 (11, 20, 25, 26, 47, 56, 59, 110, 115, 127, 133, 138, 175, 186, 208, 229, 230, 233, 239, 244, 257, 284, 287, 317, 599, 656, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 1280, 1352, 1353, 1354, 1355, 1356, 1357, 1358, 1359, 1360, 1362, 1363, 1364, 1365, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1965, 1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1974, 1975, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 2174, 2504, 2591, 2765, 2842, 2844, 2898, 2926, 2927, 2928, 2929, 2930, 2931, 2932, 2982, 3074, 3079, 3298, 3300, 3301, 3302, 3303, 3304, 3305, 3306, 3383, 3386, 3392, 3397, 3406, 3418, 3430, 3432, 3433, 3459, 3659, 3675, 3683, 3653, 3738, 3844, 3847, 3957, 3958, 3959, 3960, 3961, 3962, 3963, 3964, 3965, 3966, 3967, 3968, 3969, 3970, 3971, 3972, 3973, 3974, 3975, 3976, 3977, 3978, 3979, 3994, 4007, 4193, 4194, 4195, 4196, 4197, 4198, 4199, 4200, 4201, 4202, 4203, 4204, 4205, 4206, 4207, 4208, 4209, 4290, 4321, 4322, 4693, 4733, 4743, 4778, 4888, 4892, 4897, 4904, 4908, 4911, 4922, 4959, 5237, 5240, 5257, 5372, 5389, 5390, 5395, 5405, 5430, 5450, 5562, 5630, 5639, 5743, 6355, 6389, 6432, 6530, 6534, 6608, 6729, 6730, 6732, 6733, 6734, 6735, 6736, 6737, 6761, 6763, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6774, 6775, 6776, 6777, 6778, 6779, 6780, 6781, 6792, 6793, 6794, 6795, 6796, 6797, 6927, 7080, 7081, 7082, 7083, 7084, 7085, 7086, 7088, 7089, 7090, 7174, 7175, 7176, 7177, 7178, 7179, 7180, 7181, 7182, 7183, 7184, 7185, 7218, 7274, 7288, 7440, 7447, 7584, 7593, 7592, 7594, 7659, 7705, 7706, 8022, 8026, 8085, 8137, 8140, 8138, 8152, 8176, 8177, 8179, 8180, 8181, 8182, 8183, 8184, 8220, 8275, 8293, 8336, 8370, 8380, 8382, 8383, 8384, 8386, 8388, 8389, 8390, 8392, 8393, 8394, 8396, 8397, 8398, 8399, 8400, 8401, 8403, 8404, 8405, 8406, 8407, 8409, 8410, 8411, 8412, 8413, 8414, 8416, 8417, 8418, 8492, 8501, 8513, 8562, 8626, 8702, 8703, 8704, 8726, 9037, 9128, 9129, 9130, 9131, 9132, 9133, 9134, 9135, 9136, 9137, 9138, 9139, 9140, 9141, 9142, 9143, 9144, 9145, 9146, 9147, 9148, 9453, 9468, 9607, 9610, 9620, 9639, 9931, 9932, 9933, 9934, 9935, 9936, 9937, 9938, 9939, 9940, 9941, 9942, 9943, 9956, 9959, 9993, 10017, 10019, 10020, 10021, 10022, 10047, 10048, 10186, 10234, 10247, 10248, 10249, 10250, 10261, 10373, 10395, 10401, 10403, 10443, 10500, 10502, 10540, 10828, 10833, 10850, 10851, 10875, 9764, 10975, 11092, 11098, 11159, 11160, 11162, 11182, 11305, 11445, 11446, 11447, 11448, 11449, 11450, 11451, 11452, 11453, 11454, 11455, 11456, 11457, 11458, 11459, 11810, 11811, 11812, 11813, 11815, 11874, 12102, 12109, 12136, 12137, 12138, 12528, 12564, 12565, 12566, 12567, 12768, 12772, 12788, 12800, 12882, 12887, 12889, 12896, 12904, 12925, 12931, 13121, 13151, 13198, 13245, 13251, 13348, 13401, 13405, 13495, 13652, 13662, 13688, 13689, 13718, 13743, 13811, 13354, 13976, 14000, 14017, 14143, 14144, 14145, 14173, 14724, 14823, 14839, 14863, 14914, 14966, 15033, 15068, 15118, 15127, 15171, 15172, 15313, 15316, 15324, 15358, 15359, 15360, 15441, 15491, 15520, 15526, 15528, 15529, 15530, 15531, 15532, 15533, 15534, 15535, 15536, 15537, 15546, 15547, 15548, 15549, 15551, 15552, 15553, 15554, 15555, 15610, 15678, 15679, 15680, 15681, 15722, 15822, 15831, 15835, 15837, 15894) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '04'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '04')))) ORDER BY `Event`.`debut` ASC LIMIT 100002
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`.`id` IN (11, 20, 25, 26, 47, 56, 59, 110, 115, 127, 133, 138, 175, 186, 208, 229, 230, 233, 239, 244, 257, 284, 287, 317, 599, 656, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 1280, 1352, 1353, 1354, 1355, 1356, 1357, 1358, 1359, 1360, 1362, 1363, 1364, 1365, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1965, 1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1974, 1975, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 2174, 2504, 2591, 2765, 2842, 2844, 2898, 2926, 2927, 2928, 2929, 2930, 2931, 2932, 2982, 3074, 3079, 3298, 3300, 3301, 3302, 3303, 3304, 3305, 3306, 3383, 3386, 3392, 3397, 3406, 3418, 3430, 3432, 3433, 3459, 3659, 3675, 3683, 3653, 3738, 3844, 3847, 3957, 3958, 3959, 3960, 3961, 3962, 3963, 3964, 3965, 3966, 3967, 3968, 3969, 3970, 3971, 3972, 3973, 3974, 3975, 3976, 3977, 3978, 3979, 3994, 4007, 4193, 4194, 4195, 4196, 4197, 4198, 4199, 4200, 4201, 4202, 4203, 4204, 4205, 4206, 4207, 4208, 4209, 4290, 4321, 4322, 4693, 4733, 4743, 4778, 4888, 4892, 4897, 4904, 4908, 4911, 4922, 4959, 5237, 5240, 5257, 5372, 5389, 5390, 5395, 5405, 5430, 5450, 5562, 5630, 5639, 5743, 6355, 6389, 6432, 6530, 6534, 6608, 6729, 6730, 6732, 6733, 6734, 6735, 6736, 6737, 6761, 6763, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6774, 6775, 6776, 6777, 6778, 6779, 6780, 6781, 6792, 6793, 6794, 6795, 6796, 6797, 6927, 7080, 7081, 7082, 7083, 7084, 7085, 7086, 7088, 7089, 7090, 7174, 7175, 7176, 7177, 7178, 7179, 7180, 7181, 7182, 7183, 7184, 7185, 7218, 7274, 7288, 7440, 7447, 7584, 7593, 7592, 7594, 7659, 7705, 7706, 8022, 8026, 8085, 8137, 8140, 8138, 8152, 8176, 8177, 8179, 8180, 8181, 8182, 8183, 8184, 8220, 8275, 8293, 8336, 8370, 8380, 8382, 8383, 8384, 8386, 8388, 8389, 8390, 8392, 8393, 8394, 8396, 8397, 8398, 8399, 8400, 8401, 8403, 8404, 8405, 8406, 8407, 8409, 8410, 8411, 8412, 8413, 8414, 8416, 8417, 8418, 8492, 8501, 8513, 8562, 8626, 8702, 8703, 8704, 8726, 9037, 9128, 9129, 9130, 9131, 9132, 9133, 9134, 9135, 9136, 9137, 9138, 9139, 9140, 9141, 9142, 9143, 9144, 9145, 9146, 9147, 9148, 9453, 9468, 9607, 9610, 9620, 9639, 9931, 9932, 9933, 9934, 9935, 9936, 9937, 9938, 9939, 9940, 9941, 9942, 9943, 9956, 9959, 9993, 10017, 10019, 10020, 10021, 10022, 10047, 10048, 10186, 10234, 10247, 10248, 10249, 10250, 10261, 10373, 10395, 10401, 10403, 10443, 10500, 10502, 10540, 10828, 10833, 10850, 10851, 10875, 9764, 10975, 11092, 11098, 11159, 11160, 11162, 11182, 11305, 11445, 11446, 11447, 11448, 11449, 11450, 11451, 11452, 11453, 11454, 11455, 11456, 11457, 11458, 11459, 11810, 11811, 11812, 11813, 11815, 11874, 12102, 12109, 12136, 12137, 12138, 12528, 12564, 12565, 12566, 12567, 12768, 12772, 12788, 12800, 12882, 12887, 12889, 12896, 12904, 12925, 12931, 13121, 13151, 13198, 13245, 13251, 13348, 13401, 13405, 13495, 13652, 13662, 13688, 13689, 13718, 13743, 13811, 13354, 13976, 14000, 14017, 14143, 14144, 14145, 14173, 14724, 14823, 14839, 14863, 14914, 14966, 15033, 15068, 15118, 15127, 15171, 15172, 15313, 15316, 15324, 15358, 15359, 15360, 15441, 15491, 15520, 15526, 15528, 15529, 15530, 15531, 15532, 15533, 15534, 15535, 15536, 15537, 15546, 15547, 15548, 15549, 15551, 15552, 15553, 15554, 15555, 15610, 15678, 15679, 15680, 15681, 15722, 15822, 15831, 15835, 15837, 15894) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '05'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '05')))) ORDER BY `Event`.`debut` ASC LIMIT 100002
11SELECT `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 (11, 20, 25, 26, 47, 56, 59, 110, 115, 127, 133, 138, 175, 186, 208, 229, 230, 233, 239, 244, 257, 284, 287, 317, 599, 656, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 1280, 1352, 1353, 1354, 1355, 1356, 1357, 1358, 1359, 1360, 1362, 1363, 1364, 1365, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1965, 1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1974, 1975, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 2174, 2504, 2591, 2765, 2842, 2844, 2898, 2926, 2927, 2928, 2929, 2930, 2931, 2932, 2982, 3074, 3079, 3298, 3300, 3301, 3302, 3303, 3304, 3305, 3306, 3383, 3386, 3392, 3397, 3406, 3418, 3430, 3432, 3433, 3459, 3659, 3675, 3683, 3653, 3738, 3844, 3847, 3957, 3958, 3959, 3960, 3961, 3962, 3963, 3964, 3965, 3966, 3967, 3968, 3969, 3970, 3971, 3972, 3973, 3974, 3975, 3976, 3977, 3978, 3979, 3994, 4007, 4193, 4194, 4195, 4196, 4197, 4198, 4199, 4200, 4201, 4202, 4203, 4204, 4205, 4206, 4207, 4208, 4209, 4290, 4321, 4322, 4693, 4733, 4743, 4778, 4888, 4892, 4897, 4904, 4908, 4911, 4922, 4959, 5237, 5240, 5257, 5372, 5389, 5390, 5395, 5405, 5430, 5450, 5562, 5630, 5639, 5743, 6355, 6389, 6432, 6530, 6534, 6608, 6729, 6730, 6732, 6733, 6734, 6735, 6736, 6737, 6761, 6763, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6774, 6775, 6776, 6777, 6778, 6779, 6780, 6781, 6792, 6793, 6794, 6795, 6796, 6797, 6927, 7080, 7081, 7082, 7083, 7084, 7085, 7086, 7088, 7089, 7090, 7174, 7175, 7176, 7177, 7178, 7179, 7180, 7181, 7182, 7183, 7184, 7185, 7218, 7274, 7288, 7440, 7447, 7584, 7593, 7592, 7594, 7659, 7705, 7706, 8022, 8026, 8085, 8137, 8140, 8138, 8152, 8176, 8177, 8179, 8180, 8181, 8182, 8183, 8184, 8220, 8275, 8293, 8336, 8370, 8380, 8382, 8383, 8384, 8386, 8388, 8389, 8390, 8392, 8393, 8394, 8396, 8397, 8398, 8399, 8400, 8401, 8403, 8404, 8405, 8406, 8407, 8409, 8410, 8411, 8412, 8413, 8414, 8416, 8417, 8418, 8492, 8501, 8513, 8562, 8626, 8702, 8703, 8704, 8726, 9037, 9128, 9129, 9130, 9131, 9132, 9133, 9134, 9135, 9136, 9137, 9138, 9139, 9140, 9141, 9142, 9143, 9144, 9145, 9146, 9147, 9148, 9453, 9468, 9607, 9610, 9620, 9639, 9931, 9932, 9933, 9934, 9935, 9936, 9937, 9938, 9939, 9940, 9941, 9942, 9943, 9956, 9959, 9993, 10017, 10019, 10020, 10021, 10022, 10047, 10048, 10186, 10234, 10247, 10248, 10249, 10250, 10261, 10373, 10395, 10401, 10403, 10443, 10500, 10502, 10540, 10828, 10833, 10850, 10851, 10875, 9764, 10975, 11092, 11098, 11159, 11160, 11162, 11182, 11305, 11445, 11446, 11447, 11448, 11449, 11450, 11451, 11452, 11453, 11454, 11455, 11456, 11457, 11458, 11459, 11810, 11811, 11812, 11813, 11815, 11874, 12102, 12109, 12136, 12137, 12138, 12528, 12564, 12565, 12566, 12567, 12768, 12772, 12788, 12800, 12882, 12887, 12889, 12896, 12904, 12925, 12931, 13121, 13151, 13198, 13245, 13251, 13348, 13401, 13405, 13495, 13652, 13662, 13688, 13689, 13718, 13743, 13811, 13354, 13976, 14000, 14017, 14143, 14144, 14145, 14173, 14724, 14823, 14839, 14863, 14914, 14966, 15033, 15068, 15118, 15127, 15171, 15172, 15313, 15316, 15324, 15358, 15359, 15360, 15441, 15491, 15520, 15526, 15528, 15529, 15530, 15531, 15532, 15533, 15534, 15535, 15536, 15537, 15546, 15547, 15548, 15549, 15551, 15552, 15553, 15554, 15555, 15610, 15678, 15679, 15680, 15681, 15722, 15822, 15831, 15835, 15837, 15894) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '06'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '06')))) ORDER BY `Event`.`debut` ASC LIMIT 100222
12SELECT `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 (14145, 15520)220
13SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '20'110
14SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '20'110
15SELECT `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 (11, 20, 25, 26, 47, 56, 59, 110, 115, 127, 133, 138, 175, 186, 208, 229, 230, 233, 239, 244, 257, 284, 287, 317, 599, 656, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 1280, 1352, 1353, 1354, 1355, 1356, 1357, 1358, 1359, 1360, 1362, 1363, 1364, 1365, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1965, 1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1974, 1975, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 2174, 2504, 2591, 2765, 2842, 2844, 2898, 2926, 2927, 2928, 2929, 2930, 2931, 2932, 2982, 3074, 3079, 3298, 3300, 3301, 3302, 3303, 3304, 3305, 3306, 3383, 3386, 3392, 3397, 3406, 3418, 3430, 3432, 3433, 3459, 3659, 3675, 3683, 3653, 3738, 3844, 3847, 3957, 3958, 3959, 3960, 3961, 3962, 3963, 3964, 3965, 3966, 3967, 3968, 3969, 3970, 3971, 3972, 3973, 3974, 3975, 3976, 3977, 3978, 3979, 3994, 4007, 4193, 4194, 4195, 4196, 4197, 4198, 4199, 4200, 4201, 4202, 4203, 4204, 4205, 4206, 4207, 4208, 4209, 4290, 4321, 4322, 4693, 4733, 4743, 4778, 4888, 4892, 4897, 4904, 4908, 4911, 4922, 4959, 5237, 5240, 5257, 5372, 5389, 5390, 5395, 5405, 5430, 5450, 5562, 5630, 5639, 5743, 6355, 6389, 6432, 6530, 6534, 6608, 6729, 6730, 6732, 6733, 6734, 6735, 6736, 6737, 6761, 6763, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6774, 6775, 6776, 6777, 6778, 6779, 6780, 6781, 6792, 6793, 6794, 6795, 6796, 6797, 6927, 7080, 7081, 7082, 7083, 7084, 7085, 7086, 7088, 7089, 7090, 7174, 7175, 7176, 7177, 7178, 7179, 7180, 7181, 7182, 7183, 7184, 7185, 7218, 7274, 7288, 7440, 7447, 7584, 7593, 7592, 7594, 7659, 7705, 7706, 8022, 8026, 8085, 8137, 8140, 8138, 8152, 8176, 8177, 8179, 8180, 8181, 8182, 8183, 8184, 8220, 8275, 8293, 8336, 8370, 8380, 8382, 8383, 8384, 8386, 8388, 8389, 8390, 8392, 8393, 8394, 8396, 8397, 8398, 8399, 8400, 8401, 8403, 8404, 8405, 8406, 8407, 8409, 8410, 8411, 8412, 8413, 8414, 8416, 8417, 8418, 8492, 8501, 8513, 8562, 8626, 8702, 8703, 8704, 8726, 9037, 9128, 9129, 9130, 9131, 9132, 9133, 9134, 9135, 9136, 9137, 9138, 9139, 9140, 9141, 9142, 9143, 9144, 9145, 9146, 9147, 9148, 9453, 9468, 9607, 9610, 9620, 9639, 9931, 9932, 9933, 9934, 9935, 9936, 9937, 9938, 9939, 9940, 9941, 9942, 9943, 9956, 9959, 9993, 10017, 10019, 10020, 10021, 10022, 10047, 10048, 10186, 10234, 10247, 10248, 10249, 10250, 10261, 10373, 10395, 10401, 10403, 10443, 10500, 10502, 10540, 10828, 10833, 10850, 10851, 10875, 9764, 10975, 11092, 11098, 11159, 11160, 11162, 11182, 11305, 11445, 11446, 11447, 11448, 11449, 11450, 11451, 11452, 11453, 11454, 11455, 11456, 11457, 11458, 11459, 11810, 11811, 11812, 11813, 11815, 11874, 12102, 12109, 12136, 12137, 12138, 12528, 12564, 12565, 12566, 12567, 12768, 12772, 12788, 12800, 12882, 12887, 12889, 12896, 12904, 12925, 12931, 13121, 13151, 13198, 13245, 13251, 13348, 13401, 13405, 13495, 13652, 13662, 13688, 13689, 13718, 13743, 13811, 13354, 13976, 14000, 14017, 14143, 14144, 14145, 14173, 14724, 14823, 14839, 14863, 14914, 14966, 15033, 15068, 15118, 15127, 15171, 15172, 15313, 15316, 15324, 15358, 15359, 15360, 15441, 15491, 15520, 15526, 15528, 15529, 15530, 15531, 15532, 15533, 15534, 15535, 15536, 15537, 15546, 15547, 15548, 15549, 15551, 15552, 15553, 15554, 15555, 15610, 15678, 15679, 15680, 15681, 15722, 15822, 15831, 15835, 15837, 15894) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '07'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '07')))) ORDER BY `Event`.`debut` ASC LIMIT 100002
16SELECT `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 (11, 20, 25, 26, 47, 56, 59, 110, 115, 127, 133, 138, 175, 186, 208, 229, 230, 233, 239, 244, 257, 284, 287, 317, 599, 656, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 1280, 1352, 1353, 1354, 1355, 1356, 1357, 1358, 1359, 1360, 1362, 1363, 1364, 1365, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1965, 1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1974, 1975, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 2174, 2504, 2591, 2765, 2842, 2844, 2898, 2926, 2927, 2928, 2929, 2930, 2931, 2932, 2982, 3074, 3079, 3298, 3300, 3301, 3302, 3303, 3304, 3305, 3306, 3383, 3386, 3392, 3397, 3406, 3418, 3430, 3432, 3433, 3459, 3659, 3675, 3683, 3653, 3738, 3844, 3847, 3957, 3958, 3959, 3960, 3961, 3962, 3963, 3964, 3965, 3966, 3967, 3968, 3969, 3970, 3971, 3972, 3973, 3974, 3975, 3976, 3977, 3978, 3979, 3994, 4007, 4193, 4194, 4195, 4196, 4197, 4198, 4199, 4200, 4201, 4202, 4203, 4204, 4205, 4206, 4207, 4208, 4209, 4290, 4321, 4322, 4693, 4733, 4743, 4778, 4888, 4892, 4897, 4904, 4908, 4911, 4922, 4959, 5237, 5240, 5257, 5372, 5389, 5390, 5395, 5405, 5430, 5450, 5562, 5630, 5639, 5743, 6355, 6389, 6432, 6530, 6534, 6608, 6729, 6730, 6732, 6733, 6734, 6735, 6736, 6737, 6761, 6763, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6774, 6775, 6776, 6777, 6778, 6779, 6780, 6781, 6792, 6793, 6794, 6795, 6796, 6797, 6927, 7080, 7081, 7082, 7083, 7084, 7085, 7086, 7088, 7089, 7090, 7174, 7175, 7176, 7177, 7178, 7179, 7180, 7181, 7182, 7183, 7184, 7185, 7218, 7274, 7288, 7440, 7447, 7584, 7593, 7592, 7594, 7659, 7705, 7706, 8022, 8026, 8085, 8137, 8140, 8138, 8152, 8176, 8177, 8179, 8180, 8181, 8182, 8183, 8184, 8220, 8275, 8293, 8336, 8370, 8380, 8382, 8383, 8384, 8386, 8388, 8389, 8390, 8392, 8393, 8394, 8396, 8397, 8398, 8399, 8400, 8401, 8403, 8404, 8405, 8406, 8407, 8409, 8410, 8411, 8412, 8413, 8414, 8416, 8417, 8418, 8492, 8501, 8513, 8562, 8626, 8702, 8703, 8704, 8726, 9037, 9128, 9129, 9130, 9131, 9132, 9133, 9134, 9135, 9136, 9137, 9138, 9139, 9140, 9141, 9142, 9143, 9144, 9145, 9146, 9147, 9148, 9453, 9468, 9607, 9610, 9620, 9639, 9931, 9932, 9933, 9934, 9935, 9936, 9937, 9938, 9939, 9940, 9941, 9942, 9943, 9956, 9959, 9993, 10017, 10019, 10020, 10021, 10022, 10047, 10048, 10186, 10234, 10247, 10248, 10249, 10250, 10261, 10373, 10395, 10401, 10403, 10443, 10500, 10502, 10540, 10828, 10833, 10850, 10851, 10875, 9764, 10975, 11092, 11098, 11159, 11160, 11162, 11182, 11305, 11445, 11446, 11447, 11448, 11449, 11450, 11451, 11452, 11453, 11454, 11455, 11456, 11457, 11458, 11459, 11810, 11811, 11812, 11813, 11815, 11874, 12102, 12109, 12136, 12137, 12138, 12528, 12564, 12565, 12566, 12567, 12768, 12772, 12788, 12800, 12882, 12887, 12889, 12896, 12904, 12925, 12931, 13121, 13151, 13198, 13245, 13251, 13348, 13401, 13405, 13495, 13652, 13662, 13688, 13689, 13718, 13743, 13811, 13354, 13976, 14000, 14017, 14143, 14144, 14145, 14173, 14724, 14823, 14839, 14863, 14914, 14966, 15033, 15068, 15118, 15127, 15171, 15172, 15313, 15316, 15324, 15358, 15359, 15360, 15441, 15491, 15520, 15526, 15528, 15529, 15530, 15531, 15532, 15533, 15534, 15535, 15536, 15537, 15546, 15547, 15548, 15549, 15551, 15552, 15553, 15554, 15555, 15610, 15678, 15679, 15680, 15681, 15722, 15822, 15831, 15835, 15837, 15894) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '08'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '08')))) ORDER BY `Event`.`debut` ASC LIMIT 100002
17SELECT `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 (11, 20, 25, 26, 47, 56, 59, 110, 115, 127, 133, 138, 175, 186, 208, 229, 230, 233, 239, 244, 257, 284, 287, 317, 599, 656, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 1280, 1352, 1353, 1354, 1355, 1356, 1357, 1358, 1359, 1360, 1362, 1363, 1364, 1365, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1965, 1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1974, 1975, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 2174, 2504, 2591, 2765, 2842, 2844, 2898, 2926, 2927, 2928, 2929, 2930, 2931, 2932, 2982, 3074, 3079, 3298, 3300, 3301, 3302, 3303, 3304, 3305, 3306, 3383, 3386, 3392, 3397, 3406, 3418, 3430, 3432, 3433, 3459, 3659, 3675, 3683, 3653, 3738, 3844, 3847, 3957, 3958, 3959, 3960, 3961, 3962, 3963, 3964, 3965, 3966, 3967, 3968, 3969, 3970, 3971, 3972, 3973, 3974, 3975, 3976, 3977, 3978, 3979, 3994, 4007, 4193, 4194, 4195, 4196, 4197, 4198, 4199, 4200, 4201, 4202, 4203, 4204, 4205, 4206, 4207, 4208, 4209, 4290, 4321, 4322, 4693, 4733, 4743, 4778, 4888, 4892, 4897, 4904, 4908, 4911, 4922, 4959, 5237, 5240, 5257, 5372, 5389, 5390, 5395, 5405, 5430, 5450, 5562, 5630, 5639, 5743, 6355, 6389, 6432, 6530, 6534, 6608, 6729, 6730, 6732, 6733, 6734, 6735, 6736, 6737, 6761, 6763, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6774, 6775, 6776, 6777, 6778, 6779, 6780, 6781, 6792, 6793, 6794, 6795, 6796, 6797, 6927, 7080, 7081, 7082, 7083, 7084, 7085, 7086, 7088, 7089, 7090, 7174, 7175, 7176, 7177, 7178, 7179, 7180, 7181, 7182, 7183, 7184, 7185, 7218, 7274, 7288, 7440, 7447, 7584, 7593, 7592, 7594, 7659, 7705, 7706, 8022, 8026, 8085, 8137, 8140, 8138, 8152, 8176, 8177, 8179, 8180, 8181, 8182, 8183, 8184, 8220, 8275, 8293, 8336, 8370, 8380, 8382, 8383, 8384, 8386, 8388, 8389, 8390, 8392, 8393, 8394, 8396, 8397, 8398, 8399, 8400, 8401, 8403, 8404, 8405, 8406, 8407, 8409, 8410, 8411, 8412, 8413, 8414, 8416, 8417, 8418, 8492, 8501, 8513, 8562, 8626, 8702, 8703, 8704, 8726, 9037, 9128, 9129, 9130, 9131, 9132, 9133, 9134, 9135, 9136, 9137, 9138, 9139, 9140, 9141, 9142, 9143, 9144, 9145, 9146, 9147, 9148, 9453, 9468, 9607, 9610, 9620, 9639, 9931, 9932, 9933, 9934, 9935, 9936, 9937, 9938, 9939, 9940, 9941, 9942, 9943, 9956, 9959, 9993, 10017, 10019, 10020, 10021, 10022, 10047, 10048, 10186, 10234, 10247, 10248, 10249, 10250, 10261, 10373, 10395, 10401, 10403, 10443, 10500, 10502, 10540, 10828, 10833, 10850, 10851, 10875, 9764, 10975, 11092, 11098, 11159, 11160, 11162, 11182, 11305, 11445, 11446, 11447, 11448, 11449, 11450, 11451, 11452, 11453, 11454, 11455, 11456, 11457, 11458, 11459, 11810, 11811, 11812, 11813, 11815, 11874, 12102, 12109, 12136, 12137, 12138, 12528, 12564, 12565, 12566, 12567, 12768, 12772, 12788, 12800, 12882, 12887, 12889, 12896, 12904, 12925, 12931, 13121, 13151, 13198, 13245, 13251, 13348, 13401, 13405, 13495, 13652, 13662, 13688, 13689, 13718, 13743, 13811, 13354, 13976, 14000, 14017, 14143, 14144, 14145, 14173, 14724, 14823, 14839, 14863, 14914, 14966, 15033, 15068, 15118, 15127, 15171, 15172, 15313, 15316, 15324, 15358, 15359, 15360, 15441, 15491, 15520, 15526, 15528, 15529, 15530, 15531, 15532, 15533, 15534, 15535, 15536, 15537, 15546, 15547, 15548, 15549, 15551, 15552, 15553, 15554, 15555, 15610, 15678, 15679, 15680, 15681, 15722, 15822, 15831, 15835, 15837, 15894) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '09'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '09')))) ORDER BY `Event`.`debut` ASC LIMIT 100002
18SELECT `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 (11, 20, 25, 26, 47, 56, 59, 110, 115, 127, 133, 138, 175, 186, 208, 229, 230, 233, 239, 244, 257, 284, 287, 317, 599, 656, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 1280, 1352, 1353, 1354, 1355, 1356, 1357, 1358, 1359, 1360, 1362, 1363, 1364, 1365, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1965, 1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1974, 1975, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 2174, 2504, 2591, 2765, 2842, 2844, 2898, 2926, 2927, 2928, 2929, 2930, 2931, 2932, 2982, 3074, 3079, 3298, 3300, 3301, 3302, 3303, 3304, 3305, 3306, 3383, 3386, 3392, 3397, 3406, 3418, 3430, 3432, 3433, 3459, 3659, 3675, 3683, 3653, 3738, 3844, 3847, 3957, 3958, 3959, 3960, 3961, 3962, 3963, 3964, 3965, 3966, 3967, 3968, 3969, 3970, 3971, 3972, 3973, 3974, 3975, 3976, 3977, 3978, 3979, 3994, 4007, 4193, 4194, 4195, 4196, 4197, 4198, 4199, 4200, 4201, 4202, 4203, 4204, 4205, 4206, 4207, 4208, 4209, 4290, 4321, 4322, 4693, 4733, 4743, 4778, 4888, 4892, 4897, 4904, 4908, 4911, 4922, 4959, 5237, 5240, 5257, 5372, 5389, 5390, 5395, 5405, 5430, 5450, 5562, 5630, 5639, 5743, 6355, 6389, 6432, 6530, 6534, 6608, 6729, 6730, 6732, 6733, 6734, 6735, 6736, 6737, 6761, 6763, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6774, 6775, 6776, 6777, 6778, 6779, 6780, 6781, 6792, 6793, 6794, 6795, 6796, 6797, 6927, 7080, 7081, 7082, 7083, 7084, 7085, 7086, 7088, 7089, 7090, 7174, 7175, 7176, 7177, 7178, 7179, 7180, 7181, 7182, 7183, 7184, 7185, 7218, 7274, 7288, 7440, 7447, 7584, 7593, 7592, 7594, 7659, 7705, 7706, 8022, 8026, 8085, 8137, 8140, 8138, 8152, 8176, 8177, 8179, 8180, 8181, 8182, 8183, 8184, 8220, 8275, 8293, 8336, 8370, 8380, 8382, 8383, 8384, 8386, 8388, 8389, 8390, 8392, 8393, 8394, 8396, 8397, 8398, 8399, 8400, 8401, 8403, 8404, 8405, 8406, 8407, 8409, 8410, 8411, 8412, 8413, 8414, 8416, 8417, 8418, 8492, 8501, 8513, 8562, 8626, 8702, 8703, 8704, 8726, 9037, 9128, 9129, 9130, 9131, 9132, 9133, 9134, 9135, 9136, 9137, 9138, 9139, 9140, 9141, 9142, 9143, 9144, 9145, 9146, 9147, 9148, 9453, 9468, 9607, 9610, 9620, 9639, 9931, 9932, 9933, 9934, 9935, 9936, 9937, 9938, 9939, 9940, 9941, 9942, 9943, 9956, 9959, 9993, 10017, 10019, 10020, 10021, 10022, 10047, 10048, 10186, 10234, 10247, 10248, 10249, 10250, 10261, 10373, 10395, 10401, 10403, 10443, 10500, 10502, 10540, 10828, 10833, 10850, 10851, 10875, 9764, 10975, 11092, 11098, 11159, 11160, 11162, 11182, 11305, 11445, 11446, 11447, 11448, 11449, 11450, 11451, 11452, 11453, 11454, 11455, 11456, 11457, 11458, 11459, 11810, 11811, 11812, 11813, 11815, 11874, 12102, 12109, 12136, 12137, 12138, 12528, 12564, 12565, 12566, 12567, 12768, 12772, 12788, 12800, 12882, 12887, 12889, 12896, 12904, 12925, 12931, 13121, 13151, 13198, 13245, 13251, 13348, 13401, 13405, 13495, 13652, 13662, 13688, 13689, 13718, 13743, 13811, 13354, 13976, 14000, 14017, 14143, 14144, 14145, 14173, 14724, 14823, 14839, 14863, 14914, 14966, 15033, 15068, 15118, 15127, 15171, 15172, 15313, 15316, 15324, 15358, 15359, 15360, 15441, 15491, 15520, 15526, 15528, 15529, 15530, 15531, 15532, 15533, 15534, 15535, 15536, 15537, 15546, 15547, 15548, 15549, 15551, 15552, 15553, 15554, 15555, 15610, 15678, 15679, 15680, 15681, 15722, 15822, 15831, 15835, 15837, 15894) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '10'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '10')))) ORDER BY `Event`.`debut` ASC LIMIT 100002
19SELECT `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 (11, 20, 25, 26, 47, 56, 59, 110, 115, 127, 133, 138, 175, 186, 208, 229, 230, 233, 239, 244, 257, 284, 287, 317, 599, 656, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 1280, 1352, 1353, 1354, 1355, 1356, 1357, 1358, 1359, 1360, 1362, 1363, 1364, 1365, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1965, 1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1974, 1975, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 2174, 2504, 2591, 2765, 2842, 2844, 2898, 2926, 2927, 2928, 2929, 2930, 2931, 2932, 2982, 3074, 3079, 3298, 3300, 3301, 3302, 3303, 3304, 3305, 3306, 3383, 3386, 3392, 3397, 3406, 3418, 3430, 3432, 3433, 3459, 3659, 3675, 3683, 3653, 3738, 3844, 3847, 3957, 3958, 3959, 3960, 3961, 3962, 3963, 3964, 3965, 3966, 3967, 3968, 3969, 3970, 3971, 3972, 3973, 3974, 3975, 3976, 3977, 3978, 3979, 3994, 4007, 4193, 4194, 4195, 4196, 4197, 4198, 4199, 4200, 4201, 4202, 4203, 4204, 4205, 4206, 4207, 4208, 4209, 4290, 4321, 4322, 4693, 4733, 4743, 4778, 4888, 4892, 4897, 4904, 4908, 4911, 4922, 4959, 5237, 5240, 5257, 5372, 5389, 5390, 5395, 5405, 5430, 5450, 5562, 5630, 5639, 5743, 6355, 6389, 6432, 6530, 6534, 6608, 6729, 6730, 6732, 6733, 6734, 6735, 6736, 6737, 6761, 6763, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6774, 6775, 6776, 6777, 6778, 6779, 6780, 6781, 6792, 6793, 6794, 6795, 6796, 6797, 6927, 7080, 7081, 7082, 7083, 7084, 7085, 7086, 7088, 7089, 7090, 7174, 7175, 7176, 7177, 7178, 7179, 7180, 7181, 7182, 7183, 7184, 7185, 7218, 7274, 7288, 7440, 7447, 7584, 7593, 7592, 7594, 7659, 7705, 7706, 8022, 8026, 8085, 8137, 8140, 8138, 8152, 8176, 8177, 8179, 8180, 8181, 8182, 8183, 8184, 8220, 8275, 8293, 8336, 8370, 8380, 8382, 8383, 8384, 8386, 8388, 8389, 8390, 8392, 8393, 8394, 8396, 8397, 8398, 8399, 8400, 8401, 8403, 8404, 8405, 8406, 8407, 8409, 8410, 8411, 8412, 8413, 8414, 8416, 8417, 8418, 8492, 8501, 8513, 8562, 8626, 8702, 8703, 8704, 8726, 9037, 9128, 9129, 9130, 9131, 9132, 9133, 9134, 9135, 9136, 9137, 9138, 9139, 9140, 9141, 9142, 9143, 9144, 9145, 9146, 9147, 9148, 9453, 9468, 9607, 9610, 9620, 9639, 9931, 9932, 9933, 9934, 9935, 9936, 9937, 9938, 9939, 9940, 9941, 9942, 9943, 9956, 9959, 9993, 10017, 10019, 10020, 10021, 10022, 10047, 10048, 10186, 10234, 10247, 10248, 10249, 10250, 10261, 10373, 10395, 10401, 10403, 10443, 10500, 10502, 10540, 10828, 10833, 10850, 10851, 10875, 9764, 10975, 11092, 11098, 11159, 11160, 11162, 11182, 11305, 11445, 11446, 11447, 11448, 11449, 11450, 11451, 11452, 11453, 11454, 11455, 11456, 11457, 11458, 11459, 11810, 11811, 11812, 11813, 11815, 11874, 12102, 12109, 12136, 12137, 12138, 12528, 12564, 12565, 12566, 12567, 12768, 12772, 12788, 12800, 12882, 12887, 12889, 12896, 12904, 12925, 12931, 13121, 13151, 13198, 13245, 13251, 13348, 13401, 13405, 13495, 13652, 13662, 13688, 13689, 13718, 13743, 13811, 13354, 13976, 14000, 14017, 14143, 14144, 14145, 14173, 14724, 14823, 14839, 14863, 14914, 14966, 15033, 15068, 15118, 15127, 15171, 15172, 15313, 15316, 15324, 15358, 15359, 15360, 15441, 15491, 15520, 15526, 15528, 15529, 15530, 15531, 15532, 15533, 15534, 15535, 15536, 15537, 15546, 15547, 15548, 15549, 15551, 15552, 15553, 15554, 15555, 15610, 15678, 15679, 15680, 15681, 15722, 15822, 15831, 15835, 15837, 15894) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '11'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '11')))) ORDER BY `Event`.`debut` ASC LIMIT 100002
20SELECT `FamillesEvent`.`id`, `FamillesEvent`.`name` FROM `ExtranetFFH`.`familles_events` AS `FamillesEvent` WHERE 1 = 1 ORDER BY `name` ASC10100
21SELECT `Handicap`.`id`, `Handicap`.`name` FROM `ExtranetFFH`.`handicaps` AS `Handicap` WHERE 1 = 1 ORDER BY `name` ASC770
22SELECT `Region`.`id`, `Region`.`name` FROM `ExtranetFFH`.`regions` AS `Region` WHERE 1 = 1 ORDER BY `Region`.`name` ASC39390