SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3901629' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-3901629.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3901665' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-3901665.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4901779' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-4901779.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4902117' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-4902117.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4902397' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-4902397.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4902481' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-4902481.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4902487' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-4902487.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4903275' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-4903275.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4903359' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-4903359.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4903360' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-4903360.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4903361' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-4903361.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4903362' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-4903362.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4903365' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-4903365.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5904774' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-5904774.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901930' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-6901930.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902728' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-6902728.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902749' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-6902749.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902751' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-6902751.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902752' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-6902752.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902786' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-6902786.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902791' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-6902791.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902792' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-6902792.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902793' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-6902793.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902807' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-6902807.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902882' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-6902882.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903006' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-6903006.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903027' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-6903027.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903030' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-6903030.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903039' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-6903039.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903041' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-6903041.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903042' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-6903042.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903083' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-6903083.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903086' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-6903086.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903545' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-6903545.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903872' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-6903872.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903873' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-6903873.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900556' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/argo-trajectory-7900556.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2501510' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-2501510.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2501512' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-2501512.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2501513' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-2501513.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2501514' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-2501514.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2501538' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-2501538.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2501714' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-2501714.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4401895' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-4401895.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4401901' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-4401901.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6202632' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6202632.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6202658' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6202658.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6202678' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6202678.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203588' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6203588.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203633' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6203633.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203710' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6203710.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203753' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6203753.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203794' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6203794.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203795' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6203795.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203796' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6203796.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203797' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6203797.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203798' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6203798.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203799' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6203799.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203800' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6203800.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203801' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6203801.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203802' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6203802.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203803' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6203803.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203804' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6203804.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203805' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6203805.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203806' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6203806.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203807' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6203807.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203808' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6203808.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203809' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6203809.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6204584' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6204584.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6301511' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6301511.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6301564' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6301564.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6301567' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6301567.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6301570' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6301570.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401573' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6401573.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401574' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6401574.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401748' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6401748.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401751' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6401751.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401758' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6401758.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401759' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6401759.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401760' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6401760.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401761' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6401761.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401811' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6401811.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401832' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6401832.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401842' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6401842.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401853' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6401853.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401858' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6401858.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401863' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6401863.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401864' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6401864.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401865' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6401865.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401872' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6401872.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401873' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6401873.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402523' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402523.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402543' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402543.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402555' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402555.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402559' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402559.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402562' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402562.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402592' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402592.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402593' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402593.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402594' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402594.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402595' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402595.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402596' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402596.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402597' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402597.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402598' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402598.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402599' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402599.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402610' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402610.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402611' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402611.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402645' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402645.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402646' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402646.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402656' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402656.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402663' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402663.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402668' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402668.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402672' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402672.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402673' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402673.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402677' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402677.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402678' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402678.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402680' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6402680.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6501535' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6501535.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6501681' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/drifting-buoys-6501681.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='DBBT' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/tsg-DBBT.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='OYTR2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/tsg-OYTR2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='44078' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135545_15092981/mooring-buoys-time-series-44078.nc; -valid_qc=12578