SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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_20250121_063849_15143991/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('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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_20250121_063849_15143991/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('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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_20250121_063849_15143991/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('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='2BD3DVL' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-2BD3DVL.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='2BRAZTM' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-2BRAZTM.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='2FRXYUC' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-2FRXYUC.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='2ICI4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-2ICI4.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='2PN7YZN' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-2PN7YZN.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='3EWSVMK' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-3EWSVMK.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='3EXN5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-3EXN5.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='3FAR9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-3FAR9.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='3FPV6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-3FPV6.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='3KNJUWA' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-3KNJUWA.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='4WA287U' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-4WA287U.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='5MGXH3D' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-5MGXH3D.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='6CV53CK' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-6CV53CK.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='6QDWLCH' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-6QDWLCH.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='7AZU3YW' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-7AZU3YW.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='8UQ98MG' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-8UQ98MG.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='8ZMBQGS' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-8ZMBQGS.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='9HA2006' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-9HA2006.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='9HA3858' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-9HA3858.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='9HA4974' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-9HA4974.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='9HA5028' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-9HA5028.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='9HA5486' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-9HA5486.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='9HY07' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-9HY07.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='9HYO7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-9HYO7.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='9V2734' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-9V2734.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='9V3736' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-9V3736.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='9V3776' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-9V3776.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='9V5076' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-9V5076.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='9V5241' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-9V5241.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='9V5634' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-9V5634.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9V6256' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-9V6256.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='9V6416' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-9V6416.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='9V8190' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-9V8190.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='9V9143' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-9V9143.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9V9375' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-9V9375.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='9V9399' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-9V9399.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='9V9400' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-9V9400.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='9V9402' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-9V9402.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9V9404' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-9V9404.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='A8VP8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-A8VP8.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='ABR9RDM' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-ABR9RDM.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='AHSBERV' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-AHSBERV.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='ARVPSCA' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-ARVPSCA.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='AUBE' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-AUBE.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='AUCU' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-AUCU.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='AUHB' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-AUHB.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='AUTV' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-AUTV.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='AUYN' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-AUYN.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='AVBD' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-AVBD.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='AVKB' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-AVKB.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='AVQU' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-AVQU.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='AWTX' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-AWTX.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='AWUU' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-AWUU.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='AWWB' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-AWWB.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='AWYE' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-AWYE.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='AWZI' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-AWZI.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='BJKUBKR' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-BJKUBKR.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='BKIY' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-BKIY.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='CJUPDZS' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-CJUPDZS.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='CQ2247' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-CQ2247.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='CQDB' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-CQDB.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='CYL9ERY' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-CYL9ERY.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='D5AD7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-D5AD7.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='DBUXMBJ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-DBUXMBJ.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='DCQP2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-DCQP2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='DDGR99J' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-DDGR99J.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='DLXM4SN' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-DLXM4SN.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='FNSLEAC' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-FNSLEAC.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='GAZ35FF' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-GAZ35FF.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='GZF8NZQ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-GZF8NZQ.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='GZU6L8G' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-GZU6L8G.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='HLTDM3H' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-HLTDM3H.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='HNQN49W' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-HNQN49W.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='KSKM' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-KSKM.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='NDN4JZX' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-NDN4JZX.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='PWNLHBZ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-PWNLHBZ.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='QPMLKFB' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-QPMLKFB.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='RRYTS7Z' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-RRYTS7Z.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='RULLM7N' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-RULLM7N.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='RYPU8UL' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-RYPU8UL.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='S6NQ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-S6NQ.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='SCY6TVD' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-SCY6TVD.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='SDRRFMA' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-SDRRFMA.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='SKQ4L3C' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-SKQ4L3C.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='TBWUK53' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-TBWUK53.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='TBWUK63' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-TBWUK63.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='TBWUK68' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-TBWUK68.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='TBWUK72' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-TBWUK72.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='TBWUK74' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-TBWUK74.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='TBWUK80' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-TBWUK80.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='TWQZHTC' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-TWQZHTC.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='TZK8KDX' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-TZK8KDX.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='V7A4221' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-V7A4221.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='V7A5099' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-V7A5099.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='V7A5254' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-V7A5254.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='V7A5868' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-V7A5868.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='V7A6082' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-V7A6082.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='V7A6411' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-V7A6411.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='V7A6441' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-V7A6441.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='V7A6497' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-V7A6497.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='V7A6509' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-V7A6509.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='V7DI9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-V7DI9.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='V7DJ5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-V7DJ5.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='V7DR9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-V7DR9.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='V7EQ4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-V7EQ4.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='V7HH2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-V7HH2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='V7HU5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-V7HU5.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='V7JD2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-V7JD2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='V7KD8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-V7KD8.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='V7OE5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-V7OE5.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='V7QJ3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-V7QJ3.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='V7QJ5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-V7QJ5.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='V7QJ6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-V7QJ6.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='V7UU3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-V7UU3.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='VRIR7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-VRIR7.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='VRJT5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-VRJT5.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='VRJU8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-VRJU8.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='VRLK2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-VRLK2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='VRLQ4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-VRLQ4.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VRMD3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-VRMD3.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='VRNS2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-VRNS2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='VROB9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-VROB9.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='VRPY6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-VRPY6.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='VRQZ7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-VRQZ7.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='VRRP8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-VRRP8.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='VRRQ4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-VRRQ4.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='VRVK9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-VRVK9.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='VTHK' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-VTHK.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='VTHL' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-VTHL.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='VTKK' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-VTKK.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='VTKL' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-VTKL.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='VTLJ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-VTLJ.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='VUD7WQF' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-VUD7WQF.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='WMDQ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-WMDQ.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='WMKN' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-WMKN.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='WSEP' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-WSEP.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='WWY5NFD' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-WWY5NFD.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='WZU9GCQ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-WZU9GCQ.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='XCGBCPP' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-XCGBCPP.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='YEADUPA' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-YEADUPA.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='YUTPB4M' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/tsg-YUTPB4M.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/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, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 24.231 AND cl.lat_max >= 17.631 AND ((cl.long_min <= 67.336 AND cl.long_max >= 61.799) OR (cl.long_min <= MOD(67.336+360, 360) AND cl.long_max >= MOD(61.799+360, 360)) OR (cl.long_min <= MOD(67.336-360, 360) AND cl.long_max >= MOD(61.799-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 24.231 AND l.latitude >= 17.631 AND ((l.longitude <= 67.336 AND l.longitude >= 61.799) OR (l.longitude <= MOD(67.336+360, 360) AND l.longitude >= MOD(61.799+360, 360)) OR (l.longitude <= MOD(67.336-360, 360) AND l.longitude >= MOD(61.799-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR chlo = '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='2300456' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250121_063849_15143991/mooring-buoys-time-series-2300456.nc; -valid_qc=12578