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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='22941' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/drifting-buoys-22941.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='22942' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/drifting-buoys-22942.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='22944' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/drifting-buoys-22944.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='22946' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/drifting-buoys-22946.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='22947' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/drifting-buoys-22947.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='22948' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/drifting-buoys-22948.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='3801677' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/drifting-buoys-3801677.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='5102835' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/drifting-buoys-5102835.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='5102843' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/drifting-buoys-5102843.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='5201802' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/drifting-buoys-5201802.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='3E2032' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-3E2032.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='3E2422' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-3E2422.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='3E3566' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-3E3566.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='3E5420' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-3E5420.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='3E6625' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-3E6625.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='3EKT8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-3EKT8.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='3ESK5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-3ESK5.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='3EWI2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-3EWI2.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='3EZM3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-3EZM3.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='3FBO6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-3FBO6.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='3FEN2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-3FEN2.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='3FOS8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-3FOS8.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='3FUY2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-3FUY2.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='3FYF2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-3FYF2.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='3FYP8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-3FYP8.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='5LEW9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-5LEW9.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='6LDRRAL' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-6LDRRAL.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='6QRXSMH' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-6QRXSMH.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='7JFK' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-7JFK.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='7JGE' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-7JGE.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='7JMY' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-7JMY.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='7JRT' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-7JRT.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='7JUC' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-7JUC.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='7JUE' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-7JUE.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='7JVF' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-7JVF.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='7JXX' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-7JXX.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='7JYC' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-7JYC.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='7KAB' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-7KAB.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='7KDA' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-7KDA.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='7KHY' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-7KHY.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='7KIY' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-7KIY.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='7KJS' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-7KJS.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='7KJY' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-7KJY.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='7KKB' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-7KKB.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='7KKD' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-7KKD.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='7KOB' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-7KOB.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='8RJHNYQ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-8RJHNYQ.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='8ZMBQGS' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-8ZMBQGS.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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_20241203_061148_15124024/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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='9HA5406' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-9HA5406.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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_20241203_061148_15124024/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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='9V5247' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-9V5247.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='9V6256' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-9V6256.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='9V7629' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-9V7629.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='9V8372' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-9V8372.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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_20241203_061148_15124024/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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='9V9404' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-9V9404.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='9V9450' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-9V9450.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='ARCGM3F' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-ARCGM3F.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='AUYN' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-AUYN.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='BHJG' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-BHJG.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='BKIY' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-BKIY.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='BKKH' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-BKKH.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='CQ2132' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-CQ2132.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='CQNL' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-CQNL.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='D5DG4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-D5DG4.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='D5VC2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-D5VC2.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='ETWE69U' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-ETWE69U.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='FDWKMSB' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-FDWKMSB.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='GKHEABF' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-GKHEABF.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='H3JW' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-H3JW.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='H9KL' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-H9KL.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='JCP83EY' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-JCP83EY.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='JDWV7LP' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-JDWV7LP.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='JGMSWAT' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-JGMSWAT.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='JJKGXKX' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-JJKGXKX.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='MPP7LPS' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-MPP7LPS.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='ONKD' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-ONKD.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='ONKF' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-ONKF.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='ONLW' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-ONLW.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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_20241203_061148_15124024/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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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_20241203_061148_15124024/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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='QPMLKFB' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-QPMLKFB.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='RUQGHAC' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-RUQGHAC.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='TZK8KDX' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-TZK8KDX.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='USS8SCM' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-USS8SCM.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='V7A4788' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-V7A4788.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='V7A5716' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-V7A5716.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='V7A6082' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-V7A6082.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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_20241203_061148_15124024/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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='V7A6495' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-V7A6495.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='V7EQ4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-V7EQ4.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='V7OT3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-V7OT3.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='V7QS7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-V7QS7.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='V7QT7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-V7QT7.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='V7TR9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-V7TR9.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='V7UX2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-V7UX2.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='V7YO3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-V7YO3.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='VREM6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-VREM6.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='VRFT7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-VRFT7.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='VRLJ2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-VRLJ2.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='VRMD3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-VRMD3.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='VROV7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-VROV7.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='VRQS3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-VRQS3.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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_20241203_061148_15124024/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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='VRTF2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-VRTF2.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='VRUY5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-VRUY5.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='VRVJ5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-VRVJ5.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='VRVR2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-VRVR2.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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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_20241203_061148_15124024/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('31/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/10/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 <= 23.284 AND cl.lat_max >= 18.33 AND ((cl.long_min <= 122.664 AND cl.long_max >= 115.793) OR (cl.long_min <= MOD(122.664+360, 360) AND cl.long_max >= MOD(115.793+360, 360)) OR (cl.long_min <= MOD(122.664-360, 360) AND cl.long_max >= MOD(115.793-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 <= 23.284 AND l.latitude >= 18.33 AND ((l.longitude <= 122.664 AND l.longitude >= 115.793) OR (l.longitude <= MOD(122.664+360, 360) AND l.longitude >= MOD(115.793+360, 360)) OR (l.longitude <= MOD(122.664-360, 360) AND l.longitude >= MOD(115.793-360, 360)) ) AND (temp = 'Y' OR not 1=1)) 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='XPPQEVQ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061148_15124024/tsg-XPPQEVQ.nc; -valid_qc=12578