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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='1900562' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-1900562.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='1900735' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-1900735.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='1900736' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-1900736.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='1900777' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-1900777.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='1900801' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-1900801.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='1900984' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-1900984.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='1901457' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-1901457.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='1902208' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-1902208.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='2903822' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-2903822.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='2903823' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-2903823.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='2903882' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-2903882.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='3901236' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-3901236.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='3901942' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-3901942.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='3901972' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-3901972.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='3901989' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-3901989.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='3902126' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-3902126.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='4901296' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-4901296.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='4901588' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-4901588.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='4903485' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-4903485.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='4903487' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-4903487.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='4903537' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-4903537.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='4903541' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-4903541.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='4903712' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-4903712.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='4903713' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-4903713.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='5903999' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-5903999.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6900126' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6900126.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6900243' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6900243.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6900266' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6900266.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6900407' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6900407.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6900410' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6900410.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6900411' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6900411.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6900467' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6900467.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6900506' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6900506.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6900508' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6900508.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6900511' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6900511.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6900512' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6900512.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6900513' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6900513.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6900571' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6900571.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6900610' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6900610.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6900692' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6900692.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6900702' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6900702.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6900764' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6900764.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6900765' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6900765.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6900769' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6900769.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6900772' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6900772.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6900789' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6900789.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901122' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901122.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901123' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901123.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901124' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901124.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901142' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901142.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901143' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901143.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901146' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901146.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901151' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901151.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901152' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901152.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901153' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901153.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901154' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901154.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901155' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901155.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901156' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901156.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901163' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901163.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901164' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901164.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901165' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901165.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901197' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901197.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901240' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901240.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901241' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901241.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901246' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901246.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901248' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901248.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901254' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901254.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901256' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901256.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901258' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901258.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901261' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901261.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901271' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901271.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901273' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901273.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901274' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901274.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901410' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901410.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901411' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901411.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901412' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901412.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901414' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901414.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901415' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901415.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901416' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901416.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901417' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901417.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901418' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901418.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901419' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901419.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901619' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901619.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901620' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901620.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901665' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901665.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6901672' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6901672.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6902572' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6902572.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6902656' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6902656.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6902768' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6902768.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6903010' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6903010.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6903073' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6903073.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6903074' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6903074.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6903075' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6903075.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6903076' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6903076.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6903717' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6903717.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6903758' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6903758.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6904125' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6904125.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6904181' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6904181.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6904182' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6904182.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6990625' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6990625.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6990627' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6990627.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6990628' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/argo-profiles-6990628.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='2FGX5' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/xbt-profiles-2FGX5.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='3YYQ' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/xbt-profiles-3YYQ.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='DAJT' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/xbt-profiles-DAJT.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='DBBH' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/xbt-profiles-DBBH.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='DMQN' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/xbt-profiles-DMQN.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='EXSD2684' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/xbt-profiles-EXSD2684.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='EXSD2692' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/xbt-profiles-EXSD2692.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='EXSD2693' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/xbt-profiles-EXSD2693.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='FABB' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/xbt-profiles-FABB.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='FMCY' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/xbt-profiles-FMCY.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='FNFP' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/xbt-profiles-FNFP.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='FNHO' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/xbt-profiles-FNHO.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='FZVN' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/xbt-profiles-FZVN.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='MGJS8' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/xbt-profiles-MGJS8.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='ZCDJ3' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/xbt-profiles-ZCDJ3.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='ZDLP' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/xbt-profiles-ZDLP.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='2FGX5' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/ctd-profiles-2FGX5.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='DBFP' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/ctd-profiles-DBFP.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='DMQN' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/ctd-profiles-DMQN.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='EAKF' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/ctd-profiles-EAKF.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='EBBW' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/ctd-profiles-EBBW.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='EFCP' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/ctd-profiles-EFCP.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='GLNE' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/ctd-profiles-GLNE.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='KCEJ' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/ctd-profiles-KCEJ.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='MLRM6' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/ctd-profiles-MLRM6.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='WTEC' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/ctd-profiles-WTEC.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='1801501' and cs.classification_code=4;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/glider-profiles-1801501.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6800458' and cs.classification_code=4;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/glider-profiles-6800458.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6800991' and cs.classification_code=4;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/glider-profiles-6800991.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6801631' and cs.classification_code=4;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/glider-profiles-6801631.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6801633' and cs.classification_code=4;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/glider-profiles-6801633.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, 2, 3, 4, 5, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 30 AND s.latitude >= 24 AND ((s.longitude <= -10 AND s.longitude >= -25) OR (s.longitude <= MOD(-10+360, 360) AND s.longitude >= MOD(-25+360, 360)) OR (s.longitude <= MOD(-10-360, 360) AND s.longitude >= MOD(-25-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2010 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) 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='6801636' and cs.classification_code=4;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250423_102811_15191078/glider-profiles-6801636.nc; -valid_qc=12578