SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1902579' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-1902579.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1902602' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-1902602.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1902604' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-1902604.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1902621' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-1902621.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2903771' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-2903771.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2903899' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-2903899.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901598' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-3901598.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901850' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-3901850.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901864' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-3901864.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901865' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-3901865.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901872' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-3901872.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901875' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-3901875.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901945' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-3901945.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3902102' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-3902102.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3902114' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-3902114.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3902116' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-3902116.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3902118' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-3902118.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3902119' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-3902119.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3902462' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-3902462.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3902463' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-3902463.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3902464' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-3902464.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3902465' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-3902465.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3902579' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-3902579.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4902469' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4902469.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4902471' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4902471.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4902477' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4902477.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4902479' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4902479.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4902505' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4902505.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4902506' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4902506.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4902509' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4902509.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4902513' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4902513.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4902535' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4902535.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4902557' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4902557.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4902579' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4902579.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4902594' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4902594.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4902652' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4902652.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4902670' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4902670.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4902684' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4902684.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4902685' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4902685.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903357' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4903357.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903455' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4903455.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903532' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4903532.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903634' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4903634.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903663' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4903663.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903672' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4903672.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903673' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4903673.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903674' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-4903674.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906983' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-5906983.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906984' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-5906984.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906994' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-5906994.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901201' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6901201.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901921' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6901921.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901924' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6901924.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901928' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6901928.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901929' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6901929.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901932' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6901932.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901933' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6901933.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901935' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6901935.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901937' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6901937.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901938' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6901938.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901939' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6901939.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6902794' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6902794.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6902807' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6902807.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6902864' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6902864.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6902895' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6902895.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6902910' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6902910.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6902911' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6902911.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6902912' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6902912.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903009' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903009.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903027' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903027.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903041' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903041.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903086' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903086.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903102' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903102.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903113' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903113.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903131' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903131.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903546' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903546.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903547' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903547.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903560' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903560.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903561' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903561.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903562' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903562.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903563' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903563.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903565' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903565.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903566' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903566.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903571' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903571.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903573' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903573.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903582' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903582.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903584' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903584.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903585' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903585.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903586' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903586.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903590' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903590.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903591' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903591.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903592' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903592.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903760' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903760.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903761' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903761.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903872' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6903872.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6904084' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6904084.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6904085' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6904085.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6904106' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6904106.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6904185' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6904185.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6904191' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6904191.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6904192' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6904192.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6904231' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6904231.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6904240' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6904240.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6904242' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6904242.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6990526' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-6990526.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900528' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-7900528.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900535' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-7900535.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900536' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-7900536.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900537' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-7900537.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900556' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-7900556.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900557' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-7900557.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900571' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-7900571.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900585' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-7900585.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7901006' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-7901006.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7901007' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-7901007.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7901027' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-7901027.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7901036' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-7901036.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7901037' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-7901037.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7901038' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/argo-profiles-7901038.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3YYQ' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY3698' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/xbt-profiles-EXMY3698.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='LDGJ' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/xbt-profiles-LDGJ.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='LMEL' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/xbt-profiles-LMEL.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6800983' and cs.classification_code=4;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/glider-profiles-6800983.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6801562' and cs.classification_code=4;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/glider-profiles-6801562.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6801620' and cs.classification_code=4;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/glider-profiles-6801620.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6801729' and cs.classification_code=4;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/glider-profiles-6801729.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9901780' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/animal-profiles-9901780.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2903794' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-2903794.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4902235' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-4902235.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903564' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-6903564.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7901028' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-7901028.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1717' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1717.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1718' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1718.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1719' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1719.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1720' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1720.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1721' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1721.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1726' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1726.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1727' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1727.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1728' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1728.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1730' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1730.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1731' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1731.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1732' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1732.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1735' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1735.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1739' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1739.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1741' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1741.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1751' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1751.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1879' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1879.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1881' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1881.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1882' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1882.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1890' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1890.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1892' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1892.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1950' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1950.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1951' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1951.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1952' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1952.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1953' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1953.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1954' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1954.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1955' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1955.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1956' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1956.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1957' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1957.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1959' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1959.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1960' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1960.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1961' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1961.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1962' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1962.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1970' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1970.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY1972' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY1972.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (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 <= 90 AND s.latitude >= 57 AND ((s.longitude <= 90 AND s.longitude >= -90) OR (s.longitude <= MOD(90+360, 360) AND s.longitude >= MOD(-90+360, 360)) OR (s.longitude <= MOD(90-360, 360) AND s.longitude >= MOD(-90-360, 360)) ) AND s.station_date <= TO_DATE('28/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXMY3696' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_134153_15041534/other-profiles-EXMY3696.nc; -valid_qc=12578