SELECT --+FIRST_ROWS
RESULT_XML,
INSTITUTION_ID,
SERVICE_CODE,
SERVICE_SYS_ID,
PHYSIOLOGIC_TIME
FROM SPEXTRACT_WORK
INNER JOIN MULTIMEDIA_CONTENT
USING(INSTITUTION_ID, MULTIMEDIA_CONTENT_ID)
INNER JOIN (
SELECT MEDICAL_ORDER_ID,
PATIENT_ID,
SERVICE_CODE,
SERVICE_SYS_ID,
PHYSIOLOGIC_TIME
FROM MEDICAL_ORDER
) USING(MEDICAL_ORDER_ID)
WHERE STATUS='FINISHED'
AND MULTIMEDIA_CONTENT_ID >=
AND ( SERVICE_SYS_ID=1 AND SERVICE_CODE IN (''
, '
'
) )
AND PATIENT_ID =
AND MEDICAL_ORDER_ID =
AND INSTITUTION_ID =