SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5902374' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/argo-profiles-5902374.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5902387' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/argo-profiles-5902387.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904116' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/argo-profiles-5904116.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904339' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/argo-profiles-5904339.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904358' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/argo-profiles-5904358.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904372' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/argo-profiles-5904372.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904374' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/argo-profiles-5904374.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904389' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/argo-profiles-5904389.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906138' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/argo-profiles-5906138.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='D5LR9' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/ctd-profiles-D5LR9.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='FASB' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/ctd-profiles-FASB.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1902077' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-1902077.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5901385' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5901385.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5902501' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5902501.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5903622' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5903622.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904650' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5904650.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904811' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5904811.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904925' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5904925.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905039' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905039.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905040' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905040.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905042' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905042.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905044' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905044.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905128' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905128.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905129' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905129.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905166' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905166.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905172' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905172.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905193' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905193.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905203' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905203.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905208' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905208.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905210' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905210.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905398' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905398.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905400' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905400.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905402' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905402.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905408' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905408.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905413' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905413.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905433' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905433.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905434' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905434.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905436' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905436.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905438' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905438.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905439' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905439.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905440' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905440.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905441' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905441.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905442' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905442.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905447' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905447.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905469' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905469.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905481' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905481.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905640' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905640.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905644' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905644.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905645' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905645.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905649' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905649.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905651' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905651.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905665' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905665.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905690' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905690.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905726' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905726.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905968' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5905968.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906138' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5906138.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906139' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5906139.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906151' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5906151.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906152' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5906152.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906255' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5906255.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906260' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5906260.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906270' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5906270.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906617' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5906617.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906618' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5906618.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906631' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5906631.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906632' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5906632.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906635' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5906635.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906636' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5906636.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906637' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5906637.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906638' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5906638.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906639' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5906639.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906640' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5906640.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906641' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5906641.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906642' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5906642.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5906645' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-5906645.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901656' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-6901656.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903214' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-6903214.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= -10.269 AND s.latitude >= -44.906 AND ((s.longitude <= 158.469 AND s.longitude >= 140.491) OR (s.longitude <= MOD(158.469+360, 360) AND s.longitude >= MOD(140.491+360, 360)) OR (s.longitude <= MOD(158.469-360, 360) AND s.longitude >= MOD(140.491-360, 360)) ) AND s.station_date <= TO_DATE('27/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903215' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/other-profiles-6903215.nc; -valid_qc=12578