SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901162' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-3901162.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904307' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904307.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904343' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904343.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904359' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904359.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904391' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904391.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904398' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904398.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904404' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904404.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904406' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904406.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904496' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904496.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904498' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904498.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904499' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904499.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904501' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904501.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904502' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904502.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904503' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904503.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904504' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904504.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904506' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904506.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904507' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904507.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904508' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904508.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904510' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904510.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904512' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904512.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904513' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904513.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904515' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904515.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904516' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904516.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904517' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904517.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904521' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904521.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904522' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904522.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904523' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904523.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904524' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904524.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904526' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904526.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904527' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904527.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904530' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904530.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904531' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-5904531.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901677' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-6901677.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 2 AND s.latitude >= -2 AND ((s.longitude <= -130 AND s.longitude >= 150) OR (s.longitude <= MOD(-130+360, 360) AND s.longitude >= MOD(150+360, 360)) OR (s.longitude <= MOD(-130-360, 360) AND s.longitude >= MOD(150-360, 360)) ) AND s.station_date <= TO_DATE('25/09/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901678' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240925_041557_15075845/argo-profiles-6901678.nc; -valid_qc=12578