SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='1900158' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-1900158.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='1900169' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-1900169.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='1900188' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-1900188.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='2900226' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-2900226.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='2900229' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-2900229.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='2900232' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-2900232.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='2900233' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-2900233.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='2900265' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-2900265.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='2900266' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-2900266.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='2900267' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-2900267.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='2900268' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-2900268.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='2900269' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-2900269.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='2900270' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-2900270.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='2900271' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-2900271.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='2900272' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-2900272.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='2900273' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-2900273.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='2900274' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-2900274.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='2900354' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-2900354.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='2900359' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-2900359.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='2900459' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-2900459.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='2900538' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-2900538.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='2900570' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-2900570.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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_090746_15121332/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/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2002 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='5900517' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241202_090746_15121332/argo-trajectory-5900517.nc; -valid_qc=12578