SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901215' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-3901215.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901900' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-3901900.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901904' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-3901904.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901906' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-3901906.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3902326' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-3902326.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3902327' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-3902327.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5902371' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-5902371.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5902383' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-5902383.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5902384' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-5902384.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5902440' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-5902440.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904198' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-5904198.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904437' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-5904437.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905678' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-5905678.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905680' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-5905680.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905781' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-5905781.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905782' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-5905782.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905783' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-5905783.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906909' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-5906909.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903049' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-6903049.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903052' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-6903052.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903211' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-6903211.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903212' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-6903212.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903251' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-6903251.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903253' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-6903253.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903254' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-6903254.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903255' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-6903255.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903769' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-6903769.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903771' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-6903771.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6904092' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-6904092.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6904093' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-6904093.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900210' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-7900210.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900212' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-7900212.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900213' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-7900213.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900971' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-7900971.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900979' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-7900979.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900980' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-7900980.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900981' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-7900981.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900982' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-7900982.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900983' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-7900983.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900987' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-7900987.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900988' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-7900988.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900994' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-7900994.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900996' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-7900996.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900997' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-profiles-7900997.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2FGX5' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/xbt-profiles-2FGX5.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='PWAR' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/xbt-profiles-PWAR.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='PWPM' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/xbt-profiles-PWPM.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='WCX7445' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/xbt-profiles-WCX7445.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4801927' and cs.classification_code=4;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/glider-profiles-4801927.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4802944' and cs.classification_code=4;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/glider-profiles-4802944.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9901673' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/animal-profiles-9901673.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9901763' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/animal-profiles-9901763.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9901764' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/animal-profiles-9901764.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9901769' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/animal-profiles-9901769.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9901770' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/animal-profiles-9901770.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9901771' and cs.classification_code=5;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/animal-profiles-9901771.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1901734' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-1901734.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1901906' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-1901906.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1901921' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-1901921.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1901926' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-1901926.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1901937' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-1901937.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1901938' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-1901938.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1901939' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-1901939.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1902084' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-1902084.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1902085' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-1902085.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1902086' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-1902086.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1902087' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-1902087.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1902088' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-1902088.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1902093' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-1902093.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1902094' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-1902094.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1902095' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-1902095.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902825' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-2902825.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902830' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-2902830.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902831' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-2902831.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902832' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-2902832.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2903774' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-2903774.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901212' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-3901212.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901215' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-3901215.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901298' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-3901298.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901476' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-3901476.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901478' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-3901478.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901565' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-3901565.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901567' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-3901567.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901568' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-3901568.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901569' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-3901569.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901900' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-3901900.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901904' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-3901904.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3901906' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-3901906.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3902468' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-3902468.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='3902469' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-3902469.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903639' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-4903639.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='4903640' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-4903640.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5902383' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5902383.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5902438' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5902438.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904806' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5904806.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905034' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5905034.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905035' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5905035.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905098' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5905098.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905185' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5905185.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905186' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5905186.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905216' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5905216.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905267' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5905267.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905279' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5905279.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905318' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5905318.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905380' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5905380.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905383' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5905383.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905443' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5905443.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905982' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5905982.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905993' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5905993.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905994' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5905994.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905995' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5905995.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906217' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5906217.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906225' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5906225.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906227' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5906227.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906248' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5906248.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906312' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5906312.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906495' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5906495.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906498' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5906498.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906499' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5906499.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906541' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5906541.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906544' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5906544.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906560' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5906560.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906561' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5906561.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906562' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-5906562.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901987' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-6901987.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901988' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-6901988.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901993' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-6901993.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6902892' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-6902892.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6902894' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-6902894.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6902977' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-6902977.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6902979' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-6902979.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903213' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-6903213.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903223' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-6903223.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903232' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-6903232.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903251' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-6903251.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903253' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-6903253.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903254' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-6903254.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903255' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-6903255.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903767' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-6903767.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6904091' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-6904091.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6990502' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-6990502.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6990516' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-6990516.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900205' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900205.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900211' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900211.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900300' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900300.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900302' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900302.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900304' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900304.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900531' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900531.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900540' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900540.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900626' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900626.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900668' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900668.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900675' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900675.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900676' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900676.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900680' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900680.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900804' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900804.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900971' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900971.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900973' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900973.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900979' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900979.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900980' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900980.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900981' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900981.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900982' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900982.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900983' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900983.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900984' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900984.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900987' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900987.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900988' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900988.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900994' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900994.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900996' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900996.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900997' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900997.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900998' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900998.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7900999' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7900999.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='7901010' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-7901010.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -47.979 AND s.latitude >= -73.487 AND ((s.longitude <= -32.667 AND s.longitude >= -92.483) OR (s.longitude <= MOD(-32.667+360, 360) AND s.longitude >= MOD(-92.483+360, 360)) OR (s.longitude <= MOD(-32.667-360, 360) AND s.longitude >= MOD(-92.483-360, 360)) ) AND s.station_date <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/08/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='ZDLQ3' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/other-profiles-ZDLQ3.nc;