SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='1900171' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-1900171.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='1900187' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-1900187.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='1900226' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-1900226.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='1900633' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-1900633.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900093' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900093.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900101' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900101.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900103' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900103.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900105' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900105.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900228' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900228.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900230' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900230.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900349' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900349.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900351' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900351.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900352' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900352.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900353' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900353.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900357' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900357.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900358' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900358.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900493' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900493.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900530' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900530.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900531' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900531.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900532' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900532.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900533' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900533.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900534' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900534.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900535' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900535.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900536' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900536.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900537' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900537.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900567' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900567.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900593' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900593.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900679' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900679.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900680' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900680.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900681' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900681.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900682' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900682.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900758' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900758.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900761' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900761.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900765' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900765.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900766' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900766.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900877' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900877.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900878' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900878.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900879' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900879.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900881' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900881.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900884' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900884.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900885' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900885.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900886' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900886.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2900887' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2900887.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2901075' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2901075.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2901085' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2901085.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2901086' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2901086.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='2901087' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-2901087.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='4900511' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-4900511.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='4900671' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-4900671.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='4900672' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-4900672.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='4900673' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-4900673.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='4900674' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-4900674.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='4900675' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-4900675.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='5900234' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-5900234.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='5901212' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-5901212.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='5901370' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-5901370.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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_090654_15121331/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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='5901374' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-5901374.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2009 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2006 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='5901524' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090654_15121331/argo-trajectory-5901524.nc; -valid_qc=12578