| 1 | SELECT `Fsession`.`id`, `Fsession`.`departement_id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` WHERE `published` = 1 AND (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) > '2018-08-19' ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC | | 40 | 40 | 0 |
| 2 | SELECT `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` ASC | | 18 | 18 | 0 |
| 3 | SELECT `Fsession`.`id`, `Fsession`.`region_id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` WHERE `published` = 1 AND (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) > '2018-08-19' ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC | | 40 | 40 | 0 |
| 4 | SELECT `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` ASC | | 11 | 11 | 0 |
| 5 | SELECT `Fsession`.`id`, `Diplome`.`fsport_id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `published` = 1 AND (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) > '2018-08-19' ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC | | 40 | 40 | 0 |
| 6 | SELECT `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` ASC | | 10 | 10 | 0 |
| 7 | SELECT `Diplome`.`id`, `Diplome`.`name` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`published` = 1 AND (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) > '2018-08-19' GROUP BY `Fsession`.`diplome_id` ORDER BY `Diplome`.`name` ASC | | 20 | 20 | 0 |
| 8 | SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2018' AND MONTH(debut) = '06' AND `debut` > '2018-08-19' | | 0 | 0 | 0 |
| 9 | SELECT `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 30 | | 0 | 0 | 0 |
| 10 | SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2018' AND MONTH(debut) = '07' AND `debut` > '2018-08-19' | | 0 | 0 | 0 |
| 11 | SELECT `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 30 | | 0 | 0 | 0 |
| 12 | SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2018' AND MONTH(debut) = '08' AND `debut` > '2018-08-19' | | 0 | 0 | 0 |
| 13 | SELECT `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 30 | | 0 | 0 | 0 |
| 14 | SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2018' AND MONTH(debut) = '09' AND `debut` > '2018-08-19' | | 8 | 8 | 0 |
| 15 | SELECT `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 30 | | 8 | 8 | 0 |
| 16 | SELECT `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) | | 90 | 90 | 0 |
| 17 | SELECT `FsessionDATES`.`commune`, `FsessionDATES`.`debut`, `FsessionDATES`.`departement_id`, (CONCAT(DATE_FORMAT(`FsessionDATES`.`debut`, "%d/%m/%Y")," au ",DATE_FORMAT(`FsessionDATES`.`fin`, "%d/%m/%Y"))) AS `FsessionDATES__dates`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE `FsessionDATES`.`fsession_id` IN (1163, 1178, 1180, 1181, 1126, 1205, 1179, 1182) | | 9 | 9 | 0 |
| 18 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '090250025' | | 1 | 1 | 0 |
| 19 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '130540054' | | 1 | 1 | 0 |
| 20 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '130540054' | | 1 | 1 | 0 |
| 21 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220010001' | | 1 | 1 | 0 |
| 22 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '050350035' | | 1 | 1 | 0 |
| 23 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '140320032' | | 1 | 1 | 0 |
| 24 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '150590059' | | 1 | 1 | 0 |
| 25 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '040710071' | | 1 | 1 | 0 |
| 26 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100940094' | | 1 | 1 | 0 |
| 27 | SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2018' AND MONTH(debut) = '10' AND `debut` > '2018-08-19' | | 10 | 10 | 0 |
| 28 | SELECT `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 30 | | 9 | 9 | 0 |
| 29 | SELECT `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) | | 10 | 10 | 0 |
| 30 | SELECT `FsessionDATES`.`commune`, `FsessionDATES`.`debut`, `FsessionDATES`.`departement_id`, (CONCAT(DATE_FORMAT(`FsessionDATES`.`debut`, "%d/%m/%Y")," au ",DATE_FORMAT(`FsessionDATES`.`fin`, "%d/%m/%Y"))) AS `FsessionDATES__dates`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE `FsessionDATES`.`fsession_id` IN (1175, 1195, 1159, 1172, 1217, 1197, 1206, 1187, 1196) | | 10 | 10 | 0 |
| 31 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220420042' | | 1 | 1 | 0 |
| 32 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '070510051' | | 1 | 1 | 0 |
| 33 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '180440044' | | 1 | 1 | 0 |
| 34 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '300060006' | | 1 | 1 | 0 |
| 35 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '180440044' | | 1 | 1 | 0 |
| 36 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '180440044' | | 1 | 1 | 0 |
| 37 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100940094' | | 1 | 1 | 0 |
| 38 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100940094' | | 1 | 1 | 0 |
| 39 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075' | | 1 | 1 | 0 |
| 40 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '040580058' | | 1 | 1 | 0 |
| 41 | SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2018' AND MONTH(debut) = '11' AND `debut` > '2018-08-19' | | 7 | 7 | 0 |
| 42 | SELECT `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 30 | | 7 | 7 | 0 |
| 43 | SELECT `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) | | 3 | 3 | 0 |
| 44 | SELECT `FsessionDATES`.`commune`, `FsessionDATES`.`debut`, `FsessionDATES`.`departement_id`, (CONCAT(DATE_FORMAT(`FsessionDATES`.`debut`, "%d/%m/%Y")," au ",DATE_FORMAT(`FsessionDATES`.`fin`, "%d/%m/%Y"))) AS `FsessionDATES__dates`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE `FsessionDATES`.`fsession_id` IN (1197, 1192, 1216, 1171, 1146, 1214, 1189) | | 10 | 10 | 0 |
| 45 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '020330033' | | 1 | 1 | 0 |
| 46 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '300830083' | | 1 | 1 | 0 |
| 47 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '300830083' | | 1 | 1 | 0 |
| 48 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075' | | 1 | 1 | 0 |
| 49 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '020330033' | | 1 | 1 | 0 |
| 50 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100940094' | | 1 | 1 | 0 |
| 51 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100940094' | | 1 | 1 | 0 |
| 52 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220690069' | | 1 | 1 | 0 |
| 53 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220690069' | | 1 | 1 | 0 |
| 54 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220690069' | | 1 | 1 | 0 |
| 55 | SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2018' AND MONTH(debut) = '12' AND `debut` > '2018-08-19' | | 5 | 5 | 0 |
| 56 | SELECT `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 30 | | 5 | 5 | 0 |
| 57 | SELECT `FsessionSTA`.`id`, `FsessionSTA`.`fsession_id` FROM `ExtranetFFH`.`fsessions_stagiaires` AS `FsessionSTA` WHERE `signup` != 3 AND `FsessionSTA`.`fsession_id` IN (1214, 1147, 1193, 1143, 1208) | | 5 | 5 | 0 |
| 58 | SELECT `FsessionDATES`.`commune`, `FsessionDATES`.`debut`, `FsessionDATES`.`departement_id`, (CONCAT(DATE_FORMAT(`FsessionDATES`.`debut`, "%d/%m/%Y")," au ",DATE_FORMAT(`FsessionDATES`.`fin`, "%d/%m/%Y"))) AS `FsessionDATES__dates`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE `FsessionDATES`.`fsession_id` IN (1214, 1147, 1193, 1143, 1208) | | 6 | 6 | 0 |
| 59 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220730073' | | 1 | 1 | 0 |
| 60 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '020330033' | | 1 | 1 | 0 |
| 61 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '160140014' | | 1 | 1 | 0 |
| 62 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075' | | 1 | 1 | 0 |
| 63 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220690069' | | 1 | 1 | 0 |
| 64 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220690069' | | 1 | 1 | 0 |
| 65 | SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2019' AND MONTH(debut) = '01' AND `debut` > '2018-08-19' | | 4 | 4 | 0 |
| 66 | SELECT `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 30 | | 3 | 3 | 0 |
| 67 | SELECT `FsessionSTA`.`id`, `FsessionSTA`.`fsession_id` FROM `ExtranetFFH`.`fsessions_stagiaires` AS `FsessionSTA` WHERE `signup` != 3 AND `FsessionSTA`.`fsession_id` IN (1200, 1174, 1188) | | 0 | 0 | 0 |
| 68 | SELECT `FsessionDATES`.`commune`, `FsessionDATES`.`debut`, `FsessionDATES`.`departement_id`, (CONCAT(DATE_FORMAT(`FsessionDATES`.`debut`, "%d/%m/%Y")," au ",DATE_FORMAT(`FsessionDATES`.`fin`, "%d/%m/%Y"))) AS `FsessionDATES__dates`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE `FsessionDATES`.`fsession_id` IN (1200, 1174, 1188) | | 3 | 3 | 0 |
| 69 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '130540054' | | 1 | 1 | 0 |
| 70 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075' | | 1 | 1 | 0 |
| 71 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '100750075' | | 1 | 1 | 0 |
| 72 | SELECT `Fsession`.`id`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `Diplome`.`id`, (SELECT `fsessions_dates`.`commune` FROM fsessions_dates where fsession_id = `Fsession`.`id` limit 0,1) AS `Fsession__commune`, (SELECT MAX(`fsessions_dates`.`fin`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__max_date`, (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__min_date`, (SELECT MIN(`fsessions_dates`.`latitude`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__lat`, (SELECT MIN(`fsessions_dates`.`longitude`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__long` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`published` = 1 AND (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) >= '2018-08-19' ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC | | 40 | 40 | 0 |
| 73 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 74 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 75 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 76 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 77 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 78 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 79 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 80 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 81 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 82 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 83 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 84 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 85 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 86 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 87 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 88 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 89 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 90 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 91 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 92 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 93 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 94 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 95 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 96 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 97 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 98 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 99 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 100 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 101 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, (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 1 | | 1 | 1 | 0 |
| 102 | SELECT `Diplome`.`id`, `Diplome`.`name` FROM `ExtranetFFH`.`diplomes` AS `Diplome` WHERE `active` = 1 AND `thematique_id` = 1 ORDER BY `Diplome`.`name` ASC | | 54 | 54 | 0 |
| 103 | SELECT `Departement`.`id`, (CONCAT(`Departement`.`DEP`, " / ", `Departement`.`name`)) AS `Departement__numName` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE 1 = 1 ORDER BY (CONCAT(`Departement`.`DEP`, " / ", `Departement`.`name`)) ASC | | 105 | 105 | 0 |
Développé par la Fédération Française Handisport 2016 Version 3.0
Webmaster : extranet@handisport.org
