SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='13516' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-13516.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='13570' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-13570.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='13585' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-13585.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='13589' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-13589.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='13639' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-13639.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='13640' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-13640.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='13910' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-13910.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='13918' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-13918.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='13940' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-13940.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='13972' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-13972.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='41852' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-41852.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='44624' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-44624.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='44645' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-44645.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='44839' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-44839.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='44840' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-44840.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61788' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-61788.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61850C' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-61850C.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61852C' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-61852C.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61854C' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-61854C.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61855C' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-61855C.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61856C' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-61856C.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61857C' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-61857C.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61858C' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-61858C.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61859C' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-61859C.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61860C' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-61860C.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61862' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-61862.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61865A' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-61865A.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='61867' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-61867.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='62507' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-62507.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='62511' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-62511.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='62516' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-62516.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='62517' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-62517.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='62563' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-62563.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='62714' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-62714.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='62772B' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-62772B.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='62773B' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-62773B.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='62818' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-62818.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='62899' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-62899.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='62900' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-62900.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='62902' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-62902.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='62903' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-62903.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='62904' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-62904.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='62938' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-62938.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='62941' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-62941.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='62955' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-62955.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='62956' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-62956.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD07615' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD07615.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD07767' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD07767.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD08194' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD08194.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD08195' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD08195.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD08331' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD08331.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD09147' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD09147.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD09512' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD09512.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD09515' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD09515.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD09517' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD09517.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD09738' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD09738.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD09797' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD09797.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD09799' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD09799.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD09801' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD09801.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD09883' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD09883.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD09885' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD09885.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD09887' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD09887.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD09888' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD09888.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD09936' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD09936.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD09939' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD09939.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD09942' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD09942.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD09943' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD09943.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD12561' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD12561.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD13044' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD13044.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD13220' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD13220.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD13561' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD13561.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD13574' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD13574.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD13575' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD13575.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD13578' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD13578.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD13948' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/drifting-buoys-EXD13948.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5BAD2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/tsg-5BAD2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='A8IG2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/tsg-A8IG2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_20250303_144111_15163744/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('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='DGPT2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/tsg-DGPT2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EDSV' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/tsg-EDSV.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FABB' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/tsg-FABB.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FGTO' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/tsg-FGTO.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FKJB' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/tsg-FKJB.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FMCY' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/tsg-FMCY.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_20250303_144111_15163744/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('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FNFP' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/tsg-FNFP.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_20250303_144111_15163744/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('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FVHY' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/tsg-FVHY.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FZVN' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/tsg-FZVN.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='MGJS8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/tsg-MGJS8.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='SMLQ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/tsg-SMLQ.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='ZCDJ6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/tsg-ZCDJ6.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='A8IG2' and cl.classification_code=14;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/bottles-A8IG2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='DGPT2' and cl.classification_code=14;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/bottles-DGPT2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FABB' and cl.classification_code=14;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/bottles-FABB.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FMCY' and cl.classification_code=14;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/bottles-FMCY.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_20250303_144111_15163744/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('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FNFP' and cl.classification_code=14;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/bottles-FNFP.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_20250303_144111_15163744/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('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FVHY' and cl.classification_code=14;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/bottles-FVHY.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FZVN' and cl.classification_code=14;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/bottles-FZVN.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='MGJS8' and cl.classification_code=14;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/bottles-MGJS8.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6100198' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-6100198.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6100280' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-6100280.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6100281' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-6100281.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6100417' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-6100417.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6100430' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-6100430.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6101024' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-6101024.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6200084' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-6200084.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6200085' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-6200085.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6200191' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-6200191.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6200192' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-6200192.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6200199' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-6200199.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6201031' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-6201031.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6201040' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-6201040.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMY1091' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-EXMY1091.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMY2011' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-EXMY2011.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMY2028' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-EXMY2028.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMY2030' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-EXMY2030.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMY2036' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-EXMY2036.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMY2950' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-EXMY2950.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMY2951' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-EXMY2951.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMY2958' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-EXMY2958.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMY2963' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-EXMY2963.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMY2971' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/mooring-buoys-time-series-EXMY2971.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2011 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 42.267 AND cl.lat_max >= 29.737 AND ((cl.long_min <= 3.58 AND cl.long_max >= -14.917) OR (cl.long_min <= MOD(3.58+360, 360) AND cl.long_max >= MOD(-14.917+360, 360)) OR (cl.long_min <= MOD(3.58-360, 360) AND cl.long_max >= MOD(-14.917-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 42.267 AND l.latitude >= 29.737 AND ((l.longitude <= 3.58 AND l.longitude >= -14.917) OR (l.longitude <= MOD(3.58+360, 360) AND l.longitude >= MOD(-14.917+360, 360)) OR (l.longitude <= MOD(3.58-360, 360) AND l.longitude >= MOD(-14.917-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6201040' and cl.classification_code=19;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144111_15163744/other-time-series-or-trajectories-6201040.nc; -valid_qc=12578