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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='1902110' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-1902110.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='1902574' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-1902574.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='1902621' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-1902621.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='1902637' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-1902637.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='3901580' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-3901580.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='3901583' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-3901583.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='3901586' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-3901586.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='3902258' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-3902258.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='3902259' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-3902259.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='3902506' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-3902506.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='4902439' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-4902439.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='4902488' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-4902488.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='4902504' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-4902504.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='4902507' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-4902507.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='4902527' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-4902527.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='4903357' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-4903357.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='4903358' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-4903358.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='4903488' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-4903488.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='4903740' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-4903740.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='5904771' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-5904771.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='5904773' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-5904773.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='6901926' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-6901926.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='6901932' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-6901932.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='6901938' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-6901938.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='6902910' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-6902910.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='6903871' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-6903871.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='6904089' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-6904089.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='6904098' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-6904098.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='6904102' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-6904102.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='6904111' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-6904111.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='6904112' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-6904112.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='6904121' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-6904121.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='6990538' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-6990538.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='6990580' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-6990580.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='7900529' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-7900529.csv;-time=iso -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 <= 61.904 AND s.latitude >= 46.93 AND ((s.longitude <= 2.613 AND s.longitude >= -26.215) OR (s.longitude <= MOD(2.613+360, 360) AND s.longitude >= MOD(-26.215+360, 360)) OR (s.longitude <= MOD(2.613-360, 360) AND s.longitude >= MOD(-26.215-360, 360)) ) AND s.station_date <= TO_DATE('20/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('20/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188) AND P.station_id = s.station_id) 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='7900572' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_125001_15174025/argo-profiles-7900572.csv;-time=iso -valid_qc=12578