SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='D5LS3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/tsg-D5LS3.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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_20250205_135222_15148870/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('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='FNAV' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/tsg-FNAV.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='FNHO' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/tsg-FNHO.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='FS4536' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/tsg-FS4536.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='LXSQ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/tsg-LXSQ.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='ORCO' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/tsg-ORCO.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='SKEC' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/tsg-SKEC.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='6200170' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-6200170.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY0443' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY0443.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY0490' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY0490.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY0594' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY0594.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY0668' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY0668.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY0670' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY0670.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY0684' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY0684.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY1095' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY1095.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY1097' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY1097.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY1245' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY1245.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY1262' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY1262.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY1288' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY1288.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY1307' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY1307.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY1309' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY1309.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY1311' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY1311.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY1319' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY1319.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY1324' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY1324.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY1635' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY1635.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2125' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2125.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2126' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2126.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2436' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2436.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2437' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2437.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2440' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2440.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2443' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2443.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2444' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2444.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2446' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2446.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2447' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2447.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2448' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2448.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2449' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2449.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2450' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2450.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2452' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2452.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2454' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2454.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2560' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2560.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2561' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2561.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2562' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2562.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2566' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2566.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2567' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2567.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2588' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2588.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2589' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2589.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2590' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2590.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2606' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2606.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='EXMY2607' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-EXMY2607.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/09/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/04/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 50.9 AND ((cl.long_min <= 3.6 AND cl.long_max >= 2) OR (cl.long_min <= MOD(3.6+360, 360) AND cl.long_max >= MOD(2+360, 360)) OR (cl.long_min <= MOD(3.6-360, 360) AND cl.long_max >= MOD(2-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 50.9 AND ((l.longitude <= 3.6 AND l.longitude >= 2) OR (l.longitude <= MOD(3.6+360, 360) AND l.longitude >= MOD(2+360, 360)) OR (l.longitude <= MOD(3.6-360, 360) AND l.longitude >= MOD(2-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='IF000357' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_135222_15148870/mooring-buoys-time-series-IF000357.nc; -valid_qc=12578