Calendrier des formations handisport:

RECHERCHER

Effacer critère

La Fédération Française Handisport propose des formations dédiées aux professionnels du champ sportif mais aussi aux bénévoles souhaitant développer leurs compétences et leurs connaissances dans l’encadrement de personne en situation de handicap moteur et/ou sensoriel.

ASTUCE !

Vous avez consulté le calendrier des formations handisport ?
Malheureusement, la/les formations fédérales que vous avez ciblé(es), ne sont pas proposées actuellement sur notre calendrier.

En attendant :
Inscrivez ici les formations que vous souhaitez réaliser à l'avenir. Vos besoins nous permettront peut-être d'organiser une session de formation si votre demande est partagée par d'autre.

SESSIONS DE FORMATION DU MOIS

1521

Accompagnateur Randonnée - Option Fauteuil Tout Terrain Piloté Cimgo ®

06/07/2020 au 07/07/2020

BESSE ET ST ANASTAISE (63)

1528	HandiSport Santé - Module 1	07/09/2020 au 11/09/2020	PARIS (75)
1448	Accompagnateur Randonnnée	12/09/2020 au 13/09/2020	METABIEF (25)
1524	C.Q.H. - Canoë-Kayak	21/09/2020 au 25/09/2020	REDON (35)
1526	Arbitre régional Boccia	24/09/2020 au 25/09/2020	MACON (71)
1530	Certificat de Qualification Professionnelle - Animateur de Loisir Sportif Option Handisport	30/09/2020 au 02/10/2020 et ...	PARIS et ...

1469	Abécédaire Polyvalent	03/10/2020 au 04/10/2020	DIJON (21)
1511	C.Q.H. - Randonnée	12/10/2020 au 16/10/2020	EMBRUN (05)
1513	Arbitre régional Boccia	15/10/2020 au 15/11/2020	TALENCE (33)

(production) 63 queries took 29 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Fsession`.`id`, `Fsession`.`departement_id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` WHERE `published` = 1 AND (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) > '2020-06-03' ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC	14	14	4
2	SELECT `Departement`.`id`, (CONCAT(`Departement`.`DEP`, " / ", `Departement`.`name`)) AS `Departement__numName` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `id` IN ('100750075', '030630063', '100750075', '090250025', '050350035', '040710071', '100750075', '040210021', '210050005', '020330033', '100750075', '220730073', '220730073', '100750075') ORDER BY `Departement`.`DEP` ASC	9	9	0
3	SELECT `Fsession`.`id`, `Fsession`.`region_id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` WHERE `published` = 1 AND (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) > '2020-06-03' ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC	14	14	4
4	SELECT `Region`.`id`, `Region`.`name` FROM `ExtranetFFH`.`regions` AS `Region` WHERE `id` IN ('100000110', '310000131', '100000110', '320000132', '050000105', '320000132', '100000110', '320000132', '280000128', '350000135', '100000110', '310000131', '310000131', '100000110') ORDER BY `Region`.`name` ASC	6	6	0
5	SELECT `Fsession`.`id`, `Diplome`.`fsport_id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `published` = 1 AND (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) > '2020-06-03' ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC	14	14	4
6	SELECT `Fsport`.`id`, `Fsport`.`name` FROM `ExtranetFFH`.`fsports` AS `Fsport` WHERE `id` IN (19, 23, 19, 23, 8, 6, 20, 19, 23, 6, 19, 26, 26, 39) ORDER BY `name` ASC	7	7	0
7	SELECT `Diplome`.`id`, `Diplome`.`name` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`published` = 1 AND (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) > '2020-06-03' GROUP BY `Fsession`.`diplome_id` ORDER BY `Diplome`.`name` ASC	13	13	4
8	SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2020' AND MONTH(debut) = '04' AND `debut` > '2020-06-03'	0	0	0
9	SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `Diplome`.`types_dip_id`, `Diplome`.`id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`published` = 1 AND `Fsession`.`cancel` IS NULL AND `Fsession`.`id` IS NULL ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 30	0	0	0
10	SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2020' AND MONTH(debut) = '05' AND `debut` > '2020-06-03'	0	0	0
11	SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `Diplome`.`types_dip_id`, `Diplome`.`id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`published` = 1 AND `Fsession`.`cancel` IS NULL AND `Fsession`.`id` IS NULL ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 30	0	0	0
12	SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2020' AND MONTH(debut) = '06' AND `debut` > '2020-06-03'	4	4	0
13	SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `Diplome`.`types_dip_id`, `Diplome`.`id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`published` = 1 AND `Fsession`.`cancel` IS NULL AND `Fsession`.`id` IN (1408, 1436, 1395, 1386) ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 30	0	0	0
14	SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2020' AND MONTH(debut) = '07' AND `debut` > '2020-06-03'	1	1	0
15	SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `Diplome`.`types_dip_id`, `Diplome`.`id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`published` = 1 AND `Fsession`.`cancel` IS NULL AND `Fsession`.`id` = (1521) ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 30	1	1	0
16	SELECT `FsessionSTA`.`id`, `FsessionSTA`.`fsession_id` FROM `ExtranetFFH`.`fsessions_stagiaires` AS `FsessionSTA` WHERE `signup` != 3 AND `FsessionSTA`.`fsession_id` = (1521)	6	6	0
17	SELECT `FsessionDATES`.`commune`, `FsessionDATES`.`debut`, `FsessionDATES`.`departement_id`, (CONCAT(DATE_FORMAT(`FsessionDATES`.`debut`, "%d/%m/%Y")," au ",DATE_FORMAT(`FsessionDATES`.`fin`, "%d/%m/%Y"))) AS `FsessionDATES__dates`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE `FsessionDATES`.`fsession_id` = (1521)	1	1	0
18	SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '030630063'	1	1	0
19	SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2020' AND MONTH(debut) = '08' AND `debut` > '2020-06-03'	0	0	0
20	SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `Diplome`.`types_dip_id`, `Diplome`.`id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`published` = 1 AND `Fsession`.`cancel` IS NULL AND `Fsession`.`id` IS NULL ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 30	0	0	0
21	SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2020' AND MONTH(debut) = '09' AND `debut` > '2020-06-03'	8	8	0
22	SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `Diplome`.`types_dip_id`, `Diplome`.`id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`published` = 1 AND `Fsession`.`cancel` IS NULL AND `Fsession`.`id` IN (1528, 1356, 1448, 1549, 1449, 1524, 1526, 1530) ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 30	5	5	0
23	SELECT `FsessionSTA`.`id`, `FsessionSTA`.`fsession_id` FROM `ExtranetFFH`.`fsessions_stagiaires` AS `FsessionSTA` WHERE `signup` != 3 AND `FsessionSTA`.`fsession_id` IN (1528, 1448, 1524, 1526, 1530)	3	3	0
24	SELECT `FsessionDATES`.`commune`, `FsessionDATES`.`debut`, `FsessionDATES`.`departement_id`, (CONCAT(DATE_FORMAT(`FsessionDATES`.`debut`, "%d/%m/%Y")," au ",DATE_FORMAT(`FsessionDATES`.`fin`, "%d/%m/%Y"))) AS `FsessionDATES__dates`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE `FsessionDATES`.`fsession_id` IN (1528, 1448, 1524, 1526, 1530)	10	10	0
25	SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '090250025'	1	1	0
26	SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '050350035'	1	1	0
27	SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '040710071'	1	1	0
28	SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'	1	1	0
29	SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'	1	1	0
30	SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'	1	1	0
31	SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'	1	1	0
32	SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'	1	1	0
33	SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'	1	1	0
34	SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'	1	1	0
35	SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2020' AND MONTH(debut) = '10' AND `debut` > '2020-06-03'	4	4	0
36	SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `Diplome`.`types_dip_id`, `Diplome`.`id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`published` = 1 AND `Fsession`.`cancel` IS NULL AND `Fsession`.`id` IN (1469, 1544, 1511, 1513) ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 30	3	3	0
37	SELECT `FsessionSTA`.`id`, `FsessionSTA`.`fsession_id` FROM `ExtranetFFH`.`fsessions_stagiaires` AS `FsessionSTA` WHERE `signup` != 3 AND `FsessionSTA`.`fsession_id` IN (1469, 1511, 1513)	4	4	0
38	SELECT `FsessionDATES`.`commune`, `FsessionDATES`.`debut`, `FsessionDATES`.`departement_id`, (CONCAT(DATE_FORMAT(`FsessionDATES`.`debut`, "%d/%m/%Y")," au ",DATE_FORMAT(`FsessionDATES`.`fin`, "%d/%m/%Y"))) AS `FsessionDATES__dates`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE `FsessionDATES`.`fsession_id` IN (1469, 1511, 1513)	3	3	0
39	SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '040210021'	1	1	0
40	SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '210050005'	1	1	0
41	SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '020330033'	1	1	0
42	SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2020' AND MONTH(debut) = '11' AND `debut` > '2020-06-03'	7	7	0
43	SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `Diplome`.`types_dip_id`, `Diplome`.`id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`published` = 1 AND `Fsession`.`cancel` IS NULL AND `Fsession`.`id` IN (1356, 1530, 1554, 1545, 1532, 1550, 1545) ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 30	1	1	0
44	SELECT `FsessionSTA`.`id`, `FsessionSTA`.`fsession_id` FROM `ExtranetFFH`.`fsessions_stagiaires` AS `FsessionSTA` WHERE `signup` != 3 AND `FsessionSTA`.`fsession_id` = (1530)	0	0	0
45	SELECT `FsessionDATES`.`commune`, `FsessionDATES`.`debut`, `FsessionDATES`.`departement_id`, (CONCAT(DATE_FORMAT(`FsessionDATES`.`debut`, "%d/%m/%Y")," au ",DATE_FORMAT(`FsessionDATES`.`fin`, "%d/%m/%Y"))) AS `FsessionDATES__dates`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE `FsessionDATES`.`fsession_id` = (1530)	6	6	0
46	SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'	1	1	0
47	SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'	1	1	0
48	SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'	1	1	0
49	SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'	1	1	0
50	SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'	1	1	0
51	SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'	1	1	0
52	SELECT `Fsession`.`id`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `Diplome`.`id`, (SELECT `fsessions_dates`.`commune` FROM fsessions_dates where fsession_id = `Fsession`.`id` limit 0,1) AS `Fsession__commune`, (SELECT MAX(`fsessions_dates`.`fin`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__max_date`, (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__min_date`, (SELECT MIN(`fsessions_dates`.`latitude`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__lat`, (SELECT MIN(`fsessions_dates`.`longitude`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__long` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`published` = 1 AND (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) >= '2020-06-03' ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC	15	15	4
53	SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, (SELECT `fsessions_dates`.`commune` FROM fsessions_dates where fsession_id = `Fsession`.`id` limit 0,1) AS `Fsession__commune`, (SELECT `diplomes`.`name` FROM diplomes where id = `Fsession`.`diplome_id`) AS `Fsession__diplome`, (SELECT YEAR(MIN(`fsessions_dates`.`debut`)) FROM fsessions_dates where `fsessions_dates`.`fsession_id` = `Fsession`.`id`) AS `Fsession__year_min_date`, (SELECT MAX(`fsessions_dates`.`fin`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__max_date`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`user_create_id`) AS `Fsession__UCR`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`user_modify_id`) AS `Fsession__UMY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`certified_user_id`) AS `Fsession__UCY`, (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__min_date`, (SELECT MIN(`fsessions_dates`.`latitude`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__lat`, (SELECT MIN(`fsessions_dates`.`longitude`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__long`, (SELECT types_dip_id FROM diplomes where id = `Fsession`.`diplome_id`) AS `Fsession__typeDip`, `Diplome`.`nb_stag_max` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`id` = 1521 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1	1	1	1
54	SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, (SELECT `fsessions_dates`.`commune` FROM fsessions_dates where fsession_id = `Fsession`.`id` limit 0,1) AS `Fsession__commune`, (SELECT `diplomes`.`name` FROM diplomes where id = `Fsession`.`diplome_id`) AS `Fsession__diplome`, (SELECT YEAR(MIN(`fsessions_dates`.`debut`)) FROM fsessions_dates where `fsessions_dates`.`fsession_id` = `Fsession`.`id`) AS `Fsession__year_min_date`, (SELECT MAX(`fsessions_dates`.`fin`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__max_date`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`user_create_id`) AS `Fsession__UCR`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`user_modify_id`) AS `Fsession__UMY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`certified_user_id`) AS `Fsession__UCY`, (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__min_date`, (SELECT MIN(`fsessions_dates`.`latitude`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__lat`, (SELECT MIN(`fsessions_dates`.`longitude`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__long`, (SELECT types_dip_id FROM diplomes where id = `Fsession`.`diplome_id`) AS `Fsession__typeDip`, `Diplome`.`nb_stag_max` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`id` = 1528 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1	1	1	1
55	SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, (SELECT `fsessions_dates`.`commune` FROM fsessions_dates where fsession_id = `Fsession`.`id` limit 0,1) AS `Fsession__commune`, (SELECT `diplomes`.`name` FROM diplomes where id = `Fsession`.`diplome_id`) AS `Fsession__diplome`, (SELECT YEAR(MIN(`fsessions_dates`.`debut`)) FROM fsessions_dates where `fsessions_dates`.`fsession_id` = `Fsession`.`id`) AS `Fsession__year_min_date`, (SELECT MAX(`fsessions_dates`.`fin`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__max_date`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`user_create_id`) AS `Fsession__UCR`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`user_modify_id`) AS `Fsession__UMY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`certified_user_id`) AS `Fsession__UCY`, (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__min_date`, (SELECT MIN(`fsessions_dates`.`latitude`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__lat`, (SELECT MIN(`fsessions_dates`.`longitude`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__long`, (SELECT types_dip_id FROM diplomes where id = `Fsession`.`diplome_id`) AS `Fsession__typeDip`, `Diplome`.`nb_stag_max` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`id` = 1448 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1	1	1	1
56	SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, (SELECT `fsessions_dates`.`commune` FROM fsessions_dates where fsession_id = `Fsession`.`id` limit 0,1) AS `Fsession__commune`, (SELECT `diplomes`.`name` FROM diplomes where id = `Fsession`.`diplome_id`) AS `Fsession__diplome`, (SELECT YEAR(MIN(`fsessions_dates`.`debut`)) FROM fsessions_dates where `fsessions_dates`.`fsession_id` = `Fsession`.`id`) AS `Fsession__year_min_date`, (SELECT MAX(`fsessions_dates`.`fin`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__max_date`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`user_create_id`) AS `Fsession__UCR`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`user_modify_id`) AS `Fsession__UMY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`certified_user_id`) AS `Fsession__UCY`, (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__min_date`, (SELECT MIN(`fsessions_dates`.`latitude`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__lat`, (SELECT MIN(`fsessions_dates`.`longitude`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__long`, (SELECT types_dip_id FROM diplomes where id = `Fsession`.`diplome_id`) AS `Fsession__typeDip`, `Diplome`.`nb_stag_max` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`id` = 1524 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1	1	1	1
57	SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, (SELECT `fsessions_dates`.`commune` FROM fsessions_dates where fsession_id = `Fsession`.`id` limit 0,1) AS `Fsession__commune`, (SELECT `diplomes`.`name` FROM diplomes where id = `Fsession`.`diplome_id`) AS `Fsession__diplome`, (SELECT YEAR(MIN(`fsessions_dates`.`debut`)) FROM fsessions_dates where `fsessions_dates`.`fsession_id` = `Fsession`.`id`) AS `Fsession__year_min_date`, (SELECT MAX(`fsessions_dates`.`fin`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__max_date`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`user_create_id`) AS `Fsession__UCR`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`user_modify_id`) AS `Fsession__UMY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`certified_user_id`) AS `Fsession__UCY`, (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__min_date`, (SELECT MIN(`fsessions_dates`.`latitude`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__lat`, (SELECT MIN(`fsessions_dates`.`longitude`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__long`, (SELECT types_dip_id FROM diplomes where id = `Fsession`.`diplome_id`) AS `Fsession__typeDip`, `Diplome`.`nb_stag_max` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`id` = 1526 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1	1	1	1
58	SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, (SELECT `fsessions_dates`.`commune` FROM fsessions_dates where fsession_id = `Fsession`.`id` limit 0,1) AS `Fsession__commune`, (SELECT `diplomes`.`name` FROM diplomes where id = `Fsession`.`diplome_id`) AS `Fsession__diplome`, (SELECT YEAR(MIN(`fsessions_dates`.`debut`)) FROM fsessions_dates where `fsessions_dates`.`fsession_id` = `Fsession`.`id`) AS `Fsession__year_min_date`, (SELECT MAX(`fsessions_dates`.`fin`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__max_date`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`user_create_id`) AS `Fsession__UCR`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`user_modify_id`) AS `Fsession__UMY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`certified_user_id`) AS `Fsession__UCY`, (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__min_date`, (SELECT MIN(`fsessions_dates`.`latitude`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__lat`, (SELECT MIN(`fsessions_dates`.`longitude`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__long`, (SELECT types_dip_id FROM diplomes where id = `Fsession`.`diplome_id`) AS `Fsession__typeDip`, `Diplome`.`nb_stag_max` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`id` = 1530 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1	1	1	1
59	SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, (SELECT `fsessions_dates`.`commune` FROM fsessions_dates where fsession_id = `Fsession`.`id` limit 0,1) AS `Fsession__commune`, (SELECT `diplomes`.`name` FROM diplomes where id = `Fsession`.`diplome_id`) AS `Fsession__diplome`, (SELECT YEAR(MIN(`fsessions_dates`.`debut`)) FROM fsessions_dates where `fsessions_dates`.`fsession_id` = `Fsession`.`id`) AS `Fsession__year_min_date`, (SELECT MAX(`fsessions_dates`.`fin`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__max_date`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`user_create_id`) AS `Fsession__UCR`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`user_modify_id`) AS `Fsession__UMY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`certified_user_id`) AS `Fsession__UCY`, (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__min_date`, (SELECT MIN(`fsessions_dates`.`latitude`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__lat`, (SELECT MIN(`fsessions_dates`.`longitude`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__long`, (SELECT types_dip_id FROM diplomes where id = `Fsession`.`diplome_id`) AS `Fsession__typeDip`, `Diplome`.`nb_stag_max` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`id` = 1469 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1	1	1	1
60	SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, (SELECT `fsessions_dates`.`commune` FROM fsessions_dates where fsession_id = `Fsession`.`id` limit 0,1) AS `Fsession__commune`, (SELECT `diplomes`.`name` FROM diplomes where id = `Fsession`.`diplome_id`) AS `Fsession__diplome`, (SELECT YEAR(MIN(`fsessions_dates`.`debut`)) FROM fsessions_dates where `fsessions_dates`.`fsession_id` = `Fsession`.`id`) AS `Fsession__year_min_date`, (SELECT MAX(`fsessions_dates`.`fin`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__max_date`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`user_create_id`) AS `Fsession__UCR`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`user_modify_id`) AS `Fsession__UMY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`certified_user_id`) AS `Fsession__UCY`, (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__min_date`, (SELECT MIN(`fsessions_dates`.`latitude`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__lat`, (SELECT MIN(`fsessions_dates`.`longitude`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__long`, (SELECT types_dip_id FROM diplomes where id = `Fsession`.`diplome_id`) AS `Fsession__typeDip`, `Diplome`.`nb_stag_max` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`id` = 1511 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1	1	1	1
61	SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, (SELECT `fsessions_dates`.`commune` FROM fsessions_dates where fsession_id = `Fsession`.`id` limit 0,1) AS `Fsession__commune`, (SELECT `diplomes`.`name` FROM diplomes where id = `Fsession`.`diplome_id`) AS `Fsession__diplome`, (SELECT YEAR(MIN(`fsessions_dates`.`debut`)) FROM fsessions_dates where `fsessions_dates`.`fsession_id` = `Fsession`.`id`) AS `Fsession__year_min_date`, (SELECT MAX(`fsessions_dates`.`fin`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__max_date`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`user_create_id`) AS `Fsession__UCR`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`user_modify_id`) AS `Fsession__UMY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`certified_user_id`) AS `Fsession__UCY`, (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__min_date`, (SELECT MIN(`fsessions_dates`.`latitude`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__lat`, (SELECT MIN(`fsessions_dates`.`longitude`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__long`, (SELECT types_dip_id FROM diplomes where id = `Fsession`.`diplome_id`) AS `Fsession__typeDip`, `Diplome`.`nb_stag_max` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`id` = 1513 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1	1	1	1
62	SELECT `Diplome`.`id`, `Diplome`.`name` FROM `ExtranetFFH`.`diplomes` AS `Diplome` WHERE `active` = 1 AND `thematique_id` = 1 ORDER BY `Diplome`.`name` ASC	103	103	0
63	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

History
+
Request History
4 previous requests available
====
Session
+
Session
- 0(null)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerfsessions
- actioncalendarPublic
- named(empty)
- pass(empty)
- isAjax(false)
- paging(array)
  Fsession(array)
  page1
  current1
  count1
  prevPage(false)
  nextPage(false)
  pageCount1
  order(array)
  min_dateASC
  limit30
  options(array)
  order(array)
  min_dateASC
  conditions(empty)
  paramTypenamed
  queryScope(null)
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys(array)
  0controller
  1action
- options(array)
  defaultRoute(true)
- defaults(array)
  plugin(null)
- template/:controller/:action/*
====
Sql Log
+

Sql Logs

production

Total Time: 29 ms
Total Queries: 63 queries
Query Affected Num. rows Took (ms) Actions

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 3.88 MB

Message	Memory use
Component initialization	1012 KB
Controller action start	1.12 MB
Controller render start	2.06 MB
View render complete	3.26 MB

Timers

Total Request Time: 165 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	3.96
Event: Controller.initialize	0.05
Event: Controller.startup	98.80
Controller action	136.32
Event: Controller.beforeRender	1.81
» Processing toolbar data	1.74
Rendering View	20.60
» Event: View.beforeRender	0.01
» Rendering APP/View/Fsessions/calendar_public.ctp	19.08
» » Rendering APP/View/Elements/bloc_calendar_formation_search.ctp	3.08
» » Rendering APP/View/Elements/bloc_calendar_formation_avenir.ctp	10.22
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/defaultCalendarFormation.ctp	1.16
» » Rendering CORE/Cake/View/Elements/sql_dump.ctp	0.26
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- fsessions_lieux(array)
  0(array)
  Fsession(array)
  id1553
  traduction_lsf0
  communePARIS
  max_date2020-06-03
  min_date2020-06-03
  lat(null)
  long(null)
  Diplome(array)
  nameWeb Conférence - Découverte des formations Handisport proposées par la commission randonnée
  id437
  1(array)
  Fsession(array)
  id1408
  traduction_lsf0
  communeLYON
  max_date2020-06-12
  min_date2020-06-08
  lat(null)
  long(null)
  Diplome(array)
  nameModule de formation - Activités physiques et sportives et les blessés médullaires
  id406
  2(array)
  Fsession(array)
  id1521
  traduction_lsf0
  communeBESSE ET ST ANASTAISE
  max_date2020-07-07
  min_date2020-07-06
  lat(null)
  long(null)
  Diplome(array)
  nameAccompagnateur Randonnée - Option Fauteuil Tout Terrain Piloté Cimgo ®
  id393
  3(array)
  Fsession(array)
  id1528
  traduction_lsf0
  communePARIS
  max_date2020-09-11
  min_date2020-09-07
  lat(null)
  long(null)
  Diplome(array)
  nameHandiSport Santé - Module 1
  id403
  4(array)
  Fsession(array)
  id1448
  traduction_lsf0
  communeMETABIEF
  max_date2020-09-13
  min_date2020-09-12
  lat(null)
  long(null)
  Diplome(array)
  nameAccompagnateur Randonnnée
  id287
  5(array)
  Fsession(array)
  id1524
  traduction_lsf0
  communeREDON
  max_date2020-09-25
  min_date2020-09-21
  lat(null)
  long(null)
  Diplome(array)
  nameC.Q.H. - Canoë-Kayak
  id339
  6(array)
  Fsession(array)
  id1526
  traduction_lsf0
  communeMACON
  max_date2020-09-25
  min_date2020-09-24
  lat(null)
  long(null)
  Diplome(array)
  nameArbitre régional Boccia
  id214
  7(array)
  Fsession(array)
  id1530
  traduction_lsf0
  communePARIS
  max_date2021-03-26
  min_date2020-09-30
  lat(null)
  long(null)
  Diplome(array)
  nameCertificat de Qualification Professionnelle - Animateur de Loisir Sportif Option Handisport
  id419
  8(array)
  Fsession(array)
  id1469
  traduction_lsf0
  communeDIJON
  max_date2020-10-04
  min_date2020-10-03
  lat(null)
  long(null)
  Diplome(array)
  nameAbécédaire Polyvalent
  id218
  9(array)
  Fsession(array)
  id1511
  traduction_lsf0
  communeEMBRUN
  max_date2020-10-16
  min_date2020-10-12
  lat(null)
  long(null)
  Diplome(array)
  nameC.Q.H. - Randonnée
  id347
  10(array)
  Fsession(array)
  id1513
  traduction_lsf0
  communeTALENCE
  max_date2020-11-15
  min_date2020-10-15
  lat(null)
  long(null)
  Diplome(array)
  nameArbitre régional Boccia
  id214
  11(array)
  Fsession(array)
  id1529
  traduction_lsf0
  communePARIS
  max_date2020-12-10
  min_date2020-12-07
  lat(null)
  long(null)
  Diplome(array)
  nameHandiSport Santé - Module 2
  id424
  12(array)
  Fsession(array)
  id1531
  traduction_lsf0
  communeTIGNES
  max_date2020-12-17
  min_date2020-12-14
  lat(null)
  long(null)
  Diplome(array)
  nameAccompagnateur Ski Alpin
  id296
  13(array)
  Fsession(array)
  id1541
  traduction_lsf0
  communeST SORLIN D ARVES
  max_date2021-01-09
  min_date2021-01-04
  lat(null)
  long(null)
  Diplome(array)
  namePilote - Tandem'Flex et Tandemski
  id387
  14(array)
  Fsession(array)
  id1527
  traduction_lsf0
  communePARIS
  max_date2021-03-12
  min_date2021-03-08
  lat(null)
  long(null)
  Diplome(array)
  nameFormation Para-Danse Handisport
  id422
- filter2(empty)
- filter(empty)
- fsessionsMois7(array)
  0(array)
  Fsession(array)
  id1530
  type3
  traduction_lsf0
  Diplome(array)
  nameCertificat de Qualification Professionnelle - Animateur de Loisir Sportif Option Handisport
  types_dip_id41
  id419
  FsessionSTA(empty)
  FsessionDATES(array)
  0(array)
  communePARIS
  debut2020-09-30
  departement_id100750075
  fsession_id1530
  dates30/09/2020 au 02/10/2020
  Departement(array)
  DEP75
  1(array)
  communePARIS
  debut2020-11-04
  departement_id100750075
  fsession_id1530
  dates04/11/2020 au 06/11/2020
  Departement(array)
  DEP75
  2(array)
  communePARIS
  debut2020-12-09
  departement_id100750075
  fsession_id1530
  dates09/12/2020 au 11/12/2020
  Departement(array)
  DEP75
  3(array)
  communePARIS
  debut2021-01-27
  departement_id100750075
  fsession_id1530
  dates27/01/2021 au 29/01/2021
  Departement(array)
  DEP75
  4(array)
  communePARIS
  debut2021-03-10
  departement_id100750075
  fsession_id1530
  dates10/03/2021 au 12/03/2021
  Departement(array)
  DEP75
  5(array)
  communePARIS
  debut2021-03-24
  departement_id100750075
  fsession_id1530
  dates24/03/2021 au 26/03/2021
  Departement(array)
  DEP75
- fsessionsMois6(array)
  0(array)
  Fsession(array)
  id1469
  type3
  traduction_lsf0
  Diplome(array)
  nameAbécédaire Polyvalent
  types_dip_id3
  id218
  FsessionSTA(array)
  0(array)
  id10634
  fsession_id1469
  1(array)
  id10661
  fsession_id1469
  2(array)
  id10664
  fsession_id1469
  3(array)
  id11386
  fsession_id1469
  FsessionDATES(array)
  0(array)
  communeDIJON
  debut2020-10-03
  departement_id040210021
  fsession_id1469
  dates03/10/2020 au 04/10/2020
  Departement(array)
  DEP21
  1(array)
  Fsession(array)
  id1511
  type3
  traduction_lsf0
  Diplome(array)
  nameC.Q.H. - Randonnée
  types_dip_id34
  id347
  FsessionSTA(empty)
  FsessionDATES(array)
  0(array)
  communeEMBRUN
  debut2020-10-12
  departement_id210050005
  fsession_id1511
  dates12/10/2020 au 16/10/2020
  Departement(array)
  DEP05
  2(array)
  Fsession(array)
  id1513
  type3
  traduction_lsf0
  Diplome(array)
  nameArbitre régional Boccia
  types_dip_id12
  id214
  FsessionSTA(empty)
  FsessionDATES(array)
  0(array)
  communeTALENCE
  debut2020-10-15
  departement_id020330033
  fsession_id1513
  dates15/10/2020 au 15/11/2020
  Departement(array)
  DEP33
- fsessionsMois5(array)
  0(array)
  Fsession(array)
  id1528
  type3
  traduction_lsf0
  Diplome(array)
  nameHandiSport Santé - Module 1
  types_dip_id51
  id403
  FsessionSTA(array)
  0(array)
  id11313
  fsession_id1528
  FsessionDATES(array)
  0(array)
  communePARIS
  debut2020-09-07
  departement_id100750075
  fsession_id1528
  dates07/09/2020 au 11/09/2020
  Departement(array)
  DEP75
  1(array)
  Fsession(array)
  id1448
  type3
  traduction_lsf0
  Diplome(array)
  nameAccompagnateur Randonnnée
  types_dip_id8
  id287
  FsessionSTA(array)
  0(array)
  id11389
  fsession_id1448
  FsessionDATES(array)
  0(array)
  communeMETABIEF
  debut2020-09-12
  departement_id090250025
  fsession_id1448
  dates12/09/2020 au 13/09/2020
  Departement(array)
  DEP25
  2(array)
  Fsession(array)
  id1524
  type3
  traduction_lsf0
  Diplome(array)
  nameC.Q.H. - Canoë-Kayak
  types_dip_id34
  id339
  FsessionSTA(array)
  0(array)
  id11330
  fsession_id1524
  FsessionDATES(array)
  0(array)
  communeREDON
  debut2020-09-21
  departement_id050350035
  fsession_id1524
  dates21/09/2020 au 25/09/2020
  Departement(array)
  DEP35
  3(array)
  Fsession(array)
  id1526
  type3
  traduction_lsf0
  Diplome(array)
  nameArbitre régional Boccia
  types_dip_id12
  id214
  FsessionSTA(empty)
  FsessionDATES(array)
  0(array)
  communeMACON
  debut2020-09-24
  departement_id040710071
  fsession_id1526
  dates24/09/2020 au 25/09/2020
  Departement(array)
  DEP71
  4(array)
  Fsession(array)
  id1530
  type3
  traduction_lsf0
  Diplome(array)
  nameCertificat de Qualification Professionnelle - Animateur de Loisir Sportif Option Handisport
  types_dip_id41
  id419
  FsessionSTA(empty)
  FsessionDATES(array)
  0(array)
  communePARIS
  debut2020-09-30
  departement_id100750075
  fsession_id1530
  dates30/09/2020 au 02/10/2020
  Departement(array)
  DEP75
  1(array)
  communePARIS
  debut2020-11-04
  departement_id100750075
  fsession_id1530
  dates04/11/2020 au 06/11/2020
  Departement(array)
  DEP75
  2(array)
  communePARIS
  debut2020-12-09
  departement_id100750075
  fsession_id1530
  dates09/12/2020 au 11/12/2020
  Departement(array)
  DEP75
  3(array)
  communePARIS
  debut2021-01-27
  departement_id100750075
  fsession_id1530
  dates27/01/2021 au 29/01/2021
  Departement(array)
  DEP75
  4(array)
  communePARIS
  debut2021-03-10
  departement_id100750075
  fsession_id1530
  dates10/03/2021 au 12/03/2021
  Departement(array)
  DEP75
  5(array)
  communePARIS
  debut2021-03-24
  departement_id100750075
  fsession_id1530
  dates24/03/2021 au 26/03/2021
  Departement(array)
  DEP75
- fsessionsMois4(empty)
- fsessionsMois3(array)
  0(array)
  Fsession(array)
  id1521
  type3
  traduction_lsf0
  Diplome(array)
  nameAccompagnateur Randonnée - Option Fauteuil Tout Terrain Piloté Cimgo ®
  types_dip_id8
  id393
  FsessionSTA(array)
  0(array)
  id10953
  fsession_id1521
  1(array)
  id10952
  fsession_id1521
  2(array)
  id10950
  fsession_id1521
  3(array)
  id10951
  fsession_id1521
  4(array)
  id10954
  fsession_id1521
  5(array)
  id11319
  fsession_id1521
  FsessionDATES(array)
  0(array)
  communeBESSE ET ST ANASTAISE
  debut2020-07-06
  departement_id030630063
  fsession_id1521
  dates06/07/2020 au 07/07/2020
  Departement(array)
  DEP63
- fsessionsMois2(empty)
- fsessionsMois1(empty)
- fsessionsMois0(empty)
- diplomes(array)
  218Abécédaire Polyvalent
  393Accompagnateur Randonnée - Option Fauteuil Tout Terrain Piloté Cimgo ®
  287Accompagnateur Randonnnée
  296Accompagnateur Ski Alpin
  214Arbitre régional Boccia
  339C.Q.H. - Canoë-Kayak
  347C.Q.H. - Randonnée
  419Certificat de Qualification Professionnelle - Animateur de Loisir Sportif Option Handisport
  422Formation Para-Danse Handisport
  403HandiSport Santé - Module 1
  424HandiSport Santé - Module 2
  406Module de formation - Activités physiques et sportives et les blessés médullaires
  387Pilote - Tandem'Flex et Tandemski
- sports(array)
  6Boccia
  8Canoë-Kayak
  39Danse
  20Métiers de la Forme
  19Multidisciplinaire
  23Randonnée
  26Ski Alpin
- regs(array)
  310000131AUVERGNE RHÔNE-ALPES
  320000132BOURGOGNE FRANCHE-COMTE
  050000105BRETAGNE
  100000110ILE-DE-FRANCE
  350000135NOUVELLE AQUITAINE
  280000128PROVENCE-ALPES CÔTE D'AZUR
- depts(array)
  21005000505 / HAUTES-ALPES
  04021002121 / COTE-D'OR
  09025002525 / DOUBS
  02033003333 / GIRONDE
  05035003535 / ILLE-ET-VILAINE
  03063006363 / PUY-DE-DOME
  04071007171 / SAONE-ET-LOIRE
  22073007373 / SAVOIE
  10075007575 / PARIS
- typesFsessions(array)
  3Diplomante
- view_session0
- $request->data(empty)
- $this->validationErrors(array)
  Fsession(empty)
  Ue(empty)
  Diplome(empty)
  Departement(empty)
  Region(empty)
  Fsport(empty)
  FsessionDATES(empty)
  FsessionSTA(empty)
  Stagiaire(empty)
  StagiairesProjet(empty)
- Loaded Helpers(array)
  0Js
  1Session
  2GoogleMap
  3Formatage
  4Listes
  5Html
  6Form
  7Paginator
  8Cache
  9Image
  10JqueryValidation
  11Media
  12PhpExcel
  13Champs
  14Number
  15SimpleGraph
  16DebugTimer
  17Toolbar
  18Verif
  19Text
  20HtmlToolbar
====

Environment

App Constants

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

CakePHP Constants

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/

PHP Environment

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	/fsessions/calendarPublic
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/fsessions/calendarPublic
Remote Port	12256
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 09:05:09 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	1591142933.3031
Request Time	1591142933

====

Include
+
Included Files

Include Paths
- 0/home/extranet/public_html/lib
- 2/usr/share/php
- 3-> /home/extranet/public_html/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/ContainableBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/SessionComponent.php
  1CORE/Controller/Component/CookieComponent.php
  2CORE/Controller/Component/AuthComponent.php
  3CORE/Controller/Component/RequestHandlerComponent.php
  4CORE/Controller/Component/PaginatorComponent.php
  5CORE/Controller/Component/Auth/FormAuthenticate.php
  6CORE/Controller/Component/Auth/BaseAuthenticate.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ModelBehavior.php
  3CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/CakeObject.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/CakeText.php
  5CORE/Utility/ClassRegistry.php
  6CORE/Utility/Set.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Component(array)
  0APP/Controller/Component/FonctionsComponent.php
  1APP/Controller/Component/PasswordComponent.php
  2APP/Controller/Component/FormatageComponent.php
  3APP/Controller/Component/SqlComponent.php
  4APP/Controller/Component/CheckComponent.php
  5APP/Controller/Component/ListesComponent.php
  6APP/Controller/Component/FilterComponent.php
  7APP/Controller/Component/VerifComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/FsessionsController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/Fsession.php
  1APP/Model/AppModel.php
  2APP/Model/Ue.php
  3APP/Model/Diplome.php
  4APP/Model/Departement.php
  5APP/Model/Region.php
  6APP/Model/Fsport.php
  7APP/Model/FsessionDATES.php
  8APP/Model/FsessionSTA.php
  Other(array)
  0APP/webroot/index.php
  1APP/Vendor/autoload.php
  2APP/Vendor/composer/autoload_real.php
  3APP/Vendor/composer/ClassLoader.php
  4APP/Vendor/composer/autoload_static.php
  5APP/Vendor/markbaker/complex/classes/src/functions/abs.php
  6APP/Vendor/markbaker/complex/classes/src/functions/acos.php
  7APP/Vendor/markbaker/complex/classes/src/functions/acosh.php
  8APP/Vendor/markbaker/complex/classes/src/functions/acot.php
  9APP/Vendor/markbaker/complex/classes/src/functions/acoth.php
  10APP/Vendor/markbaker/complex/classes/src/functions/acsc.php
  11APP/Vendor/markbaker/complex/classes/src/functions/acsch.php
  12APP/Vendor/markbaker/complex/classes/src/functions/argument.php
  13APP/Vendor/markbaker/complex/classes/src/functions/asec.php
  14APP/Vendor/markbaker/complex/classes/src/functions/asech.php
  15APP/Vendor/markbaker/complex/classes/src/functions/asin.php
  16APP/Vendor/markbaker/complex/classes/src/functions/asinh.php
  17APP/Vendor/markbaker/complex/classes/src/functions/atan.php
  18APP/Vendor/markbaker/complex/classes/src/functions/atanh.php
  19APP/Vendor/markbaker/complex/classes/src/functions/conjugate.php
  20APP/Vendor/markbaker/complex/classes/src/functions/cos.php
  21APP/Vendor/markbaker/complex/classes/src/functions/cosh.php
  22APP/Vendor/markbaker/complex/classes/src/functions/cot.php
  23APP/Vendor/markbaker/complex/classes/src/functions/coth.php
  24APP/Vendor/markbaker/complex/classes/src/functions/csc.php
  25APP/Vendor/markbaker/complex/classes/src/functions/csch.php
  26APP/Vendor/markbaker/complex/classes/src/functions/exp.php
  27APP/Vendor/markbaker/complex/classes/src/functions/inverse.php
  28APP/Vendor/markbaker/complex/classes/src/functions/ln.php
  29APP/Vendor/markbaker/complex/classes/src/functions/log2.php
  30APP/Vendor/markbaker/complex/classes/src/functions/log10.php
  31APP/Vendor/markbaker/complex/classes/src/functions/negative.php
  32APP/Vendor/markbaker/complex/classes/src/functions/pow.php
  33APP/Vendor/markbaker/complex/classes/src/functions/rho.php
  34APP/Vendor/markbaker/complex/classes/src/functions/sec.php
  35APP/Vendor/markbaker/complex/classes/src/functions/sech.php
  36APP/Vendor/markbaker/complex/classes/src/functions/sin.php
  37APP/Vendor/markbaker/complex/classes/src/functions/sinh.php
  38APP/Vendor/markbaker/complex/classes/src/functions/sqrt.php
  39APP/Vendor/markbaker/complex/classes/src/functions/tan.php
  40APP/Vendor/markbaker/complex/classes/src/functions/tanh.php
  41APP/Vendor/markbaker/complex/classes/src/functions/theta.php
  42APP/Vendor/markbaker/complex/classes/src/operations/add.php
  43APP/Vendor/markbaker/complex/classes/src/operations/subtract.php
  44APP/Vendor/markbaker/complex/classes/src/operations/multiply.php
  45APP/Vendor/markbaker/complex/classes/src/operations/divideby.php
  46APP/Vendor/markbaker/complex/classes/src/operations/divideinto.php
  47APP/Vendor/markbaker/matrix/classes/src/functions/adjoint.php
  48APP/Vendor/markbaker/matrix/classes/src/functions/antidiagonal.php
  49APP/Vendor/markbaker/matrix/classes/src/functions/cofactors.php
  50APP/Vendor/markbaker/matrix/classes/src/functions/determinant.php
  51APP/Vendor/markbaker/matrix/classes/src/functions/diagonal.php
  52APP/Vendor/markbaker/matrix/classes/src/functions/identity.php
  53APP/Vendor/markbaker/matrix/classes/src/functions/inverse.php
  54APP/Vendor/markbaker/matrix/classes/src/functions/minors.php
  55APP/Vendor/markbaker/matrix/classes/src/functions/trace.php
  56APP/Vendor/markbaker/matrix/classes/src/functions/transpose.php
  57APP/Vendor/markbaker/matrix/classes/src/operations/add.php
  58APP/Vendor/markbaker/matrix/classes/src/operations/directsum.php
  59APP/Vendor/markbaker/matrix/classes/src/operations/subtract.php
  60APP/Vendor/markbaker/matrix/classes/src/operations/multiply.php
  61APP/Vendor/markbaker/matrix/classes/src/operations/divideby.php
  62APP/Vendor/markbaker/matrix/classes/src/operations/divideinto.php
- plugins(array)
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  Geocoder(array)
  Component(array)
  0Geocoder/Controller/Component/GeocoderComponent.php
  Media(array)
  Behavior(array)
  0Media/Model/Behavior/MediaBehavior.php
  Uploader(array)
  Behavior(array)
  0Uploader/Model/Behavior/AttachmentBehavior.php
  1Uploader/Model/Behavior/FileValidationBehavior.php
====

1521

1528

1448

1524

1526

1530

1469

1511

1513

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

production

Total Time: 29 ms Total Queries: 63 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 29 ms
Total Queries: 63 queries