select
  case when clFirst.src_abonent_type = 'SP' then clFirst.src_abonent else clFirst.src_id end as abonent, 
  que.enqueued_time as enqueued_time,
  que.unblocked_time as unblocked_time,
  inc2.title as project,
  case when que.unblocked_time is not NULL then INTERVALTOSEC(que.unblocked_time - que.enqueued_time) else INTERVALTOSEC(que.dequeued_time- que.enqueued_time) end as ivrtime,
  case when que.unblocked_time is not NULL then INTERVALTOSEC(que.dequeued_time - que.unblocked_time) else 0 end as waittime,  
  que.final_stage as final_stage,
  coalesce(clOp.dst_abonent,case when clNum.dst_abonent_type = 'SP' then clNum.dst_abonent else clNum.dst_id end) as nextId,
  coalesce(clOp.created,clNum.created) as nextCreated,
  coalesce(clOp.connected,clNum.connected) as nextConnected,
  coalesce(clOp.ended,clNum.ended) as nextEnded,
  coalesce(INTERVALTOSEC(clOp.connected-clOp.created),INTERVALTOSEC(clNum.connected-clNum.created)) as pickupTime,
  coalesce(INTERVALTOSEC(clOp.ended-clOp.connected),INTERVALTOSEC(clNum.ended-clNum.connected)) as speakingTime,
  inc.uuid as changecallproject,
  coalesce(ph.wrapuptime,0) as wrapuptime,
  ph.formuuid as phuuid,
  que.session_id as session_id_2,
  que.session_id as session_id
from 
  queued_calls que
  join call_legs clFirst on (clFirst.session_id = que.session_id and clFirst.leg_id = que.first_leg_id)
  left join call_legs clOp on (clOp.session_id = que.session_id and clOp.leg_id = que.next_leg_id and que.final_stage = 'operator')
  left join call_legs clNum on (clNum.session_id = que.session_id and clNum.leg_id = que.next_leg_id and que.final_stage = 'redirect')
  left join mv_employee emp on (emp.login = clOp.dst_abonent or emp.login = clNum.dst_abonent)
  left join mv_incoming_call_project inc on (inc.uuid = que.change_call_project and que.final_stage = 'changecallproject')
  left join mv_phone_call ph on (ph.projectuuid = que.project_id and ph.sessionid = que.session_id and ph.operatoruuid = emp.uuid)
  left join mv_incoming_call_project inc2 on (inc2.uuid = que.project_id)
where 
  que.enqueued_time >= '2020-05-01' and que.enqueued_time < '2020-06-01'
  and que.project_id in 
                                    
               ('0ma57t2aon9ul800', 
                '0mcko0m6k3utcq1s',
                '0ma57thknjaaq3kg',
               '0ma57tb6l1bnuml8', 
               '0mavrfon73dg88n0', 
               '0mavrclt6kn95bm4', 
               '0mad0fnq8nq408q4', 
               '0mbafmjq9kh2kkok', 
               '0mavr9eqlg47esbs', 
               '0mdbub6jhlb8n67g', 
               '0me206gphg8j910s', 
               '0meniml6jgn3cq28', 
               '0mfaqdsnb6k23sbk',
               '0mh7h659b38q3ub0',
               '0mb41s15b2l0h34g' 
               )