SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JD2769' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/xbt-profiles-JD2769.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JEHK' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/xbt-profiles-JEHK.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JLPT' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/xbt-profiles-JLPT.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JNZL' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/xbt-profiles-JNZL.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JPBN' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/xbt-profiles-JPBN.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JCOY' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/ctd-profiles-JCOY.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JRZH' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/ctd-profiles-JRZH.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='OCL0388' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/ctd-profiles-OCL0388.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901480' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2901480.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901481' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2901481.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901482' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2901482.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901492' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2901492.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901504' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2901504.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901524' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2901524.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901529' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2901529.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901543' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2901543.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901570' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2901570.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901571' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2901571.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901574' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2901574.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901577' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2901577.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901679' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2901679.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901680' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2901680.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902044' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902044.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902045' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902045.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902047' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902047.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902050' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902050.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902051' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902051.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902052' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902052.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902053' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902053.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902054' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902054.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902055' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902055.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902056' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902056.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902057' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902057.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902159' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902159.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902453' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902453.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902474' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902474.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902485' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902485.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902488' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902488.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902491' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902491.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902493' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902493.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902494' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902494.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902495' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902495.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902497' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902497.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902498' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902498.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902500' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902500.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902502' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902502.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902503' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902503.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902504' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902504.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902507' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902507.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902511' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902511.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902515' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902515.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902532' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902532.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902533' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902533.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902545' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902545.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902546' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902546.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902552' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902552.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902555' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902555.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902653' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902653.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902656' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902656.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902667' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902667.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902668' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902668.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902670' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902670.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902674' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902674.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902691' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902691.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902692' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902692.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902693' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902693.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902694' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902694.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902695' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902695.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902696' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902696.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902700' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902700.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902940' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902940.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902944' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902944.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902945' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902945.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902949' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902949.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902951' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902951.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902953' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902953.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902954' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902954.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902959' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902959.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902960' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902960.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902961' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902961.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902962' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902962.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902963' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902963.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902964' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902964.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902966' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902966.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902975' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902975.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902981' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902981.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902982' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2902982.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2903003' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2903003.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2903014' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2903014.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2903170' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-2903170.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5901408' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-5901408.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5901690' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-5901690.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5901811' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-5901811.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5903752' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-5903752.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904025' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-5904025.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904034' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-5904034.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904091' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-5904091.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904566' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-5904566.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904741' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-5904741.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904746' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-5904746.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904747' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-5904747.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904748' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-5904748.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904935' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-5904935.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901559' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-6901559.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select 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 <= 38.69 AND s.latitude >= 11.84 AND ((s.longitude <= 159.16 AND s.longitude >= 92.04) OR (s.longitude <= MOD(159.16+360, 360) AND s.longitude >= MOD(92.04+360, 360)) OR (s.longitude <= MOD(159.16-360, 360) AND s.longitude >= MOD(92.04-360, 360)) ) AND s.station_date <= TO_DATE('28/09/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('25/09/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901738' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241208_111022_15124692/other-profiles-6901738.nc; -valid_qc=12578