Calendrier des événements handisport:

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

(production) 133 queries took 1 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT SUBSTR(StructureNomCourt,7) as SPORT, `Structure`.`id` FROM `ExtranetFFH`.`structures` AS `Structure` WHERE `StructureCode` = '000000201' LIMIT 1

SELECT `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` ASC

SELECT `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`)) ASC

105

SELECT `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 = 1

16742

SELECT `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` DESC

SELECT `EventsUne`.`id`, `EventsUne`.`structure_id`, `EventsUne`.`event_id`, `EventsUne`.`active`, `EventsUne`.`created`, `EventsUne`.`modified`, `EventsUne`.`add_user_id`, `EventsUne`.`type_une`, `EventsUne`.`type_une_id`, `EventsUne`.`photo`, `EventsUne`.`credit_photo`, `Event`.`id`, `Event`.`user_id`, `Event`.`user_structure_id`, `Event`.`name2`, `Event`.`name`, `Event`.`short_name`, `Event`.`created`, `Event`.`modified`, `Event`.`sport`, `Event`.`competition`, `Event`.`types_event_id`, `Event`.`type_complement`, `Event`.`activite`, `Event`.`activite_id`, `Event`.`titre`, `Event`.`region_id`, `Event`.`departement_id`, `Event`.`departement_id3`, `Event`.`description`, `Event`.`resume`, `Event`.`begin_published`, `Event`.`end_published`, `Event`.`published`, `Event`.`date_published`, `Event`.`calendar_ffh_published`, `Event`.`une_ffh_published`, `Event`.`une_cr_published`, `Event`.`une_cd_published`, `Event`.`niveau`, `Event`.`web_site`, `Event`.`facebook_page`, `Event`.`galerie_photo`, `Event`.`resultats_page`, `Event`.`debut`, `Event`.`fin`, `Event`.`report`, `Event`.`report_user_id`, `Event`.`report_details`, `Event`.`debut2`, `Event`.`fin2`, `Event`.`code_postal`, `Event`.`commune`, `Event`.`stop_event`, `Event`.`stop_event_user_id`, `Event`.`stop_event_date`, `Event`.`stop_event_details`, `Event`.`age_min`, `Event`.`ddn_min`, `Event`.`age_max`, `Event`.`ddn_max`, `Event`.`licence_ffh`, `Event`.`type_licence_ffh`, `Event`.`ouvert_valide_participant`, `Event`.`gratuit_participant`, `Event`.`price_participant`, `Event`.`open_public`, `Event`.`gratuit_public`, `Event`.`price_public`, `Event`.`country_id`, `Event`.`format`, `Event`.`format_nb_jours`, `Event`.`contact_structure`, `Event`.`contact_interlocuteur`, `Event`.`contact_email`, `Event`.`contact_tel`, `Event`.`capacite_public`, `Event`.`genre`, `Event`.`photo_thumb`, `Event`.`photo_une`, `Event`.`photo_view`, `Event`.`credit_photo`, `Event`.`end_inscription`, `Event`.`begin_inscription`, `Event`.`annulation`, `Event`.`annulation_categorie`, `Event`.`annulation_details`, `Event`.`annulation_user_id`, `Event`.`representant_ffh_id`, `Event`.`representant_ffh_fonction_id`, `Event`.`search_orga`, `Event`.`periode_cible`, `Event`.`precisions_search_orga`, `Event`.`autres_informations`, `Event`.`module_hn`, `Event`.`cdc`, `Event`.`exalto_ManifId`, `Event`.`mds_urlPdf`, `Event`.`mdsevent_id`, `Event`.`insert_by_multiple`, `Event`.`import_du_debut`, `Event`.`mode_gestion`, `Event`.`engagement_individuel`, `Event`.`open_intentions`, `Event`.`end_intentions`, `Event`.`go_intentions`, `Event`.`open_engagements`, `Event`.`end_engagements`, `Event`.`end_hebergement`, `Event`.`end_restauration`, `Event`.`go_engagements`, `Event`.`user_gestion_id`, `Event`.`tel_gestion`, `Event`.`email_gestion`, `Event`.`preambule`, `Event`.`participant_doc_admin`, `Event`.`nb_epreuves_by_participant`, `Event`.`tarif_by_participant`, `Event`.`tarif_by_epreuve_participant`, `Event`.`panier_repas`, `Event`.`tarif_panier_repas`, `Event`.`order_cheque`, `Event`.`adresse_envoi_cheque`, `Event`.`type_engagement`, `Event`.`nb_max_pratiquants_by_delegation`, `Event`.`step_intention`, `Event`.`step_engagement`, `Event`.`etoiles`, `Event`.`nb_participants_moins_20ans`, `Event`.`orga_support_etoiles`, `Event`.`tab_active`, `Event`.`qualification`, `Event`.`num_edition`, `Event`.`dossard`, `Event`.`prerequis_licence_encadrant`, `Event`.`prerequis_licence`, `Event`.`prerequis_licence_sport`, `Event`.`type_prestation`, `Event`.`prestations_by_delegation`, `Event`.`prestations_by_participant`, `Event`.`delegation_heb_cond`, `Event`.`participant_heb_cond`, `Event`.`participant_taille_teeshirt`, `Event`.`participant_deficience_sensorielle`, `Event`.`participant_by_selection`, `Event`.`payment_by_delegation`, `Event`.`payment_by_participant`, `Event`.`frais_techniques_by_participant`, `Event`.`montant_frais_techniques_by_participant`, `Event`.`temps_add_epreuve_by_participant`, (MONTH(`Event`.`debut`)) AS `Event__monthDebut`, (YEAR(`Event`.`debut`)) AS `Event__yearDebut`, (MONTH(`Event`.`fin`)) AS `Event__monthFin`, (YEAR(`Event`.`fin`)) AS `Event__yearFin`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Event`.`user_id`) AS `Event__UCR`, (SELECT DEP FROM departements D where `D`.`id` = `Event`.`departement_id`) AS `Event__DEP` FROM `ExtranetFFH`.`events_unes` AS `EventsUne` LEFT JOIN `ExtranetFFH`.`events` AS `Event` ON (`EventsUne`.`event_id` = `Event`.`id`) WHERE `type_une_id` = '000000201'

SELECT `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` = 202

803

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

SELECT `EventsSport`.`id`, `EventsSport`.`user_id`, `EventsSport`.`event_id`, `EventsSport`.`sport_id`, `EventsSport`.`detail`, `EventsSport`.`created`, `EventsSport`.`modified`, (SELECT name FROM sports S where `S`.`id` = `EventsSport`.`sport_id`) AS `EventsSport__sport` FROM `ExtranetFFH`.`events_sports` AS `EventsSport` WHERE `EventsSport`.`event_id` IN (11023, 11297, 11080, 11443, 9891, 11024, 11371, 11320, 10217, 11372, 10073, 11569, 9620, 11713, 11026, 11571, 11712)

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '24'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '20'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '38'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '41'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '28'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '996'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '6'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '21'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '6'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '53'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '108'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '5'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '69'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '38'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '21'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '109'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '25'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '24'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '25'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '74'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '4'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '74'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'

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

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '1'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '39'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '38'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '26'

SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '64'