SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901441' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-1901441.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901442' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-1901442.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901445' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-1901445.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2900100' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2900100.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2900106' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2900106.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2900107' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2900107.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2900560' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2900560.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2900565' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2900565.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2900566' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2900566.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2900571' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2900571.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2900678' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2900678.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2900755' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2900755.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2900756' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2900756.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2900757' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2900757.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2900764' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2900764.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2900768' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2900768.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2900783' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2900783.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2900876' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2900876.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2900880' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2900880.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2900882' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2900882.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2900883' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2900883.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2900888' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2900888.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2900939' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2900939.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2900943' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2900943.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901073' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901073.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901074' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901074.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901080' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901080.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901083' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901083.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901084' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901084.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901090' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901090.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901091' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901091.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901092' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901092.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901253' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901253.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901254' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901254.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901255' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901255.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901256' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901256.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901257' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901257.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901266' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901266.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901283' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901283.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901284' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901284.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901285' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901285.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901286' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901286.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901287' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901287.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901288' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901288.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901289' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901289.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901290' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901290.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901291' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901291.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901292' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901292.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901293' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901293.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901294' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901294.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901296' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901296.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901312' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901312.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901323' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901323.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901325' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901325.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901326' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901326.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901327' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901327.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901328' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901328.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901329' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901329.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901330' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901330.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901331' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901331.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901332' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901332.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901333' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901333.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901334' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901334.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901335' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901335.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901336' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901336.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901521' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901521.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901522' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901522.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901592' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901592.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901593' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901593.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901595' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901595.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901596' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901596.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901597' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901597.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901598' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901598.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901616' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901616.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901617' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901617.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901618' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901618.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901619' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901619.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901620' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901620.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901621' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901621.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901622' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901622.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901623' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901623.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901624' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901624.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901625' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901625.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901626' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901626.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901627' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901627.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901628' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901628.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901629' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901629.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2901630' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2901630.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902073' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902073.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902074' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902074.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902078' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902078.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902079' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902079.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902080' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902080.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902081' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902081.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902082' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902082.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902083' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902083.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902084' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902084.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902086' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902086.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902087' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902087.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902091' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902091.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902094' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902094.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902095' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902095.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902111' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902111.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902112' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902112.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902113' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902113.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902114' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902114.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902365' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902365.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902560' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902560.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902570' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902570.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902637' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902637.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902642' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902642.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2902644' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-2902644.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4900510' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-4900510.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4900668' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-4900668.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4900669' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-4900669.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4900670' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-4900670.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5901371' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-5901371.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5901372' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-5901372.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5901373' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-5901373.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5903588' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-5903588.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5903589' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-5903589.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5903590' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-5903590.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5903712' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-5903712.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5903744' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-5903744.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5903745' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-5903745.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5903746' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-5903746.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5903747' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-5903747.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5904302' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-5904302.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5904313' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-5904313.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5904334' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-5904334.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6900498' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-6900498.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6900996' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-6900996.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901002' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-6901002.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901541' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-6901541.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2010 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 11) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 22 AND cl.lat_max >= 0 AND ((cl.long_min <= 100 AND cl.long_max >= 77) OR (cl.long_min <= MOD(100+360, 360) AND cl.long_max >= MOD(77+360, 360)) OR (cl.long_min <= MOD(100-360, 360) AND cl.long_max >= MOD(77-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 22 AND l.latitude >= 0 AND ((l.longitude <= 100 AND l.longitude >= 77) OR (l.longitude <= MOD(100+360, 360) AND l.longitude >= MOD(77+360, 360)) OR (l.longitude <= MOD(100-360, 360) AND l.longitude >= MOD(77-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901545' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090529_15121330/argo-trajectory-6901545.nc; -valid_qc=12578