SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='1902661' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-1902661.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2901806' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2901806.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2902881' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2902881.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903684' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903684.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903687' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903687.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903688' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903688.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903690' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903690.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903694' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903694.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903695' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903695.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903704' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903704.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903705' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903705.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903706' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903706.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903707' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903707.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903708' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903708.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903709' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903709.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903710' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903710.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903711' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903711.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903712' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903712.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903713' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903713.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903716' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903716.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903717' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903717.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903719' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903719.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903720' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903720.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903721' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903721.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903724' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903724.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903728' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903728.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903733' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903733.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903734' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903734.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903735' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903735.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903738' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903738.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903739' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903739.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903740' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903740.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2903741' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-2903741.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='3902012' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-3902012.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='3902565' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-3902565.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='4901648' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-4901648.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='5902518' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-5902518.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='5902519' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-5902519.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='5906510' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-5906510.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='5906513' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-5906513.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='5906519' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-5906519.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='5906522' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-5906522.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='5907069' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-5907069.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='6990596' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-6990596.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='6990597' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/argo-trajectory-6990597.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='1801765' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-1801765.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2101662' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-2101662.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2101819' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-2101819.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2101827' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-2101827.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2101855' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-2101855.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2102636' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-2102636.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2102639' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-2102639.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22683' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-22683.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22684' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-22684.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22685' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-22685.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22941' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-22941.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22943' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-22943.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22945' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-22945.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22946' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-22946.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22947' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-22947.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22948' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-22948.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2802055' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-2802055.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2802056' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-2802056.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2802057' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-2802057.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2802059' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-2802059.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2802060' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-2802060.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='3201752' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-3201752.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='4601833' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-4601833.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='4602719' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-4602719.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='4804101' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-4804101.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='5102796' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-5102796.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='5102805' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-5102805.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='5201693' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-5201693.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='5201764' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-5201764.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='5201784' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-5201784.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='5201787' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-5201787.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='5201788' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-5201788.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='5301667' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-5301667.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='5301668' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-5301668.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='5301669' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-5301669.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='5301670' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-5301670.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='5301674' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-5301674.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='5802058' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-5802058.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='5802059' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-5802059.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='6801859' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-6801859.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='6801862' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-6801862.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='6801863' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-6801863.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='6801887' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-6801887.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='7801682' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/drifting-buoys-7801682.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='7JYD' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/tsg-7JYD.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='7KAC' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/tsg-7KAC.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='C6YT4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/tsg-C6YT4.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='DIGX2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/tsg-DIGX2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='DJDS2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/tsg-DJDS2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='HORQ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/tsg-HORQ.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='JDSS' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/tsg-JDSS.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='JGQH' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/tsg-JGQH.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='JPBN' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/tsg-JPBN.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='KSKM' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/tsg-KSKM.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='21229' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-21229.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2200299' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-2200299.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='2200300' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-2200300.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22101' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-22101.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22102' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-22102.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22103' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-22103.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22104' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-22104.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22105' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-22105.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22106' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-22106.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22107' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-22107.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22108' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-22108.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22183' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-22183.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22184' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-22184.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22185' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-22185.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22186' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-22186.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22187' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-22187.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22188' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-22188.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22189' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-22189.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22190' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-22190.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22191' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-22191.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22192' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-22192.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22297' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-22297.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('03/10/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('03/09/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 38.687 AND cl.lat_max >= 11.837 AND ((cl.long_min <= 142.603 AND cl.long_max >= 108.593) OR (cl.long_min <= MOD(142.603+360, 360) AND cl.long_max >= MOD(108.593+360, 360)) OR (cl.long_min <= MOD(142.603-360, 360) AND cl.long_max >= MOD(108.593-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 38.687 AND l.latitude >= 11.837 AND ((l.longitude <= 142.603 AND l.longitude >= 108.593) OR (l.longitude <= MOD(142.603+360, 360) AND l.longitude >= MOD(108.593+360, 360)) OR (l.longitude <= MOD(142.603-360, 360) AND l.longitude >= MOD(108.593-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='22298' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241203_061042_15124023/mooring-buoys-time-series-22298.nc; -valid_qc=12578