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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='1401601' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-1401601.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='1601808' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-1601808.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='1801668' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-1801668.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='1801679' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-1801679.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='1801680' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-1801680.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='1801734' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-1801734.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='1801786' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-1801786.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='1801790' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-1801790.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2301806' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2301806.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2301807' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2301807.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2301808' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2301808.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2301809' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2301809.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2301810' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2301810.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2301811' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2301811.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2301812' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2301812.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2301813' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2301813.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2301814' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2301814.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2301815' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2301815.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2301816' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2301816.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2301817' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2301817.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2301818' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2301818.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2301819' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2301819.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2301820' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2301820.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2301823' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2301823.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2301824' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2301824.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2301826' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2301826.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2302615' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2302615.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2302616' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2302616.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2302621' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2302621.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2302623' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2302623.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2302627' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2302627.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2302628' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2302628.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2302635' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2302635.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2302637' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2302637.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2801973' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2801973.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2802086' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2802086.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2802122' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-2802122.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='3801570' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-3801570.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='3801637' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-3801637.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='3801682' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-3801682.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='3801712' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-3801712.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='4101867' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-4101867.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='4803996' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-4803996.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='4804000' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-4804000.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='4804001' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-4804001.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='4804018' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-4804018.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='4804107' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-4804107.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='5601690' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-5601690.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='5801991' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-5801991.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='5802079' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-5802079.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='6801784' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-6801784.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='6801890' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-6801890.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7801708' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7801708.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7801753' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7801753.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7801754' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7801754.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810333' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810333.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810334' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810334.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810335' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810335.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810336' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810336.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810340' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810340.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810342' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810342.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810343' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810343.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810344' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810344.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810345' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810345.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810346' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810346.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810347' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810347.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810348' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810348.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810349' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810349.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810350' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810350.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810351' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810351.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810352' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810352.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810353' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810353.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810354' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810354.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810355' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810355.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810356' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810356.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810358' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810358.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810359' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810359.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='7810362' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/drifting-buoys-7810362.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2300094' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/mooring-buoys-time-series-2300094.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='23001' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/mooring-buoys-time-series-23001.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='23003' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/mooring-buoys-time-series-23003.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2300459' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/mooring-buoys-time-series-2300459.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='2300460' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/mooring-buoys-time-series-2300460.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='23009' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/mooring-buoys-time-series-23009.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='23015' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/mooring-buoys-time-series-23015.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='23091' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/mooring-buoys-time-series-23091.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='23099' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/mooring-buoys-time-series-23099.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='23453' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/mooring-buoys-time-series-23453.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='23454' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/mooring-buoys-time-series-23454.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='23492' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/mooring-buoys-time-series-23492.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('27/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 12, 15) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 15 AND cl.lat_max >= -5 AND ((cl.long_min <= 90 AND cl.long_max >= 70) OR (cl.long_min <= MOD(90+360, 360) AND cl.long_max >= MOD(70+360, 360)) OR (cl.long_min <= MOD(90-360, 360) AND cl.long_max >= MOD(70-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 <= 15 AND l.latitude >= -5 AND ((l.longitude <= 90 AND l.longitude >= 70) OR (l.longitude <= MOD(90+360, 360) AND l.longitude >= MOD(70+360, 360)) OR (l.longitude <= MOD(90-360, 360) AND l.longitude >= MOD(70-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='23497' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250327_055035_15176671/mooring-buoys-time-series-23497.nc; -valid_qc=12578