SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3YYQ' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/xbt-profiles-3YYQ.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='DBFP' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/xbt-profiles-DBFP.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='DBLK' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/xbt-profiles-DBLK.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='LOAI' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/xbt-profiles-LOAI.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='LOPD' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/xbt-profiles-LOPD.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='NBTM' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/xbt-profiles-NBTM.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='SHIP' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/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 (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='UBSZ' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/xbt-profiles-UBSZ.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='ZDLP' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/xbt-profiles-ZDLP.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='DBBH' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-DBBH.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='DBFP' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-DBFP.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='DBLK' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-DBLK.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EBBW' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-EBBW.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='ESHZ' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-ESHZ.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='ESRL' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-ESRL.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='ESUV' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-ESUV.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='ESUW' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-ESUW.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXO10487' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-EXO10487.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXO10532' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-EXO10532.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXO10548' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-EXO10548.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXO10553' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-EXO10553.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXO10593' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-EXO10593.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXO10961' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-EXO10961.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXO11056' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-EXO11056.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXO11443' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-EXO11443.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXO11636' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-EXO11636.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXO11681' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-EXO11681.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXO12654' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-EXO12654.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXOC0426' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-EXOC0426.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXOC1087' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-EXOC1087.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='KCEJ' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-KCEJ.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='KUS1475' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-KUS1475.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='LOAI' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-LOAI.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='LRAQ' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-LRAQ.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='OCL0150' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-OCL0150.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='OCL0222' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-OCL0222.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='OCL0245' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-OCL0245.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='OCL0306' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-OCL0306.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='OCL0315' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-OCL0315.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='OCL0361' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-OCL0361.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='OCL0371' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-OCL0371.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='PWAR' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-PWAR.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='SHIP' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-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 (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='UAMZ' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-UAMZ.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='UMFW' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-UMFW.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='UNZA' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-UNZA.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='UQYC' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-UQYC.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='USPO' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-USPO.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='USXE' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-USXE.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='UUNN' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-UUNN.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='UUTU' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-UUTU.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='UVKL' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-UVKL.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='UZWK' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-UZWK.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='WECB' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-WECB.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='ZDLP' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/ctd-profiles-ZDLP.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6800980' and cs.classification_code=4;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/glider-profiles-6800980.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6801542' and cs.classification_code=4;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/glider-profiles-6801542.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6801714' and cs.classification_code=4;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/glider-profiles-6801714.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900075' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900075.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900077' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900077.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900078' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900078.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900082' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900082.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900083' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900083.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900099' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900099.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900101' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900101.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900103' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900103.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900105' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900105.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900106' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900106.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900108' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900108.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900115' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900115.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900118' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900118.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900144' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900144.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900147' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900147.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900148' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900148.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900149' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900149.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900150' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900150.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900152' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900152.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900153' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900153.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900154' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900154.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900237' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900237.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900241' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900241.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900244' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900244.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900255' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900255.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900256' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900256.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900258' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900258.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900259' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900259.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900262' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900262.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900263' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900263.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900264' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900264.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900296' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900296.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900297' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900297.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900643' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900643.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900645' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900645.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900838' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900838.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9900839' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9900839.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9901386' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9901386.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9901983' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-9901983.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXSM0344' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-EXSM0344.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXSM0368' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-EXSM0368.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXSM0390' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-EXSM0390.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXSM0440' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-EXSM0440.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXSM0486' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-EXSM0486.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXSM0489' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-EXSM0489.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXSM0490' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-EXSM0490.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXSM0491' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/animal-profiles-EXSM0491.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1900939' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-1900939.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1900940' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-1900940.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1901281' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-1901281.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1901286' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-1901286.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1901288' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-1901288.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3900086' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-3900086.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3900089' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-3900089.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3900195' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-3900195.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3900378' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-3900378.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901508' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-3901508.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5901448' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-5901448.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5901456' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-5901456.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5901728' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-5901728.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5902116' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-5902116.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904151' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-5904151.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904659' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-5904659.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904660' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-5904660.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904856' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-5904856.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906003' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-5906003.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906226' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-5906226.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906227' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-5906227.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906312' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-5906312.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6902556' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-6902556.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6904091' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-6904091.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900018' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900018.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900078' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900078.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900079' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900079.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900080' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900080.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900081' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900081.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900096' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900096.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900097' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900097.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900129' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900129.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900130' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900130.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900132' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900132.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900133' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900133.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900151' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900151.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900152' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900152.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900153' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900153.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900154' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900154.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900207' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900207.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900213' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900213.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900300' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900300.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900356' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900356.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900401' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900401.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900973' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900973.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900998' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900998.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900999' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-7900999.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -59.665 AND s.latitude >= -61.903 AND ((s.longitude <= -47.06 AND s.longitude >= -52.477) OR (s.longitude <= MOD(-47.06+360, 360) AND s.longitude >= MOD(-52.477+360, 360)) OR (s.longitude <= MOD(-47.06-360, 360) AND s.longitude >= MOD(-52.477-360, 360)) ) AND s.station_date <= TO_DATE('22/10/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('22/09/1950 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='ZDLQ3' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_165748_15094044/other-profiles-ZDLQ3.nc; -valid_qc=12578