select a.id_application
      from  (SELECT * FROM t_mission as PM
         LEFT JOIN t_mission_raf rm on PM.id_mission= rm.id_rm
        LEFT JOIN t_mission_roles AS mr ON PM.id_mission = mr.id_mission
        LEFT JOIN t_role AS r ON r.id_role = mr.id_role
        LEFT JOIN t_appli AS app ON app.id_application = r.id_application
         WHERE PM.type_mission = 1 AND PM.id_mission =24730) as a