SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2FGX5' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/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 (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3YYQ' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/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 (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7JAU' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-7JAU.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7JGQ' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-7JGQ.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7JHB' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-7JHB.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7JSB' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-7JSB.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7JXZ' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-7JXZ.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7JZG' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-7JZG.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7KAT' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-7KAT.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7KBD' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-7KBD.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7KEV' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-7KEV.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7KGM' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-7KGM.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7KHX' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-7KHX.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7KMX' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-7KMX.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7KNK' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-7KNK.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7KPB' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-7KPB.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7LNO' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-7LNO.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='8CWKFZE' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-8CWKFZE.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9V5317' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-9V5317.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='AJM592T' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-AJM592T.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='BSYBHQM' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-BSYBHQM.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='CFA3098' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-CFA3098.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='CGDJ' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-CGDJ.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='CGDN' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-CGDN.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='CGDT' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-CGDT.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='DGWF2' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-DGWF2.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY3698' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-EXMY3698.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='FKJB' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-FKJB.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='FKXMM6T' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-FKXMM6T.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='FMCY' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/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 (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='FNCM' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-FNCM.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='FNFP' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/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 (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='FNIN' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-FNIN.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='FNUR' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-FNUR.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='FQBE' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-FQBE.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='IF000650' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-IF000650.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='IF000651' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-IF000651.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='IF000652' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-IF000652.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='IF000653' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-IF000653.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='IF000654' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-IF000654.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='IF000655' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-IF000655.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='IF000656' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-IF000656.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='IF000657' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-IF000657.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='IF000658' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-IF000658.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='IF000659' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-IF000659.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JD3255' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-JD3255.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JD3706' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-JD3706.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JD4026' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-JD4026.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JD4057' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-JD4057.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JD4791' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-JD4791.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JEEB' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-JEEB.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JEGB' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-JEGB.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JEGP' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-JEGP.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JEHK' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-JEHK.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JETM' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-JETM.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JFCM' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-JFCM.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JG5710' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-JG5710.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JGKL' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-JGKL.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JJHN' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-JJHN.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JKQL' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-JKQL.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JL6653' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-JL6653.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JM6733' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-JM6733.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JNSR' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-JNSR.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JNZA' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-JNZA.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JPBN' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-JPBN.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JQIX' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-JQIX.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='LDGJ' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-LDGJ.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='LMEL' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-LMEL.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='LMVX6CS' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-LMVX6CS.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='LYBTUBW' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-LYBTUBW.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='OXCH2' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-OXCH2.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='PWCS' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-PWCS.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='PWPM' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-PWPM.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='REBCRFD' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-REBCRFD.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='SHIP' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-SHIP.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='SJA4RSK' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-SJA4RSK.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='V7FN5' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-V7FN5.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VRDE7' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-VRDE7.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (2) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 90 AND s.latitude >= -89 AND ((s.longitude <= 223.75 AND s.longitude >= -223.75) OR (s.longitude <= MOD(223.75+360, 360) AND s.longitude >= MOD(-223.75+360, 360)) OR (s.longitude <= MOD(223.75-360, 360) AND s.longitude >= MOD(-223.75-360, 360)) ) AND s.station_date <= TO_DATE('31/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/07/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='WRXMSGB' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250225_122519_15162498/xbt-profiles-WRXMSGB.nc; -valid_qc=12578