going to query db with this query : SELECT FORMATION_code, FORMATION_titre, FORMATION_R_duree_J, FORMATION_objectif, FORMATION_participants, FORMATION_programme, FORMATION_prerequis, FORMATION_moyens, FORMATION_cpf, prestation.ID_PRESTATION AS numero_session, min(PRESTATION_JOUR_LIEU_date) as DEBUT, max(PRESTATION_JOUR_LIEU_date) as FIN, FORMATION_moyeneval, FORMATION_modalite_acc_ph FROM formation INNER JOIN PRESTATION ON PRESTATION.ID_FORMATION = formation.ID_FORMATION INNER JOIN prestation_jour_lieu ON prestation.ID_PRESTATION = prestation_jour_lieu.ID_PRESTATION AND prestation_jour_lieu.PRESTATION_JOUR_LIEU_diffusion=1 AND PRESTATION_JOUR_LIEU_date>now() WHERE formation.ID_FORMATION=48 GROUP BY prestation.ID_PRESTATION ORDER BY DEBUT