Calendrier des événements handisport:

RECHERCHER

Période du

ÉVÉNEMENTS DU MOIS

~~13 déc 15 déc 19~~
10 12 Avr

Reporté !
Annulé !
Séjour
Stage 1ère neige 2019 / Ski Alpin / Val thorens

Ski alpin

Notice (8): Undefined index: EventsSite [APP/View/Elements/bloc_calendar_avenir.ctp, line 118]Code Context                          </td> 
                          <td style="padding:7px 0px 7px 0px;"><?php $sports = array(); foreach ($row['EventsSport'] as $row2): $sports[] = $row2['Sport']['name']; endforeach; echo wordwrap(implode(', ',$sports),50,'<br/>');?></td>
                          <td style="padding:7px 0px 7px 0px;"><?= strtoupper($row['EventsSite'][0]['commune']); ?></td>
$viewFile = '/home/extranet/public_html/app/View/Elements/bloc_calendar_avenir.ctp'
$dataForView = array(
	'debugToolbarPanels' => array(
		'history' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'history_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'session' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'session_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'request' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'request_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'sql_log' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'sql_log_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'timer' => array(
			'content' => null,
			'elementName' => 'timer_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'log' => array(
			'content' => object(DebugKitLog) {},
			'elementName' => 'log_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'variables' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'variables_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'environment' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'environment_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'include' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'include_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		)
	),
	'debugToolbarJavascript' => array(
		'libs' => 'DebugKit./js/js_debug_toolbar'
	),
	'debugToolbarCss' => array(
		(int) 0 => 'DebugKit./css/debug_toolbar.css'
	),
	'eventsMois7' => array(),
	'eventsMois6' => array(),
	'eventsMois5' => array(),
	'eventsMois4' => array(),
	'eventsMois3' => array(),
	'eventsMois2' => array(),
	'eventsMois1' => array(),
	'eventsMois0' => array(
		(int) 0 => array(
			'Event' => array(
				[maximum depth reached]
			),
			'TypesEvent' => array(
				[maximum depth reached]
			),
			'Country' => array(
				[maximum depth reached]
			),
			'Departement' => array(
				[maximum depth reached]
			),
			'EventsSport' => array(
				[maximum depth reached]
			)
		)
	),
	'reg' => array(
		(int) 320000132 => 'BOURGOGNE FRANCHE-COMTE',
		'050000105' => 'BRETAGNE',
		'060000106' => 'CENTRE',
		(int) 250000125 => 'CORSE',
		'090000109' => 'FRANCHE-COMTE',
		(int) 330000133 => 'GRAND-EST',
		(int) 270000127 => 'GUYANE',
		(int) 340000134 => 'HAUTS DE FRANCE',
		(int) 100000110 => 'ILE-DE-FRANCE',
		(int) 240000124 => 'MARTINIQUE',
		(int) 960000196 => 'MAYOTTE',
		(int) 150000115 => 'NORD-PAS-DE-CALAIS',
		(int) 290000129 => 'NORMANDIE',
		(int) 980000198 => 'CALEDONIE',
		(int) 350000135 => 'NOUVELLE AQUITAINE',
		(int) 360000136 => 'OCCITANIE',
		(int) 280000128 => 'PROVENCE-ALPES CÔTE D'AZUR',
		(int) 180000118 => 'PAYS DE LA LOIRE',
		(int) 190000119 => 'PICARDIE',
		(int) 970000197 => 'POLYNESIE FRANCAISE',
		(int) 260000126 => 'LA REUNION',
		(int) 950000195 => 'WALLIS ET FUTUNA',
		(int) 310000131 => 'AUVERGNE RHÔNE-ALPES',
		(int) 230000123 => 'GUADELOUPE'
	),
	'eventsUne' => array(),
	'type' => array(
		'' => null,
		(int) 136 => 'AFM téléthon',
		(int) 55 => 'Concours',
		(int) 133 => null,
		(int) 134 => 'Journée de détection',
		(int) 81 => 'Match',
		(int) 40 => 'Raid',
		(int) 72 => 'Grand Prix des Jeunes',
		(int) 13 => 'Critérium',
		(int) 108 => 'Assises',
		(int) 104 => 'Epreuve',
		(int) 122 => 'Formation',
		(int) 107 => 'Comité Directeur',
		(int) 110 => 'Réunion',
		(int) 77 => 'Jeux de l'Avenir',
		(int) 41 => 'Assemblée générale',
		(int) 137 => 'Championnat - Phase(s) finale(s)',
		(int) 1 => 'Championnat - Phase(s) qualificative(s)',
		(int) 50 => 'Challenge',
		(int) 8 => 'Jeux internationaux',
		(int) 63 => 'Coupe',
		(int) 20 => 'Meeting',
		(int) 99 => 'Régate',
		(int) 112 => 'Journée sportive',
		(int) 14 => 'Tournoi',
		(int) 38 => 'Stage',
		(int) 117 => 'Séjour',
		(int) 0 => null,
		(int) 43 => 'Colloque/conférence',
		(int) 66 => 'Course',
		(int) 100 => 'Circuit',
		(int) 12 => 'Open',
		(int) 102 => 'Compétition'
	),
	'sports' => array(
		(int) 1 => 'Athlétisme',
		(int) 10 => 'Course d'orientation',
		(int) 101 => 'Vol libre',
		(int) 104 => 'Badminton',
		(int) 105 => 'Javelot tir sur cible',
		(int) 106 => 'Basket-ball Sourds',
		(int) 108 => 'Cyclisme tricycle',
		(int) 109 => 'Futsall',
		(int) 11 => 'Cyclisme solo',
		(int) 110 => 'Hockey fauteuil électrique',
		(int) 111 => 'Showdown DV',
		(int) 112 => 'Snowboard',
		(int) 113 => 'Echecs',
		(int) 114 => 'Marche nordique',
		(int) 115 => 'Cyclisme VTT sourds',
		(int) 116 => 'Foot à 5 DV',
		(int) 117 => 'Nihon Taï Jitsu',
		(int) 118 => 'Trampoline',
		(int) 12 => 'Cyclisme tandem',
		(int) 13 => 'Danse',
		(int) 15 => 'Equitation',
		(int) 16 => 'Escalade',
		(int) 17 => 'Escrime',
		(int) 18 => 'Randonnée - FTT',
		(int) 19 => 'Foot à 5 en salle',
		(int) 2 => 'Aviron',
		(int) 20 => 'Foot fauteuil électrique',
		(int) 200 => 'Cyclisme',
		(int) 21 => 'Goalball',
		(int) 22 => 'Golf',
		(int) 23 => 'Developpé couché - Haltérophilie',
		(int) 24 => 'Cyclisme Handcycle',
		(int) 25 => 'Randonnée - Joëlette',
		(int) 26 => 'Judo',
		(int) 27 => 'Karting',
		(int) 28 => 'Natation',
		(int) 3 => 'Badminton - Sourds',
		(int) 30 => 'Plongée-sous-marine',
		(int) 32 => 'Randonnée',
		(int) 33 => 'Sarbacane',
		(int) 34 => 'Ski alpin',
		(int) 35 => 'Ski nautique',
		(int) 36 => 'Ski de fond - Biathlon',
		(int) 37 => 'Tennis',
		(int) 38 => 'Tennis de table',
		(int) 39 => 'Tir à l'arc',
		(int) 4 => 'Basket-ball Fauteuil',
		(int) 40 => 'Tir au plateau',
		(int) 41 => 'Tir sportif',
		(int) 42 => 'Torball',
		(int) 43 => 'Triathlon',
		(int) 45 => 'Voile',
		(int) 47 => 'Rugby',
		(int) 48 => 'Canne française',
		(int) 49 => 'Rugby XIII',
		(int) 5 => 'Boccia',
		(int) 50 => 'Karaté',
		(int) 51 => 'Bowling',
		(int) 52 => 'Volley-ball',
		(int) 53 => 'Foot à 11',
		(int) 54 => 'Kendo',
		(int) 55 => 'Billard',
		(int) 58 => 'Parachutisme',
		(int) 59 => 'Musculation',
		(int) 6 => 'Sports de Boules - Pétanque',
		(int) 60 => 'Pelote basque',
		(int) 61 => 'Gymnastique',
		(int) 62 => 'Aïkido',
		(int) 63 => 'Boxe',
		(int) 64 => 'Taekwondo/Taichi Chuan',
		(int) 65 => 'Hockey sur glace fauteuil',
		(int) 66 => 'Patinage',
		(int) 68 => 'Curling fauteuil',
		(int) 69 => 'Fléchette pendulaire',
		(int) 7 => 'Canoë-kayak - Pirogue',
		(int) 70 => 'Sports Aériens',
		(int) 71 => 'Roller Skating',
		(int) 72 => 'Foot à 7',
		(int) 73 => 'Parapente',
		(int) 74 => 'Handball',
		(int) 75 => 'Pêche',
		(int) 76 => 'Aéromodélisme',
		(int) 79 => 'Baseball - Softball',
		(int) 8 => 'Foot à 5',
		(int) 80 => 'Football américain',
		(int) 82 => 'Hockey sur gazon',
		(int) 85 => 'Lutte',
		(int) 86 => 'Motocyclisme',
		(int) 89 => 'Planeur - ULM',
		(int) 9 => 'Char à voile',
		(int) 90 => 'Rando - Traineau - Pulka',
		(int) 91 => 'Randonnée pédestre',
		(int) 92 => 'Roller',
		(int) 93 => 'Spéléologie',
		(int) 95 => 'Sports de Boules - Pétanque - sourd',
		(int) 98 => 'Surf',
		(int) 99 => 'Tennis - Sourds',
		(int) 995 => 'Parcours moteur',
		(int) 996 => 'Slalom',
		(int) 999 => 'Multisports',
		(int) 0 => null,
		(int) 97 => 'Squach'
	),
	'dep' => array(
		(int) 220010001 => '01 / AIN',
		(int) 190020002 => '02 / AISNE',
		'030030003' => '03 / ALLIER',
		(int) 210040004 => '04 / ALPES-DE-HAUTE-PROVENCE',
		(int) 210050005 => '05 / HAUTES-ALPES',
		(int) 300060006 => '06 / ALPES-MARITIMES',
		(int) 220070007 => '07 / ARDECHE',
		'070080008' => '08 / ARDENNES',
		(int) 140090009 => '09 / ARIEGE',
		'070100010' => '10 / AUBE',
		(int) 110110011 => '11 / AUDE',
		(int) 140120012 => '12 / AVEYRON',
		(int) 210130013 => '13 / BOUCHES-DU-RHONE',
		(int) 160140014 => '14 / CALVADOS',
		'030150015' => '15 / CANTAL',
		(int) 200160016 => '16 / CHARENTE',
		(int) 200170017 => '17 / CHARENTE-MARITIME',
		'060180018' => '18 / CHER',
		(int) 120191076 => '19 / CORREZE',
		'040210021' => '21 / COTE-D'OR',
		'050220022' => '22 / COTES-D'ARMOR',
		(int) 120230023 => '23 / CREUSE',
		'020240024' => '24 / DORDOGNE',
		'090250025' => '25 / DOUBS',
		(int) 220260026 => '26 / DROME',
		(int) 170270027 => '27 / EURE',
		'060280028' => '28 / EURE-ET-LOIR',
		'050290029' => '29 / FINISTERE',
		(int) 250200020 => '2A / CORSE-DU-SUD',
		(int) 250200021 => '2B / HAUTE-CORSE',
		(int) 110300030 => '30 / GARD',
		(int) 140310031 => '31 / HAUTE-GARONNE',
		(int) 140320032 => '32 / GERS',
		'020330033' => '33 / GIRONDE',
		(int) 110340034 => '34 / HERAULT',
		'050350035' => '35 / ILLE-ET-VILAINE',
		'060360036' => '36 / INDRE',
		'060370037' => '37 / INDRE-ET-LOIRE',
		(int) 220380038 => '38 / ISERE',
		'090390039' => '39 / JURA',
		'020400040' => '40 / LANDES',
		'060410041' => '41 / LOIR-ET-CHER',
		(int) 220420042 => '42 / LOIRE',
		'030430043' => '43 / HAUTE-LOIRE',
		(int) 180440044 => '44 / LOIRE-ATLANTIQUE',
		'060450045' => '45 / LOIRET',
		(int) 140460046 => '46 / LOT',
		'020470047' => '47 / LOT-ET-GARONNE',
		(int) 110480048 => '48 / LOZERE',
		(int) 180490049 => '49 / MAINE-ET-LOIRE',
		(int) 160500050 => '50 / MANCHE',
		'070510051' => '51 / MARNE',
		'070520052' => '52 / HAUTE-MARNE',
		(int) 180530053 => '53 / MAYENNE',
		(int) 130540054 => '54 / MEURTHE-ET-MOSELLE',
		(int) 130550055 => '55 / MEUSE',
		'050560056' => '56 / MORBIHAN',
		(int) 130570057 => '57 / MOSELLE',
		'040580058' => '58 / NIEVRE',
		(int) 150590059 => '59 / NORD',
		(int) 190600060 => '60 / OISE',
		(int) 160610061 => '61 / ORNE',
		(int) 150620062 => '62 / PAS-DE-CALAIS',
		'030630063' => '63 / PUY-DE-DOME',
		'020640064' => '64 / PYRENEES-ATLANTIQUES',
		(int) 140650065 => '65 / HAUTES-PYRENEES',
		(int) 110660066 => '66 / PYRENEES-ORIENTALES',
		'010670067' => '67 / BAS-RHIN',
		'010680068' => '68 / HAUT-RHIN',
		(int) 220690069 => '69 / RHONE',
		'090700070' => '70 / HAUTE-SAONE',
		'040710071' => '71 / SAONE-ET-LOIRE',
		(int) 180720072 => '72 / SARTHE',
		(int) 220730073 => '73 / SAVOIE',
		(int) 220740074 => '74 / HAUTE-SAVOIE',
		(int) 100750075 => '75 / PARIS',
		(int) 170760076 => '76 / SEINE-MARITIME',
		(int) 100770077 => '77 / SEINE-ET-MARNE',
		(int) 100780078 => '78 / YVELINES',
		(int) 200790079 => '79 / DEUX-SEVRES',
		(int) 190800080 => '80 / SOMME',
		(int) 140810081 => '81 / TARN',
		(int) 140820082 => '82 / TARN-ET-GARONNE',
		(int) 300830083 => '83 / VAR',
		(int) 210840084 => '84 / VAUCLUSE',
		(int) 180850085 => '85 / VENDEE',
		(int) 200860086 => '86 / VIENNE',
		(int) 120870087 => '87 / HAUTE-VIENNE',
		(int) 130880088 => '88 / VOSGES',
		'040890089' => '89 / YONNE',
		'090900090' => '90 / TERRITOIRE DE BELFORT',
		(int) 100910091 => '91 / ESSONNE',
		(int) 100920092 => '92 / HAUTS-DE-SEINE',
		(int) 100930093 => '93 / SEINE-SAINT-DENIS',
		(int) 100940094 => '94 / VAL-DE-MARNE',
		(int) 100950095 => '95 / VAL-D'OISE',
		(int) 239710971 => '971 / GUADELOUPE',
		(int) 249720972 => '972 / MARTINIQUE',
		(int) 279730973 => '973 / GUYANE',
		(int) 269740974 => '974 / LA REUNION',
		(int) 969760976 => '977 / MAYOTTE',
		(int) 959860986 => '987 / WALLIS ET FUTUNA',
		(int) 980000198 => '988 / NOUVELLE CALÉDONIE',
		(int) 979870987 => '988 / POLYNESIE FRANCAISE',
		'' => '989 / '
	)
)
$debugToolbarPanels = array(
	'history' => array(
		'content' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			)
		),
		'elementName' => 'history_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'session' => array(
		'content' => array(
			'Config' => array(
				[maximum depth reached]
			),
			'header_sport' => 'SKI ALPIN',
			'calendar_sport_id' => '000000231'
		),
		'elementName' => 'session_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'request' => array(
		'content' => array(
			'params' => array(
				[maximum depth reached]
			),
			'url' => 'events/calendarBySport/000000231',
			'query' => array([maximum depth reached]),
			'data' => array([maximum depth reached]),
			'cookie' => array([maximum depth reached]),
			'get' => array([maximum depth reached]),
			'currentRoute' => object(CakeRoute) {}
		),
		'elementName' => 'request_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'sql_log' => array(
		'content' => array(
			'connections' => array(
				[maximum depth reached]
			),
			'threshold' => (int) 20
		),
		'elementName' => 'sql_log_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'timer' => array(
		'content' => null,
		'elementName' => 'timer_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'log' => array(
		'content' => object(DebugKitLog) {},
		'elementName' => 'log_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'variables' => array(
		'content' => array(
			'eventsMois7' => array([maximum depth reached]),
			'eventsMois6' => array([maximum depth reached]),
			'eventsMois5' => array([maximum depth reached]),
			'eventsMois4' => array([maximum depth reached]),
			'eventsMois3' => array([maximum depth reached]),
			'eventsMois2' => array([maximum depth reached]),
			'eventsMois1' => array([maximum depth reached]),
			'eventsMois0' => array(
				[maximum depth reached]
			),
			'reg' => array(
				[maximum depth reached]
			),
			'eventsUne' => array([maximum depth reached]),
			'type' => array(
				[maximum depth reached]
			),
			'sports' => array(
				[maximum depth reached]
			),
			'dep' => array(
				[maximum depth reached]
			),
			'$request->data' => array([maximum depth reached])
		),
		'elementName' => 'variables_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'environment' => array(
		'content' => array(
			'php' => array(
				[maximum depth reached]
			),
			'cake' => array(
				[maximum depth reached]
			),
			'app' => array(
				[maximum depth reached]
			)
		),
		'elementName' => 'environment_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'include' => array(
		'content' => array(
			'core' => array(
				[maximum depth reached]
			),
			'app' => array(
				[maximum depth reached]
			),
			'plugins' => array(
				[maximum depth reached]
			),
			'paths' => array(
				[maximum depth reached]
			)
		),
		'elementName' => 'include_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	)
)
$debugToolbarJavascript = array(
	'libs' => 'DebugKit./js/js_debug_toolbar'
)
$debugToolbarCss = array(
	(int) 0 => 'DebugKit./css/debug_toolbar.css'
)
$eventsMois7 = array()
$eventsMois6 = array()
$eventsMois5 = array()
$eventsMois4 = array()
$eventsMois3 = array()
$eventsMois2 = array()
$eventsMois1 = array()
$eventsMois0 = array(
	(int) 0 => array(
		'Event' => array(
			'name' => 'Stage 1ère neige 2019 / Ski Alpin / Val thorens',
			'debut' => '13/12/2019',
			'fin' => '15/12/2019',
			'debut2' => '10/04/2020',
			'fin2' => '12/04/2020',
			'annulation' => '1',
			'country_id' => '75',
			'commune' => '',
			'report' => '1',
			'id' => '14605'
		),
		'TypesEvent' => array(
			'id' => '117',
			'name' => 'Séjour'
		),
		'Country' => array(
			'id' => '75',
			'alpha3' => 'FRA',
			'name' => 'France'
		),
		'Departement' => array(
			'DEP' => '73',
			'name' => 'SAVOIE',
			'id' => '220730073'
		),
		'EventsSport' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		)
	)
)
$reg = array(
	(int) 320000132 => 'BOURGOGNE FRANCHE-COMTE',
	'050000105' => 'BRETAGNE',
	'060000106' => 'CENTRE',
	(int) 250000125 => 'CORSE',
	'090000109' => 'FRANCHE-COMTE',
	(int) 330000133 => 'GRAND-EST',
	(int) 270000127 => 'GUYANE',
	(int) 340000134 => 'HAUTS DE FRANCE',
	(int) 100000110 => 'ILE-DE-FRANCE',
	(int) 240000124 => 'MARTINIQUE',
	(int) 960000196 => 'MAYOTTE',
	(int) 150000115 => 'NORD-PAS-DE-CALAIS',
	(int) 290000129 => 'NORMANDIE',
	(int) 980000198 => 'CALEDONIE',
	(int) 350000135 => 'NOUVELLE AQUITAINE',
	(int) 360000136 => 'OCCITANIE',
	(int) 280000128 => 'PROVENCE-ALPES CÔTE D'AZUR',
	(int) 180000118 => 'PAYS DE LA LOIRE',
	(int) 190000119 => 'PICARDIE',
	(int) 970000197 => 'POLYNESIE FRANCAISE',
	(int) 260000126 => 'LA REUNION',
	(int) 950000195 => 'WALLIS ET FUTUNA',
	(int) 310000131 => 'AUVERGNE RHÔNE-ALPES',
	(int) 230000123 => 'GUADELOUPE'
)
$eventsUne = array()
$type = array(
	'' => null,
	(int) 136 => 'AFM téléthon',
	(int) 55 => 'Concours',
	(int) 133 => null,
	(int) 134 => 'Journée de détection',
	(int) 81 => 'Match',
	(int) 40 => 'Raid',
	(int) 72 => 'Grand Prix des Jeunes',
	(int) 13 => 'Critérium',
	(int) 108 => 'Assises',
	(int) 104 => 'Epreuve',
	(int) 122 => 'Formation',
	(int) 107 => 'Comité Directeur',
	(int) 110 => 'Réunion',
	(int) 77 => 'Jeux de l'Avenir',
	(int) 41 => 'Assemblée générale',
	(int) 137 => 'Championnat - Phase(s) finale(s)',
	(int) 1 => 'Championnat - Phase(s) qualificative(s)',
	(int) 50 => 'Challenge',
	(int) 8 => 'Jeux internationaux',
	(int) 63 => 'Coupe',
	(int) 20 => 'Meeting',
	(int) 99 => 'Régate',
	(int) 112 => 'Journée sportive',
	(int) 14 => 'Tournoi',
	(int) 38 => 'Stage',
	(int) 117 => 'Séjour',
	(int) 0 => null,
	(int) 43 => 'Colloque/conférence',
	(int) 66 => 'Course',
	(int) 100 => 'Circuit',
	(int) 12 => 'Open',
	(int) 102 => 'Compétition'
)
$sports = array(
	(int) 0 => 'Ski alpin'
)
$dep = array(
	(int) 220010001 => '01 / AIN',
	(int) 190020002 => '02 / AISNE',
	'030030003' => '03 / ALLIER',
	(int) 210040004 => '04 / ALPES-DE-HAUTE-PROVENCE',
	(int) 210050005 => '05 / HAUTES-ALPES',
	(int) 300060006 => '06 / ALPES-MARITIMES',
	(int) 220070007 => '07 / ARDECHE',
	'070080008' => '08 / ARDENNES',
	(int) 140090009 => '09 / ARIEGE',
	'070100010' => '10 / AUBE',
	(int) 110110011 => '11 / AUDE',
	(int) 140120012 => '12 / AVEYRON',
	(int) 210130013 => '13 / BOUCHES-DU-RHONE',
	(int) 160140014 => '14 / CALVADOS',
	'030150015' => '15 / CANTAL',
	(int) 200160016 => '16 / CHARENTE',
	(int) 200170017 => '17 / CHARENTE-MARITIME',
	'060180018' => '18 / CHER',
	(int) 120191076 => '19 / CORREZE',
	'040210021' => '21 / COTE-D'OR',
	'050220022' => '22 / COTES-D'ARMOR',
	(int) 120230023 => '23 / CREUSE',
	'020240024' => '24 / DORDOGNE',
	'090250025' => '25 / DOUBS',
	(int) 220260026 => '26 / DROME',
	(int) 170270027 => '27 / EURE',
	'060280028' => '28 / EURE-ET-LOIR',
	'050290029' => '29 / FINISTERE',
	(int) 250200020 => '2A / CORSE-DU-SUD',
	(int) 250200021 => '2B / HAUTE-CORSE',
	(int) 110300030 => '30 / GARD',
	(int) 140310031 => '31 / HAUTE-GARONNE',
	(int) 140320032 => '32 / GERS',
	'020330033' => '33 / GIRONDE',
	(int) 110340034 => '34 / HERAULT',
	'050350035' => '35 / ILLE-ET-VILAINE',
	'060360036' => '36 / INDRE',
	'060370037' => '37 / INDRE-ET-LOIRE',
	(int) 220380038 => '38 / ISERE',
	'090390039' => '39 / JURA',
	'020400040' => '40 / LANDES',
	'060410041' => '41 / LOIR-ET-CHER',
	(int) 220420042 => '42 / LOIRE',
	'030430043' => '43 / HAUTE-LOIRE',
	(int) 180440044 => '44 / LOIRE-ATLANTIQUE',
	'060450045' => '45 / LOIRET',
	(int) 140460046 => '46 / LOT',
	'020470047' => '47 / LOT-ET-GARONNE',
	(int) 110480048 => '48 / LOZERE',
	(int) 180490049 => '49 / MAINE-ET-LOIRE',
	(int) 160500050 => '50 / MANCHE',
	'070510051' => '51 / MARNE',
	'070520052' => '52 / HAUTE-MARNE',
	(int) 180530053 => '53 / MAYENNE',
	(int) 130540054 => '54 / MEURTHE-ET-MOSELLE',
	(int) 130550055 => '55 / MEUSE',
	'050560056' => '56 / MORBIHAN',
	(int) 130570057 => '57 / MOSELLE',
	'040580058' => '58 / NIEVRE',
	(int) 150590059 => '59 / NORD',
	(int) 190600060 => '60 / OISE',
	(int) 160610061 => '61 / ORNE',
	(int) 150620062 => '62 / PAS-DE-CALAIS',
	'030630063' => '63 / PUY-DE-DOME',
	'020640064' => '64 / PYRENEES-ATLANTIQUES',
	(int) 140650065 => '65 / HAUTES-PYRENEES',
	(int) 110660066 => '66 / PYRENEES-ORIENTALES',
	'010670067' => '67 / BAS-RHIN',
	'010680068' => '68 / HAUT-RHIN',
	(int) 220690069 => '69 / RHONE',
	'090700070' => '70 / HAUTE-SAONE',
	'040710071' => '71 / SAONE-ET-LOIRE',
	(int) 180720072 => '72 / SARTHE',
	(int) 220730073 => '73 / SAVOIE',
	(int) 220740074 => '74 / HAUTE-SAVOIE',
	(int) 100750075 => '75 / PARIS',
	(int) 170760076 => '76 / SEINE-MARITIME',
	(int) 100770077 => '77 / SEINE-ET-MARNE',
	(int) 100780078 => '78 / YVELINES',
	(int) 200790079 => '79 / DEUX-SEVRES',
	(int) 190800080 => '80 / SOMME',
	(int) 140810081 => '81 / TARN',
	(int) 140820082 => '82 / TARN-ET-GARONNE',
	(int) 300830083 => '83 / VAR',
	(int) 210840084 => '84 / VAUCLUSE',
	(int) 180850085 => '85 / VENDEE',
	(int) 200860086 => '86 / VIENNE',
	(int) 120870087 => '87 / HAUTE-VIENNE',
	(int) 130880088 => '88 / VOSGES',
	'040890089' => '89 / YONNE',
	'090900090' => '90 / TERRITOIRE DE BELFORT',
	(int) 100910091 => '91 / ESSONNE',
	(int) 100920092 => '92 / HAUTS-DE-SEINE',
	(int) 100930093 => '93 / SEINE-SAINT-DENIS',
	(int) 100940094 => '94 / VAL-DE-MARNE',
	(int) 100950095 => '95 / VAL-D'OISE',
	(int) 239710971 => '971 / GUADELOUPE',
	(int) 249720972 => '972 / MARTINIQUE',
	(int) 279730973 => '973 / GUYANE',
	(int) 269740974 => '974 / LA REUNION',
	(int) 969760976 => '977 / MAYOTTE',
	(int) 959860986 => '987 / WALLIS ET FUTUNA',
	(int) 980000198 => '988 / NOUVELLE CALÉDONIE',
	(int) 979870987 => '988 / POLYNESIE FRANCAISE',
	'' => '989 / '
)
$date = object(DateTime) {
	date => '2020-11-03 00:00:00.000000'
	timezone_type => (int) 3
	timezone => 'Europe/Berlin'
}
$interval = object(DateInterval) {
	y => (int) 0
	m => (int) 1
	d => (int) 0
	h => (int) 0
	i => (int) 0
	s => (int) 0
	f => (float) 0
	weekday => (int) 0
	weekday_behavior => (int) 0
	first_last_day_of => (int) 0
	invert => (int) 0
	days => false
	special_type => (int) 0
	special_amount => (int) 0
	have_weekday_relative => (int) 0
	have_special_relative => (int) 0
}
$monthN0 = '4'
$month0 = '04'
$year0 = '2020'
$libelleOnglet0 = 'AVRIL 2020'
$monthN1 = '5'
$month1 = '05'
$year1 = '2020'
$libelleOnglet1 = 'MAI 2020'
$monthN2 = '6'
$month2 = '06'
$year2 = '2020'
$libelleOnglet2 = 'JUIN 2020'
$monthN3 = '7'
$month3 = '07'
$year3 = '2020'
$libelleOnglet3 = 'JUILLET 2020'
$monthN4 = '8'
$month4 = '08'
$year4 = '2020'
$libelleOnglet4 = 'AOÛT 2020'
$monthN5 = '9'
$month5 = '09'
$year5 = '2020'
$libelleOnglet5 = 'SEPTEMBRE 2020'
$monthN6 = '10'
$month6 = '10'
$year6 = '2020'
$libelleOnglet6 = 'OCTOBRE 2020'
$monthN7 = '11'
$month7 = '11'
$year7 = '2020'
$libelleOnglet7 = 'NOVEMBRE 2020'
$i = (int) 0
$eventsMois = 'eventsMois0'
$monthN = 'monthN0'
$month = 'month0'
$year = 'year0'
$row = array(
	'Event' => array(
		'name' => 'Stage 1ère neige 2019 / Ski Alpin / Val thorens',
		'debut' => '13/12/2019',
		'fin' => '15/12/2019',
		'debut2' => '10/04/2020',
		'fin2' => '12/04/2020',
		'annulation' => '1',
		'country_id' => '75',
		'commune' => '',
		'report' => '1',
		'id' => '14605'
	),
	'TypesEvent' => array(
		'id' => '117',
		'name' => 'Séjour'
	),
	'Country' => array(
		'id' => '75',
		'alpha3' => 'FRA',
		'name' => 'France'
	),
	'Departement' => array(
		'DEP' => '73',
		'name' => 'SAVOIE',
		'id' => '220730073'
	),
	'EventsSport' => array(
		(int) 0 => array(
			'id' => '23791',
			'user_id' => '44',
			'event_id' => '14605',
			'sport_id' => '34',
			'detail' => null,
			'created' => '2019-09-19 14:15:51',
			'modified' => '2019-09-19 14:15:51',
			'sport' => 'Ski alpin',
			'Sport' => array(
				[maximum depth reached]
			)
		)
	)
)
$row2 = array(
	'id' => '23791',
	'user_id' => '44',
	'event_id' => '14605',
	'sport_id' => '34',
	'detail' => null,
	'created' => '2019-09-19 14:15:51',
	'modified' => '2019-09-19 14:15:51',
	'sport' => 'Ski alpin',
	'Sport' => array(
		'name' => 'Ski alpin'
	)
)
include - APP/View/Elements/bloc_calendar_avenir.ctp, line 118
View::_evaluate() - CORE/Cake/View/View.php, line 971
View::_render() - CORE/Cake/View/View.php, line 933
View::_renderElement() - CORE/Cake/View/View.php, line 1224
View::element() - CORE/Cake/View/View.php, line 418
include - APP/View/Events/calendar_by_sport.ctp, line 26
View::_evaluate() - CORE/Cake/View/View.php, line 971
View::_render() - CORE/Cake/View/View.php, line 933
View::render() - CORE/Cake/View/View.php, line 473
Controller::render() - CORE/Cake/Controller/Controller.php, line 963
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 200
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 115

Voir les événements suivants de ce mois

Tous les événements | AVRIL 2020

Voir les événements suivants de ce mois

Tous les événements | MAI 2020

Voir les événements suivants de ce mois

Tous les événements | JUIN 2020

Voir les événements suivants de ce mois

Tous les événements | JUILLET 2020

Voir les événements suivants de ce mois

Tous les événements | AOÛT 2020

Voir les événements suivants de ce mois

Tous les événements | SEPTEMBRE 2020

Voir les événements suivants de ce mois

Tous les événements | OCTOBRE 2020

Voir les événements suivants de ce mois

Tous les événements | NOVEMBRE 2020

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.

Deprecated (16384): Using key `action` is deprecated, use `url` directly instead. [CORE/Cake/View/Helper/FormHelper.php, line 383]Code Context
        if (isset($options['action'])) {
            trigger_error('Using key `action` is deprecated, use `url` directly instead.', E_USER_DEPRECATED);
$model = 'Abonnement'
$options = array(
	'action' => 'add',
	'class' => 'form-horizontal',
	'type' => 'post',
	'url' => null,
	'default' => true,
	'encoding' => 'utf-8'
)
$created = false
$id = false
$append = ''
$key = null
$plugin = null
FormHelper::create() - CORE/Cake/View/Helper/FormHelper.php, line 383
include - APP/View/Events/calendar_by_sport.ctp, line 74
View::_evaluate() - CORE/Cake/View/View.php, line 971
View::_render() - CORE/Cake/View/View.php, line 933
View::render() - CORE/Cake/View/View.php, line 473
Controller::render() - CORE/Cake/Controller/Controller.php, line 963
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 200
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 115

Veuillez choisir un critère ci-dessous.

Sport

Votre email

Deprecated (16384): Using key `action` is deprecated, use `url` directly instead. [CORE/Cake/View/Helper/FormHelper.php, line 383]Code Context
        if (isset($options['action'])) {
            trigger_error('Using key `action` is deprecated, use `url` directly instead.', E_USER_DEPRECATED);
$model = 'AlertesMissEvent'
$options = array(
	'controller' => 'AlertesMissEvents',
	'action' => 'addMissEvent',
	'class' => 'form-horizontal',
	'type' => 'post',
	'url' => null,
	'default' => true,
	'encoding' => 'utf-8'
)
$created = false
$id = false
$append = ''
$key = 'id'
$plugin = null
$recordExists = false
FormHelper::create() - CORE/Cake/View/Helper/FormHelper.php, line 383
include - APP/View/Events/calendar_by_sport.ctp, line 115
View::_evaluate() - CORE/Cake/View/View.php, line 971
View::_render() - CORE/Cake/View/View.php, line 933
View::render() - CORE/Cake/View/View.php, line 473
Controller::render() - CORE/Cake/Controller/Controller.php, line 963
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 200
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 115

Vous avez remarqué qu'un événement handisport est manquant sur le calendrier ?
Vous souhaitez alerter le responsable du département concerné ?

Pour cela, remplissez le formulaire ci-dessous.

Libellé événement

Début

Fin

Département

Commune

Votre email

(production) 21 queries took 353 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT SUBSTR(StructureNomCourt,7) as SPORT, `Structure`.`id` FROM `ExtranetFFH`.`structures` AS `Structure` WHERE `StructureCode` = '000000231' LIMIT 1	1	1	2
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	24	24	13
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	24544	24544	276
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	33	33	22
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`.`user_modify_id`, `Event`.`modified`, `Event`.`sport`, `Event`.`competition`, `Event`.`types_event_id`, `Event`.`type_complement`, `Event`.`activite`, `Event`.`activite_id`, `Event`.`titre`, `Event`.`region_id`, `Event`.`departement_id`, `Event`.`departement_id3`, `Event`.`description`, `Event`.`resume`, `Event`.`begin_published`, `Event`.`end_published`, `Event`.`published`, `Event`.`date_published`, `Event`.`calendar_ffh_published`, `Event`.`une_ffh_published`, `Event`.`une_cr_published`, `Event`.`une_cd_published`, `Event`.`niveau`, `Event`.`web_site`, `Event`.`facebook_page`, `Event`.`galerie_photo`, `Event`.`resultats_page`, `Event`.`debut`, `Event`.`fin`, `Event`.`report`, `Event`.`report_user_id`, `Event`.`report_details`, `Event`.`debut2`, `Event`.`fin2`, `Event`.`code_postal`, `Event`.`commune`, `Event`.`stop_event`, `Event`.`stop_event_user_id`, `Event`.`stop_event_date`, `Event`.`stop_event_details`, `Event`.`age_min`, `Event`.`ddn_min`, `Event`.`age_max`, `Event`.`ddn_max`, `Event`.`licence_ffh`, `Event`.`type_licence_ffh`, `Event`.`ouvert_valide_participant`, `Event`.`gratuit_participant`, `Event`.`price_participant`, `Event`.`open_public`, `Event`.`gratuit_public`, `Event`.`price_public`, `Event`.`country_id`, `Event`.`format`, `Event`.`format_nb_jours`, `Event`.`contact_structure`, `Event`.`contact_interlocuteur`, `Event`.`contact_email`, `Event`.`contact_tel`, `Event`.`capacite_public`, `Event`.`genre`, `Event`.`photo_thumb`, `Event`.`photo_une`, `Event`.`photo_view`, `Event`.`credit_photo`, `Event`.`end_inscription`, `Event`.`begin_inscription`, `Event`.`annulation`, `Event`.`annulation_categorie`, `Event`.`annulation_details`, `Event`.`annulation_user_id`, `Event`.`representant_ffh_id`, `Event`.`representant_ffh_fonction_id`, `Event`.`search_orga`, `Event`.`periode_cible`, `Event`.`precisions_search_orga`, `Event`.`autres_informations`, `Event`.`module_hn`, `Event`.`cdc`, `Event`.`exalto_ManifId`, `Event`.`mds_urlPdf`, `Event`.`mdsevent_id`, `Event`.`insert_by_multiple`, `Event`.`import_du_debut`, `Event`.`mode_gestion`, `Event`.`engagement_individuel`, `Event`.`open_intentions`, `Event`.`end_intentions`, `Event`.`go_intentions`, `Event`.`delegation_precree`, `Event`.`open_engagements`, `Event`.`end_engagements`, `Event`.`end_hebergement`, `Event`.`end_restauration`, `Event`.`go_engagements`, `Event`.`user_gestion_id`, `Event`.`tel_gestion`, `Event`.`email_gestion`, `Event`.`preambule`, `Event`.`delegation_doc_admin`, `Event`.`participant_doc_admin`, `Event`.`epreuves_by_participant`, `Event`.`nb_epreuves_by_participant`, `Event`.`tarif_by_participant`, `Event`.`tarif_by_epreuve_participant`, `Event`.`panier_repas`, `Event`.`tarif_panier_repas`, `Event`.`order_cheque`, `Event`.`adresse_envoi_cheque`, `Event`.`type_engagement`, `Event`.`nb_max_pratiquants_by_delegation`, `Event`.`step_intention`, `Event`.`step_engagement`, `Event`.`etoiles`, `Event`.`nb_participants_moins_20ans`, `Event`.`orga_support_etoiles`, `Event`.`tab_active`, `Event`.`qualification`, `Event`.`num_edition`, `Event`.`dossard`, `Event`.`prerequis_licence_encadrant`, `Event`.`prerequis_licence`, `Event`.`prerequis_licence_sport`, `Event`.`type_prestation`, `Event`.`prestations_by_delegation`, `Event`.`prestations_by_participant`, `Event`.`delegation_heb_cond`, `Event`.`participant_heb_cond`, `Event`.`participant_list_taille_teeshirt`, `Event`.`participant_taille_teeshirt`, `Event`.`participant_deficience_sensorielle`, `Event`.`participant_by_selection`, `Event`.`payment_by_delegation`, `Event`.`payment_by_participant`, `Event`.`frais_techniques_by_participant`, `Event`.`montant_frais_techniques_by_participant`, `Event`.`temps_add_epreuve_by_participant`, `Event`.`billet_congres`, `Event`.`iban`, `Event`.`siret`, `Event`.`prefixe_num_facture`, `Event`.`logo_facture`, `Event`.`width_logo_facture`, `Event`.`sites_transport`, `Event`.`nb_plannings`, `Event`.`montant_promotion_prestation_by_participant`, (MONTH(`Event`.`debut`)) AS `Event__monthDebut`, (YEAR(`Event`.`debut`)) AS `Event__yearDebut`, (MONTH(`Event`.`fin`)) AS `Event__monthFin`, (YEAR(`Event`.`fin`)) AS `Event__yearFin`, (CONCAT(`Event`.`name`," • ",date_format(`Event`.`debut`, '%d/%m/%Y')," au ",date_format(`Event`.`fin`, '%d/%m/%Y'))) AS `Event__eventDates`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Event`.`user_id`) AS `Event__UCR`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Event`.`user_modify_id`) AS `Event__UMR`, (SELECT DEP FROM departements D where `D`.`id` = `Event`.`departement_id`) AS `Event__DEP` FROM `ExtranetFFH`.`events_unes` AS `EventsUne` LEFT JOIN `ExtranetFFH`.`events` AS `Event` ON (`EventsUne`.`event_id` = `Event`.`id`) WHERE `type_une_id` = '000000231'	0	0	1
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` = 232	750	750	1
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	24	24	7
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 (3179, 3216, 3217, 3218, 3219, 3220, 3221, 3867, 3891, 3892, 3893, 3894, 3895, 4276, 4581, 4582, 5935, 5941, 6834, 7645, 7669, 2467, 9487, 11078, 11089, 12396, 12397, 12398, 12399, 12402, 12403, 12991, 15018, 7, 12, 17, 23, 28, 34, 39, 41, 43, 45, 49, 55, 65, 68, 73, 77, 84, 87, 89, 91, 136, 145, 352, 368, 380, 396, 416, 418, 431, 433, 437, 438, 439, 442, 445, 449, 495, 708, 709, 710, 711, 712, 713, 714, 715, 716, 718, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1523, 1524, 1525, 1526, 1527, 1528, 1529, 1530, 1531, 1572, 1573, 1574, 1575, 1576, 1784, 1785, 1786, 1787, 1788, 1789, 1791, 1792, 1793, 1794, 1795, 1858, 1859, 1862, 1863, 1864, 1865, 1896, 1897, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2191, 2192, 2193, 2201, 2203, 2204, 2202, 2603, 2613, 2995, 3203, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3311, 3337, 3460, 3462, 3507, 3512, 3627, 3639, 3483, 3774, 3776, 3802, 3819, 3866, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3890, 3984, 3985, 4182, 4188, 4278, 4280, 4281, 4282, 4288, 4293, 4308, 4017, 4560, 4578, 4579, 4580, 4607, 4687, 4712, 4713, 4715, 4831, 4924, 5081, 5130, 5152, 5165, 5201, 5215, 5229, 5245, 5246, 5260, 5639, 5930, 5931, 5932, 5933, 5934, 6188, 6422, 6472, 6533, 6618, 6659, 6744, 6798, 6799, 6800, 6801, 6802, 6836, 7000, 7012, 7013, 7016, 7018, 7023, 7025, 7068, 7075, 7076, 7077, 7078, 7115, 7116, 7117, 7118, 7202, 7203, 7204, 7205, 7231, 7253, 7255, 7258, 7263, 7266, 7278, 7305, 7402, 7404, 7405, 7406, 7407, 7408, 7409, 7410, 7411, 7412, 7413, 7415, 7417, 7418, 7422, 7427, 7428, 7430, 7451, 7490, 7530, 7645, 7646, 7647, 7648, 7649, 7650, 7651, 7652, 7670, 7671, 7672, 7673, 7674, 7676, 7677, 7679, 8309, 1910, 8464, 2467, 8905, 9155, 9184, 9454, 9487, 9713, 9819, 9820, 9822, 9825, 9826, 9827, 9828, 9829, 9830, 9831, 9832, 9834, 9835, 9836, 9837, 9839, 9840, 9841, 9842, 9844, 9845, 9846, 9847, 9872, 9887, 9889, 9964, 9986, 9996, 10042, 10043, 10075, 10166, 10215, 10223, 10225, 10203, 10300, 10314, 10396, 10423, 10523, 10534, 10751, 10768, 10802, 10854, 10878, 10934, 10962, 10970, 10971, 10972, 10973, 10974, 10992, 10993, 10994, 11077, 11079, 11082, 11089, 11261, 11262, 11263, 11264, 11265, 11266, 11366, 11959, 11960, 11961, 11962, 11963, 11964, 11965, 11966, 11967, 11968, 12191, 12271, 12272, 12273, 12368, 12369, 12371, 12372, 12373, 12374, 12375, 12376, 12377, 12378, 12379, 12380, 12381, 12382, 12383, 12384, 12386, 12387, 12389, 12390, 12391, 12392, 12394, 12395, 12556, 12596, 12597, 12621, 12624, 12642, 12681, 12727, 12803, 12870, 12909, 12940, 12964, 12965, 12967, 12970, 12974, 12984, 12985, 12986, 12987, 12988, 12989, 12990, 12992, 13005, 13008, 13017, 13018, 13019, 13020, 13021, 13022, 13023, 13024, 13025, 13030, 13029, 13083, 13084, 13085, 13223, 13294, 13343, 13392, 13398, 13399, 13711, 14148, 14165, 14490, 14605, 14610, 14768, 14655, 14858, 14860, 14861, 14927, 14928, 14929, 14930, 14931, 14932, 14934, 14970, 14989, 14990, 14991, 14992, 14993, 15013, 15014, 15016, 15153, 15161, 15200, 15206, 15207, 15213, 15214, 15215, 15216, 15217, 15218, 15222, 15225, 15227, 15228, 15230, 15231, 15233, 15234, 15246, 15250, 15271, 15327, 15351, 15353, 15355, 15356, 15129, 15406, 15451, 15457, 15458, 15459, 15460, 15461, 15462, 15463, 15464, 15466, 15467, 15468, 15469, 15471, 15472, 15475, 15476, 15303, 15492, 15516, 15523, 15541, 15542, 15545, 15629, 15728, 15813, 15825, 15838, 15996, 15997, 15998, 15999, 6, 24, 29, 50, 51, 88, 137, 491, 699, 700, 701, 702, 703, 704, 705, 706, 707, 1030, 1031, 1032, 1033, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1332, 1532, 1533, 1534, 1535, 1558, 1570, 1571, 1796, 1797, 1798, 1805, 1806, 1807, 1808, 2098, 2099, 2100, 2101, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2603, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3311, 3337, 3639, 3868, 3869, 3870, 3871, 3985, 3987, 3989, 4048, 4226, 4280, 4303, 4308, 4017, 4677, 4720, 5201, 5164, 5936, 5937, 5938, 5939, 5940, 6317, 6744, 7231, 6835, 7402, 7431, 7451, 7490, 7529, 7645, 7653, 7654, 7656, 7657, 7658, 8218, 8234, 8309, 1910, 2467, 9155, 9713, 10044, 10045, 10046, 10166, 10225, 10314, 10396, 10523, 10534, 10546, 10547, 10549, 10550, 10551, 10803, 10852, 10878, 10933, 11089, 11260, 12274, 12276, 12278, 12279, 12280, 12281, 12282, 12556, 12597, 12692, 12864, 12908, 12940, 12964, 12969, 12983, 12984, 12277, 13086, 13087, 13199, 13293, 13343, 14260, 14760, 14763, 14768, 14862, 14934, 15019, 15141, 15229, 15234, 15245, 15251, 15356, 15383, 15388, 15401, 15402, 15403, 15406, 15466, 15471, 15473, 15476, 15523, 15630, 15636, 15638, 15813, 15838, 15915) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '04'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '04')))) ORDER BY `Event`.`debut` ASC LIMIT 100	1	1	2
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` = (14605)	1	1	0
11	SELECT `Sport`.`name` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '34'	1	1	0
12	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 (3179, 3216, 3217, 3218, 3219, 3220, 3221, 3867, 3891, 3892, 3893, 3894, 3895, 4276, 4581, 4582, 5935, 5941, 6834, 7645, 7669, 2467, 9487, 11078, 11089, 12396, 12397, 12398, 12399, 12402, 12403, 12991, 15018, 7, 12, 17, 23, 28, 34, 39, 41, 43, 45, 49, 55, 65, 68, 73, 77, 84, 87, 89, 91, 136, 145, 352, 368, 380, 396, 416, 418, 431, 433, 437, 438, 439, 442, 445, 449, 495, 708, 709, 710, 711, 712, 713, 714, 715, 716, 718, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1523, 1524, 1525, 1526, 1527, 1528, 1529, 1530, 1531, 1572, 1573, 1574, 1575, 1576, 1784, 1785, 1786, 1787, 1788, 1789, 1791, 1792, 1793, 1794, 1795, 1858, 1859, 1862, 1863, 1864, 1865, 1896, 1897, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2191, 2192, 2193, 2201, 2203, 2204, 2202, 2603, 2613, 2995, 3203, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3311, 3337, 3460, 3462, 3507, 3512, 3627, 3639, 3483, 3774, 3776, 3802, 3819, 3866, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3890, 3984, 3985, 4182, 4188, 4278, 4280, 4281, 4282, 4288, 4293, 4308, 4017, 4560, 4578, 4579, 4580, 4607, 4687, 4712, 4713, 4715, 4831, 4924, 5081, 5130, 5152, 5165, 5201, 5215, 5229, 5245, 5246, 5260, 5639, 5930, 5931, 5932, 5933, 5934, 6188, 6422, 6472, 6533, 6618, 6659, 6744, 6798, 6799, 6800, 6801, 6802, 6836, 7000, 7012, 7013, 7016, 7018, 7023, 7025, 7068, 7075, 7076, 7077, 7078, 7115, 7116, 7117, 7118, 7202, 7203, 7204, 7205, 7231, 7253, 7255, 7258, 7263, 7266, 7278, 7305, 7402, 7404, 7405, 7406, 7407, 7408, 7409, 7410, 7411, 7412, 7413, 7415, 7417, 7418, 7422, 7427, 7428, 7430, 7451, 7490, 7530, 7645, 7646, 7647, 7648, 7649, 7650, 7651, 7652, 7670, 7671, 7672, 7673, 7674, 7676, 7677, 7679, 8309, 1910, 8464, 2467, 8905, 9155, 9184, 9454, 9487, 9713, 9819, 9820, 9822, 9825, 9826, 9827, 9828, 9829, 9830, 9831, 9832, 9834, 9835, 9836, 9837, 9839, 9840, 9841, 9842, 9844, 9845, 9846, 9847, 9872, 9887, 9889, 9964, 9986, 9996, 10042, 10043, 10075, 10166, 10215, 10223, 10225, 10203, 10300, 10314, 10396, 10423, 10523, 10534, 10751, 10768, 10802, 10854, 10878, 10934, 10962, 10970, 10971, 10972, 10973, 10974, 10992, 10993, 10994, 11077, 11079, 11082, 11089, 11261, 11262, 11263, 11264, 11265, 11266, 11366, 11959, 11960, 11961, 11962, 11963, 11964, 11965, 11966, 11967, 11968, 12191, 12271, 12272, 12273, 12368, 12369, 12371, 12372, 12373, 12374, 12375, 12376, 12377, 12378, 12379, 12380, 12381, 12382, 12383, 12384, 12386, 12387, 12389, 12390, 12391, 12392, 12394, 12395, 12556, 12596, 12597, 12621, 12624, 12642, 12681, 12727, 12803, 12870, 12909, 12940, 12964, 12965, 12967, 12970, 12974, 12984, 12985, 12986, 12987, 12988, 12989, 12990, 12992, 13005, 13008, 13017, 13018, 13019, 13020, 13021, 13022, 13023, 13024, 13025, 13030, 13029, 13083, 13084, 13085, 13223, 13294, 13343, 13392, 13398, 13399, 13711, 14148, 14165, 14490, 14605, 14610, 14768, 14655, 14858, 14860, 14861, 14927, 14928, 14929, 14930, 14931, 14932, 14934, 14970, 14989, 14990, 14991, 14992, 14993, 15013, 15014, 15016, 15153, 15161, 15200, 15206, 15207, 15213, 15214, 15215, 15216, 15217, 15218, 15222, 15225, 15227, 15228, 15230, 15231, 15233, 15234, 15246, 15250, 15271, 15327, 15351, 15353, 15355, 15356, 15129, 15406, 15451, 15457, 15458, 15459, 15460, 15461, 15462, 15463, 15464, 15466, 15467, 15468, 15469, 15471, 15472, 15475, 15476, 15303, 15492, 15516, 15523, 15541, 15542, 15545, 15629, 15728, 15813, 15825, 15838, 15996, 15997, 15998, 15999, 6, 24, 29, 50, 51, 88, 137, 491, 699, 700, 701, 702, 703, 704, 705, 706, 707, 1030, 1031, 1032, 1033, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1332, 1532, 1533, 1534, 1535, 1558, 1570, 1571, 1796, 1797, 1798, 1805, 1806, 1807, 1808, 2098, 2099, 2100, 2101, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2603, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3311, 3337, 3639, 3868, 3869, 3870, 3871, 3985, 3987, 3989, 4048, 4226, 4280, 4303, 4308, 4017, 4677, 4720, 5201, 5164, 5936, 5937, 5938, 5939, 5940, 6317, 6744, 7231, 6835, 7402, 7431, 7451, 7490, 7529, 7645, 7653, 7654, 7656, 7657, 7658, 8218, 8234, 8309, 1910, 2467, 9155, 9713, 10044, 10045, 10046, 10166, 10225, 10314, 10396, 10523, 10534, 10546, 10547, 10549, 10550, 10551, 10803, 10852, 10878, 10933, 11089, 11260, 12274, 12276, 12278, 12279, 12280, 12281, 12282, 12556, 12597, 12692, 12864, 12908, 12940, 12964, 12969, 12983, 12984, 12277, 13086, 13087, 13199, 13293, 13343, 14260, 14760, 14763, 14768, 14862, 14934, 15019, 15141, 15229, 15234, 15245, 15251, 15356, 15383, 15388, 15401, 15402, 15403, 15406, 15466, 15471, 15473, 15476, 15523, 15630, 15636, 15638, 15813, 15838, 15915) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '05'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '05')))) ORDER BY `Event`.`debut` ASC LIMIT 100	0	0	2
13	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 (3179, 3216, 3217, 3218, 3219, 3220, 3221, 3867, 3891, 3892, 3893, 3894, 3895, 4276, 4581, 4582, 5935, 5941, 6834, 7645, 7669, 2467, 9487, 11078, 11089, 12396, 12397, 12398, 12399, 12402, 12403, 12991, 15018, 7, 12, 17, 23, 28, 34, 39, 41, 43, 45, 49, 55, 65, 68, 73, 77, 84, 87, 89, 91, 136, 145, 352, 368, 380, 396, 416, 418, 431, 433, 437, 438, 439, 442, 445, 449, 495, 708, 709, 710, 711, 712, 713, 714, 715, 716, 718, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1523, 1524, 1525, 1526, 1527, 1528, 1529, 1530, 1531, 1572, 1573, 1574, 1575, 1576, 1784, 1785, 1786, 1787, 1788, 1789, 1791, 1792, 1793, 1794, 1795, 1858, 1859, 1862, 1863, 1864, 1865, 1896, 1897, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2191, 2192, 2193, 2201, 2203, 2204, 2202, 2603, 2613, 2995, 3203, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3311, 3337, 3460, 3462, 3507, 3512, 3627, 3639, 3483, 3774, 3776, 3802, 3819, 3866, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3890, 3984, 3985, 4182, 4188, 4278, 4280, 4281, 4282, 4288, 4293, 4308, 4017, 4560, 4578, 4579, 4580, 4607, 4687, 4712, 4713, 4715, 4831, 4924, 5081, 5130, 5152, 5165, 5201, 5215, 5229, 5245, 5246, 5260, 5639, 5930, 5931, 5932, 5933, 5934, 6188, 6422, 6472, 6533, 6618, 6659, 6744, 6798, 6799, 6800, 6801, 6802, 6836, 7000, 7012, 7013, 7016, 7018, 7023, 7025, 7068, 7075, 7076, 7077, 7078, 7115, 7116, 7117, 7118, 7202, 7203, 7204, 7205, 7231, 7253, 7255, 7258, 7263, 7266, 7278, 7305, 7402, 7404, 7405, 7406, 7407, 7408, 7409, 7410, 7411, 7412, 7413, 7415, 7417, 7418, 7422, 7427, 7428, 7430, 7451, 7490, 7530, 7645, 7646, 7647, 7648, 7649, 7650, 7651, 7652, 7670, 7671, 7672, 7673, 7674, 7676, 7677, 7679, 8309, 1910, 8464, 2467, 8905, 9155, 9184, 9454, 9487, 9713, 9819, 9820, 9822, 9825, 9826, 9827, 9828, 9829, 9830, 9831, 9832, 9834, 9835, 9836, 9837, 9839, 9840, 9841, 9842, 9844, 9845, 9846, 9847, 9872, 9887, 9889, 9964, 9986, 9996, 10042, 10043, 10075, 10166, 10215, 10223, 10225, 10203, 10300, 10314, 10396, 10423, 10523, 10534, 10751, 10768, 10802, 10854, 10878, 10934, 10962, 10970, 10971, 10972, 10973, 10974, 10992, 10993, 10994, 11077, 11079, 11082, 11089, 11261, 11262, 11263, 11264, 11265, 11266, 11366, 11959, 11960, 11961, 11962, 11963, 11964, 11965, 11966, 11967, 11968, 12191, 12271, 12272, 12273, 12368, 12369, 12371, 12372, 12373, 12374, 12375, 12376, 12377, 12378, 12379, 12380, 12381, 12382, 12383, 12384, 12386, 12387, 12389, 12390, 12391, 12392, 12394, 12395, 12556, 12596, 12597, 12621, 12624, 12642, 12681, 12727, 12803, 12870, 12909, 12940, 12964, 12965, 12967, 12970, 12974, 12984, 12985, 12986, 12987, 12988, 12989, 12990, 12992, 13005, 13008, 13017, 13018, 13019, 13020, 13021, 13022, 13023, 13024, 13025, 13030, 13029, 13083, 13084, 13085, 13223, 13294, 13343, 13392, 13398, 13399, 13711, 14148, 14165, 14490, 14605, 14610, 14768, 14655, 14858, 14860, 14861, 14927, 14928, 14929, 14930, 14931, 14932, 14934, 14970, 14989, 14990, 14991, 14992, 14993, 15013, 15014, 15016, 15153, 15161, 15200, 15206, 15207, 15213, 15214, 15215, 15216, 15217, 15218, 15222, 15225, 15227, 15228, 15230, 15231, 15233, 15234, 15246, 15250, 15271, 15327, 15351, 15353, 15355, 15356, 15129, 15406, 15451, 15457, 15458, 15459, 15460, 15461, 15462, 15463, 15464, 15466, 15467, 15468, 15469, 15471, 15472, 15475, 15476, 15303, 15492, 15516, 15523, 15541, 15542, 15545, 15629, 15728, 15813, 15825, 15838, 15996, 15997, 15998, 15999, 6, 24, 29, 50, 51, 88, 137, 491, 699, 700, 701, 702, 703, 704, 705, 706, 707, 1030, 1031, 1032, 1033, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1332, 1532, 1533, 1534, 1535, 1558, 1570, 1571, 1796, 1797, 1798, 1805, 1806, 1807, 1808, 2098, 2099, 2100, 2101, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2603, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3311, 3337, 3639, 3868, 3869, 3870, 3871, 3985, 3987, 3989, 4048, 4226, 4280, 4303, 4308, 4017, 4677, 4720, 5201, 5164, 5936, 5937, 5938, 5939, 5940, 6317, 6744, 7231, 6835, 7402, 7431, 7451, 7490, 7529, 7645, 7653, 7654, 7656, 7657, 7658, 8218, 8234, 8309, 1910, 2467, 9155, 9713, 10044, 10045, 10046, 10166, 10225, 10314, 10396, 10523, 10534, 10546, 10547, 10549, 10550, 10551, 10803, 10852, 10878, 10933, 11089, 11260, 12274, 12276, 12278, 12279, 12280, 12281, 12282, 12556, 12597, 12692, 12864, 12908, 12940, 12964, 12969, 12983, 12984, 12277, 13086, 13087, 13199, 13293, 13343, 14260, 14760, 14763, 14768, 14862, 14934, 15019, 15141, 15229, 15234, 15245, 15251, 15356, 15383, 15388, 15401, 15402, 15403, 15406, 15466, 15471, 15473, 15476, 15523, 15630, 15636, 15638, 15813, 15838, 15915) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '06'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '06')))) ORDER BY `Event`.`debut` ASC LIMIT 100	0	0	13
14	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 (3179, 3216, 3217, 3218, 3219, 3220, 3221, 3867, 3891, 3892, 3893, 3894, 3895, 4276, 4581, 4582, 5935, 5941, 6834, 7645, 7669, 2467, 9487, 11078, 11089, 12396, 12397, 12398, 12399, 12402, 12403, 12991, 15018, 7, 12, 17, 23, 28, 34, 39, 41, 43, 45, 49, 55, 65, 68, 73, 77, 84, 87, 89, 91, 136, 145, 352, 368, 380, 396, 416, 418, 431, 433, 437, 438, 439, 442, 445, 449, 495, 708, 709, 710, 711, 712, 713, 714, 715, 716, 718, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1523, 1524, 1525, 1526, 1527, 1528, 1529, 1530, 1531, 1572, 1573, 1574, 1575, 1576, 1784, 1785, 1786, 1787, 1788, 1789, 1791, 1792, 1793, 1794, 1795, 1858, 1859, 1862, 1863, 1864, 1865, 1896, 1897, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2191, 2192, 2193, 2201, 2203, 2204, 2202, 2603, 2613, 2995, 3203, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3311, 3337, 3460, 3462, 3507, 3512, 3627, 3639, 3483, 3774, 3776, 3802, 3819, 3866, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3890, 3984, 3985, 4182, 4188, 4278, 4280, 4281, 4282, 4288, 4293, 4308, 4017, 4560, 4578, 4579, 4580, 4607, 4687, 4712, 4713, 4715, 4831, 4924, 5081, 5130, 5152, 5165, 5201, 5215, 5229, 5245, 5246, 5260, 5639, 5930, 5931, 5932, 5933, 5934, 6188, 6422, 6472, 6533, 6618, 6659, 6744, 6798, 6799, 6800, 6801, 6802, 6836, 7000, 7012, 7013, 7016, 7018, 7023, 7025, 7068, 7075, 7076, 7077, 7078, 7115, 7116, 7117, 7118, 7202, 7203, 7204, 7205, 7231, 7253, 7255, 7258, 7263, 7266, 7278, 7305, 7402, 7404, 7405, 7406, 7407, 7408, 7409, 7410, 7411, 7412, 7413, 7415, 7417, 7418, 7422, 7427, 7428, 7430, 7451, 7490, 7530, 7645, 7646, 7647, 7648, 7649, 7650, 7651, 7652, 7670, 7671, 7672, 7673, 7674, 7676, 7677, 7679, 8309, 1910, 8464, 2467, 8905, 9155, 9184, 9454, 9487, 9713, 9819, 9820, 9822, 9825, 9826, 9827, 9828, 9829, 9830, 9831, 9832, 9834, 9835, 9836, 9837, 9839, 9840, 9841, 9842, 9844, 9845, 9846, 9847, 9872, 9887, 9889, 9964, 9986, 9996, 10042, 10043, 10075, 10166, 10215, 10223, 10225, 10203, 10300, 10314, 10396, 10423, 10523, 10534, 10751, 10768, 10802, 10854, 10878, 10934, 10962, 10970, 10971, 10972, 10973, 10974, 10992, 10993, 10994, 11077, 11079, 11082, 11089, 11261, 11262, 11263, 11264, 11265, 11266, 11366, 11959, 11960, 11961, 11962, 11963, 11964, 11965, 11966, 11967, 11968, 12191, 12271, 12272, 12273, 12368, 12369, 12371, 12372, 12373, 12374, 12375, 12376, 12377, 12378, 12379, 12380, 12381, 12382, 12383, 12384, 12386, 12387, 12389, 12390, 12391, 12392, 12394, 12395, 12556, 12596, 12597, 12621, 12624, 12642, 12681, 12727, 12803, 12870, 12909, 12940, 12964, 12965, 12967, 12970, 12974, 12984, 12985, 12986, 12987, 12988, 12989, 12990, 12992, 13005, 13008, 13017, 13018, 13019, 13020, 13021, 13022, 13023, 13024, 13025, 13030, 13029, 13083, 13084, 13085, 13223, 13294, 13343, 13392, 13398, 13399, 13711, 14148, 14165, 14490, 14605, 14610, 14768, 14655, 14858, 14860, 14861, 14927, 14928, 14929, 14930, 14931, 14932, 14934, 14970, 14989, 14990, 14991, 14992, 14993, 15013, 15014, 15016, 15153, 15161, 15200, 15206, 15207, 15213, 15214, 15215, 15216, 15217, 15218, 15222, 15225, 15227, 15228, 15230, 15231, 15233, 15234, 15246, 15250, 15271, 15327, 15351, 15353, 15355, 15356, 15129, 15406, 15451, 15457, 15458, 15459, 15460, 15461, 15462, 15463, 15464, 15466, 15467, 15468, 15469, 15471, 15472, 15475, 15476, 15303, 15492, 15516, 15523, 15541, 15542, 15545, 15629, 15728, 15813, 15825, 15838, 15996, 15997, 15998, 15999, 6, 24, 29, 50, 51, 88, 137, 491, 699, 700, 701, 702, 703, 704, 705, 706, 707, 1030, 1031, 1032, 1033, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1332, 1532, 1533, 1534, 1535, 1558, 1570, 1571, 1796, 1797, 1798, 1805, 1806, 1807, 1808, 2098, 2099, 2100, 2101, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2603, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3311, 3337, 3639, 3868, 3869, 3870, 3871, 3985, 3987, 3989, 4048, 4226, 4280, 4303, 4308, 4017, 4677, 4720, 5201, 5164, 5936, 5937, 5938, 5939, 5940, 6317, 6744, 7231, 6835, 7402, 7431, 7451, 7490, 7529, 7645, 7653, 7654, 7656, 7657, 7658, 8218, 8234, 8309, 1910, 2467, 9155, 9713, 10044, 10045, 10046, 10166, 10225, 10314, 10396, 10523, 10534, 10546, 10547, 10549, 10550, 10551, 10803, 10852, 10878, 10933, 11089, 11260, 12274, 12276, 12278, 12279, 12280, 12281, 12282, 12556, 12597, 12692, 12864, 12908, 12940, 12964, 12969, 12983, 12984, 12277, 13086, 13087, 13199, 13293, 13343, 14260, 14760, 14763, 14768, 14862, 14934, 15019, 15141, 15229, 15234, 15245, 15251, 15356, 15383, 15388, 15401, 15402, 15403, 15406, 15466, 15471, 15473, 15476, 15523, 15630, 15636, 15638, 15813, 15838, 15915) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '07'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '07')))) ORDER BY `Event`.`debut` ASC LIMIT 100	0	0	6
15	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 (3179, 3216, 3217, 3218, 3219, 3220, 3221, 3867, 3891, 3892, 3893, 3894, 3895, 4276, 4581, 4582, 5935, 5941, 6834, 7645, 7669, 2467, 9487, 11078, 11089, 12396, 12397, 12398, 12399, 12402, 12403, 12991, 15018, 7, 12, 17, 23, 28, 34, 39, 41, 43, 45, 49, 55, 65, 68, 73, 77, 84, 87, 89, 91, 136, 145, 352, 368, 380, 396, 416, 418, 431, 433, 437, 438, 439, 442, 445, 449, 495, 708, 709, 710, 711, 712, 713, 714, 715, 716, 718, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1523, 1524, 1525, 1526, 1527, 1528, 1529, 1530, 1531, 1572, 1573, 1574, 1575, 1576, 1784, 1785, 1786, 1787, 1788, 1789, 1791, 1792, 1793, 1794, 1795, 1858, 1859, 1862, 1863, 1864, 1865, 1896, 1897, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2191, 2192, 2193, 2201, 2203, 2204, 2202, 2603, 2613, 2995, 3203, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3311, 3337, 3460, 3462, 3507, 3512, 3627, 3639, 3483, 3774, 3776, 3802, 3819, 3866, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3890, 3984, 3985, 4182, 4188, 4278, 4280, 4281, 4282, 4288, 4293, 4308, 4017, 4560, 4578, 4579, 4580, 4607, 4687, 4712, 4713, 4715, 4831, 4924, 5081, 5130, 5152, 5165, 5201, 5215, 5229, 5245, 5246, 5260, 5639, 5930, 5931, 5932, 5933, 5934, 6188, 6422, 6472, 6533, 6618, 6659, 6744, 6798, 6799, 6800, 6801, 6802, 6836, 7000, 7012, 7013, 7016, 7018, 7023, 7025, 7068, 7075, 7076, 7077, 7078, 7115, 7116, 7117, 7118, 7202, 7203, 7204, 7205, 7231, 7253, 7255, 7258, 7263, 7266, 7278, 7305, 7402, 7404, 7405, 7406, 7407, 7408, 7409, 7410, 7411, 7412, 7413, 7415, 7417, 7418, 7422, 7427, 7428, 7430, 7451, 7490, 7530, 7645, 7646, 7647, 7648, 7649, 7650, 7651, 7652, 7670, 7671, 7672, 7673, 7674, 7676, 7677, 7679, 8309, 1910, 8464, 2467, 8905, 9155, 9184, 9454, 9487, 9713, 9819, 9820, 9822, 9825, 9826, 9827, 9828, 9829, 9830, 9831, 9832, 9834, 9835, 9836, 9837, 9839, 9840, 9841, 9842, 9844, 9845, 9846, 9847, 9872, 9887, 9889, 9964, 9986, 9996, 10042, 10043, 10075, 10166, 10215, 10223, 10225, 10203, 10300, 10314, 10396, 10423, 10523, 10534, 10751, 10768, 10802, 10854, 10878, 10934, 10962, 10970, 10971, 10972, 10973, 10974, 10992, 10993, 10994, 11077, 11079, 11082, 11089, 11261, 11262, 11263, 11264, 11265, 11266, 11366, 11959, 11960, 11961, 11962, 11963, 11964, 11965, 11966, 11967, 11968, 12191, 12271, 12272, 12273, 12368, 12369, 12371, 12372, 12373, 12374, 12375, 12376, 12377, 12378, 12379, 12380, 12381, 12382, 12383, 12384, 12386, 12387, 12389, 12390, 12391, 12392, 12394, 12395, 12556, 12596, 12597, 12621, 12624, 12642, 12681, 12727, 12803, 12870, 12909, 12940, 12964, 12965, 12967, 12970, 12974, 12984, 12985, 12986, 12987, 12988, 12989, 12990, 12992, 13005, 13008, 13017, 13018, 13019, 13020, 13021, 13022, 13023, 13024, 13025, 13030, 13029, 13083, 13084, 13085, 13223, 13294, 13343, 13392, 13398, 13399, 13711, 14148, 14165, 14490, 14605, 14610, 14768, 14655, 14858, 14860, 14861, 14927, 14928, 14929, 14930, 14931, 14932, 14934, 14970, 14989, 14990, 14991, 14992, 14993, 15013, 15014, 15016, 15153, 15161, 15200, 15206, 15207, 15213, 15214, 15215, 15216, 15217, 15218, 15222, 15225, 15227, 15228, 15230, 15231, 15233, 15234, 15246, 15250, 15271, 15327, 15351, 15353, 15355, 15356, 15129, 15406, 15451, 15457, 15458, 15459, 15460, 15461, 15462, 15463, 15464, 15466, 15467, 15468, 15469, 15471, 15472, 15475, 15476, 15303, 15492, 15516, 15523, 15541, 15542, 15545, 15629, 15728, 15813, 15825, 15838, 15996, 15997, 15998, 15999, 6, 24, 29, 50, 51, 88, 137, 491, 699, 700, 701, 702, 703, 704, 705, 706, 707, 1030, 1031, 1032, 1033, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1332, 1532, 1533, 1534, 1535, 1558, 1570, 1571, 1796, 1797, 1798, 1805, 1806, 1807, 1808, 2098, 2099, 2100, 2101, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2603, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3311, 3337, 3639, 3868, 3869, 3870, 3871, 3985, 3987, 3989, 4048, 4226, 4280, 4303, 4308, 4017, 4677, 4720, 5201, 5164, 5936, 5937, 5938, 5939, 5940, 6317, 6744, 7231, 6835, 7402, 7431, 7451, 7490, 7529, 7645, 7653, 7654, 7656, 7657, 7658, 8218, 8234, 8309, 1910, 2467, 9155, 9713, 10044, 10045, 10046, 10166, 10225, 10314, 10396, 10523, 10534, 10546, 10547, 10549, 10550, 10551, 10803, 10852, 10878, 10933, 11089, 11260, 12274, 12276, 12278, 12279, 12280, 12281, 12282, 12556, 12597, 12692, 12864, 12908, 12940, 12964, 12969, 12983, 12984, 12277, 13086, 13087, 13199, 13293, 13343, 14260, 14760, 14763, 14768, 14862, 14934, 15019, 15141, 15229, 15234, 15245, 15251, 15356, 15383, 15388, 15401, 15402, 15403, 15406, 15466, 15471, 15473, 15476, 15523, 15630, 15636, 15638, 15813, 15838, 15915) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '08'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '08')))) ORDER BY `Event`.`debut` ASC LIMIT 100	0	0	2
16	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 (3179, 3216, 3217, 3218, 3219, 3220, 3221, 3867, 3891, 3892, 3893, 3894, 3895, 4276, 4581, 4582, 5935, 5941, 6834, 7645, 7669, 2467, 9487, 11078, 11089, 12396, 12397, 12398, 12399, 12402, 12403, 12991, 15018, 7, 12, 17, 23, 28, 34, 39, 41, 43, 45, 49, 55, 65, 68, 73, 77, 84, 87, 89, 91, 136, 145, 352, 368, 380, 396, 416, 418, 431, 433, 437, 438, 439, 442, 445, 449, 495, 708, 709, 710, 711, 712, 713, 714, 715, 716, 718, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1523, 1524, 1525, 1526, 1527, 1528, 1529, 1530, 1531, 1572, 1573, 1574, 1575, 1576, 1784, 1785, 1786, 1787, 1788, 1789, 1791, 1792, 1793, 1794, 1795, 1858, 1859, 1862, 1863, 1864, 1865, 1896, 1897, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2191, 2192, 2193, 2201, 2203, 2204, 2202, 2603, 2613, 2995, 3203, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3311, 3337, 3460, 3462, 3507, 3512, 3627, 3639, 3483, 3774, 3776, 3802, 3819, 3866, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3890, 3984, 3985, 4182, 4188, 4278, 4280, 4281, 4282, 4288, 4293, 4308, 4017, 4560, 4578, 4579, 4580, 4607, 4687, 4712, 4713, 4715, 4831, 4924, 5081, 5130, 5152, 5165, 5201, 5215, 5229, 5245, 5246, 5260, 5639, 5930, 5931, 5932, 5933, 5934, 6188, 6422, 6472, 6533, 6618, 6659, 6744, 6798, 6799, 6800, 6801, 6802, 6836, 7000, 7012, 7013, 7016, 7018, 7023, 7025, 7068, 7075, 7076, 7077, 7078, 7115, 7116, 7117, 7118, 7202, 7203, 7204, 7205, 7231, 7253, 7255, 7258, 7263, 7266, 7278, 7305, 7402, 7404, 7405, 7406, 7407, 7408, 7409, 7410, 7411, 7412, 7413, 7415, 7417, 7418, 7422, 7427, 7428, 7430, 7451, 7490, 7530, 7645, 7646, 7647, 7648, 7649, 7650, 7651, 7652, 7670, 7671, 7672, 7673, 7674, 7676, 7677, 7679, 8309, 1910, 8464, 2467, 8905, 9155, 9184, 9454, 9487, 9713, 9819, 9820, 9822, 9825, 9826, 9827, 9828, 9829, 9830, 9831, 9832, 9834, 9835, 9836, 9837, 9839, 9840, 9841, 9842, 9844, 9845, 9846, 9847, 9872, 9887, 9889, 9964, 9986, 9996, 10042, 10043, 10075, 10166, 10215, 10223, 10225, 10203, 10300, 10314, 10396, 10423, 10523, 10534, 10751, 10768, 10802, 10854, 10878, 10934, 10962, 10970, 10971, 10972, 10973, 10974, 10992, 10993, 10994, 11077, 11079, 11082, 11089, 11261, 11262, 11263, 11264, 11265, 11266, 11366, 11959, 11960, 11961, 11962, 11963, 11964, 11965, 11966, 11967, 11968, 12191, 12271, 12272, 12273, 12368, 12369, 12371, 12372, 12373, 12374, 12375, 12376, 12377, 12378, 12379, 12380, 12381, 12382, 12383, 12384, 12386, 12387, 12389, 12390, 12391, 12392, 12394, 12395, 12556, 12596, 12597, 12621, 12624, 12642, 12681, 12727, 12803, 12870, 12909, 12940, 12964, 12965, 12967, 12970, 12974, 12984, 12985, 12986, 12987, 12988, 12989, 12990, 12992, 13005, 13008, 13017, 13018, 13019, 13020, 13021, 13022, 13023, 13024, 13025, 13030, 13029, 13083, 13084, 13085, 13223, 13294, 13343, 13392, 13398, 13399, 13711, 14148, 14165, 14490, 14605, 14610, 14768, 14655, 14858, 14860, 14861, 14927, 14928, 14929, 14930, 14931, 14932, 14934, 14970, 14989, 14990, 14991, 14992, 14993, 15013, 15014, 15016, 15153, 15161, 15200, 15206, 15207, 15213, 15214, 15215, 15216, 15217, 15218, 15222, 15225, 15227, 15228, 15230, 15231, 15233, 15234, 15246, 15250, 15271, 15327, 15351, 15353, 15355, 15356, 15129, 15406, 15451, 15457, 15458, 15459, 15460, 15461, 15462, 15463, 15464, 15466, 15467, 15468, 15469, 15471, 15472, 15475, 15476, 15303, 15492, 15516, 15523, 15541, 15542, 15545, 15629, 15728, 15813, 15825, 15838, 15996, 15997, 15998, 15999, 6, 24, 29, 50, 51, 88, 137, 491, 699, 700, 701, 702, 703, 704, 705, 706, 707, 1030, 1031, 1032, 1033, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1332, 1532, 1533, 1534, 1535, 1558, 1570, 1571, 1796, 1797, 1798, 1805, 1806, 1807, 1808, 2098, 2099, 2100, 2101, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2603, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3311, 3337, 3639, 3868, 3869, 3870, 3871, 3985, 3987, 3989, 4048, 4226, 4280, 4303, 4308, 4017, 4677, 4720, 5201, 5164, 5936, 5937, 5938, 5939, 5940, 6317, 6744, 7231, 6835, 7402, 7431, 7451, 7490, 7529, 7645, 7653, 7654, 7656, 7657, 7658, 8218, 8234, 8309, 1910, 2467, 9155, 9713, 10044, 10045, 10046, 10166, 10225, 10314, 10396, 10523, 10534, 10546, 10547, 10549, 10550, 10551, 10803, 10852, 10878, 10933, 11089, 11260, 12274, 12276, 12278, 12279, 12280, 12281, 12282, 12556, 12597, 12692, 12864, 12908, 12940, 12964, 12969, 12983, 12984, 12277, 13086, 13087, 13199, 13293, 13343, 14260, 14760, 14763, 14768, 14862, 14934, 15019, 15141, 15229, 15234, 15245, 15251, 15356, 15383, 15388, 15401, 15402, 15403, 15406, 15466, 15471, 15473, 15476, 15523, 15630, 15636, 15638, 15813, 15838, 15915) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '09'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '09')))) ORDER BY `Event`.`debut` ASC LIMIT 100	0	0	2
17	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 (3179, 3216, 3217, 3218, 3219, 3220, 3221, 3867, 3891, 3892, 3893, 3894, 3895, 4276, 4581, 4582, 5935, 5941, 6834, 7645, 7669, 2467, 9487, 11078, 11089, 12396, 12397, 12398, 12399, 12402, 12403, 12991, 15018, 7, 12, 17, 23, 28, 34, 39, 41, 43, 45, 49, 55, 65, 68, 73, 77, 84, 87, 89, 91, 136, 145, 352, 368, 380, 396, 416, 418, 431, 433, 437, 438, 439, 442, 445, 449, 495, 708, 709, 710, 711, 712, 713, 714, 715, 716, 718, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1523, 1524, 1525, 1526, 1527, 1528, 1529, 1530, 1531, 1572, 1573, 1574, 1575, 1576, 1784, 1785, 1786, 1787, 1788, 1789, 1791, 1792, 1793, 1794, 1795, 1858, 1859, 1862, 1863, 1864, 1865, 1896, 1897, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2191, 2192, 2193, 2201, 2203, 2204, 2202, 2603, 2613, 2995, 3203, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3311, 3337, 3460, 3462, 3507, 3512, 3627, 3639, 3483, 3774, 3776, 3802, 3819, 3866, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3890, 3984, 3985, 4182, 4188, 4278, 4280, 4281, 4282, 4288, 4293, 4308, 4017, 4560, 4578, 4579, 4580, 4607, 4687, 4712, 4713, 4715, 4831, 4924, 5081, 5130, 5152, 5165, 5201, 5215, 5229, 5245, 5246, 5260, 5639, 5930, 5931, 5932, 5933, 5934, 6188, 6422, 6472, 6533, 6618, 6659, 6744, 6798, 6799, 6800, 6801, 6802, 6836, 7000, 7012, 7013, 7016, 7018, 7023, 7025, 7068, 7075, 7076, 7077, 7078, 7115, 7116, 7117, 7118, 7202, 7203, 7204, 7205, 7231, 7253, 7255, 7258, 7263, 7266, 7278, 7305, 7402, 7404, 7405, 7406, 7407, 7408, 7409, 7410, 7411, 7412, 7413, 7415, 7417, 7418, 7422, 7427, 7428, 7430, 7451, 7490, 7530, 7645, 7646, 7647, 7648, 7649, 7650, 7651, 7652, 7670, 7671, 7672, 7673, 7674, 7676, 7677, 7679, 8309, 1910, 8464, 2467, 8905, 9155, 9184, 9454, 9487, 9713, 9819, 9820, 9822, 9825, 9826, 9827, 9828, 9829, 9830, 9831, 9832, 9834, 9835, 9836, 9837, 9839, 9840, 9841, 9842, 9844, 9845, 9846, 9847, 9872, 9887, 9889, 9964, 9986, 9996, 10042, 10043, 10075, 10166, 10215, 10223, 10225, 10203, 10300, 10314, 10396, 10423, 10523, 10534, 10751, 10768, 10802, 10854, 10878, 10934, 10962, 10970, 10971, 10972, 10973, 10974, 10992, 10993, 10994, 11077, 11079, 11082, 11089, 11261, 11262, 11263, 11264, 11265, 11266, 11366, 11959, 11960, 11961, 11962, 11963, 11964, 11965, 11966, 11967, 11968, 12191, 12271, 12272, 12273, 12368, 12369, 12371, 12372, 12373, 12374, 12375, 12376, 12377, 12378, 12379, 12380, 12381, 12382, 12383, 12384, 12386, 12387, 12389, 12390, 12391, 12392, 12394, 12395, 12556, 12596, 12597, 12621, 12624, 12642, 12681, 12727, 12803, 12870, 12909, 12940, 12964, 12965, 12967, 12970, 12974, 12984, 12985, 12986, 12987, 12988, 12989, 12990, 12992, 13005, 13008, 13017, 13018, 13019, 13020, 13021, 13022, 13023, 13024, 13025, 13030, 13029, 13083, 13084, 13085, 13223, 13294, 13343, 13392, 13398, 13399, 13711, 14148, 14165, 14490, 14605, 14610, 14768, 14655, 14858, 14860, 14861, 14927, 14928, 14929, 14930, 14931, 14932, 14934, 14970, 14989, 14990, 14991, 14992, 14993, 15013, 15014, 15016, 15153, 15161, 15200, 15206, 15207, 15213, 15214, 15215, 15216, 15217, 15218, 15222, 15225, 15227, 15228, 15230, 15231, 15233, 15234, 15246, 15250, 15271, 15327, 15351, 15353, 15355, 15356, 15129, 15406, 15451, 15457, 15458, 15459, 15460, 15461, 15462, 15463, 15464, 15466, 15467, 15468, 15469, 15471, 15472, 15475, 15476, 15303, 15492, 15516, 15523, 15541, 15542, 15545, 15629, 15728, 15813, 15825, 15838, 15996, 15997, 15998, 15999, 6, 24, 29, 50, 51, 88, 137, 491, 699, 700, 701, 702, 703, 704, 705, 706, 707, 1030, 1031, 1032, 1033, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1332, 1532, 1533, 1534, 1535, 1558, 1570, 1571, 1796, 1797, 1798, 1805, 1806, 1807, 1808, 2098, 2099, 2100, 2101, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2603, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3311, 3337, 3639, 3868, 3869, 3870, 3871, 3985, 3987, 3989, 4048, 4226, 4280, 4303, 4308, 4017, 4677, 4720, 5201, 5164, 5936, 5937, 5938, 5939, 5940, 6317, 6744, 7231, 6835, 7402, 7431, 7451, 7490, 7529, 7645, 7653, 7654, 7656, 7657, 7658, 8218, 8234, 8309, 1910, 2467, 9155, 9713, 10044, 10045, 10046, 10166, 10225, 10314, 10396, 10523, 10534, 10546, 10547, 10549, 10550, 10551, 10803, 10852, 10878, 10933, 11089, 11260, 12274, 12276, 12278, 12279, 12280, 12281, 12282, 12556, 12597, 12692, 12864, 12908, 12940, 12964, 12969, 12983, 12984, 12277, 13086, 13087, 13199, 13293, 13343, 14260, 14760, 14763, 14768, 14862, 14934, 15019, 15141, 15229, 15234, 15245, 15251, 15356, 15383, 15388, 15401, 15402, 15403, 15406, 15466, 15471, 15473, 15476, 15523, 15630, 15636, 15638, 15813, 15838, 15915) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '10'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '10')))) ORDER BY `Event`.`debut` ASC LIMIT 100	0	0	2
18	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 (3179, 3216, 3217, 3218, 3219, 3220, 3221, 3867, 3891, 3892, 3893, 3894, 3895, 4276, 4581, 4582, 5935, 5941, 6834, 7645, 7669, 2467, 9487, 11078, 11089, 12396, 12397, 12398, 12399, 12402, 12403, 12991, 15018, 7, 12, 17, 23, 28, 34, 39, 41, 43, 45, 49, 55, 65, 68, 73, 77, 84, 87, 89, 91, 136, 145, 352, 368, 380, 396, 416, 418, 431, 433, 437, 438, 439, 442, 445, 449, 495, 708, 709, 710, 711, 712, 713, 714, 715, 716, 718, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1523, 1524, 1525, 1526, 1527, 1528, 1529, 1530, 1531, 1572, 1573, 1574, 1575, 1576, 1784, 1785, 1786, 1787, 1788, 1789, 1791, 1792, 1793, 1794, 1795, 1858, 1859, 1862, 1863, 1864, 1865, 1896, 1897, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2191, 2192, 2193, 2201, 2203, 2204, 2202, 2603, 2613, 2995, 3203, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3311, 3337, 3460, 3462, 3507, 3512, 3627, 3639, 3483, 3774, 3776, 3802, 3819, 3866, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3879, 3880, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3890, 3984, 3985, 4182, 4188, 4278, 4280, 4281, 4282, 4288, 4293, 4308, 4017, 4560, 4578, 4579, 4580, 4607, 4687, 4712, 4713, 4715, 4831, 4924, 5081, 5130, 5152, 5165, 5201, 5215, 5229, 5245, 5246, 5260, 5639, 5930, 5931, 5932, 5933, 5934, 6188, 6422, 6472, 6533, 6618, 6659, 6744, 6798, 6799, 6800, 6801, 6802, 6836, 7000, 7012, 7013, 7016, 7018, 7023, 7025, 7068, 7075, 7076, 7077, 7078, 7115, 7116, 7117, 7118, 7202, 7203, 7204, 7205, 7231, 7253, 7255, 7258, 7263, 7266, 7278, 7305, 7402, 7404, 7405, 7406, 7407, 7408, 7409, 7410, 7411, 7412, 7413, 7415, 7417, 7418, 7422, 7427, 7428, 7430, 7451, 7490, 7530, 7645, 7646, 7647, 7648, 7649, 7650, 7651, 7652, 7670, 7671, 7672, 7673, 7674, 7676, 7677, 7679, 8309, 1910, 8464, 2467, 8905, 9155, 9184, 9454, 9487, 9713, 9819, 9820, 9822, 9825, 9826, 9827, 9828, 9829, 9830, 9831, 9832, 9834, 9835, 9836, 9837, 9839, 9840, 9841, 9842, 9844, 9845, 9846, 9847, 9872, 9887, 9889, 9964, 9986, 9996, 10042, 10043, 10075, 10166, 10215, 10223, 10225, 10203, 10300, 10314, 10396, 10423, 10523, 10534, 10751, 10768, 10802, 10854, 10878, 10934, 10962, 10970, 10971, 10972, 10973, 10974, 10992, 10993, 10994, 11077, 11079, 11082, 11089, 11261, 11262, 11263, 11264, 11265, 11266, 11366, 11959, 11960, 11961, 11962, 11963, 11964, 11965, 11966, 11967, 11968, 12191, 12271, 12272, 12273, 12368, 12369, 12371, 12372, 12373, 12374, 12375, 12376, 12377, 12378, 12379, 12380, 12381, 12382, 12383, 12384, 12386, 12387, 12389, 12390, 12391, 12392, 12394, 12395, 12556, 12596, 12597, 12621, 12624, 12642, 12681, 12727, 12803, 12870, 12909, 12940, 12964, 12965, 12967, 12970, 12974, 12984, 12985, 12986, 12987, 12988, 12989, 12990, 12992, 13005, 13008, 13017, 13018, 13019, 13020, 13021, 13022, 13023, 13024, 13025, 13030, 13029, 13083, 13084, 13085, 13223, 13294, 13343, 13392, 13398, 13399, 13711, 14148, 14165, 14490, 14605, 14610, 14768, 14655, 14858, 14860, 14861, 14927, 14928, 14929, 14930, 14931, 14932, 14934, 14970, 14989, 14990, 14991, 14992, 14993, 15013, 15014, 15016, 15153, 15161, 15200, 15206, 15207, 15213, 15214, 15215, 15216, 15217, 15218, 15222, 15225, 15227, 15228, 15230, 15231, 15233, 15234, 15246, 15250, 15271, 15327, 15351, 15353, 15355, 15356, 15129, 15406, 15451, 15457, 15458, 15459, 15460, 15461, 15462, 15463, 15464, 15466, 15467, 15468, 15469, 15471, 15472, 15475, 15476, 15303, 15492, 15516, 15523, 15541, 15542, 15545, 15629, 15728, 15813, 15825, 15838, 15996, 15997, 15998, 15999, 6, 24, 29, 50, 51, 88, 137, 491, 699, 700, 701, 702, 703, 704, 705, 706, 707, 1030, 1031, 1032, 1033, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1332, 1532, 1533, 1534, 1535, 1558, 1570, 1571, 1796, 1797, 1798, 1805, 1806, 1807, 1808, 2098, 2099, 2100, 2101, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2603, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3311, 3337, 3639, 3868, 3869, 3870, 3871, 3985, 3987, 3989, 4048, 4226, 4280, 4303, 4308, 4017, 4677, 4720, 5201, 5164, 5936, 5937, 5938, 5939, 5940, 6317, 6744, 7231, 6835, 7402, 7431, 7451, 7490, 7529, 7645, 7653, 7654, 7656, 7657, 7658, 8218, 8234, 8309, 1910, 2467, 9155, 9713, 10044, 10045, 10046, 10166, 10225, 10314, 10396, 10523, 10534, 10546, 10547, 10549, 10550, 10551, 10803, 10852, 10878, 10933, 11089, 11260, 12274, 12276, 12278, 12279, 12280, 12281, 12282, 12556, 12597, 12692, 12864, 12908, 12940, 12964, 12969, 12983, 12984, 12277, 13086, 13087, 13199, 13293, 13343, 14260, 14760, 14763, 14768, 14862, 14934, 15019, 15141, 15229, 15234, 15245, 15251, 15356, 15383, 15388, 15401, 15402, 15403, 15406, 15466, 15471, 15473, 15476, 15523, 15630, 15636, 15638, 15813, 15838, 15915) AND `published` = 1 AND `calendar_ffh_published` = 1 AND `stop_event` != 1 AND ((((YEAR(`Event`.`debut`) = '2020') AND (MONTH(`Event`.`debut`) = '11'))) OR (((YEAR(`Event`.`debut2`) = '2020') AND (MONTH(`Event`.`debut2`) = '11')))) ORDER BY `Event`.`debut` ASC LIMIT 100	0	0	2
19	SELECT `FamillesEvent`.`id`, `FamillesEvent`.`name` FROM `ExtranetFFH`.`familles_events` AS `FamillesEvent` WHERE 1 = 1 ORDER BY `name` ASC	10	10	0
20	SELECT `Handicap`.`id`, `Handicap`.`name` FROM `ExtranetFFH`.`handicaps` AS `Handicap` WHERE 1 = 1 ORDER BY `name` ASC	7	7	0
21	SELECT `Region`.`id`, `Region`.`name` FROM `ExtranetFFH`.`regions` AS `Region` WHERE 1 = 1 ORDER BY `Region`.`name` ASC	39	39	0

(production) 21 queries took 353 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT SUBSTR(StructureNomCourt,7) as SPORT, `Structure`.`id` FROM `ExtranetFFH`.`structures` AS `Structure` WHERE `StructureCode` = '000000231' 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

24544

276

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

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` = 232

750

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

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

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

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

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

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

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

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

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

SELECT `FamillesEvent`.`id`, `FamillesEvent`.`name` FROM `ExtranetFFH`.`familles_events` AS `FamillesEvent` WHERE 1 = 1 ORDER BY `name` ASC

SELECT `Handicap`.`id`, `Handicap`.`name` FROM `ExtranetFFH`.`handicaps` AS `Handicap` WHERE 1 = 1 ORDER BY `name` ASC

SELECT `Region`.`id`, `Region`.`name` FROM `ExtranetFFH`.`regions` AS `Region` WHERE 1 = 1 ORDER BY `Region`.`name` ASC

Message	Memory use
Component initialization	1.06 MB
Controller action start	1.19 MB
Controller render start	3.43 MB
View render complete	4.21 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	3.96
Event: Controller.initialize	0.08
Event: Controller.startup	25.81
Controller action	564.66
Event: Controller.beforeRender	2.04
» Processing toolbar data	1.98
Rendering View	10.24
» Event: View.beforeRender	0.02
» Rendering APP/View/Events/calendar_by_sport.ctp	8.37
» » Rendering APP/View/Elements/bloc_calendar_events_une.ctp	0.07
» » Rendering APP/View/Elements/bloc_calendar_search.ctp	2.80
» » Rendering APP/View/Elements/bloc_calendar_avenir.ctp	1.82
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/defaultCalendar.ctp	1.44
» » Rendering CORE/Cake/View/Elements/sql_dump.ctp	0.28
Event: View.afterLayout	0.00

Constant	Value
CONFIG	/home/extranet/public_html/app/Config/
emailAdmin	s.ginot@handisport.org
EMAIL_CONFIG	prod
userAdmin	23
modeSupprTab	1
HELLOASSO_MODE	prod
IP_SAM	77.131.126.45
JNH_LOGIN_URL	../events/viewGestion/14746/participants
JNH_LOGIN_USERS	6542
user_miss_email	s.ginot@handisport.org
DB	production
alerteEmail	1
LARAVEL_URL	https://lara-prod.extranet.handisport.org
LARAVEL_DB	extranet-ffh-laravel-prod
LOCAL	0
serveur	https://extranet.handisport.org
serveurhttps	https://extranet.handisport.org
ROOTUPLOAD	/home/extranet/public_html/app/webroot/img/uploads/events_img/img_une

Constant	Value
APP	/home/extranet/public_html/app/
APP_DIR	app
APPLIBS	/home/extranet/public_html/app/Lib/
CACHE	/home/extranet/public_html/app/tmp/cache/
CAKE	/home/extranet/public_html/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/home/extranet/public_html/lib
CORE_PATH	/home/extranet/public_html/lib/
CAKE_VERSION	2.10.8
CSS	/home/extranet/public_html/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://extranet.handisport.org
IMAGES	/home/extranet/public_html/app/webroot/img/
IMAGES_URL	img/
JS	/home/extranet/public_html/app/webroot/js/
JS_URL	js/
LOGS	/home/extranet/public_html/app/tmp/logs/
ROOT	/home/extranet/public_html
TESTS	/home/extranet/public_html/app/Test/
TMP	/home/extranet/public_html/app/tmp/
VENDORS	/home/extranet/public_html/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/home/extranet/public_html/app/webroot/

Environment Variable	Value
Php Version	7.2.31-1+0~20200514.41+debian9~1.gbpe2a56b
Tmp	/home/extranet/tmp/tmp
Homedir	/home/extranet
Script Name	/app/webroot/index.php
Request Uri	/events/calendarBySport/000000231
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/events/calendarBySport/000000231
Remote Port	61470
Script Filename	/home/extranet/public_html/app/webroot/index.php
Server Admin	[no address given]
Context Document Root	/home/extranet/public_html
Context Prefix
Request Scheme	http
Document Root	/home/extranet/public_html
Remote Addr	18.206.187.81
Server Port	80
Server Addr	127.0.0.1
Server Name	extranet.handisport.org
Server Software	Apache/2.4.25
Server Signature
Path	/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin:/opt/puppetlabs/bin:/usr/local/.aqadmin/bin
Http Connection	close
Http X Forwarded For	18.206.187.81
Http X Forwarded Proto	https
Http Host	extranet.handisport.org
Http Accept Encoding	br,gzip
Http If Modified Since	Mon, 30 Mar 2020 07:47:25 CEST
Http Accept Language	en-US,en;q=0.5
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Proxy-nokeepalive	1
Https	on
Redirect Status	200
Redirect Https	on
Redirect Redirect Status	200
Redirect Redirect Https	on
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1591138268.0069
Request Time	1591138268

Toute l’info sur les temps forts de la discipline

production

Total Time: 353 ms
Total Queries: 21 queries

Query Explain:

Memory

Timers

Toute l’info sur les temps forts de la discipline

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

production

Total Time: 353 ms Total Queries: 21 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 353 ms
Total Queries: 21 queries