SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='1900349' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/argo-trajectory-1900349.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='1900350' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/argo-trajectory-1900350.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='1900352' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/argo-trajectory-1900352.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='6900045' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/argo-trajectory-6900045.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='6900132' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/argo-trajectory-6900132.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='6900162' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/argo-trajectory-6900162.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='6900163' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/argo-trajectory-6900163.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='6900180' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/argo-trajectory-6900180.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='6900237' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/argo-trajectory-6900237.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='6900238' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/argo-trajectory-6900238.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='6900295' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/argo-trajectory-6900295.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='69035' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/argo-trajectory-69035.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='69044' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/argo-trajectory-69044.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXB03476' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXB03476.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXB03480' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXB03480.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXB03794' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXB03794.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXB03812' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXB03812.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXB09761' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXB09761.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXB09764' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXB09764.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD02735' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD02735.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD03231' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD03231.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD03303' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD03303.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD04077' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD04077.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD04734' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD04734.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD04906' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD04906.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD04908' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD04908.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD04998' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD04998.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD05057' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD05057.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD05059' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD05059.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD05589' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD05589.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD05599' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD05599.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD05665' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD05665.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD11053' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD11053.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD11086' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD11086.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD11106' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD11106.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD11108' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD11108.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD11220' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD11220.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD11224' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD11224.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD11248' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD11248.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD11353' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD11353.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD11377' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD11377.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD11383' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD11383.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD11436' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD11436.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD11454' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD11454.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD11509' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD11509.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD11649' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD11649.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD11651' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD11651.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD11653' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD11653.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD11667' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD11667.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD11671' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD11671.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD11676' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD11676.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD11826' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD11826.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD11833' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD11833.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD12157' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD12157.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD12167' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD12167.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXD12277' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/drifting-buoys-EXD12277.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='C6RH8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/tsg-C6RH8.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='DBBH' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/tsg-DBBH.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='ELVX4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/tsg-ELVX4.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='ELVZ5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/tsg-ELVZ5.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='ELVZ6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/tsg-ELVZ6.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='ELWT7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/tsg-ELWT7.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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_143220_15163523/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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_143220_15163523/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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_143220_15163523/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='FNCM' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/tsg-FNCM.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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_143220_15163523/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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_143220_15163523/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='FNIN' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/tsg-FNIN.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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_143220_15163523/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='OXYH2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/tsg-OXYH2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('01/01/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='ZSUY' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/tsg-ZSUY.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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_143220_15163523/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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_143220_15163523/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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_143220_15163523/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='ZSUY' and cl.classification_code=14;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/bottles-ZSUY.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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_143220_15163523/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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_143220_15163523/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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_143220_15163523/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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_143220_15163523/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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_143220_15163523/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXMY2949' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/mooring-buoys-time-series-EXMY2949.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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_143220_15163523/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXMY2969' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/mooring-buoys-time-series-EXMY2969.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 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='EXMY2972' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_143220_15163523/mooring-buoys-time-series-EXMY2972.nc; -valid_qc=12578