SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1902717' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/argo-trajectory-1902717.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3901830' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/argo-trajectory-3901830.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3901939' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/argo-trajectory-3901939.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3901969' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/argo-trajectory-3901969.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3901998' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/argo-trajectory-3901998.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3902472' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/argo-trajectory-3902472.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4902654' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/argo-trajectory-4902654.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4903800' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/argo-trajectory-4903800.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5906246' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/argo-trajectory-5906246.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6904138' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/argo-trajectory-6904138.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6904206' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/argo-trajectory-6904206.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6904227' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/argo-trajectory-6904227.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900503' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/argo-trajectory-7900503.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900505' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/argo-trajectory-7900505.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7901113' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/argo-trajectory-7901113.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601749' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/drifting-buoys-1601749.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4804058' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/drifting-buoys-4804058.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6801794' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/drifting-buoys-6801794.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2GLI9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-2GLI9.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2HDF9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-2HDF9.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2JUNJ5J' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-2JUNJ5J.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2KGEW3Q' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-2KGEW3Q.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3E2382' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-3E2382.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3EFK6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-3EFK6.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3ERG5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-3ERG5.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3FAR9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-3FAR9.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3FPV6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-3FPV6.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3FWH8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-3FWH8.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5LKN3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-5LKN3.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5LSO7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-5LSO7.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5MGXH3D' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-5MGXH3D.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7KDT' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-7KDT.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7NC9H6B' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-7NC9H6B.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9HA3973' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-9HA3973.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9HA4240' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-9HA4240.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9HA4876' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-9HA4876.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9HA4974' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-9HA4974.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9HA4987' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-9HA4987.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9HA6068' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-9HA6068.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9V3912' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-9V3912.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9V5244' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-9V5244.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9V5246' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-9V5246.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9V6459' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-9V6459.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9V6841' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-9V6841.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9V9375' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-9V9375.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9V9399' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-9V9399.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9V9400' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-9V9400.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9V9917' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-9V9917.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9VFV4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-9VFV4.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='A8VP8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-A8VP8.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='AHXS2YR' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-AHXS2YR.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='ARVPSCA' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-ARVPSCA.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='AZGM4MC' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-AZGM4MC.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='BHJH' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-BHJH.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='C6CG4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-C6CG4.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='CCVCVLC' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-CCVCVLC.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='CFPNY8Y' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-CFPNY8Y.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='DUUFU3N' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-DUUFU3N.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='ENDJTLV' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-ENDJTLV.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='KBYV56K' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-KBYV56K.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='KHVEVKQ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-KHVEVKQ.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='KUL7SEK' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-KUL7SEK.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='LAQM7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-LAQM7.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='LAQO7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-LAQO7.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='LWHWD2N' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-LWHWD2N.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='LZGZ56S' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-LZGZ56S.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='MRVWWQV' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-MRVWWQV.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='NAXMCDF' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-NAXMCDF.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='NSSZH9D' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-NSSZH9D.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='ONLX' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-ONLX.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='OWRS2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-OWRS2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='OZFW2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-OZFW2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='RLJY5YZ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-RLJY5YZ.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='SJGS5AE' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-SJGS5AE.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='TBAGLYM' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-TBAGLYM.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='TNVXRHV' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-TNVXRHV.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='TWQZHTC' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-TWQZHTC.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='V7A2148' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-V7A2148.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='V7A5099' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-V7A5099.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='V7A5868' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-V7A5868.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='V7A6440' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-V7A6440.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='V7A6441' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-V7A6441.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='V7A6442' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-V7A6442.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='V7A6497' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-V7A6497.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='V7WS5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-V7WS5.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='V7ZZ6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-V7ZZ6.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VRKX8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-VRKX8.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VRLA6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-VRLA6.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VRLJ3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-VRLJ3.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VRLN5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-VRLN5.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VROX2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-VROX2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VRPJ7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-VRPJ7.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VRRB6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-VRRB6.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VRRH6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-VRRH6.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VRRI5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-VRRI5.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VRRP8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-VRRP8.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VRTG6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-VRTG6.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VRTU3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-VRTU3.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VRUN4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-VRUN4.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VRUX2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-VRUX2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VRVI8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-VRVI8.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VTHYFYA' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-VTHYFYA.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='WLZ256G' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-WLZ256G.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='WTAA' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-WTAA.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='XDEPLRT' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-XDEPLRT.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='YCAAYCC' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-YCAAYCC.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/11/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -27.357 AND cl.lat_max >= -41.677 AND ((cl.long_min <= 22.338 AND cl.long_max >= 9.659) OR (cl.long_min <= MOD(22.338+360, 360) AND cl.long_max >= MOD(9.659+360, 360)) OR (cl.long_min <= MOD(22.338-360, 360) AND cl.long_max >= MOD(9.659-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -27.357 AND l.latitude >= -41.677 AND ((l.longitude <= 22.338 AND l.longitude >= 9.659) OR (l.longitude <= MOD(22.338+360, 360) AND l.longitude >= MOD(9.659+360, 360)) OR (l.longitude <= MOD(22.338-360, 360) AND l.longitude >= MOD(9.659-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='YUUA5TE' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241218_102243_15134934/tsg-YUUA5TE.nc; -valid_qc=12578