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
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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`) ASC14144
2SELECT `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` ASC990
3SELECT `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`) ASC14144
4SELECT `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` ASC660
5SELECT `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`) ASC14144
6SELECT `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` ASC770
7SELECT `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` ASC13134
8SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2020' AND MONTH(debut) = '04' AND `debut` > '2020-06-03'000
9SELECT `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 30000
10SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2020' AND MONTH(debut) = '05' AND `debut` > '2020-06-03'000
11SELECT `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 30000
12SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2020' AND MONTH(debut) = '06' AND `debut` > '2020-06-03'440
13SELECT `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 30000
14SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2020' AND MONTH(debut) = '07' AND `debut` > '2020-06-03'110
15SELECT `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 30110
16SELECT `FsessionSTA`.`id`, `FsessionSTA`.`fsession_id` FROM `ExtranetFFH`.`fsessions_stagiaires` AS `FsessionSTA` WHERE `signup` != 3 AND `FsessionSTA`.`fsession_id` = (1521)660
17SELECT `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)110
18SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '030630063'110
19SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2020' AND MONTH(debut) = '08' AND `debut` > '2020-06-03'000
20SELECT `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 30000
21SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2020' AND MONTH(debut) = '09' AND `debut` > '2020-06-03'880
22SELECT `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 30550
23SELECT `FsessionSTA`.`id`, `FsessionSTA`.`fsession_id` FROM `ExtranetFFH`.`fsessions_stagiaires` AS `FsessionSTA` WHERE `signup` != 3 AND `FsessionSTA`.`fsession_id` IN (1528, 1448, 1524, 1526, 1530)330
24SELECT `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)10100
25SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '090250025'110
26SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '050350035'110
27SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '040710071'110
28SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'110
29SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'110
30SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'110
31SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'110
32SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'110
33SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'110
34SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'110
35SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2020' AND MONTH(debut) = '10' AND `debut` > '2020-06-03'440
36SELECT `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 30330
37SELECT `FsessionSTA`.`id`, `FsessionSTA`.`fsession_id` FROM `ExtranetFFH`.`fsessions_stagiaires` AS `FsessionSTA` WHERE `signup` != 3 AND `FsessionSTA`.`fsession_id` IN (1469, 1511, 1513)440
38SELECT `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)330
39SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '040210021'110
40SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '210050005'110
41SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '020330033'110
42SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2020' AND MONTH(debut) = '11' AND `debut` > '2020-06-03'770
43SELECT `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 30110
44SELECT `FsessionSTA`.`id`, `FsessionSTA`.`fsession_id` FROM `ExtranetFFH`.`fsessions_stagiaires` AS `FsessionSTA` WHERE `signup` != 3 AND `FsessionSTA`.`fsession_id` = (1530)000
45SELECT `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)660
46SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'110
47SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'110
48SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'110
49SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'110
50SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'110
51SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'110
52SELECT `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`) ASC15154
53SELECT `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 1111
54SELECT `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 1111
55SELECT `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 1111
56SELECT `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 1111
57SELECT `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 1111
58SELECT `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 1111
59SELECT `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 1111
60SELECT `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 1111
61SELECT `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 1111
62SELECT `Diplome`.`id`, `Diplome`.`name` FROM `ExtranetFFH`.`diplomes` AS `Diplome` WHERE `active` = 1 AND `thematique_id` = 1 ORDER BY `Diplome`.`name` ASC1031030
63SELECT `Departement`.`id`, (CONCAT(`Departement`.`DEP`, " / ", `Departement`.`name`)) AS `Departement__numName` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE 1 = 1 ORDER BY (CONCAT(`Departement`.`DEP`, " / ", `Departement`.`name`)) ASC1051050