SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='1902574' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-1902574.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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_20240619_005332_15040144/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, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='3901580' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-3901580.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='3901943' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-3901943.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='4902438' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-4902438.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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_20240619_005332_15040144/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, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='4902507' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-4902507.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='4902508' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-4902508.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='4902512' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-4902512.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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_20240619_005332_15040144/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, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='4902592' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-4902592.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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_20240619_005332_15040144/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, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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_20240619_005332_15040144/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, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='4902686' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-4902686.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='4902687' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-4902687.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='4902688' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-4902688.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='4903046' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-4903046.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='4903364' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-4903364.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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_20240619_005332_15040144/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, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='6901926' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-6901926.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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_20240619_005332_15040144/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, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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_20240619_005332_15040144/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, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='6902862' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-6902862.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='6902863' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-6902863.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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_20240619_005332_15040144/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, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='6902865' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-6902865.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='6903082' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-6903082.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='6904098' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-6904098.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='6904121' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-6904121.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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_20240619_005332_15040144/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, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='6990580' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-6990580.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='6990636' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-6990636.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='7900526' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/argo-profiles-7900526.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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_20240619_005332_15040144/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, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='CFA3098' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/xbt-profiles-CFA3098.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='DBBT' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/ctd-profiles-DBBT.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='6801547' and cs.classification_code=4;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/glider-profiles-6801547.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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='6801573' and cs.classification_code=4;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240619_005332_15040144/glider-profiles-6801573.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 6) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 68.37 AND s.latitude >= 46 AND ((s.longitude <= -8.99 AND s.longitude >= -64.92) OR (s.longitude <= MOD(-8.99+360, 360) AND s.longitude >= MOD(-64.92+360, 360)) OR (s.longitude <= MOD(-8.99-360, 360) AND s.longitude >= MOD(-64.92-360, 360)) ) AND s.station_date <= TO_DATE('02/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/06/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_20240619_005332_15040144/glider-profiles-6801729.nc; -valid_qc=12578