SELECT
   t.start_date_time_key,
  (TO_DATE('1.1.1970 07:00:00','dd.mm.yyyy hh24:mi:ss') +  t.start_date_time_key /24/60/60) start_tk,
  (TO_DATE('1.1.1970 07:00:00','dd.mm.yyyy hh24:mi:ss') +  t.start_ts /24/60/60) start_time,
  (TO_DATE('1.1.1970 07:00:00','dd.mm.yyyy hh24:mi:ss') +  t.end_ts /24/60/60) end_time,
  MAX((TO_DATE('1.1.1970 07:00:00','dd.mm.yyyy hh24:mi:ss') +  t.start_date_time_key /24/60/60)) over (PARTITION BY 1) AS max_start_tk,
  t.contact_info,
  c.campaign_name,
  cl.calling_list_name,
  r.resource_type,
  r.resource_key,
  r.resource_name,
  t.call_result_key,
  cr.call_result
  FROM gimdb.contact_attempt_fact PARTITION(GIM_2018_09_02_00_00_00) t
  inner join gimdb.campaign c
        ON c.campaign_key = t.campaign_key
--        and c.campaign_name not like 'LCS%'
  inner join gimdb.calling_list cl
        ON cl.calling_list_key = t.CALLING_LIST_KEY
  inner join gimdb.resource_ r
        ON r.resource_key = t.resource_key
  inner join gimdb.call_result cr
        ON cr.call_result_key = t.call_result_key
  WHERE 0=0
--  and   r.resource_name = 'msoraya'
  AND   t.record_field_35 = 3701635354
  ;
  SELECT * FROM gimdb.interaction_fact PARTITION(GIM_2018_09_02_00_00_00) t
  WHERE t.media_server_ixn_guid = '01B31JGORCDJ3D7U1023G2LAES9QLU9H'
  ;
  SELECT * FROM gimdb.interaction_resource_fact PARTITION(GIM_2018_09_02_00_00_00) t
  WHERE t.interaction_id = 4929070357