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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3902491' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-3902491.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4902349' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4902349.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4902350' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4902350.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4902351' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4902351.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4902352' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4902352.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4902915' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4902915.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903232' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903232.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903237' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903237.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903238' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903238.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903240' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903240.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903248' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903248.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903249' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903249.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903250' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903250.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903254' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903254.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903255' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903255.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903278' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903278.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903279' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903279.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903353' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903353.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903354' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903354.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903356' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903356.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903464' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903464.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903466' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903466.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903468' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903468.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903469' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903469.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903471' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903471.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903472' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903472.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903542' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903542.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903543' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903543.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903544' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903544.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903545' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903545.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903546' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903546.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903547' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903547.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903548' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903548.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903549' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903549.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903550' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903550.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903551' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903551.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903552' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903552.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903553' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903553.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903554' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903554.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903555' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903555.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903556' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903556.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903557' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903557.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903559' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903559.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903562' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903562.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903563' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903563.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903622' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903622.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903624' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903624.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903662' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-4903662.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, 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 <= 30 AND s.latitude >= 20 AND ((s.longitude <= -80 AND s.longitude >= -100) OR (s.longitude <= MOD(-80+360, 360) AND s.longitude >= MOD(-100+360, 360)) OR (s.longitude <= MOD(-80-360, 360) AND s.longitude >= MOD(-100-360, 360)) ) AND s.station_date <= TO_DATE('01/03/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/10/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7901009' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250326_090523_15176379/argo-profiles-7901009.nc; -valid_qc=12578