RECHERCHER


Effacer critère
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

1178

Arbitre fédéral Basket-ball 14/09/2018 au 16/09/2018 MEXIMIEUX (01)

1180

Arbitre régional Basket-ball 21/09/2018 au 23/09/2018 AUCH (32)

1181

Arbitre régional Basket-ball 21/09/2018 au 23/09/2018 LILLE (59)

1126

Accompagnateur Randonnée 22/09/2018 au 23/09/2018 METABIEF (25)

1205

Abécédaire Polyvalent 25/09/2018 au 26/09/2018 CRETEIL (94)

1179

Arbitre régional Basket-ball 28/09/2018 au 30/09/2018 RENNES (35)

1182

Arbitre régional Basket-ball 28/09/2018 au 30/09/2018 CHALON SUR SAONE (71)

1175

Abécédaire Polyvalent 05/10/2018 au 06/10/2018 NANTES (44)

1195

Moniteur Athlétisme 08/10/2018 au 12/10/2018 NANTES (44)

1159

Abécédaire Polyvalent 11/10/2018 au 12/10/2018 ST ETIENNE (42)

1172

Abécédaire Polyvalent 13/10/2018 au 14/10/2018 REIMS (51)

1217

Abécédaire Polyvalent 13/10/2018 au 14/10/2018 VARENNES VAUZELLES (58)

1197

Moniteur - Multidisciplinaire 15/10/2018 au 17/10/2018 et ... CRETEIL et ...

1206

Abécédaire Polyvalent 17/10/2018 au 18/10/2018 PARIS (75)

1187

Abécédaire Polyvalent 26/10/2018 au 27/10/2018 MANDELIEU LA NAPOULE (06)

1196

C.Q.H. - Golf 29/10/2018 au 02/11/2018 NANTES (44)

1192

Moniteur Basket-Ball 05/11/2018 au 09/11/2018 TALENCE (33)

1216

Moniteur Escalade 05/11/2018 au 08/11/2018 DARDILLY (69)

1171

Moniteur Boccia 09/11/2018 au 11/11/2018 et ... HYERES et ...

1146

Moniteur Natation 12/11/2018 au 16/11/2018 TALENCE (33)

1214

Abécédaire Polyvalent 24/11/2018 au 24/11/2018 et ... DARDILLY et ...

1189

Moniteur Natation 26/11/2018 au 30/11/2018 PARIS (75)

1147

C.Q.H. - Natation 03/12/2018 au 07/12/2018 TALENCE (33)

1193

Moniteur Basket-Ball 14/12/2018 au 18/12/2018 TROUVILLE SUR MER (14)

1143

Accompagnateur Ski Alpin 17/12/2018 au 20/12/2018 TIGNES (73)

1208

Abécédaire Polyvalent 18/12/2018 au 19/12/2018 PARIS (75)

1200

Formaliser un projet de développement Handisport 14/01/2019 au 15/01/2019 PARIS (75)

1174

Arbitre fédéral Boccia 19/01/2019 au 20/01/2019 TOMBLAINE (54)

1188

Moniteur Athlétisme 21/01/2019 au 25/01/2019 PARIS (75)


(production) 103 queries took 0 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`) > '2018-08-19' ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC40400
2SELECT `Departement`.`id`, (CONCAT(`Departement`.`DEP`, " / ", `Departement`.`name`)) AS `Departement__numName` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `id` IN ('220010001', '140320032', '150590059', '090250025', '100750075', '040710071', '050350035', '180440044', '180440044', '220420042', '040580058', '070510051', '100940094', '100750075', '300060006', '180440044', '020330033', '220690069', '300830083', '020330033', '220690069', '100750075', '020330033', '020330033', '220730073', '100750075', '100750075', '130540054', '100750075', '100750075', '100750075', '100750075', '100750075', '020330033', '220690069', '100750075', '100750075', '100750075', '100750075', '100750075') ORDER BY `Departement`.`DEP` ASC18180
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`) > '2018-08-19' ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC40400
4SELECT `Region`.`id`, `Region`.`name` FROM `ExtranetFFH`.`regions` AS `Region` WHERE `id` IN ('310000131', '360000136', '150000115', '090000109', '100000110', '040000104', '050000105', '180000118', '180000118', '310000131', '040000104', '330000133', '100000110', '100000110', '280000128', '180000118', '350000135', '310000131', '280000128', '350000135', '310000131', '100000110', '350000135', '350000135', '310000131', '100000110', '100000110', '330000133', '100000110', '100000110', '100000110', '100000110', '100000110', '350000135', '310000131', '100000110', '100000110', '100000110', '100000110', '100000110') ORDER BY `Region`.`name` ASC11110
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`) > '2018-08-19' ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC40400
6SELECT `Fsport`.`id`, `Fsport`.`name` FROM `ExtranetFFH`.`fsports` AS `Fsport` WHERE `id` IN (5, 5, 5, 23, 19, 5, 5, 19, 2, 19, 19, 19, 19, 19, 19, 38, 5, 13, 6, 21, 19, 21, 21, 5, 26, 19, 0, 6, 2, 0, 19, 0, 19, 5, 19, 19, 31, 19, 0, 0) ORDER BY `name` ASC10100
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`) > '2018-08-19' GROUP BY `Fsession`.`diplome_id` ORDER BY `Diplome`.`name` ASC20200
8SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2018' AND MONTH(debut) = '06' AND `debut` > '2018-08-19'000
9SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `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) = '2018' AND MONTH(debut) = '07' AND `debut` > '2018-08-19'000
11SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `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) = '2018' AND MONTH(debut) = '08' AND `debut` > '2018-08-19'000
13SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `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
14SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2018' AND MONTH(debut) = '09' AND `debut` > '2018-08-19'880
15SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `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 (1178, 1180, 1181, 1126, 1205, 1163, 1179, 1182) ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 30880
16SELECT `FsessionSTA`.`id`, `FsessionSTA`.`fsession_id` FROM `ExtranetFFH`.`fsessions_stagiaires` AS `FsessionSTA` WHERE `signup` != 3 AND `FsessionSTA`.`fsession_id` IN (1163, 1178, 1180, 1181, 1126, 1205, 1179, 1182)90900
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` IN (1163, 1178, 1180, 1181, 1126, 1205, 1179, 1182)990
18SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '090250025'110
19SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '130540054'110
20SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '130540054'110
21SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220010001'110
22SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '050350035'110
23SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '140320032'110
24SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '150590059'110
25SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '040710071'110
26SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100940094'110
27SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2018' AND MONTH(debut) = '10' AND `debut` > '2018-08-19'10100
28SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `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 (1175, 1198, 1195, 1159, 1172, 1217, 1197, 1206, 1187, 1196) ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 30990
29SELECT `FsessionSTA`.`id`, `FsessionSTA`.`fsession_id` FROM `ExtranetFFH`.`fsessions_stagiaires` AS `FsessionSTA` WHERE `signup` != 3 AND `FsessionSTA`.`fsession_id` IN (1175, 1195, 1159, 1172, 1217, 1197, 1206, 1187, 1196)10100
30SELECT `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 (1175, 1195, 1159, 1172, 1217, 1197, 1206, 1187, 1196)10100
31SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220420042'110
32SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '070510051'110
33SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '180440044'110
34SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '300060006'110
35SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '180440044'110
36SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '180440044'110
37SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100940094'110
38SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100940094'110
39SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'110
40SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '040580058'110
41SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2018' AND MONTH(debut) = '11' AND `debut` > '2018-08-19'770
42SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `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 (1216, 1192, 1171, 1197, 1146, 1214, 1189) ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 30770
43SELECT `FsessionSTA`.`id`, `FsessionSTA`.`fsession_id` FROM `ExtranetFFH`.`fsessions_stagiaires` AS `FsessionSTA` WHERE `signup` != 3 AND `FsessionSTA`.`fsession_id` IN (1197, 1192, 1216, 1171, 1146, 1214, 1189)330
44SELECT `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 (1197, 1192, 1216, 1171, 1146, 1214, 1189)10100
45SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '020330033'110
46SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '300830083'110
47SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '300830083'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` = '020330033'110
50SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100940094'110
51SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100940094'110
52SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220690069'110
53SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220690069'110
54SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220690069'110
55SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2018' AND MONTH(debut) = '12' AND `debut` > '2018-08-19'550
56SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `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 (1214, 1147, 1193, 1143, 1208) ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 30550
57SELECT `FsessionSTA`.`id`, `FsessionSTA`.`fsession_id` FROM `ExtranetFFH`.`fsessions_stagiaires` AS `FsessionSTA` WHERE `signup` != 3 AND `FsessionSTA`.`fsession_id` IN (1214, 1147, 1193, 1143, 1208)550
58SELECT `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 (1214, 1147, 1193, 1143, 1208)660
59SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220730073'110
60SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '020330033'110
61SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '160140014'110
62SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'110
63SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220690069'110
64SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220690069'110
65SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2019' AND MONTH(debut) = '01' AND `debut` > '2018-08-19'440
66SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `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 (1204, 1200, 1174, 1188) ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 30330
67SELECT `FsessionSTA`.`id`, `FsessionSTA`.`fsession_id` FROM `ExtranetFFH`.`fsessions_stagiaires` AS `FsessionSTA` WHERE `signup` != 3 AND `FsessionSTA`.`fsession_id` IN (1200, 1174, 1188)000
68SELECT `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 (1200, 1174, 1188)330
69SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '130540054'110
70SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'110
71SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075'110
72SELECT `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`) >= '2018-08-19' ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC40400
73SELECT `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`, (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` = 1178 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
74SELECT `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`, (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` = 1180 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
75SELECT `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`, (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` = 1181 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
76SELECT `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`, (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` = 1126 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
77SELECT `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`, (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` = 1205 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
78SELECT `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`, (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` = 1179 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
79SELECT `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`, (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` = 1182 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
80SELECT `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`, (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` = 1175 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
81SELECT `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`, (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` = 1195 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
82SELECT `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`, (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` = 1159 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
83SELECT `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`, (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` = 1172 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
84SELECT `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`, (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` = 1217 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
85SELECT `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`, (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` = 1197 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
86SELECT `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`, (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` = 1206 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
87SELECT `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`, (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` = 1187 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
88SELECT `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`, (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` = 1196 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
89SELECT `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`, (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` = 1192 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
90SELECT `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`, (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` = 1216 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
91SELECT `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`, (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` = 1171 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
92SELECT `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`, (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` = 1146 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
93SELECT `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`, (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` = 1214 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
94SELECT `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`, (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` = 1189 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
95SELECT `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`, (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` = 1147 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
96SELECT `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`, (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` = 1193 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
97SELECT `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`, (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` = 1143 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
98SELECT `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`, (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` = 1208 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
99SELECT `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`, (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` = 1200 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
100SELECT `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`, (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` = 1174 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
101SELECT `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`, (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` = 1188 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1110
102SELECT `Diplome`.`id`, `Diplome`.`name` FROM `ExtranetFFH`.`diplomes` AS `Diplome` WHERE `active` = 1 AND `thematique_id` = 1 ORDER BY `Diplome`.`name` ASC54540
103SELECT `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