SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1900819' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/argo-trajectory-1900819.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901078' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/argo-trajectory-1901078.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901467' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/argo-trajectory-1901467.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901487' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/argo-trajectory-1901487.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901489' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/argo-trajectory-1901489.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901498' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/argo-trajectory-1901498.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901504' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/argo-trajectory-1901504.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901538' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/argo-trajectory-1901538.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901674' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/argo-trajectory-1901674.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3900692' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/argo-trajectory-3900692.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3900707' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/argo-trajectory-3900707.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3900708' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/argo-trajectory-3900708.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4901031' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/argo-trajectory-4901031.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4901059' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/argo-trajectory-4901059.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6900723' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/argo-trajectory-6900723.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901445' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/argo-trajectory-6901445.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901494' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/argo-trajectory-6901494.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901495' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/argo-trajectory-6901495.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='13899' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-13899.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1500510' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-1500510.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1500619' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-1500619.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1500647' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-1500647.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1500914' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-1500914.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1500934' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-1500934.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='15614' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-15614.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='15615' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-15615.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='15618' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-15618.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='15619' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-15619.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='15620' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-15620.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='15663' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-15663.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='15664' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-15664.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='15911' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-15911.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='15928' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-15928.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='15934' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-15934.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='15950' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-15950.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='31513' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-31513.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='31519' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-31519.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='31537' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-31537.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='31542' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-31542.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='31726' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-31726.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='31740' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-31740.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='31906' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-31906.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4100734' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-4100734.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='41709' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-41709.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='41734' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-41734.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='41736' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-41736.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00371' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXB00371.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00403' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXB00403.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00435' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXB00435.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00442' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXB00442.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00718' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXB00718.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01624' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXB01624.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01633' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXB01633.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01664' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXB01664.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01718' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXB01718.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01719' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXB01719.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01729' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXB01729.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01733' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXB01733.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01735' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXB01735.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01755' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXB01755.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01757' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXB01757.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB04014' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXB04014.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB04015' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXB04015.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15073' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXD15073.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15945' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXD15945.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15964' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXD15964.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15982' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXD15982.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD16498' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXD16498.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD16582' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXD16582.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD16768' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/drifting-buoys-EXD16768.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='A8YW2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/tsg-A8YW2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='C6TN4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/tsg-C6TN4.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXEI0028' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/tsg-EXEI0028.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXEI0029' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/tsg-EXEI0029.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXEI0032' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/tsg-EXEI0032.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FIBQ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/tsg-FIBQ.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FNAV' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/tsg-FNAV.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_20250206_160619_15151130/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('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FNHO' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/tsg-FNHO.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='WTEC' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/tsg-WTEC.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='A8YW2' and cl.classification_code=14;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/bottles-A8YW2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FIBQ' and cl.classification_code=14;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/bottles-FIBQ.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FNAV' and cl.classification_code=14;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/bottles-FNAV.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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=14;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/bottles-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('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FNHO' and cl.classification_code=14;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/bottles-FNHO.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='13009' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/mooring-buoys-time-series-13009.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='31001' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/mooring-buoys-time-series-31001.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='31002' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/mooring-buoys-time-series-31002.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='31217' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/mooring-buoys-time-series-31217.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMF0044' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/mooring-buoys-time-series-EXMF0044.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMF0045' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/mooring-buoys-time-series-EXMF0045.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMF0046' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/mooring-buoys-time-series-EXMF0046.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMF0047' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/mooring-buoys-time-series-EXMF0047.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXSH0049' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/mooring-buoys-time-series-EXSH0049.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXSH0080' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/mooring-buoys-time-series-EXSH0080.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='IF000372' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/mooring-buoys-time-series-IF000372.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 8 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 8 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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=19;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_160619_15151130/other-time-series-or-trajectories-FNCM.nc; -valid_qc=12578