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) 19 queries took 342 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT SUBSTR(StructureNomCourt,7) as SPORT, `Structure`.`id` FROM `ExtranetFFH`.`structures` AS `Structure` WHERE `StructureCode` = '000000248' LIMIT 1111
2SELECT `Structure`.`StructureCode`, (SELECT name FROM regions where `regions`.`id` = `Structure`.`StructureCode`) AS `Structure__Region` FROM `ExtranetFFH`.`structures` AS `Structure` WHERE `StructureType` = 'LIG' AND `StructureEtat` = 'A' ORDER BY `StructureNomCourt` ASC24247
3SELECT `Departement`.`id`, (CONCAT(`Departement`.`DEP`, " / ", `Departement`.`name`)) AS `Departement__numName` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE 1 = 1 ORDER BY (CONCAT(`Departement`.`DEP`, " / ", `Departement`.`name`)) ASC1051050
4SELECT `EventsSport`.`sport_id`, `Sport`.`name` FROM `ExtranetFFH`.`events_sports` AS `EventsSport` LEFT JOIN `ExtranetFFH`.`sports` AS `Sport` ON (`EventsSport`.`sport_id` = `Sport`.`id`) LEFT JOIN `ExtranetFFH`.`events` AS `Event` ON (`EventsSport`.`event_id` = `Event`.`id`) WHERE 1 = 12454424544294
5SELECT `Event`.`types_event_id`, `TypesEvent`.`name` FROM `ExtranetFFH`.`events` AS `Event` LEFT JOIN `ExtranetFFH`.`types_events` AS `TypesEvent` ON (`Event`.`types_event_id` = `TypesEvent`.`id`) WHERE `published` = 1 GROUP BY `Event`.`types_event_id` ORDER BY `Event`.`debut` DESC333321
6SELECT `EventsUne`.`id`, `EventsUne`.`structure_id`, `EventsUne`.`event_id`, `EventsUne`.`active`, `EventsUne`.`created`, `EventsUne`.`modified`, `EventsUne`.`add_user_id`, `EventsUne`.`type_une`, `EventsUne`.`type_une_id`, `EventsUne`.`photo`, `EventsUne`.`credit_photo`, `Event`.`id`, `Event`.`user_id`, `Event`.`user_structure_id`, `Event`.`name2`, `Event`.`name`, `Event`.`short_name`, `Event`.`created`, `Event`.`user_modify_id`, `Event`.`modified`, `Event`.`sport`, `Event`.`competition`, `Event`.`types_event_id`, `Event`.`type_complement`, `Event`.`activite`, `Event`.`activite_id`, `Event`.`titre`, `Event`.`region_id`, `Event`.`departement_id`, `Event`.`departement_id3`, `Event`.`description`, `Event`.`resume`, `Event`.`begin_published`, `Event`.`end_published`, `Event`.`published`, `Event`.`date_published`, `Event`.`calendar_ffh_published`, `Event`.`une_ffh_published`, `Event`.`une_cr_published`, `Event`.`une_cd_published`, `Event`.`niveau`, `Event`.`web_site`, `Event`.`facebook_page`, `Event`.`galerie_photo`, `Event`.`resultats_page`, `Event`.`debut`, `Event`.`fin`, `Event`.`report`, `Event`.`report_user_id`, `Event`.`report_details`, `Event`.`debut2`, `Event`.`fin2`, `Event`.`code_postal`, `Event`.`commune`, `Event`.`stop_event`, `Event`.`stop_event_user_id`, `Event`.`stop_event_date`, `Event`.`stop_event_details`, `Event`.`age_min`, `Event`.`ddn_min`, `Event`.`age_max`, `Event`.`ddn_max`, `Event`.`licence_ffh`, `Event`.`type_licence_ffh`, `Event`.`ouvert_valide_participant`, `Event`.`gratuit_participant`, `Event`.`price_participant`, `Event`.`open_public`, `Event`.`gratuit_public`, `Event`.`price_public`, `Event`.`country_id`, `Event`.`format`, `Event`.`format_nb_jours`, `Event`.`contact_structure`, `Event`.`contact_interlocuteur`, `Event`.`contact_email`, `Event`.`contact_tel`, `Event`.`capacite_public`, `Event`.`genre`, `Event`.`photo_thumb`, `Event`.`photo_une`, `Event`.`photo_view`, `Event`.`credit_photo`, `Event`.`end_inscription`, `Event`.`begin_inscription`, `Event`.`annulation`, `Event`.`annulation_categorie`, `Event`.`annulation_details`, `Event`.`annulation_user_id`, `Event`.`representant_ffh_id`, `Event`.`representant_ffh_fonction_id`, `Event`.`search_orga`, `Event`.`periode_cible`, `Event`.`precisions_search_orga`, `Event`.`autres_informations`, `Event`.`module_hn`, `Event`.`cdc`, `Event`.`exalto_ManifId`, `Event`.`mds_urlPdf`, `Event`.`mdsevent_id`, `Event`.`insert_by_multiple`, `Event`.`import_du_debut`, `Event`.`mode_gestion`, `Event`.`engagement_individuel`, `Event`.`open_intentions`, `Event`.`end_intentions`, `Event`.`go_intentions`, `Event`.`delegation_precree`, `Event`.`open_engagements`, `Event`.`end_engagements`, `Event`.`end_hebergement`, `Event`.`end_restauration`, `Event`.`go_engagements`, `Event`.`user_gestion_id`, `Event`.`tel_gestion`, `Event`.`email_gestion`, `Event`.`preambule`, `Event`.`delegation_doc_admin`, `Event`.`participant_doc_admin`, `Event`.`epreuves_by_participant`, `Event`.`nb_epreuves_by_participant`, `Event`.`tarif_by_participant`, `Event`.`tarif_by_epreuve_participant`, `Event`.`panier_repas`, `Event`.`tarif_panier_repas`, `Event`.`order_cheque`, `Event`.`adresse_envoi_cheque`, `Event`.`type_engagement`, `Event`.`nb_max_pratiquants_by_delegation`, `Event`.`step_intention`, `Event`.`step_engagement`, `Event`.`etoiles`, `Event`.`nb_participants_moins_20ans`, `Event`.`orga_support_etoiles`, `Event`.`tab_active`, `Event`.`qualification`, `Event`.`num_edition`, `Event`.`dossard`, `Event`.`prerequis_licence_encadrant`, `Event`.`prerequis_licence`, `Event`.`prerequis_licence_sport`, `Event`.`type_prestation`, `Event`.`prestations_by_delegation`, `Event`.`prestations_by_participant`, `Event`.`delegation_heb_cond`, `Event`.`participant_heb_cond`, `Event`.`participant_list_taille_teeshirt`, `Event`.`participant_taille_teeshirt`, `Event`.`participant_deficience_sensorielle`, `Event`.`participant_by_selection`, `Event`.`payment_by_delegation`, `Event`.`payment_by_participant`, `Event`.`frais_techniques_by_participant`, `Event`.`montant_frais_techniques_by_participant`, `Event`.`temps_add_epreuve_by_participant`, `Event`.`billet_congres`, `Event`.`iban`, `Event`.`siret`, `Event`.`prefixe_num_facture`, `Event`.`logo_facture`, `Event`.`width_logo_facture`, `Event`.`sites_transport`, `Event`.`nb_plannings`, `Event`.`montant_promotion_prestation_by_participant`, (MONTH(`Event`.`debut`)) AS `Event__monthDebut`, (YEAR(`Event`.`debut`)) AS `Event__yearDebut`, (MONTH(`Event`.`fin`)) AS `Event__monthFin`, (YEAR(`Event`.`fin`)) AS `Event__yearFin`, (CONCAT(`Event`.`name`," • ",date_format(`Event`.`debut`, '%d/%m/%Y')," au ",date_format(`Event`.`fin`, '%d/%m/%Y'))) AS `Event__eventDates`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Event`.`user_id`) AS `Event__UCR`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Event`.`user_modify_id`) AS `Event__UMR`, (SELECT DEP FROM departements D where `D`.`id` = `Event`.`departement_id`) AS `Event__DEP` FROM `ExtranetFFH`.`events_unes` AS `EventsUne` LEFT JOIN `ExtranetFFH`.`events` AS `Event` ON (`EventsUne`.`event_id` = `Event`.`id`) WHERE `type_une_id` = '000000248'001
7SELECT `EventsSport`.`id`, `EventsSport`.`event_id` FROM `ExtranetFFH`.`events_sports` AS `EventsSport` LEFT JOIN `ExtranetFFH`.`sports` AS `Sport` ON (`EventsSport`.`sport_id` = `Sport`.`id`) WHERE `Sport`.`cms` = 32151581581
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` ASC24249
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 (205, 314, 443, 488, 506, 511, 607, 1101, 1102, 1103, 1536, 1537, 1538, 1539, 1540, 1541, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1550, 1551, 1552, 1553, 1554, 1555, 1556, 2171, 2692, 3732, 4671, 4694, 5085, 5141, 5158, 5187, 3572, 5200, 5514, 5738, 5454, 5456, 5457, 5851, 5878, 5896, 5900, 6007, 6180, 6589, 5747, 6755, 6756, 6253, 6989, 7119, 7120, 7121, 7122, 7123, 7124, 7125, 7126, 7127, 7129, 7130, 7131, 7132, 7133, 7134, 7135, 7137, 7138, 7139, 7424, 7474, 7629, 7689, 7877, 7878, 7879, 7880, 7881, 7882, 8074, 8342, 8521, 9012, 9019, 9042, 9056, 9109, 9111, 9113, 9115, 9182, 10266, 10267, 10268, 10275, 10276, 10277, 11011, 11251, 11483, 11490, 11596, 11599, 12077, 12147, 12148, 12151, 12154, 12155, 12157, 12158, 12159, 12161, 12302, 12303, 13198, 13791, 13867, 13990, 14517, 14518, 14519, 14541, 14609, 14966, 15118, 15307, 15526, 15528, 15529, 15530, 15531, 15532, 15533, 15534, 15535, 15536, 15537, 15546, 15547, 15548, 15549, 15551, 15552, 15553, 15554, 15555, 15781, 15782) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '04'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '04')))) ORDER BY `Event`.`debut` ASC LIMIT 100001
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 (205, 314, 443, 488, 506, 511, 607, 1101, 1102, 1103, 1536, 1537, 1538, 1539, 1540, 1541, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1550, 1551, 1552, 1553, 1554, 1555, 1556, 2171, 2692, 3732, 4671, 4694, 5085, 5141, 5158, 5187, 3572, 5200, 5514, 5738, 5454, 5456, 5457, 5851, 5878, 5896, 5900, 6007, 6180, 6589, 5747, 6755, 6756, 6253, 6989, 7119, 7120, 7121, 7122, 7123, 7124, 7125, 7126, 7127, 7129, 7130, 7131, 7132, 7133, 7134, 7135, 7137, 7138, 7139, 7424, 7474, 7629, 7689, 7877, 7878, 7879, 7880, 7881, 7882, 8074, 8342, 8521, 9012, 9019, 9042, 9056, 9109, 9111, 9113, 9115, 9182, 10266, 10267, 10268, 10275, 10276, 10277, 11011, 11251, 11483, 11490, 11596, 11599, 12077, 12147, 12148, 12151, 12154, 12155, 12157, 12158, 12159, 12161, 12302, 12303, 13198, 13791, 13867, 13990, 14517, 14518, 14519, 14541, 14609, 14966, 15118, 15307, 15526, 15528, 15529, 15530, 15531, 15532, 15533, 15534, 15535, 15536, 15537, 15546, 15547, 15548, 15549, 15551, 15552, 15553, 15554, 15555, 15781, 15782) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '05'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '05')))) ORDER BY `Event`.`debut` ASC LIMIT 100001
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 (205, 314, 443, 488, 506, 511, 607, 1101, 1102, 1103, 1536, 1537, 1538, 1539, 1540, 1541, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1550, 1551, 1552, 1553, 1554, 1555, 1556, 2171, 2692, 3732, 4671, 4694, 5085, 5141, 5158, 5187, 3572, 5200, 5514, 5738, 5454, 5456, 5457, 5851, 5878, 5896, 5900, 6007, 6180, 6589, 5747, 6755, 6756, 6253, 6989, 7119, 7120, 7121, 7122, 7123, 7124, 7125, 7126, 7127, 7129, 7130, 7131, 7132, 7133, 7134, 7135, 7137, 7138, 7139, 7424, 7474, 7629, 7689, 7877, 7878, 7879, 7880, 7881, 7882, 8074, 8342, 8521, 9012, 9019, 9042, 9056, 9109, 9111, 9113, 9115, 9182, 10266, 10267, 10268, 10275, 10276, 10277, 11011, 11251, 11483, 11490, 11596, 11599, 12077, 12147, 12148, 12151, 12154, 12155, 12157, 12158, 12159, 12161, 12302, 12303, 13198, 13791, 13867, 13990, 14517, 14518, 14519, 14541, 14609, 14966, 15118, 15307, 15526, 15528, 15529, 15530, 15531, 15532, 15533, 15534, 15535, 15536, 15537, 15546, 15547, 15548, 15549, 15551, 15552, 15553, 15554, 15555, 15781, 15782) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '06'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '06')))) ORDER BY `Event`.`debut` ASC LIMIT 100001
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 (205, 314, 443, 488, 506, 511, 607, 1101, 1102, 1103, 1536, 1537, 1538, 1539, 1540, 1541, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1550, 1551, 1552, 1553, 1554, 1555, 1556, 2171, 2692, 3732, 4671, 4694, 5085, 5141, 5158, 5187, 3572, 5200, 5514, 5738, 5454, 5456, 5457, 5851, 5878, 5896, 5900, 6007, 6180, 6589, 5747, 6755, 6756, 6253, 6989, 7119, 7120, 7121, 7122, 7123, 7124, 7125, 7126, 7127, 7129, 7130, 7131, 7132, 7133, 7134, 7135, 7137, 7138, 7139, 7424, 7474, 7629, 7689, 7877, 7878, 7879, 7880, 7881, 7882, 8074, 8342, 8521, 9012, 9019, 9042, 9056, 9109, 9111, 9113, 9115, 9182, 10266, 10267, 10268, 10275, 10276, 10277, 11011, 11251, 11483, 11490, 11596, 11599, 12077, 12147, 12148, 12151, 12154, 12155, 12157, 12158, 12159, 12161, 12302, 12303, 13198, 13791, 13867, 13990, 14517, 14518, 14519, 14541, 14609, 14966, 15118, 15307, 15526, 15528, 15529, 15530, 15531, 15532, 15533, 15534, 15535, 15536, 15537, 15546, 15547, 15548, 15549, 15551, 15552, 15553, 15554, 15555, 15781, 15782) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '07'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '07')))) ORDER BY `Event`.`debut` ASC LIMIT 100001
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 (205, 314, 443, 488, 506, 511, 607, 1101, 1102, 1103, 1536, 1537, 1538, 1539, 1540, 1541, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1550, 1551, 1552, 1553, 1554, 1555, 1556, 2171, 2692, 3732, 4671, 4694, 5085, 5141, 5158, 5187, 3572, 5200, 5514, 5738, 5454, 5456, 5457, 5851, 5878, 5896, 5900, 6007, 6180, 6589, 5747, 6755, 6756, 6253, 6989, 7119, 7120, 7121, 7122, 7123, 7124, 7125, 7126, 7127, 7129, 7130, 7131, 7132, 7133, 7134, 7135, 7137, 7138, 7139, 7424, 7474, 7629, 7689, 7877, 7878, 7879, 7880, 7881, 7882, 8074, 8342, 8521, 9012, 9019, 9042, 9056, 9109, 9111, 9113, 9115, 9182, 10266, 10267, 10268, 10275, 10276, 10277, 11011, 11251, 11483, 11490, 11596, 11599, 12077, 12147, 12148, 12151, 12154, 12155, 12157, 12158, 12159, 12161, 12302, 12303, 13198, 13791, 13867, 13990, 14517, 14518, 14519, 14541, 14609, 14966, 15118, 15307, 15526, 15528, 15529, 15530, 15531, 15532, 15533, 15534, 15535, 15536, 15537, 15546, 15547, 15548, 15549, 15551, 15552, 15553, 15554, 15555, 15781, 15782) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '08'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '08')))) ORDER BY `Event`.`debut` ASC LIMIT 100001
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 (205, 314, 443, 488, 506, 511, 607, 1101, 1102, 1103, 1536, 1537, 1538, 1539, 1540, 1541, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1550, 1551, 1552, 1553, 1554, 1555, 1556, 2171, 2692, 3732, 4671, 4694, 5085, 5141, 5158, 5187, 3572, 5200, 5514, 5738, 5454, 5456, 5457, 5851, 5878, 5896, 5900, 6007, 6180, 6589, 5747, 6755, 6756, 6253, 6989, 7119, 7120, 7121, 7122, 7123, 7124, 7125, 7126, 7127, 7129, 7130, 7131, 7132, 7133, 7134, 7135, 7137, 7138, 7139, 7424, 7474, 7629, 7689, 7877, 7878, 7879, 7880, 7881, 7882, 8074, 8342, 8521, 9012, 9019, 9042, 9056, 9109, 9111, 9113, 9115, 9182, 10266, 10267, 10268, 10275, 10276, 10277, 11011, 11251, 11483, 11490, 11596, 11599, 12077, 12147, 12148, 12151, 12154, 12155, 12157, 12158, 12159, 12161, 12302, 12303, 13198, 13791, 13867, 13990, 14517, 14518, 14519, 14541, 14609, 14966, 15118, 15307, 15526, 15528, 15529, 15530, 15531, 15532, 15533, 15534, 15535, 15536, 15537, 15546, 15547, 15548, 15549, 15551, 15552, 15553, 15554, 15555, 15781, 15782) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '09'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '09')))) ORDER BY `Event`.`debut` ASC LIMIT 100001
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 (205, 314, 443, 488, 506, 511, 607, 1101, 1102, 1103, 1536, 1537, 1538, 1539, 1540, 1541, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1550, 1551, 1552, 1553, 1554, 1555, 1556, 2171, 2692, 3732, 4671, 4694, 5085, 5141, 5158, 5187, 3572, 5200, 5514, 5738, 5454, 5456, 5457, 5851, 5878, 5896, 5900, 6007, 6180, 6589, 5747, 6755, 6756, 6253, 6989, 7119, 7120, 7121, 7122, 7123, 7124, 7125, 7126, 7127, 7129, 7130, 7131, 7132, 7133, 7134, 7135, 7137, 7138, 7139, 7424, 7474, 7629, 7689, 7877, 7878, 7879, 7880, 7881, 7882, 8074, 8342, 8521, 9012, 9019, 9042, 9056, 9109, 9111, 9113, 9115, 9182, 10266, 10267, 10268, 10275, 10276, 10277, 11011, 11251, 11483, 11490, 11596, 11599, 12077, 12147, 12148, 12151, 12154, 12155, 12157, 12158, 12159, 12161, 12302, 12303, 13198, 13791, 13867, 13990, 14517, 14518, 14519, 14541, 14609, 14966, 15118, 15307, 15526, 15528, 15529, 15530, 15531, 15532, 15533, 15534, 15535, 15536, 15537, 15546, 15547, 15548, 15549, 15551, 15552, 15553, 15554, 15555, 15781, 15782) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '10'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '10')))) ORDER BY `Event`.`debut` ASC LIMIT 100001
16SELECT `Event`.`name`, `Event`.`debut`, `Event`.`fin`, `Event`.`debut2`, `Event`.`fin2`, `Event`.`annulation`, `Event`.`country_id`, `Event`.`commune`, `Event`.`report`, `TypesEvent`.`id`, `TypesEvent`.`name`, `Country`.`id`, `Country`.`alpha3`, `Country`.`name`, `Departement`.`DEP`, `Departement`.`name`, `Departement`.`id`, `Event`.`id` FROM `ExtranetFFH`.`events` AS `Event` LEFT JOIN `ExtranetFFH`.`types_events` AS `TypesEvent` ON (`Event`.`types_event_id` = `TypesEvent`.`id`) LEFT JOIN `ExtranetFFH`.`countries` AS `Country` ON (`Event`.`country_id` = `Country`.`id`) LEFT JOIN `ExtranetFFH`.`departements` AS `Departement` ON (`Event`.`departement_id` = `Departement`.`id`) WHERE `Event`.`id` IN (205, 314, 443, 488, 506, 511, 607, 1101, 1102, 1103, 1536, 1537, 1538, 1539, 1540, 1541, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1550, 1551, 1552, 1553, 1554, 1555, 1556, 2171, 2692, 3732, 4671, 4694, 5085, 5141, 5158, 5187, 3572, 5200, 5514, 5738, 5454, 5456, 5457, 5851, 5878, 5896, 5900, 6007, 6180, 6589, 5747, 6755, 6756, 6253, 6989, 7119, 7120, 7121, 7122, 7123, 7124, 7125, 7126, 7127, 7129, 7130, 7131, 7132, 7133, 7134, 7135, 7137, 7138, 7139, 7424, 7474, 7629, 7689, 7877, 7878, 7879, 7880, 7881, 7882, 8074, 8342, 8521, 9012, 9019, 9042, 9056, 9109, 9111, 9113, 9115, 9182, 10266, 10267, 10268, 10275, 10276, 10277, 11011, 11251, 11483, 11490, 11596, 11599, 12077, 12147, 12148, 12151, 12154, 12155, 12157, 12158, 12159, 12161, 12302, 12303, 13198, 13791, 13867, 13990, 14517, 14518, 14519, 14541, 14609, 14966, 15118, 15307, 15526, 15528, 15529, 15530, 15531, 15532, 15533, 15534, 15535, 15536, 15537, 15546, 15547, 15548, 15549, 15551, 15552, 15553, 15554, 15555, 15781, 15782) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '11'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '11')))) ORDER BY `Event`.`debut` ASC LIMIT 100001
17SELECT `FamillesEvent`.`id`, `FamillesEvent`.`name` FROM `ExtranetFFH`.`familles_events` AS `FamillesEvent` WHERE 1 = 1 ORDER BY `name` ASC10100
18SELECT `Handicap`.`id`, `Handicap`.`name` FROM `ExtranetFFH`.`handicaps` AS `Handicap` WHERE 1 = 1 ORDER BY `name` ASC770
19SELECT `Region`.`id`, `Region`.`name` FROM `ExtranetFFH`.`regions` AS `Region` WHERE 1 = 1 ORDER BY `Region`.`name` ASC39390