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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-1902110.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-1902574.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-1902621.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-1902637.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-3901580.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-3901583.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-3901586.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-3902258.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-3902259.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-3902506.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-4902439.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-4902488.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-4902504.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-4902507.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-4902527.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-4903357.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-4903358.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-4903488.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-4903740.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-5904771.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-5904773.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-6901926.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-6901932.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-6901938.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-6902910.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-6903871.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-6904089.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-6904098.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-6904102.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-6904111.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-6904112.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-6904121.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-6990538.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-6990580.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-7900529.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, 3, 11, 12, 13, 14, 15, 19) 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_121433_15173857/argo-profiles-7900572.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, 3, 11, 12, 13, 14, 15, 19) 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='IF000650' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_121433_15173857/ctd-profiles-IF000650.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, 3, 11, 12, 13, 14, 15, 19) 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='IF000651' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_121433_15173857/ctd-profiles-IF000651.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, 3, 11, 12, 13, 14, 15, 19) 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='IF000652' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_121433_15173857/ctd-profiles-IF000652.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, 3, 11, 12, 13, 14, 15, 19) 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='IF000653' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_121433_15173857/ctd-profiles-IF000653.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, 3, 11, 12, 13, 14, 15, 19) 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='IF000654' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_121433_15173857/ctd-profiles-IF000654.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, 3, 11, 12, 13, 14, 15, 19) 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='IF000655' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_121433_15173857/ctd-profiles-IF000655.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, 3, 11, 12, 13, 14, 15, 19) 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='IF000656' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_121433_15173857/ctd-profiles-IF000656.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, 3, 11, 12, 13, 14, 15, 19) 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='IF000657' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_121433_15173857/ctd-profiles-IF000657.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, 3, 11, 12, 13, 14, 15, 19) 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='IF000658' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_121433_15173857/ctd-profiles-IF000658.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, 3, 11, 12, 13, 14, 15, 19) 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='IF000659' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250321_121433_15173857/ctd-profiles-IF000659.nc; -valid_qc=12578