OAR::IO::get_gantt_jobs_to_launch question about oar HOT 3 CLOSED

SELECT g2.moldable_job_id, g1.resource_id, j.job_id
                FROM gantt_jobs_resources g1, gantt_jobs_predictions g2, jobs j, moldable_job_descriptions m, resources r
                WHERE
                    m.moldable_index = \'CURRENT\'
                    AND g1.moldable_job_id = g2.moldable_job_id
                    AND m.moldable_id = g1.moldable_job_id
                    AND j.job_id = m.moldable_job_id
                    AND g2.start_time <= $date
                    AND j.state = \'Waiting\'
                    AND r.resource_id = g1.resource_id
                    AND r.state = \'Alive\'
                    AND NOT EXISTS ( 
                        SELECT 1 
                        FROM resources rr, gantt_jobs_resources g
                        WHERE g.moldable_job_id = g1.moldable_job_id
                            AND rr.resource_id = g.resource_id 
                            AND ( rr.state IN (\'Dead\',\'Suspected\',\Absent\')
                            OR rr.next_state IN (\'Dead\',\'Suspected\',\Absent\') )
                    )