SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901200' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/argo-trajectory-1901200.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4900489' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/argo-trajectory-4900489.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4900540' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/argo-trajectory-4900540.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4900541' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/argo-trajectory-4900541.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4900542' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/argo-trajectory-4900542.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61501' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61501.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61502' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61502.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61503' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61503.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61504' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61504.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61525' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61525.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61526' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61526.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61530' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61530.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61552' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61552.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61553' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61553.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61555' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61555.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61556' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61556.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61557' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61557.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61662' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61662.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61663' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61663.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61664' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61664.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61666' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61666.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61667' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61667.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61670' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61670.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61671' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61671.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61675' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61675.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61677' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61677.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61678' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61678.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61689' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61689.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61690' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61690.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61691' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61691.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61767' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61767.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61769' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-61769.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB03467' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXB03467.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB03468' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXB03468.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB03469' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXB03469.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB03470' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXB03470.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB03471' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXB03471.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB03472' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXB03472.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB03473' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXB03473.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB03474' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXB03474.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB04082' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXB04082.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB08381' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXB08381.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB08382' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXB08382.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD10970' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD10970.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD11520' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD11520.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD11521' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD11521.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD11522' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD11522.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD11523' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD11523.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD11524' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD11524.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD11575' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD11575.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD11576' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD11576.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD11577' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD11577.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD11578' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD11578.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD11579' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD11579.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD11580' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD11580.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD11870' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD11870.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD11871' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD11871.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD11872' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD11872.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD11873' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD11873.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD11874' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD11874.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD11875' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD11875.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD11953' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD11953.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD11954' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD11954.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD11955' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD11955.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD12056' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD12056.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD12120' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD12120.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD12121' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD12121.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD12122' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD12122.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD12123' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD12123.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD12124' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD12124.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD12125' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD12125.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD12126' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD12126.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD12127' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD12127.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD12138' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD12138.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD12248' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD12248.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD12261' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD12261.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD12262' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD12262.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD12263' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD12263.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD12264' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD12264.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD12265' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD12265.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD12339' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD12339.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD12340' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/drifting-buoys-EXD12340.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FNCM' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/tsg-FNCM.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FNIN' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/tsg-FNIN.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FZVN' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/tsg-FZVN.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMY2909' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/mooring-buoys-time-series-EXMY2909.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 47 AND cl.lat_max >= 41 AND ((cl.long_min <= 42 AND cl.long_max >= 27) OR (cl.long_min <= MOD(42+360, 360) AND cl.long_max >= MOD(27+360, 360)) OR (cl.long_min <= MOD(42-360, 360) AND cl.long_max >= MOD(27-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 47 AND l.latitude >= 41 AND ((l.longitude <= 42 AND l.longitude >= 27) OR (l.longitude <= MOD(42+360, 360) AND l.longitude >= MOD(27+360, 360)) OR (l.longitude <= MOD(42-360, 360) AND l.longitude >= MOD(27-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FZVN' and cl.classification_code=19;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250409_163451_15185017/other-time-series-or-trajectories-FZVN.nc; -valid_qc=12578