SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='3901851' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/argo-trajectory-3901851.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='4901809' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/argo-trajectory-4901809.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='4901817' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/argo-trajectory-4901817.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='5903394' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/argo-trajectory-5903394.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='5904173' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/argo-trajectory-5904173.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6901720' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/argo-trajectory-6901720.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6901724' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/argo-trajectory-6901724.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6902660' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/argo-trajectory-6902660.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6902695' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/argo-trajectory-6902695.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6902788' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/argo-trajectory-6902788.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6902800' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/argo-trajectory-6902800.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='2501526' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-2501526.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='4101658' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-4101658.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='4101664' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-4101664.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='4401565' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-4401565.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='4401574' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-4401574.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='4401786' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-4401786.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='4401896' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-4401896.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='4401897' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-4401897.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='4401899' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-4401899.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='4402534' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-4402534.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='4402537' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-4402537.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='4402538' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-4402538.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='4402540' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-4402540.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='5301764' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-5301764.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6202628' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6202628.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6202633' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6202633.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6202660' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6202660.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6202661' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6202661.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6202662' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6202662.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6202663' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6202663.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6202664' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6202664.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6202665' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6202665.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6202669' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6202669.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6203569' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6203569.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6203572' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6203572.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6203582' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6203582.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6203583' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6203583.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6301569' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6301569.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6301571' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6301571.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6401502' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6401502.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6401531' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6401531.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6402539' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6402539.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6402540' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6402540.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6402547' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6402547.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6402551' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6402551.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6402564' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6402564.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6402566' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6402566.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='6402568' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/drifting-buoys-6402568.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='DBBE' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/tsg-DBBE.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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='OXYH2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_135607_15092982/tsg-OXYH2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/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/2020 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2020 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_135607_15092982/mooring-buoys-time-series-44078.nc; -valid_qc=12578