RECHERCHER

Période du
au




ÉVÉNEMENTS DU MOIS
13 déc 15 déc 19
10 12 Avr
Reporté !
Annulé !
Séjour
Stage 1ère neige 2019 / Ski Alpin / Val thorens
Ski alpin
Notice (8): Undefined index: EventsSite [APP/View/Elements/bloc_calendar_avenir.ctp, line 118]
73
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) 21 queries took 353 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT SUBSTR(StructureNomCourt,7) as SPORT, `Structure`.`id` FROM `ExtranetFFH`.`structures` AS `Structure` WHERE `StructureCode` = '000000231' LIMIT 1112
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` ASC242413
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 = 12454424544276
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` DESC333322
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` = '000000231'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` = 2327507501
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 (3179, 3216, 3217, 3218, 3219, 3220, 3221, 3867, 3891, 3892, 3893, 3894, 3895, 4276, 4581, 4582, 5935, 5941, 6834, 7645, 7669, 2467, 9487, 11078, 11089, 12396, 12397, 12398, 12399, 12402, 12403, 12991, 15018, 7, 12, 17, 23, 28, 34, 39, 41, 43, 45, 49, 55, 65, 68, 73, 77, 84, 87, 89, 91, 136, 145, 352, 368, 380, 396, 416, 418, 431, 433, 437, 438, 439, 442, 445, 449, 495, 708, 709, 710, 711, 712, 713, 714, 715, 716, 718, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1523, 1524, 1525, 1526, 1527, 1528, 1529, 1530, 1531, 1572, 1573, 1574, 1575, 1576, 1784, 1785, 1786, 1787, 1788, 1789, 1791, 1792, 1793, 1794, 1795, 1858, 1859, 1862, 1863, 1864, 1865, 1896, 1897, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2191, 2192, 2193, 2201, 2203, 2204, 2202, 2603, 2613, 2995, 3203, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3311, 3337, 3460, 3462, 3507, 3512, 3627, 3639, 3483, 3774, 3776, 3802, 3819, 3866, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3890, 3984, 3985, 4182, 4188, 4278, 4280, 4281, 4282, 4288, 4293, 4308, 4017, 4560, 4578, 4579, 4580, 4607, 4687, 4712, 4713, 4715, 4831, 4924, 5081, 5130, 5152, 5165, 5201, 5215, 5229, 5245, 5246, 5260, 5639, 5930, 5931, 5932, 5933, 5934, 6188, 6422, 6472, 6533, 6618, 6659, 6744, 6798, 6799, 6800, 6801, 6802, 6836, 7000, 7012, 7013, 7016, 7018, 7023, 7025, 7068, 7075, 7076, 7077, 7078, 7115, 7116, 7117, 7118, 7202, 7203, 7204, 7205, 7231, 7253, 7255, 7258, 7263, 7266, 7278, 7305, 7402, 7404, 7405, 7406, 7407, 7408, 7409, 7410, 7411, 7412, 7413, 7415, 7417, 7418, 7422, 7427, 7428, 7430, 7451, 7490, 7530, 7645, 7646, 7647, 7648, 7649, 7650, 7651, 7652, 7670, 7671, 7672, 7673, 7674, 7676, 7677, 7679, 8309, 1910, 8464, 2467, 8905, 9155, 9184, 9454, 9487, 9713, 9819, 9820, 9822, 9825, 9826, 9827, 9828, 9829, 9830, 9831, 9832, 9834, 9835, 9836, 9837, 9839, 9840, 9841, 9842, 9844, 9845, 9846, 9847, 9872, 9887, 9889, 9964, 9986, 9996, 10042, 10043, 10075, 10166, 10215, 10223, 10225, 10203, 10300, 10314, 10396, 10423, 10523, 10534, 10751, 10768, 10802, 10854, 10878, 10934, 10962, 10970, 10971, 10972, 10973, 10974, 10992, 10993, 10994, 11077, 11079, 11082, 11089, 11261, 11262, 11263, 11264, 11265, 11266, 11366, 11959, 11960, 11961, 11962, 11963, 11964, 11965, 11966, 11967, 11968, 12191, 12271, 12272, 12273, 12368, 12369, 12371, 12372, 12373, 12374, 12375, 12376, 12377, 12378, 12379, 12380, 12381, 12382, 12383, 12384, 12386, 12387, 12389, 12390, 12391, 12392, 12394, 12395, 12556, 12596, 12597, 12621, 12624, 12642, 12681, 12727, 12803, 12870, 12909, 12940, 12964, 12965, 12967, 12970, 12974, 12984, 12985, 12986, 12987, 12988, 12989, 12990, 12992, 13005, 13008, 13017, 13018, 13019, 13020, 13021, 13022, 13023, 13024, 13025, 13030, 13029, 13083, 13084, 13085, 13223, 13294, 13343, 13392, 13398, 13399, 13711, 14148, 14165, 14490, 14605, 14610, 14768, 14655, 14858, 14860, 14861, 14927, 14928, 14929, 14930, 14931, 14932, 14934, 14970, 14989, 14990, 14991, 14992, 14993, 15013, 15014, 15016, 15153, 15161, 15200, 15206, 15207, 15213, 15214, 15215, 15216, 15217, 15218, 15222, 15225, 15227, 15228, 15230, 15231, 15233, 15234, 15246, 15250, 15271, 15327, 15351, 15353, 15355, 15356, 15129, 15406, 15451, 15457, 15458, 15459, 15460, 15461, 15462, 15463, 15464, 15466, 15467, 15468, 15469, 15471, 15472, 15475, 15476, 15303, 15492, 15516, 15523, 15541, 15542, 15545, 15629, 15728, 15813, 15825, 15838, 15996, 15997, 15998, 15999, 6, 24, 29, 50, 51, 88, 137, 491, 699, 700, 701, 702, 703, 704, 705, 706, 707, 1030, 1031, 1032, 1033, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1332, 1532, 1533, 1534, 1535, 1558, 1570, 1571, 1796, 1797, 1798, 1805, 1806, 1807, 1808, 2098, 2099, 2100, 2101, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2603, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3311, 3337, 3639, 3868, 3869, 3870, 3871, 3985, 3987, 3989, 4048, 4226, 4280, 4303, 4308, 4017, 4677, 4720, 5201, 5164, 5936, 5937, 5938, 5939, 5940, 6317, 6744, 7231, 6835, 7402, 7431, 7451, 7490, 7529, 7645, 7653, 7654, 7656, 7657, 7658, 8218, 8234, 8309, 1910, 2467, 9155, 9713, 10044, 10045, 10046, 10166, 10225, 10314, 10396, 10523, 10534, 10546, 10547, 10549, 10550, 10551, 10803, 10852, 10878, 10933, 11089, 11260, 12274, 12276, 12278, 12279, 12280, 12281, 12282, 12556, 12597, 12692, 12864, 12908, 12940, 12964, 12969, 12983, 12984, 12277, 13086, 13087, 13199, 13293, 13343, 14260, 14760, 14763, 14768, 14862, 14934, 15019, 15141, 15229, 15234, 15245, 15251, 15356, 15383, 15388, 15401, 15402, 15403, 15406, 15466, 15471, 15473, 15476, 15523, 15630, 15636, 15638, 15813, 15838, 15915) 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 100112
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` = (14605)110
11SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '34'110
12SELECT `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 (3179, 3216, 3217, 3218, 3219, 3220, 3221, 3867, 3891, 3892, 3893, 3894, 3895, 4276, 4581, 4582, 5935, 5941, 6834, 7645, 7669, 2467, 9487, 11078, 11089, 12396, 12397, 12398, 12399, 12402, 12403, 12991, 15018, 7, 12, 17, 23, 28, 34, 39, 41, 43, 45, 49, 55, 65, 68, 73, 77, 84, 87, 89, 91, 136, 145, 352, 368, 380, 396, 416, 418, 431, 433, 437, 438, 439, 442, 445, 449, 495, 708, 709, 710, 711, 712, 713, 714, 715, 716, 718, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1523, 1524, 1525, 1526, 1527, 1528, 1529, 1530, 1531, 1572, 1573, 1574, 1575, 1576, 1784, 1785, 1786, 1787, 1788, 1789, 1791, 1792, 1793, 1794, 1795, 1858, 1859, 1862, 1863, 1864, 1865, 1896, 1897, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2191, 2192, 2193, 2201, 2203, 2204, 2202, 2603, 2613, 2995, 3203, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3311, 3337, 3460, 3462, 3507, 3512, 3627, 3639, 3483, 3774, 3776, 3802, 3819, 3866, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3890, 3984, 3985, 4182, 4188, 4278, 4280, 4281, 4282, 4288, 4293, 4308, 4017, 4560, 4578, 4579, 4580, 4607, 4687, 4712, 4713, 4715, 4831, 4924, 5081, 5130, 5152, 5165, 5201, 5215, 5229, 5245, 5246, 5260, 5639, 5930, 5931, 5932, 5933, 5934, 6188, 6422, 6472, 6533, 6618, 6659, 6744, 6798, 6799, 6800, 6801, 6802, 6836, 7000, 7012, 7013, 7016, 7018, 7023, 7025, 7068, 7075, 7076, 7077, 7078, 7115, 7116, 7117, 7118, 7202, 7203, 7204, 7205, 7231, 7253, 7255, 7258, 7263, 7266, 7278, 7305, 7402, 7404, 7405, 7406, 7407, 7408, 7409, 7410, 7411, 7412, 7413, 7415, 7417, 7418, 7422, 7427, 7428, 7430, 7451, 7490, 7530, 7645, 7646, 7647, 7648, 7649, 7650, 7651, 7652, 7670, 7671, 7672, 7673, 7674, 7676, 7677, 7679, 8309, 1910, 8464, 2467, 8905, 9155, 9184, 9454, 9487, 9713, 9819, 9820, 9822, 9825, 9826, 9827, 9828, 9829, 9830, 9831, 9832, 9834, 9835, 9836, 9837, 9839, 9840, 9841, 9842, 9844, 9845, 9846, 9847, 9872, 9887, 9889, 9964, 9986, 9996, 10042, 10043, 10075, 10166, 10215, 10223, 10225, 10203, 10300, 10314, 10396, 10423, 10523, 10534, 10751, 10768, 10802, 10854, 10878, 10934, 10962, 10970, 10971, 10972, 10973, 10974, 10992, 10993, 10994, 11077, 11079, 11082, 11089, 11261, 11262, 11263, 11264, 11265, 11266, 11366, 11959, 11960, 11961, 11962, 11963, 11964, 11965, 11966, 11967, 11968, 12191, 12271, 12272, 12273, 12368, 12369, 12371, 12372, 12373, 12374, 12375, 12376, 12377, 12378, 12379, 12380, 12381, 12382, 12383, 12384, 12386, 12387, 12389, 12390, 12391, 12392, 12394, 12395, 12556, 12596, 12597, 12621, 12624, 12642, 12681, 12727, 12803, 12870, 12909, 12940, 12964, 12965, 12967, 12970, 12974, 12984, 12985, 12986, 12987, 12988, 12989, 12990, 12992, 13005, 13008, 13017, 13018, 13019, 13020, 13021, 13022, 13023, 13024, 13025, 13030, 13029, 13083, 13084, 13085, 13223, 13294, 13343, 13392, 13398, 13399, 13711, 14148, 14165, 14490, 14605, 14610, 14768, 14655, 14858, 14860, 14861, 14927, 14928, 14929, 14930, 14931, 14932, 14934, 14970, 14989, 14990, 14991, 14992, 14993, 15013, 15014, 15016, 15153, 15161, 15200, 15206, 15207, 15213, 15214, 15215, 15216, 15217, 15218, 15222, 15225, 15227, 15228, 15230, 15231, 15233, 15234, 15246, 15250, 15271, 15327, 15351, 15353, 15355, 15356, 15129, 15406, 15451, 15457, 15458, 15459, 15460, 15461, 15462, 15463, 15464, 15466, 15467, 15468, 15469, 15471, 15472, 15475, 15476, 15303, 15492, 15516, 15523, 15541, 15542, 15545, 15629, 15728, 15813, 15825, 15838, 15996, 15997, 15998, 15999, 6, 24, 29, 50, 51, 88, 137, 491, 699, 700, 701, 702, 703, 704, 705, 706, 707, 1030, 1031, 1032, 1033, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1332, 1532, 1533, 1534, 1535, 1558, 1570, 1571, 1796, 1797, 1798, 1805, 1806, 1807, 1808, 2098, 2099, 2100, 2101, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2603, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3311, 3337, 3639, 3868, 3869, 3870, 3871, 3985, 3987, 3989, 4048, 4226, 4280, 4303, 4308, 4017, 4677, 4720, 5201, 5164, 5936, 5937, 5938, 5939, 5940, 6317, 6744, 7231, 6835, 7402, 7431, 7451, 7490, 7529, 7645, 7653, 7654, 7656, 7657, 7658, 8218, 8234, 8309, 1910, 2467, 9155, 9713, 10044, 10045, 10046, 10166, 10225, 10314, 10396, 10523, 10534, 10546, 10547, 10549, 10550, 10551, 10803, 10852, 10878, 10933, 11089, 11260, 12274, 12276, 12278, 12279, 12280, 12281, 12282, 12556, 12597, 12692, 12864, 12908, 12940, 12964, 12969, 12983, 12984, 12277, 13086, 13087, 13199, 13293, 13343, 14260, 14760, 14763, 14768, 14862, 14934, 15019, 15141, 15229, 15234, 15245, 15251, 15356, 15383, 15388, 15401, 15402, 15403, 15406, 15466, 15471, 15473, 15476, 15523, 15630, 15636, 15638, 15813, 15838, 15915) 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
13SELECT `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 (3179, 3216, 3217, 3218, 3219, 3220, 3221, 3867, 3891, 3892, 3893, 3894, 3895, 4276, 4581, 4582, 5935, 5941, 6834, 7645, 7669, 2467, 9487, 11078, 11089, 12396, 12397, 12398, 12399, 12402, 12403, 12991, 15018, 7, 12, 17, 23, 28, 34, 39, 41, 43, 45, 49, 55, 65, 68, 73, 77, 84, 87, 89, 91, 136, 145, 352, 368, 380, 396, 416, 418, 431, 433, 437, 438, 439, 442, 445, 449, 495, 708, 709, 710, 711, 712, 713, 714, 715, 716, 718, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1523, 1524, 1525, 1526, 1527, 1528, 1529, 1530, 1531, 1572, 1573, 1574, 1575, 1576, 1784, 1785, 1786, 1787, 1788, 1789, 1791, 1792, 1793, 1794, 1795, 1858, 1859, 1862, 1863, 1864, 1865, 1896, 1897, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2191, 2192, 2193, 2201, 2203, 2204, 2202, 2603, 2613, 2995, 3203, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3311, 3337, 3460, 3462, 3507, 3512, 3627, 3639, 3483, 3774, 3776, 3802, 3819, 3866, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3890, 3984, 3985, 4182, 4188, 4278, 4280, 4281, 4282, 4288, 4293, 4308, 4017, 4560, 4578, 4579, 4580, 4607, 4687, 4712, 4713, 4715, 4831, 4924, 5081, 5130, 5152, 5165, 5201, 5215, 5229, 5245, 5246, 5260, 5639, 5930, 5931, 5932, 5933, 5934, 6188, 6422, 6472, 6533, 6618, 6659, 6744, 6798, 6799, 6800, 6801, 6802, 6836, 7000, 7012, 7013, 7016, 7018, 7023, 7025, 7068, 7075, 7076, 7077, 7078, 7115, 7116, 7117, 7118, 7202, 7203, 7204, 7205, 7231, 7253, 7255, 7258, 7263, 7266, 7278, 7305, 7402, 7404, 7405, 7406, 7407, 7408, 7409, 7410, 7411, 7412, 7413, 7415, 7417, 7418, 7422, 7427, 7428, 7430, 7451, 7490, 7530, 7645, 7646, 7647, 7648, 7649, 7650, 7651, 7652, 7670, 7671, 7672, 7673, 7674, 7676, 7677, 7679, 8309, 1910, 8464, 2467, 8905, 9155, 9184, 9454, 9487, 9713, 9819, 9820, 9822, 9825, 9826, 9827, 9828, 9829, 9830, 9831, 9832, 9834, 9835, 9836, 9837, 9839, 9840, 9841, 9842, 9844, 9845, 9846, 9847, 9872, 9887, 9889, 9964, 9986, 9996, 10042, 10043, 10075, 10166, 10215, 10223, 10225, 10203, 10300, 10314, 10396, 10423, 10523, 10534, 10751, 10768, 10802, 10854, 10878, 10934, 10962, 10970, 10971, 10972, 10973, 10974, 10992, 10993, 10994, 11077, 11079, 11082, 11089, 11261, 11262, 11263, 11264, 11265, 11266, 11366, 11959, 11960, 11961, 11962, 11963, 11964, 11965, 11966, 11967, 11968, 12191, 12271, 12272, 12273, 12368, 12369, 12371, 12372, 12373, 12374, 12375, 12376, 12377, 12378, 12379, 12380, 12381, 12382, 12383, 12384, 12386, 12387, 12389, 12390, 12391, 12392, 12394, 12395, 12556, 12596, 12597, 12621, 12624, 12642, 12681, 12727, 12803, 12870, 12909, 12940, 12964, 12965, 12967, 12970, 12974, 12984, 12985, 12986, 12987, 12988, 12989, 12990, 12992, 13005, 13008, 13017, 13018, 13019, 13020, 13021, 13022, 13023, 13024, 13025, 13030, 13029, 13083, 13084, 13085, 13223, 13294, 13343, 13392, 13398, 13399, 13711, 14148, 14165, 14490, 14605, 14610, 14768, 14655, 14858, 14860, 14861, 14927, 14928, 14929, 14930, 14931, 14932, 14934, 14970, 14989, 14990, 14991, 14992, 14993, 15013, 15014, 15016, 15153, 15161, 15200, 15206, 15207, 15213, 15214, 15215, 15216, 15217, 15218, 15222, 15225, 15227, 15228, 15230, 15231, 15233, 15234, 15246, 15250, 15271, 15327, 15351, 15353, 15355, 15356, 15129, 15406, 15451, 15457, 15458, 15459, 15460, 15461, 15462, 15463, 15464, 15466, 15467, 15468, 15469, 15471, 15472, 15475, 15476, 15303, 15492, 15516, 15523, 15541, 15542, 15545, 15629, 15728, 15813, 15825, 15838, 15996, 15997, 15998, 15999, 6, 24, 29, 50, 51, 88, 137, 491, 699, 700, 701, 702, 703, 704, 705, 706, 707, 1030, 1031, 1032, 1033, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1332, 1532, 1533, 1534, 1535, 1558, 1570, 1571, 1796, 1797, 1798, 1805, 1806, 1807, 1808, 2098, 2099, 2100, 2101, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2603, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3311, 3337, 3639, 3868, 3869, 3870, 3871, 3985, 3987, 3989, 4048, 4226, 4280, 4303, 4308, 4017, 4677, 4720, 5201, 5164, 5936, 5937, 5938, 5939, 5940, 6317, 6744, 7231, 6835, 7402, 7431, 7451, 7490, 7529, 7645, 7653, 7654, 7656, 7657, 7658, 8218, 8234, 8309, 1910, 2467, 9155, 9713, 10044, 10045, 10046, 10166, 10225, 10314, 10396, 10523, 10534, 10546, 10547, 10549, 10550, 10551, 10803, 10852, 10878, 10933, 11089, 11260, 12274, 12276, 12278, 12279, 12280, 12281, 12282, 12556, 12597, 12692, 12864, 12908, 12940, 12964, 12969, 12983, 12984, 12277, 13086, 13087, 13199, 13293, 13343, 14260, 14760, 14763, 14768, 14862, 14934, 15019, 15141, 15229, 15234, 15245, 15251, 15356, 15383, 15388, 15401, 15402, 15403, 15406, 15466, 15471, 15473, 15476, 15523, 15630, 15636, 15638, 15813, 15838, 15915) 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 1000013
14SELECT `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 (3179, 3216, 3217, 3218, 3219, 3220, 3221, 3867, 3891, 3892, 3893, 3894, 3895, 4276, 4581, 4582, 5935, 5941, 6834, 7645, 7669, 2467, 9487, 11078, 11089, 12396, 12397, 12398, 12399, 12402, 12403, 12991, 15018, 7, 12, 17, 23, 28, 34, 39, 41, 43, 45, 49, 55, 65, 68, 73, 77, 84, 87, 89, 91, 136, 145, 352, 368, 380, 396, 416, 418, 431, 433, 437, 438, 439, 442, 445, 449, 495, 708, 709, 710, 711, 712, 713, 714, 715, 716, 718, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1523, 1524, 1525, 1526, 1527, 1528, 1529, 1530, 1531, 1572, 1573, 1574, 1575, 1576, 1784, 1785, 1786, 1787, 1788, 1789, 1791, 1792, 1793, 1794, 1795, 1858, 1859, 1862, 1863, 1864, 1865, 1896, 1897, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2191, 2192, 2193, 2201, 2203, 2204, 2202, 2603, 2613, 2995, 3203, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3311, 3337, 3460, 3462, 3507, 3512, 3627, 3639, 3483, 3774, 3776, 3802, 3819, 3866, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3890, 3984, 3985, 4182, 4188, 4278, 4280, 4281, 4282, 4288, 4293, 4308, 4017, 4560, 4578, 4579, 4580, 4607, 4687, 4712, 4713, 4715, 4831, 4924, 5081, 5130, 5152, 5165, 5201, 5215, 5229, 5245, 5246, 5260, 5639, 5930, 5931, 5932, 5933, 5934, 6188, 6422, 6472, 6533, 6618, 6659, 6744, 6798, 6799, 6800, 6801, 6802, 6836, 7000, 7012, 7013, 7016, 7018, 7023, 7025, 7068, 7075, 7076, 7077, 7078, 7115, 7116, 7117, 7118, 7202, 7203, 7204, 7205, 7231, 7253, 7255, 7258, 7263, 7266, 7278, 7305, 7402, 7404, 7405, 7406, 7407, 7408, 7409, 7410, 7411, 7412, 7413, 7415, 7417, 7418, 7422, 7427, 7428, 7430, 7451, 7490, 7530, 7645, 7646, 7647, 7648, 7649, 7650, 7651, 7652, 7670, 7671, 7672, 7673, 7674, 7676, 7677, 7679, 8309, 1910, 8464, 2467, 8905, 9155, 9184, 9454, 9487, 9713, 9819, 9820, 9822, 9825, 9826, 9827, 9828, 9829, 9830, 9831, 9832, 9834, 9835, 9836, 9837, 9839, 9840, 9841, 9842, 9844, 9845, 9846, 9847, 9872, 9887, 9889, 9964, 9986, 9996, 10042, 10043, 10075, 10166, 10215, 10223, 10225, 10203, 10300, 10314, 10396, 10423, 10523, 10534, 10751, 10768, 10802, 10854, 10878, 10934, 10962, 10970, 10971, 10972, 10973, 10974, 10992, 10993, 10994, 11077, 11079, 11082, 11089, 11261, 11262, 11263, 11264, 11265, 11266, 11366, 11959, 11960, 11961, 11962, 11963, 11964, 11965, 11966, 11967, 11968, 12191, 12271, 12272, 12273, 12368, 12369, 12371, 12372, 12373, 12374, 12375, 12376, 12377, 12378, 12379, 12380, 12381, 12382, 12383, 12384, 12386, 12387, 12389, 12390, 12391, 12392, 12394, 12395, 12556, 12596, 12597, 12621, 12624, 12642, 12681, 12727, 12803, 12870, 12909, 12940, 12964, 12965, 12967, 12970, 12974, 12984, 12985, 12986, 12987, 12988, 12989, 12990, 12992, 13005, 13008, 13017, 13018, 13019, 13020, 13021, 13022, 13023, 13024, 13025, 13030, 13029, 13083, 13084, 13085, 13223, 13294, 13343, 13392, 13398, 13399, 13711, 14148, 14165, 14490, 14605, 14610, 14768, 14655, 14858, 14860, 14861, 14927, 14928, 14929, 14930, 14931, 14932, 14934, 14970, 14989, 14990, 14991, 14992, 14993, 15013, 15014, 15016, 15153, 15161, 15200, 15206, 15207, 15213, 15214, 15215, 15216, 15217, 15218, 15222, 15225, 15227, 15228, 15230, 15231, 15233, 15234, 15246, 15250, 15271, 15327, 15351, 15353, 15355, 15356, 15129, 15406, 15451, 15457, 15458, 15459, 15460, 15461, 15462, 15463, 15464, 15466, 15467, 15468, 15469, 15471, 15472, 15475, 15476, 15303, 15492, 15516, 15523, 15541, 15542, 15545, 15629, 15728, 15813, 15825, 15838, 15996, 15997, 15998, 15999, 6, 24, 29, 50, 51, 88, 137, 491, 699, 700, 701, 702, 703, 704, 705, 706, 707, 1030, 1031, 1032, 1033, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1332, 1532, 1533, 1534, 1535, 1558, 1570, 1571, 1796, 1797, 1798, 1805, 1806, 1807, 1808, 2098, 2099, 2100, 2101, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2603, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3311, 3337, 3639, 3868, 3869, 3870, 3871, 3985, 3987, 3989, 4048, 4226, 4280, 4303, 4308, 4017, 4677, 4720, 5201, 5164, 5936, 5937, 5938, 5939, 5940, 6317, 6744, 7231, 6835, 7402, 7431, 7451, 7490, 7529, 7645, 7653, 7654, 7656, 7657, 7658, 8218, 8234, 8309, 1910, 2467, 9155, 9713, 10044, 10045, 10046, 10166, 10225, 10314, 10396, 10523, 10534, 10546, 10547, 10549, 10550, 10551, 10803, 10852, 10878, 10933, 11089, 11260, 12274, 12276, 12278, 12279, 12280, 12281, 12282, 12556, 12597, 12692, 12864, 12908, 12940, 12964, 12969, 12983, 12984, 12277, 13086, 13087, 13199, 13293, 13343, 14260, 14760, 14763, 14768, 14862, 14934, 15019, 15141, 15229, 15234, 15245, 15251, 15356, 15383, 15388, 15401, 15402, 15403, 15406, 15466, 15471, 15473, 15476, 15523, 15630, 15636, 15638, 15813, 15838, 15915) 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 100006
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 (3179, 3216, 3217, 3218, 3219, 3220, 3221, 3867, 3891, 3892, 3893, 3894, 3895, 4276, 4581, 4582, 5935, 5941, 6834, 7645, 7669, 2467, 9487, 11078, 11089, 12396, 12397, 12398, 12399, 12402, 12403, 12991, 15018, 7, 12, 17, 23, 28, 34, 39, 41, 43, 45, 49, 55, 65, 68, 73, 77, 84, 87, 89, 91, 136, 145, 352, 368, 380, 396, 416, 418, 431, 433, 437, 438, 439, 442, 445, 449, 495, 708, 709, 710, 711, 712, 713, 714, 715, 716, 718, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1523, 1524, 1525, 1526, 1527, 1528, 1529, 1530, 1531, 1572, 1573, 1574, 1575, 1576, 1784, 1785, 1786, 1787, 1788, 1789, 1791, 1792, 1793, 1794, 1795, 1858, 1859, 1862, 1863, 1864, 1865, 1896, 1897, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2191, 2192, 2193, 2201, 2203, 2204, 2202, 2603, 2613, 2995, 3203, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3311, 3337, 3460, 3462, 3507, 3512, 3627, 3639, 3483, 3774, 3776, 3802, 3819, 3866, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3890, 3984, 3985, 4182, 4188, 4278, 4280, 4281, 4282, 4288, 4293, 4308, 4017, 4560, 4578, 4579, 4580, 4607, 4687, 4712, 4713, 4715, 4831, 4924, 5081, 5130, 5152, 5165, 5201, 5215, 5229, 5245, 5246, 5260, 5639, 5930, 5931, 5932, 5933, 5934, 6188, 6422, 6472, 6533, 6618, 6659, 6744, 6798, 6799, 6800, 6801, 6802, 6836, 7000, 7012, 7013, 7016, 7018, 7023, 7025, 7068, 7075, 7076, 7077, 7078, 7115, 7116, 7117, 7118, 7202, 7203, 7204, 7205, 7231, 7253, 7255, 7258, 7263, 7266, 7278, 7305, 7402, 7404, 7405, 7406, 7407, 7408, 7409, 7410, 7411, 7412, 7413, 7415, 7417, 7418, 7422, 7427, 7428, 7430, 7451, 7490, 7530, 7645, 7646, 7647, 7648, 7649, 7650, 7651, 7652, 7670, 7671, 7672, 7673, 7674, 7676, 7677, 7679, 8309, 1910, 8464, 2467, 8905, 9155, 9184, 9454, 9487, 9713, 9819, 9820, 9822, 9825, 9826, 9827, 9828, 9829, 9830, 9831, 9832, 9834, 9835, 9836, 9837, 9839, 9840, 9841, 9842, 9844, 9845, 9846, 9847, 9872, 9887, 9889, 9964, 9986, 9996, 10042, 10043, 10075, 10166, 10215, 10223, 10225, 10203, 10300, 10314, 10396, 10423, 10523, 10534, 10751, 10768, 10802, 10854, 10878, 10934, 10962, 10970, 10971, 10972, 10973, 10974, 10992, 10993, 10994, 11077, 11079, 11082, 11089, 11261, 11262, 11263, 11264, 11265, 11266, 11366, 11959, 11960, 11961, 11962, 11963, 11964, 11965, 11966, 11967, 11968, 12191, 12271, 12272, 12273, 12368, 12369, 12371, 12372, 12373, 12374, 12375, 12376, 12377, 12378, 12379, 12380, 12381, 12382, 12383, 12384, 12386, 12387, 12389, 12390, 12391, 12392, 12394, 12395, 12556, 12596, 12597, 12621, 12624, 12642, 12681, 12727, 12803, 12870, 12909, 12940, 12964, 12965, 12967, 12970, 12974, 12984, 12985, 12986, 12987, 12988, 12989, 12990, 12992, 13005, 13008, 13017, 13018, 13019, 13020, 13021, 13022, 13023, 13024, 13025, 13030, 13029, 13083, 13084, 13085, 13223, 13294, 13343, 13392, 13398, 13399, 13711, 14148, 14165, 14490, 14605, 14610, 14768, 14655, 14858, 14860, 14861, 14927, 14928, 14929, 14930, 14931, 14932, 14934, 14970, 14989, 14990, 14991, 14992, 14993, 15013, 15014, 15016, 15153, 15161, 15200, 15206, 15207, 15213, 15214, 15215, 15216, 15217, 15218, 15222, 15225, 15227, 15228, 15230, 15231, 15233, 15234, 15246, 15250, 15271, 15327, 15351, 15353, 15355, 15356, 15129, 15406, 15451, 15457, 15458, 15459, 15460, 15461, 15462, 15463, 15464, 15466, 15467, 15468, 15469, 15471, 15472, 15475, 15476, 15303, 15492, 15516, 15523, 15541, 15542, 15545, 15629, 15728, 15813, 15825, 15838, 15996, 15997, 15998, 15999, 6, 24, 29, 50, 51, 88, 137, 491, 699, 700, 701, 702, 703, 704, 705, 706, 707, 1030, 1031, 1032, 1033, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1332, 1532, 1533, 1534, 1535, 1558, 1570, 1571, 1796, 1797, 1798, 1805, 1806, 1807, 1808, 2098, 2099, 2100, 2101, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2603, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3311, 3337, 3639, 3868, 3869, 3870, 3871, 3985, 3987, 3989, 4048, 4226, 4280, 4303, 4308, 4017, 4677, 4720, 5201, 5164, 5936, 5937, 5938, 5939, 5940, 6317, 6744, 7231, 6835, 7402, 7431, 7451, 7490, 7529, 7645, 7653, 7654, 7656, 7657, 7658, 8218, 8234, 8309, 1910, 2467, 9155, 9713, 10044, 10045, 10046, 10166, 10225, 10314, 10396, 10523, 10534, 10546, 10547, 10549, 10550, 10551, 10803, 10852, 10878, 10933, 11089, 11260, 12274, 12276, 12278, 12279, 12280, 12281, 12282, 12556, 12597, 12692, 12864, 12908, 12940, 12964, 12969, 12983, 12984, 12277, 13086, 13087, 13199, 13293, 13343, 14260, 14760, 14763, 14768, 14862, 14934, 15019, 15141, 15229, 15234, 15245, 15251, 15356, 15383, 15388, 15401, 15402, 15403, 15406, 15466, 15471, 15473, 15476, 15523, 15630, 15636, 15638, 15813, 15838, 15915) 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
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 (3179, 3216, 3217, 3218, 3219, 3220, 3221, 3867, 3891, 3892, 3893, 3894, 3895, 4276, 4581, 4582, 5935, 5941, 6834, 7645, 7669, 2467, 9487, 11078, 11089, 12396, 12397, 12398, 12399, 12402, 12403, 12991, 15018, 7, 12, 17, 23, 28, 34, 39, 41, 43, 45, 49, 55, 65, 68, 73, 77, 84, 87, 89, 91, 136, 145, 352, 368, 380, 396, 416, 418, 431, 433, 437, 438, 439, 442, 445, 449, 495, 708, 709, 710, 711, 712, 713, 714, 715, 716, 718, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1523, 1524, 1525, 1526, 1527, 1528, 1529, 1530, 1531, 1572, 1573, 1574, 1575, 1576, 1784, 1785, 1786, 1787, 1788, 1789, 1791, 1792, 1793, 1794, 1795, 1858, 1859, 1862, 1863, 1864, 1865, 1896, 1897, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2191, 2192, 2193, 2201, 2203, 2204, 2202, 2603, 2613, 2995, 3203, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3311, 3337, 3460, 3462, 3507, 3512, 3627, 3639, 3483, 3774, 3776, 3802, 3819, 3866, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3890, 3984, 3985, 4182, 4188, 4278, 4280, 4281, 4282, 4288, 4293, 4308, 4017, 4560, 4578, 4579, 4580, 4607, 4687, 4712, 4713, 4715, 4831, 4924, 5081, 5130, 5152, 5165, 5201, 5215, 5229, 5245, 5246, 5260, 5639, 5930, 5931, 5932, 5933, 5934, 6188, 6422, 6472, 6533, 6618, 6659, 6744, 6798, 6799, 6800, 6801, 6802, 6836, 7000, 7012, 7013, 7016, 7018, 7023, 7025, 7068, 7075, 7076, 7077, 7078, 7115, 7116, 7117, 7118, 7202, 7203, 7204, 7205, 7231, 7253, 7255, 7258, 7263, 7266, 7278, 7305, 7402, 7404, 7405, 7406, 7407, 7408, 7409, 7410, 7411, 7412, 7413, 7415, 7417, 7418, 7422, 7427, 7428, 7430, 7451, 7490, 7530, 7645, 7646, 7647, 7648, 7649, 7650, 7651, 7652, 7670, 7671, 7672, 7673, 7674, 7676, 7677, 7679, 8309, 1910, 8464, 2467, 8905, 9155, 9184, 9454, 9487, 9713, 9819, 9820, 9822, 9825, 9826, 9827, 9828, 9829, 9830, 9831, 9832, 9834, 9835, 9836, 9837, 9839, 9840, 9841, 9842, 9844, 9845, 9846, 9847, 9872, 9887, 9889, 9964, 9986, 9996, 10042, 10043, 10075, 10166, 10215, 10223, 10225, 10203, 10300, 10314, 10396, 10423, 10523, 10534, 10751, 10768, 10802, 10854, 10878, 10934, 10962, 10970, 10971, 10972, 10973, 10974, 10992, 10993, 10994, 11077, 11079, 11082, 11089, 11261, 11262, 11263, 11264, 11265, 11266, 11366, 11959, 11960, 11961, 11962, 11963, 11964, 11965, 11966, 11967, 11968, 12191, 12271, 12272, 12273, 12368, 12369, 12371, 12372, 12373, 12374, 12375, 12376, 12377, 12378, 12379, 12380, 12381, 12382, 12383, 12384, 12386, 12387, 12389, 12390, 12391, 12392, 12394, 12395, 12556, 12596, 12597, 12621, 12624, 12642, 12681, 12727, 12803, 12870, 12909, 12940, 12964, 12965, 12967, 12970, 12974, 12984, 12985, 12986, 12987, 12988, 12989, 12990, 12992, 13005, 13008, 13017, 13018, 13019, 13020, 13021, 13022, 13023, 13024, 13025, 13030, 13029, 13083, 13084, 13085, 13223, 13294, 13343, 13392, 13398, 13399, 13711, 14148, 14165, 14490, 14605, 14610, 14768, 14655, 14858, 14860, 14861, 14927, 14928, 14929, 14930, 14931, 14932, 14934, 14970, 14989, 14990, 14991, 14992, 14993, 15013, 15014, 15016, 15153, 15161, 15200, 15206, 15207, 15213, 15214, 15215, 15216, 15217, 15218, 15222, 15225, 15227, 15228, 15230, 15231, 15233, 15234, 15246, 15250, 15271, 15327, 15351, 15353, 15355, 15356, 15129, 15406, 15451, 15457, 15458, 15459, 15460, 15461, 15462, 15463, 15464, 15466, 15467, 15468, 15469, 15471, 15472, 15475, 15476, 15303, 15492, 15516, 15523, 15541, 15542, 15545, 15629, 15728, 15813, 15825, 15838, 15996, 15997, 15998, 15999, 6, 24, 29, 50, 51, 88, 137, 491, 699, 700, 701, 702, 703, 704, 705, 706, 707, 1030, 1031, 1032, 1033, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1332, 1532, 1533, 1534, 1535, 1558, 1570, 1571, 1796, 1797, 1798, 1805, 1806, 1807, 1808, 2098, 2099, 2100, 2101, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2603, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3311, 3337, 3639, 3868, 3869, 3870, 3871, 3985, 3987, 3989, 4048, 4226, 4280, 4303, 4308, 4017, 4677, 4720, 5201, 5164, 5936, 5937, 5938, 5939, 5940, 6317, 6744, 7231, 6835, 7402, 7431, 7451, 7490, 7529, 7645, 7653, 7654, 7656, 7657, 7658, 8218, 8234, 8309, 1910, 2467, 9155, 9713, 10044, 10045, 10046, 10166, 10225, 10314, 10396, 10523, 10534, 10546, 10547, 10549, 10550, 10551, 10803, 10852, 10878, 10933, 11089, 11260, 12274, 12276, 12278, 12279, 12280, 12281, 12282, 12556, 12597, 12692, 12864, 12908, 12940, 12964, 12969, 12983, 12984, 12277, 13086, 13087, 13199, 13293, 13343, 14260, 14760, 14763, 14768, 14862, 14934, 15019, 15141, 15229, 15234, 15245, 15251, 15356, 15383, 15388, 15401, 15402, 15403, 15406, 15466, 15471, 15473, 15476, 15523, 15630, 15636, 15638, 15813, 15838, 15915) 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
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 (3179, 3216, 3217, 3218, 3219, 3220, 3221, 3867, 3891, 3892, 3893, 3894, 3895, 4276, 4581, 4582, 5935, 5941, 6834, 7645, 7669, 2467, 9487, 11078, 11089, 12396, 12397, 12398, 12399, 12402, 12403, 12991, 15018, 7, 12, 17, 23, 28, 34, 39, 41, 43, 45, 49, 55, 65, 68, 73, 77, 84, 87, 89, 91, 136, 145, 352, 368, 380, 396, 416, 418, 431, 433, 437, 438, 439, 442, 445, 449, 495, 708, 709, 710, 711, 712, 713, 714, 715, 716, 718, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1523, 1524, 1525, 1526, 1527, 1528, 1529, 1530, 1531, 1572, 1573, 1574, 1575, 1576, 1784, 1785, 1786, 1787, 1788, 1789, 1791, 1792, 1793, 1794, 1795, 1858, 1859, 1862, 1863, 1864, 1865, 1896, 1897, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2191, 2192, 2193, 2201, 2203, 2204, 2202, 2603, 2613, 2995, 3203, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3311, 3337, 3460, 3462, 3507, 3512, 3627, 3639, 3483, 3774, 3776, 3802, 3819, 3866, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3890, 3984, 3985, 4182, 4188, 4278, 4280, 4281, 4282, 4288, 4293, 4308, 4017, 4560, 4578, 4579, 4580, 4607, 4687, 4712, 4713, 4715, 4831, 4924, 5081, 5130, 5152, 5165, 5201, 5215, 5229, 5245, 5246, 5260, 5639, 5930, 5931, 5932, 5933, 5934, 6188, 6422, 6472, 6533, 6618, 6659, 6744, 6798, 6799, 6800, 6801, 6802, 6836, 7000, 7012, 7013, 7016, 7018, 7023, 7025, 7068, 7075, 7076, 7077, 7078, 7115, 7116, 7117, 7118, 7202, 7203, 7204, 7205, 7231, 7253, 7255, 7258, 7263, 7266, 7278, 7305, 7402, 7404, 7405, 7406, 7407, 7408, 7409, 7410, 7411, 7412, 7413, 7415, 7417, 7418, 7422, 7427, 7428, 7430, 7451, 7490, 7530, 7645, 7646, 7647, 7648, 7649, 7650, 7651, 7652, 7670, 7671, 7672, 7673, 7674, 7676, 7677, 7679, 8309, 1910, 8464, 2467, 8905, 9155, 9184, 9454, 9487, 9713, 9819, 9820, 9822, 9825, 9826, 9827, 9828, 9829, 9830, 9831, 9832, 9834, 9835, 9836, 9837, 9839, 9840, 9841, 9842, 9844, 9845, 9846, 9847, 9872, 9887, 9889, 9964, 9986, 9996, 10042, 10043, 10075, 10166, 10215, 10223, 10225, 10203, 10300, 10314, 10396, 10423, 10523, 10534, 10751, 10768, 10802, 10854, 10878, 10934, 10962, 10970, 10971, 10972, 10973, 10974, 10992, 10993, 10994, 11077, 11079, 11082, 11089, 11261, 11262, 11263, 11264, 11265, 11266, 11366, 11959, 11960, 11961, 11962, 11963, 11964, 11965, 11966, 11967, 11968, 12191, 12271, 12272, 12273, 12368, 12369, 12371, 12372, 12373, 12374, 12375, 12376, 12377, 12378, 12379, 12380, 12381, 12382, 12383, 12384, 12386, 12387, 12389, 12390, 12391, 12392, 12394, 12395, 12556, 12596, 12597, 12621, 12624, 12642, 12681, 12727, 12803, 12870, 12909, 12940, 12964, 12965, 12967, 12970, 12974, 12984, 12985, 12986, 12987, 12988, 12989, 12990, 12992, 13005, 13008, 13017, 13018, 13019, 13020, 13021, 13022, 13023, 13024, 13025, 13030, 13029, 13083, 13084, 13085, 13223, 13294, 13343, 13392, 13398, 13399, 13711, 14148, 14165, 14490, 14605, 14610, 14768, 14655, 14858, 14860, 14861, 14927, 14928, 14929, 14930, 14931, 14932, 14934, 14970, 14989, 14990, 14991, 14992, 14993, 15013, 15014, 15016, 15153, 15161, 15200, 15206, 15207, 15213, 15214, 15215, 15216, 15217, 15218, 15222, 15225, 15227, 15228, 15230, 15231, 15233, 15234, 15246, 15250, 15271, 15327, 15351, 15353, 15355, 15356, 15129, 15406, 15451, 15457, 15458, 15459, 15460, 15461, 15462, 15463, 15464, 15466, 15467, 15468, 15469, 15471, 15472, 15475, 15476, 15303, 15492, 15516, 15523, 15541, 15542, 15545, 15629, 15728, 15813, 15825, 15838, 15996, 15997, 15998, 15999, 6, 24, 29, 50, 51, 88, 137, 491, 699, 700, 701, 702, 703, 704, 705, 706, 707, 1030, 1031, 1032, 1033, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1332, 1532, 1533, 1534, 1535, 1558, 1570, 1571, 1796, 1797, 1798, 1805, 1806, 1807, 1808, 2098, 2099, 2100, 2101, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2603, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3311, 3337, 3639, 3868, 3869, 3870, 3871, 3985, 3987, 3989, 4048, 4226, 4280, 4303, 4308, 4017, 4677, 4720, 5201, 5164, 5936, 5937, 5938, 5939, 5940, 6317, 6744, 7231, 6835, 7402, 7431, 7451, 7490, 7529, 7645, 7653, 7654, 7656, 7657, 7658, 8218, 8234, 8309, 1910, 2467, 9155, 9713, 10044, 10045, 10046, 10166, 10225, 10314, 10396, 10523, 10534, 10546, 10547, 10549, 10550, 10551, 10803, 10852, 10878, 10933, 11089, 11260, 12274, 12276, 12278, 12279, 12280, 12281, 12282, 12556, 12597, 12692, 12864, 12908, 12940, 12964, 12969, 12983, 12984, 12277, 13086, 13087, 13199, 13293, 13343, 14260, 14760, 14763, 14768, 14862, 14934, 15019, 15141, 15229, 15234, 15245, 15251, 15356, 15383, 15388, 15401, 15402, 15403, 15406, 15466, 15471, 15473, 15476, 15523, 15630, 15636, 15638, 15813, 15838, 15915) 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
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 (3179, 3216, 3217, 3218, 3219, 3220, 3221, 3867, 3891, 3892, 3893, 3894, 3895, 4276, 4581, 4582, 5935, 5941, 6834, 7645, 7669, 2467, 9487, 11078, 11089, 12396, 12397, 12398, 12399, 12402, 12403, 12991, 15018, 7, 12, 17, 23, 28, 34, 39, 41, 43, 45, 49, 55, 65, 68, 73, 77, 84, 87, 89, 91, 136, 145, 352, 368, 380, 396, 416, 418, 431, 433, 437, 438, 439, 442, 445, 449, 495, 708, 709, 710, 711, 712, 713, 714, 715, 716, 718, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1523, 1524, 1525, 1526, 1527, 1528, 1529, 1530, 1531, 1572, 1573, 1574, 1575, 1576, 1784, 1785, 1786, 1787, 1788, 1789, 1791, 1792, 1793, 1794, 1795, 1858, 1859, 1862, 1863, 1864, 1865, 1896, 1897, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2191, 2192, 2193, 2201, 2203, 2204, 2202, 2603, 2613, 2995, 3203, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3311, 3337, 3460, 3462, 3507, 3512, 3627, 3639, 3483, 3774, 3776, 3802, 3819, 3866, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3890, 3984, 3985, 4182, 4188, 4278, 4280, 4281, 4282, 4288, 4293, 4308, 4017, 4560, 4578, 4579, 4580, 4607, 4687, 4712, 4713, 4715, 4831, 4924, 5081, 5130, 5152, 5165, 5201, 5215, 5229, 5245, 5246, 5260, 5639, 5930, 5931, 5932, 5933, 5934, 6188, 6422, 6472, 6533, 6618, 6659, 6744, 6798, 6799, 6800, 6801, 6802, 6836, 7000, 7012, 7013, 7016, 7018, 7023, 7025, 7068, 7075, 7076, 7077, 7078, 7115, 7116, 7117, 7118, 7202, 7203, 7204, 7205, 7231, 7253, 7255, 7258, 7263, 7266, 7278, 7305, 7402, 7404, 7405, 7406, 7407, 7408, 7409, 7410, 7411, 7412, 7413, 7415, 7417, 7418, 7422, 7427, 7428, 7430, 7451, 7490, 7530, 7645, 7646, 7647, 7648, 7649, 7650, 7651, 7652, 7670, 7671, 7672, 7673, 7674, 7676, 7677, 7679, 8309, 1910, 8464, 2467, 8905, 9155, 9184, 9454, 9487, 9713, 9819, 9820, 9822, 9825, 9826, 9827, 9828, 9829, 9830, 9831, 9832, 9834, 9835, 9836, 9837, 9839, 9840, 9841, 9842, 9844, 9845, 9846, 9847, 9872, 9887, 9889, 9964, 9986, 9996, 10042, 10043, 10075, 10166, 10215, 10223, 10225, 10203, 10300, 10314, 10396, 10423, 10523, 10534, 10751, 10768, 10802, 10854, 10878, 10934, 10962, 10970, 10971, 10972, 10973, 10974, 10992, 10993, 10994, 11077, 11079, 11082, 11089, 11261, 11262, 11263, 11264, 11265, 11266, 11366, 11959, 11960, 11961, 11962, 11963, 11964, 11965, 11966, 11967, 11968, 12191, 12271, 12272, 12273, 12368, 12369, 12371, 12372, 12373, 12374, 12375, 12376, 12377, 12378, 12379, 12380, 12381, 12382, 12383, 12384, 12386, 12387, 12389, 12390, 12391, 12392, 12394, 12395, 12556, 12596, 12597, 12621, 12624, 12642, 12681, 12727, 12803, 12870, 12909, 12940, 12964, 12965, 12967, 12970, 12974, 12984, 12985, 12986, 12987, 12988, 12989, 12990, 12992, 13005, 13008, 13017, 13018, 13019, 13020, 13021, 13022, 13023, 13024, 13025, 13030, 13029, 13083, 13084, 13085, 13223, 13294, 13343, 13392, 13398, 13399, 13711, 14148, 14165, 14490, 14605, 14610, 14768, 14655, 14858, 14860, 14861, 14927, 14928, 14929, 14930, 14931, 14932, 14934, 14970, 14989, 14990, 14991, 14992, 14993, 15013, 15014, 15016, 15153, 15161, 15200, 15206, 15207, 15213, 15214, 15215, 15216, 15217, 15218, 15222, 15225, 15227, 15228, 15230, 15231, 15233, 15234, 15246, 15250, 15271, 15327, 15351, 15353, 15355, 15356, 15129, 15406, 15451, 15457, 15458, 15459, 15460, 15461, 15462, 15463, 15464, 15466, 15467, 15468, 15469, 15471, 15472, 15475, 15476, 15303, 15492, 15516, 15523, 15541, 15542, 15545, 15629, 15728, 15813, 15825, 15838, 15996, 15997, 15998, 15999, 6, 24, 29, 50, 51, 88, 137, 491, 699, 700, 701, 702, 703, 704, 705, 706, 707, 1030, 1031, 1032, 1033, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1332, 1532, 1533, 1534, 1535, 1558, 1570, 1571, 1796, 1797, 1798, 1805, 1806, 1807, 1808, 2098, 2099, 2100, 2101, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2603, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3311, 3337, 3639, 3868, 3869, 3870, 3871, 3985, 3987, 3989, 4048, 4226, 4280, 4303, 4308, 4017, 4677, 4720, 5201, 5164, 5936, 5937, 5938, 5939, 5940, 6317, 6744, 7231, 6835, 7402, 7431, 7451, 7490, 7529, 7645, 7653, 7654, 7656, 7657, 7658, 8218, 8234, 8309, 1910, 2467, 9155, 9713, 10044, 10045, 10046, 10166, 10225, 10314, 10396, 10523, 10534, 10546, 10547, 10549, 10550, 10551, 10803, 10852, 10878, 10933, 11089, 11260, 12274, 12276, 12278, 12279, 12280, 12281, 12282, 12556, 12597, 12692, 12864, 12908, 12940, 12964, 12969, 12983, 12984, 12277, 13086, 13087, 13199, 13293, 13343, 14260, 14760, 14763, 14768, 14862, 14934, 15019, 15141, 15229, 15234, 15245, 15251, 15356, 15383, 15388, 15401, 15402, 15403, 15406, 15466, 15471, 15473, 15476, 15523, 15630, 15636, 15638, 15813, 15838, 15915) 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
19SELECT `FamillesEvent`.`id`, `FamillesEvent`.`name` FROM `ExtranetFFH`.`familles_events` AS `FamillesEvent` WHERE 1 = 1 ORDER BY `name` ASC10100
20SELECT `Handicap`.`id`, `Handicap`.`name` FROM `ExtranetFFH`.`handicaps` AS `Handicap` WHERE 1 = 1 ORDER BY `name` ASC770
21SELECT `Region`.`id`, `Region`.`name` FROM `ExtranetFFH`.`regions` AS `Region` WHERE 1 = 1 ORDER BY `Region`.`name` ASC39390