Entry 392

SELECT 1 FROM lateral(values(1)) z 
where exists (
         select 1 
         from NYA.PICKED_COURSE_OFFERING PCO
         INNER JOIN NYA.COURSE_OFFERING CO
                 ON (PCO.ADMISSIONROUND_ID, PCO.EDUCATIONORG_ID, PCO.COURSEOFFERING_ID)
                 =  (CO.ADMISSIONROUND_ID, CO.EDUCATIONORG_ID, CO.COURSEOFFERING_ID)
         WHERE PCO.ADMISSIONROUND_ID = 'HT2007'
         AND CO.CANCELDATE IS NULL
         AND PCO.PROCESS_STATE_ID <> 70
         AND NOT EXISTS (
                 SELECT 1 FROM NYA.PICKED_COURSE_OFFERING_MEASURE PCOM 
                 WHERE PCO.PERSON_ID = PCOM.PERSON_ID
                 AND PCO.ADMISSIONROUND_ID = PCOM.ADMISSIONROUND_ID 
                 AND PCO.COURSEOFFERING_ID = PCOM.COURSEOFFERING_ID 
                 AND PCO.EDUCATIONORG_ID = PCOM.EDUCATIONORG_ID
                 AND PCO.WITHIN_PROGRAM = PCOM.WITHIN_PROGRAM
                 AND PCOM.MEASURE_ID = 'AN023' AND PCOM.STATE = 1
         )
)