SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='9VBM5' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-9VBM5.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='A8HE4' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-A8HE4.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='A8IF2' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-A8IF2.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='A8IG2' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-A8IG2.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='A8IG9' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-A8IG9.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='CGAD' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-CGAD.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='CGAE' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-CGAE.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='CGAF' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-CGAF.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='CGAG' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-CGAG.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='CGAI' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-CGAI.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='CGAN' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-CGAN.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='DCHO' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-DCHO.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='DDFL2' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-DDFL2.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='DFCW2' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-DFCW2.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='DFCX2' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-DFCX2.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='DIDS' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-DIDS.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='DPGZ' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-DPGZ.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='ELZZ4' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-ELZZ4.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='EXO10639' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-EXO10639.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='EXO12210' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-EXO12210.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='EXO12770' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-EXO12770.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='EXO12992' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-EXO12992.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='FABB' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-FABB.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='FVNM' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-FVNM.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='FZVN' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-FZVN.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='IF000650' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-IF000650.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='NDEC' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-NDEC.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='NFSJ' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-NFSJ.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='OCL0347' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-OCL0347.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='SHIP' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-SHIP.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='UDVX' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-UDVX.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='V7NX2' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-V7NX2.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='VKDA' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-VKDA.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='VKLD' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-VKLD.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='VKLG' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-VKLG.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='VKLI' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-VKLI.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='VKLP' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-VKLP.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='VKML' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-VKML.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='VKMN' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-VKMN.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='VKNG' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-VKNG.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='VLNC' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-VLNC.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='VQEN2' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-VQEN2.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='VQEN3' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-VQEN3.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-VRCF6.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='VRCX7' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-VRCX7.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='VTJR' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-VTJR.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='WTEC' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-WTEC.nc;
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (3) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 31 AND s.latitude >= 2 AND ((s.longitude <= 78 AND s.longitude >= 44) OR (s.longitude <= MOD(78+360, 360) AND s.longitude >= MOD(44+360, 360)) OR (s.longitude <= MOD(78-360, 360) AND s.longitude >= MOD(44-360, 360)) ) AND s.station_date <= TO_DATE('3/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 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) 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='ZIZP9' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250123_082101_15144244/ctd-profiles-ZIZP9.nc;