SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901165' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-1901165.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901441' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-1901441.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901442' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-1901442.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1902198' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-1902198.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1902284' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-1902284.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1902477' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-1902477.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1902594' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-1902594.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901325' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2901325.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901326' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2901326.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901521' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2901521.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901522' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2901522.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901569' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2901569.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901593' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2901593.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901595' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2901595.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901861' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2901861.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902073' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902073.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902148' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902148.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902151' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902151.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902152' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902152.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902156' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902156.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902158' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902158.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902160' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902160.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902181' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902181.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902182' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902182.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902189' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902189.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902192' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902192.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902193' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902193.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902194' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902194.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902195' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902195.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902196' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902196.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902197' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902197.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902212' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902212.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902215' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902215.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902216' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902216.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902238' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902238.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902239' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902239.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902240' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902240.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902243' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902243.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902244' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902244.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902245' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902245.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902264' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902264.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902394' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902394.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902395' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902395.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902397' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902397.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902398' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902398.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902567' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902567.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902570' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902570.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902572' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902572.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902578' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902578.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902596' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902596.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902597' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902597.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902605' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902605.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902606' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902606.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902612' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902612.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902614' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902614.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902669' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902669.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902680' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902680.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902681' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902681.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902682' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902682.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902702' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902702.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902710' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902710.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902713' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902713.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902758' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902758.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902837' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902837.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902849' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902849.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902851' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902851.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902852' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902852.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902853' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902853.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902854' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902854.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902855' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902855.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902856' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2902856.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2903130' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2903130.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2903131' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2903131.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2903132' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2903132.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2903133' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2903133.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2903134' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2903134.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2903135' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2903135.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2903464' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2903464.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2903466' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-2903466.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5903712' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-5903712.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5904313' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-5904313.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5904728' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-5904728.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5904729' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-5904729.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905088' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-5905088.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905090' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-5905090.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901730' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-6901730.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901731' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-6901731.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901738' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-6901738.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901740' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-6901740.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901741' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090036_15121328/argo-trajectory-6901741.nc; -valid_qc=12578