SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VRCF6' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/xbt-profiles-VRCF6.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901286' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2901286.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901327' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2901327.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901331' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2901331.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901332' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2901332.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901336' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2901336.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901521' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2901521.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901522' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2901522.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901592' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2901592.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901593' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2901593.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901595' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2901595.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901620' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2901620.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901624' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2901624.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2901629' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2901629.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902086' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2902086.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902087' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2902087.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902114' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2902114.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902134' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2902134.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902365' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2902365.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902595' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2902595.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902596' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2902596.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902597' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2902597.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902599' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2902599.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902601' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2902601.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902605' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2902605.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902612' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2902612.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2902644' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-2902644.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5903588' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-5903588.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5903589' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-5903589.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904302' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-5904302.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904313' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-5904313.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904334' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-5904334.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6900996' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-6900996.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901002' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-6901002.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901541' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-6901541.csv;-time=iso
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 15) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 24.963 AND s.latitude >= 3.483 AND ((s.longitude <= 93.677 AND s.longitude >= 77.567) OR (s.longitude <= MOD(93.677+360, 360) AND s.longitude >= MOD(77.567+360, 360)) OR (s.longitude <= MOD(93.677-360, 360) AND s.longitude >= MOD(77.567-360, 360)) ) AND s.station_date <= TO_DATE('31/10/2014 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('15/09/2014 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30, 12, 61, 64, 218, 188, 65, 114, 140) AND P.station_id = s.station_id) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901545' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241204_075459_15124401/other-profiles-6901545.csv;-time=iso