| 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`) > '2025-05-23' ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC | | 18 | 18 | 0 |
| 2 | SELECT `Departement`.`id`, (CONCAT(`Departement`.`DEP`, " / ", `Departement`.`name`)) AS `Departement__numName` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `id` IN ('110110011', '140650065', '220740074', '090900090', '210050005', '210050005', '150590059', '140320032', '220690069', '030630063', '220690069', '090250025', '140310031', '060180018', '040210021', '140310031', '220420042', '090250025') ORDER BY `Departement`.`DEP` ASC | | 14 | 14 | 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`) > '2025-05-23' ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC | | 18 | 18 | 0 |
| 4 | SELECT `Region`.`id`, `Region`.`name` FROM `ExtranetFFH`.`regions` AS `Region` WHERE `id` IN ('360000136', '360000136', '310000131', '320000132', '280000128', '280000128', '340000134', '360000136', '310000131', '310000131', '310000131', '320000132', '360000136', '060000106', '320000132', '360000136', '310000131', '320000132') ORDER BY `Region`.`name` ASC | | 6 | 6 | 0 |
| 5 | SELECT `Fsession`.`id`, `Diplome`.`fsport_id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `published` = 1 AND (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) > '2025-05-23' ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC | | 18 | 18 | 0 |
| 6 | SELECT `Fsport`.`id`, `Fsport`.`name` FROM `ExtranetFFH`.`fsports` AS `Fsport` WHERE `id` IN (23, 42, 11, 2, 23, 42, 19, 6, 11, 42, 19, 23, 19, 14, 19, 19, 5, 21) ORDER BY `name` ASC | | 9 | 9 | 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`) > '2025-05-23' GROUP BY `Fsession`.`diplome_id` ORDER BY `Diplome`.`name` ASC | | 15 | 15 | 0 |
| 8 | SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2025' AND MONTH(debut) = '03' | | 13 | 13 | 0 |
| 9 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `Diplome`.`types_dip_id`, `Diplome`.`id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`published` = 1 AND `Fsession`.`cancel` IS NULL AND `Fsession`.`id` IN (2006, 2034, 2033, 2034, 2042, 2042, 2052, 2002, 2017, 2044, 2025, 2004, 2032) ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 30 | | 5 | 5 | 0 |
| 10 | SELECT `FsessionSTA`.`id`, `FsessionSTA`.`fsession_id` FROM `ExtranetFFH`.`fsessions_stagiaires` AS `FsessionSTA` WHERE `signup` != 3 AND `FsessionSTA`.`fsession_id` IN (2034, 2042, 2052, 2004, 2032) | | 38 | 38 | 0 |
| 11 | 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 (2034, 2042, 2052, 2004, 2032) | | 9 | 9 | 0 |
| 12 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220690069' | | 1 | 1 | 0 |
| 13 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220070007' | | 1 | 1 | 0 |
| 14 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '160500050' | | 1 | 1 | 0 |
| 15 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '110300030' | | 1 | 1 | 0 |
| 16 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220420042' | | 1 | 1 | 0 |
| 17 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220420042' | | 1 | 1 | 0 |
| 18 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220690069' | | 1 | 1 | 0 |
| 19 | SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2025' AND MONTH(debut) = '04' | | 10 | 10 | 0 |
| 20 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `Diplome`.`types_dip_id`, `Diplome`.`id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`published` = 1 AND `Fsession`.`cancel` IS NULL AND `Fsession`.`id` IN (2025, 2004, 2031, 2005, 2031, 2058, 2058, 2063, 2053, 2049) ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 30 | | 2 | 2 | 0 |
| 21 | SELECT `FsessionSTA`.`id`, `FsessionSTA`.`fsession_id` FROM `ExtranetFFH`.`fsessions_stagiaires` AS `FsessionSTA` WHERE `signup` != 3 AND `FsessionSTA`.`fsession_id` IN (2004, 2053) | | 14 | 14 | 0 |
| 22 | 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 (2004, 2053) | | 4 | 4 | 0 |
| 23 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220690069' | | 1 | 1 | 0 |
| 24 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220070007' | | 1 | 1 | 0 |
| 25 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '010670067' | | 1 | 1 | 0 |
| 26 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '130570057' | | 1 | 1 | 0 |
| 27 | SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2025' AND MONTH(debut) = '05' | | 10 | 10 | 0 |
| 28 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `Diplome`.`types_dip_id`, `Diplome`.`id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`published` = 1 AND `Fsession`.`cancel` IS NULL AND `Fsession`.`id` IN (1985, 2021, 2049, 2036, 2036, 2007, 2011, 2011, 2053, 2045) ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 30 | | 5 | 5 | 0 |
| 29 | SELECT `FsessionSTA`.`id`, `FsessionSTA`.`fsession_id` FROM `ExtranetFFH`.`fsessions_stagiaires` AS `FsessionSTA` WHERE `signup` != 3 AND `FsessionSTA`.`fsession_id` IN (2053, 1985, 2021, 2036, 2007) | | 378 | 378 | 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 (2053, 1985, 2021, 2036, 2007) | | 8 | 8 | 0 |
| 31 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220690069' | | 1 | 1 | 0 |
| 32 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '140310031' | | 1 | 1 | 0 |
| 33 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '010670067' | | 1 | 1 | 0 |
| 34 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '130570057' | | 1 | 1 | 0 |
| 35 | SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2025' AND MONTH(debut) = '06' | | 16 | 16 | 0 |
| 36 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `Diplome`.`types_dip_id`, `Diplome`.`id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`published` = 1 AND `Fsession`.`cancel` IS NULL AND `Fsession`.`id` IN (2007, 2041, 2038, 2041, 2051, 2048, 2051, 2048, 2013, 2014, 2013, 2014, 2014, 2064, 2042, 2064) ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 30 | | 9 | 9 | 0 |
| 37 | SELECT `FsessionSTA`.`id`, `FsessionSTA`.`fsession_id` FROM `ExtranetFFH`.`fsessions_stagiaires` AS `FsessionSTA` WHERE `signup` != 3 AND `FsessionSTA`.`fsession_id` IN (2042, 2007, 2041, 2038, 2051, 2048, 2013, 2014, 2064) | | 31 | 31 | 0 |
| 38 | SELECT `FsessionDATES`.`commune`, `FsessionDATES`.`debut`, `FsessionDATES`.`departement_id`, (CONCAT(DATE_FORMAT(`FsessionDATES`.`debut`, "%d/%m/%Y")," au ",DATE_FORMAT(`FsessionDATES`.`fin`, "%d/%m/%Y"))) AS `FsessionDATES__dates`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE `FsessionDATES`.`fsession_id` IN (2042, 2007, 2041, 2038, 2051, 2048, 2013, 2014, 2064) | | 20 | 20 | 0 |
| 39 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220690069' | | 1 | 1 | 0 |
| 40 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '210050005' | | 1 | 1 | 0 |
| 41 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '210050005' | | 1 | 1 | 0 |
| 42 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '210050005' | | 1 | 1 | 0 |
| 43 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '140650065' | | 1 | 1 | 0 |
| 44 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '110110011' | | 1 | 1 | 0 |
| 45 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220420042' | | 1 | 1 | 0 |
| 46 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220420042' | | 1 | 1 | 0 |
| 47 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '090900090' | | 1 | 1 | 0 |
| 48 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220740074' | | 1 | 1 | 0 |
| 49 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '150590059' | | 1 | 1 | 0 |
| 50 | SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2025' AND MONTH(debut) = '07' | | 4 | 4 | 0 |
| 51 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `Diplome`.`types_dip_id`, `Diplome`.`id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`published` = 1 AND `Fsession`.`cancel` IS NULL AND `Fsession`.`id` IN (2037, 2062, 2008, 2038) ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 30 | | 4 | 4 | 0 |
| 52 | SELECT `FsessionSTA`.`id`, `FsessionSTA`.`fsession_id` FROM `ExtranetFFH`.`fsessions_stagiaires` AS `FsessionSTA` WHERE `signup` != 3 AND `FsessionSTA`.`fsession_id` IN (2038, 2062, 2037, 2008) | | 12 | 12 | 0 |
| 53 | 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 (2038, 2062, 2037, 2008) | | 6 | 6 | 0 |
| 54 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '030630063' | | 1 | 1 | 0 |
| 55 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '140320032' | | 1 | 1 | 0 |
| 56 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '140650065' | | 1 | 1 | 0 |
| 57 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220690069' | | 1 | 1 | 0 |
| 58 | SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2025' AND MONTH(debut) = '08' | | 0 | 0 | 0 |
| 59 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `Diplome`.`types_dip_id`, `Diplome`.`id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`published` = 1 AND `Fsession`.`cancel` IS NULL AND `Fsession`.`id` IS NULL ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 30 | | 0 | 0 | 0 |
| 60 | SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2025' AND MONTH(debut) = '09' | | 7 | 7 | 0 |
| 61 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `Diplome`.`types_dip_id`, `Diplome`.`id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`published` = 1 AND `Fsession`.`cancel` IS NULL AND `Fsession`.`id` IN (2046, 2046, 2062, 2054, 2039, 2039, 2054) ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 30 | | 4 | 4 | 0 |
| 62 | SELECT `FsessionSTA`.`id`, `FsessionSTA`.`fsession_id` FROM `ExtranetFFH`.`fsessions_stagiaires` AS `FsessionSTA` WHERE `signup` != 3 AND `FsessionSTA`.`fsession_id` IN (2062, 2046, 2054, 2039) | | 5 | 5 | 0 |
| 63 | 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 (2062, 2046, 2054, 2039) | | 8 | 8 | 0 |
| 64 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '140310031' | | 1 | 1 | 0 |
| 65 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220690069' | | 1 | 1 | 0 |
| 66 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '090250025' | | 1 | 1 | 0 |
| 67 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '220690069' | | 1 | 1 | 0 |
| 68 | SELECT `FsessionDATES`.`id`, `FsessionDATES`.`fsession_id` FROM `ExtranetFFH`.`fsessions_dates` AS `FsessionDATES` WHERE YEAR(debut) = '2025' AND MONTH(debut) = '10' | | 6 | 6 | 0 |
| 69 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`traduction_lsf`, `Diplome`.`name`, `Diplome`.`types_dip_id`, `Diplome`.`id` FROM `ExtranetFFH`.`fsessions` AS `Fsession` LEFT JOIN `ExtranetFFH`.`diplomes` AS `Diplome` ON (`Fsession`.`diplome_id` = `Diplome`.`id`) WHERE `Fsession`.`published` = 1 AND `Fsession`.`cancel` IS NULL AND `Fsession`.`id` IN (2065, 2068, 2065, 2066, 2066, 2056) ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 30 | | 2 | 2 | 0 |
| 70 | SELECT `FsessionSTA`.`id`, `FsessionSTA`.`fsession_id` FROM `ExtranetFFH`.`fsessions_stagiaires` AS `FsessionSTA` WHERE `signup` != 3 AND `FsessionSTA`.`fsession_id` IN (2066, 2056) | | 0 | 0 | 0 |
| 71 | 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 (2066, 2056) | | 4 | 4 | 0 |
| 72 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '040210021' | | 1 | 1 | 0 |
| 73 | SELECT `Departement`.`DEP` FROM `ExtranetFFH`.`departements` AS `Departement` WHERE `Departement`.`id` = '060180018' | | 1 | 1 | 0 |
| 74 | 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`) >= '2025-05-23' ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC | | 18 | 18 | 0 |
| 75 | SELECT `Fsession`.`id`, `Fsession`.`type`, `Fsession`.`vae`, `Fsession`.`region_id`, `Fsession`.`departement_id`, `Fsession`.`structure_id`, `Fsession`.`diplome_id`, `Fsession`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2034 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2042 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2052 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2004 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2032 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2053 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 1985 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2021 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2036 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2007 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2041 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2051 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2048 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2013 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2014 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2064 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2038 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2037 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2008 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2062 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2046 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2054 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2039 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`.`moodle_course_id`, `Fsession`.`user_create_id`, `Fsession`.`user_modify_id`, `Fsession`.`submited_user_id`, `Fsession`.`code`, `Fsession`.`name`, `Fsession`.`debut`, `Fsession`.`fin`, `Fsession`.`contact`, `Fsession`.`contact_tel`, `Fsession`.`contact_email`, `Fsession`.`PresencePersonneH`, `Fsession`.`TypePresencePersonneH`, `Fsession`.`infos_calendar`, `Fsession`.`commentaires`, `Fsession`.`created`, `Fsession`.`modified`, `Fsession`.`archived`, `Fsession`.`submited`, `Fsession`.`certified`, `Fsession`.`cancel`, `Fsession`.`cancel_categorie`, `Fsession`.`cancel_details`, `Fsession`.`canceled_user_id`, `Fsession`.`canceled`, `Fsession`.`certified_number`, `Fsession`.`certified_user_id`, `Fsession`.`report`, `Fsession`.`published`, `Fsession`.`finish`, `Fsession`.`commentaires_GF`, `Fsession`.`nb_stag_max`, `Fsession`.`volume_hr`, `Fsession`.`mds_urlPdf`, `Fsession`.`mdsevent_id`, `Fsession`.`traduction_lsf`, `Fsession`.`tarif_reduit`, `Fsession`.`tarif_plein`, `Fsession`.`licence_derogation`, `Fsession`.`validate_pedagogy`, `Fsession`.`validate_pedagogy_date`, `Fsession`.`validate_pedagogy_user_id`, (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 SUBSTR(MIN(`fsessions_dates`.`debut`),1,7) FROM fsessions_dates where fsession_id = `Fsession`.`id`) AS `Fsession__year_month_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 CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Fsession`.`validate_pedagogy_user_id`) AS `Fsession__UVPY`, (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` = 2066 ORDER BY (SELECT MIN(`fsessions_dates`.`debut`) FROM fsessions_dates where fsession_id = `Fsession`.`id`) ASC LIMIT 1 | | 1 | 1 | 0 |
| 99 | SELECT `Diplome`.`id`, `Diplome`.`name` FROM `ExtranetFFH`.`diplomes` AS `Diplome` WHERE `active` = 1 AND `thematique_id` = 1 ORDER BY `Diplome`.`name` ASC | | 140 | 140 | 0 |
| 100 | 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
