RECHERCHER

Période du
au




ÉVÉNEMENTS DU 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 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT SUBSTR(StructureNomCourt,7) as SPORT, `Structure`.`id` FROM `ExtranetFFH`.`structures` AS `Structure` WHERE `StructureCode` = '000000231' LIMIT 1110
2SELECT `Structure`.`StructureCode`, (SELECT name FROM regions where `regions`.`id` = `Structure`.`StructureCode`) AS `Structure__Region` FROM `ExtranetFFH`.`structures` AS `Structure` WHERE `StructureType` = 'LIG' AND `StructureEtat` = 'A' ORDER BY `StructureNomCourt` ASC23230
3SELECT `Departement`.`id`, (CONCAT(`Departement`.`DEP`, " / ", `Departement`.`name`)) AS `Departement__numName` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE 1 = 1 ORDER BY (CONCAT(`Departement`.`DEP`, " / ", `Departement`.`name`)) ASC1051050
4SELECT `EventsSport`.`sport_id`, `Sport`.`name` FROM `ExtranetFFH`.`events_sports` AS `EventsSport` LEFT JOIN `ExtranetFFH`.`sports` AS `Sport` ON (`EventsSport`.`sport_id` = `Sport`.`id`) LEFT JOIN `ExtranetFFH`.`events` AS `Event` ON (`EventsSport`.`event_id` = `Event`.`id`) WHERE 1 = 116742167421
5SELECT `Event`.`types_event_id`, `TypesEvent`.`name` FROM `ExtranetFFH`.`events` AS `Event` LEFT JOIN `ExtranetFFH`.`types_events` AS `TypesEvent` ON (`Event`.`types_event_id` = `TypesEvent`.`id`) WHERE `published` = 1 GROUP BY `Event`.`types_event_id` ORDER BY `Event`.`debut` DESC32320
6SELECT `EventsUne`.`id`, `EventsUne`.`structure_id`, `EventsUne`.`event_id`, `EventsUne`.`active`, `EventsUne`.`created`, `EventsUne`.`modified`, `EventsUne`.`add_user_id`, `EventsUne`.`type_une`, `EventsUne`.`type_une_id`, `EventsUne`.`photo`, `EventsUne`.`credit_photo`, `Event`.`id`, `Event`.`user_id`, `Event`.`user_structure_id`, `Event`.`name2`, `Event`.`name`, `Event`.`short_name`, `Event`.`created`, `Event`.`modified`, `Event`.`sport`, `Event`.`competition`, `Event`.`types_event_id`, `Event`.`type_complement`, `Event`.`activite`, `Event`.`activite_id`, `Event`.`titre`, `Event`.`region_id`, `Event`.`departement_id`, `Event`.`departement_id3`, `Event`.`description`, `Event`.`resume`, `Event`.`begin_published`, `Event`.`end_published`, `Event`.`published`, `Event`.`date_published`, `Event`.`calendar_ffh_published`, `Event`.`une_ffh_published`, `Event`.`une_cr_published`, `Event`.`une_cd_published`, `Event`.`niveau`, `Event`.`web_site`, `Event`.`facebook_page`, `Event`.`galerie_photo`, `Event`.`resultats_page`, `Event`.`debut`, `Event`.`fin`, `Event`.`report`, `Event`.`report_user_id`, `Event`.`report_details`, `Event`.`debut2`, `Event`.`fin2`, `Event`.`code_postal`, `Event`.`commune`, `Event`.`stop_event`, `Event`.`stop_event_user_id`, `Event`.`stop_event_date`, `Event`.`stop_event_details`, `Event`.`age_min`, `Event`.`ddn_min`, `Event`.`age_max`, `Event`.`ddn_max`, `Event`.`licence_ffh`, `Event`.`type_licence_ffh`, `Event`.`ouvert_valide_participant`, `Event`.`gratuit_participant`, `Event`.`price_participant`, `Event`.`open_public`, `Event`.`gratuit_public`, `Event`.`price_public`, `Event`.`country_id`, `Event`.`format`, `Event`.`format_nb_jours`, `Event`.`contact_structure`, `Event`.`contact_interlocuteur`, `Event`.`contact_email`, `Event`.`contact_tel`, `Event`.`capacite_public`, `Event`.`genre`, `Event`.`photo_thumb`, `Event`.`photo_une`, `Event`.`photo_view`, `Event`.`credit_photo`, `Event`.`end_inscription`, `Event`.`begin_inscription`, `Event`.`annulation`, `Event`.`annulation_categorie`, `Event`.`annulation_details`, `Event`.`annulation_user_id`, `Event`.`representant_ffh_id`, `Event`.`representant_ffh_fonction_id`, `Event`.`search_orga`, `Event`.`periode_cible`, `Event`.`precisions_search_orga`, `Event`.`autres_informations`, `Event`.`module_hn`, `Event`.`cdc`, `Event`.`exalto_ManifId`, `Event`.`mds_urlPdf`, `Event`.`mdsevent_id`, `Event`.`insert_by_multiple`, `Event`.`import_du_debut`, `Event`.`mode_gestion`, `Event`.`engagement_individuel`, `Event`.`open_intentions`, `Event`.`end_intentions`, `Event`.`go_intentions`, `Event`.`open_engagements`, `Event`.`end_engagements`, `Event`.`end_hebergement`, `Event`.`end_restauration`, `Event`.`go_engagements`, `Event`.`user_gestion_id`, `Event`.`tel_gestion`, `Event`.`email_gestion`, `Event`.`preambule`, `Event`.`participant_doc_admin`, `Event`.`nb_epreuves_by_participant`, `Event`.`tarif_by_participant`, `Event`.`tarif_by_epreuve_participant`, `Event`.`panier_repas`, `Event`.`tarif_panier_repas`, `Event`.`order_cheque`, `Event`.`adresse_envoi_cheque`, `Event`.`type_engagement`, `Event`.`nb_max_pratiquants_by_delegation`, `Event`.`step_intention`, `Event`.`step_engagement`, `Event`.`etoiles`, `Event`.`nb_participants_moins_20ans`, `Event`.`orga_support_etoiles`, `Event`.`tab_active`, `Event`.`qualification`, `Event`.`num_edition`, `Event`.`dossard`, `Event`.`prerequis_licence_encadrant`, `Event`.`prerequis_licence`, `Event`.`prerequis_licence_sport`, `Event`.`type_prestation`, `Event`.`prestations_by_delegation`, `Event`.`prestations_by_participant`, `Event`.`delegation_heb_cond`, `Event`.`participant_heb_cond`, `Event`.`participant_taille_teeshirt`, `Event`.`participant_deficience_sensorielle`, `Event`.`participant_by_selection`, `Event`.`payment_by_delegation`, `Event`.`payment_by_participant`, `Event`.`frais_techniques_by_participant`, `Event`.`montant_frais_techniques_by_participant`, `Event`.`temps_add_epreuve_by_participant`, (MONTH(`Event`.`debut`)) AS `Event__monthDebut`, (YEAR(`Event`.`debut`)) AS `Event__yearDebut`, (MONTH(`Event`.`fin`)) AS `Event__monthFin`, (YEAR(`Event`.`fin`)) AS `Event__yearFin`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Event`.`user_id`) AS `Event__UCR`, (SELECT DEP FROM departements D where `D`.`id` = `Event`.`departement_id`) AS `Event__DEP` FROM `ExtranetFFH`.`events_unes` AS `EventsUne` LEFT JOIN `ExtranetFFH`.`events` AS `Event` ON (`EventsUne`.`event_id` = `Event`.`id`) WHERE `type_une_id` = '000000231'000
7SELECT `EventsSport`.`id`, `EventsSport`.`event_id` FROM `ExtranetFFH`.`events_sports` AS `EventsSport` LEFT JOIN `ExtranetFFH`.`sports` AS `Sport` ON (`EventsSport`.`sport_id` = `Sport`.`id`) WHERE `Sport`.`cms` = 2325155150
8SELECT `Structure`.`StructureCode`, (SELECT name FROM regions where `regions`.`id` = `Structure`.`StructureCode`) AS `Structure__Region` FROM `ExtranetFFH`.`structures` AS `Structure` WHERE `StructureType` = 'LIG' AND `StructureEtat` = 'A' ORDER BY `StructureNomCourt` ASC23230
9SELECT `Event`.`name`, `Event`.`debut`, `Event`.`fin`, `Event`.`debut2`, `Event`.`fin2`, `Event`.`annulation`, `Event`.`country_id`, `Event`.`commune`, `Event`.`report`, `TypesEvent`.`id`, `TypesEvent`.`name`, `Country`.`id`, `Country`.`alpha3`, `Country`.`name`, `Departement`.`DEP`, `Departement`.`name`, `Departement`.`id`, `Event`.`id` FROM `ExtranetFFH`.`events` AS `Event` LEFT JOIN `ExtranetFFH`.`types_events` AS `TypesEvent` ON (`Event`.`types_event_id` = `TypesEvent`.`id`) LEFT JOIN `ExtranetFFH`.`countries` AS `Country` ON (`Event`.`country_id` = `Country`.`id`) LEFT JOIN `ExtranetFFH`.`departements` AS `Departement` ON (`Event`.`departement_id` = `Departement`.`id`) WHERE `Event`.`id` IN (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, 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, 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) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2018') AND (MONTH(`Event`.`debut`) = '06'))) OR (((YEAR(`Event`.`debut2`) = '2018') AND (MONTH(`Event`.`debut2`) = '06')))) ORDER BY `Event`.`debut` ASC LIMIT 100000
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 (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, 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, 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) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2018') AND (MONTH(`Event`.`debut`) = '07'))) OR (((YEAR(`Event`.`debut2`) = '2018') AND (MONTH(`Event`.`debut2`) = '07')))) ORDER BY `Event`.`debut` ASC LIMIT 100000
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 (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, 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, 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) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2018') AND (MONTH(`Event`.`debut`) = '08'))) OR (((YEAR(`Event`.`debut2`) = '2018') AND (MONTH(`Event`.`debut2`) = '08')))) ORDER BY `Event`.`debut` ASC LIMIT 100000
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, 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, 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) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2018') AND (MONTH(`Event`.`debut`) = '09'))) OR (((YEAR(`Event`.`debut2`) = '2018') AND (MONTH(`Event`.`debut2`) = '09')))) ORDER BY `Event`.`debut` ASC LIMIT 100000
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, 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, 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) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2018') AND (MONTH(`Event`.`debut`) = '10'))) OR (((YEAR(`Event`.`debut2`) = '2018') AND (MONTH(`Event`.`debut2`) = '10')))) ORDER BY `Event`.`debut` ASC LIMIT 100000
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, 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, 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) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2018') AND (MONTH(`Event`.`debut`) = '11'))) OR (((YEAR(`Event`.`debut2`) = '2018') AND (MONTH(`Event`.`debut2`) = '11')))) ORDER BY `Event`.`debut` ASC LIMIT 100000
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, 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, 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) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2018') AND (MONTH(`Event`.`debut`) = '12'))) OR (((YEAR(`Event`.`debut2`) = '2018') AND (MONTH(`Event`.`debut2`) = '12')))) ORDER BY `Event`.`debut` ASC LIMIT 100110
16SELECT `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` = (11366)110
17SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '34'110
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, 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, 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) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2019') AND (MONTH(`Event`.`debut`) = '01'))) OR (((YEAR(`Event`.`debut2`) = '2019') AND (MONTH(`Event`.`debut2`) = '01')))) ORDER BY `Event`.`debut` ASC LIMIT 100000
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` ASC38380