declare 
  @sd datetime = '20201001',
  @ed datetime = '20201001 23:59:59.997',
  @Task_ID int = '2101'
   

select [Интервал 15 мин] = left(sp.Caption1,5),
       [День] = cal.DT, 
	   [ДН] = cal.DAY_CAP,
       lcs.Session_id, 
       lcs.Questionniare_ID,
       [Номер в цепочке звонка] = lcs.Call_No,
       [Номер звонка в анкете]  = case when lcs.Questionniare_ID = 0 then 1 
                                       else ROW_NUMBER() OVER(PARTITION BY lcs.Questionniare_ID ORDER BY CREATED)
                                   end,
       Call_ID,
       Subscriber_ID,
       CallDate = lcs.CREATED, 
       IVRTime = lcs.IVRTime, 
       [QueueTime+Ringing] = lcs.QueueTime,
       [Источник] = cs.Name,
       [Статус Очереди] = qsl.QueueStatus,       
       [Статус выхода на оператора] = osl.OperStatus,
       [Oper_ID] = lcs.User_ID,
       [Площадка] = f.field_Name,
       [Login] = isnull(nullif(u.user_number, ''), u.old_user_number),
	   [Роль] = isnull(en.Name , ''),
       [OperName] = u.user_surname + CHAR(32) + u.user_firstname + CHAR(32) + u.user_secondname,
       RingingTime = lcs.RingTime ,	
       TalkTime	 = lcs.ConnTime - lcs.HoldTime,
       HoldTime	= lcs.HoldTime,       
       ACW = lcs.ACW, 
       HT = case when lcs.Input = 0 or DialStat = 2 then lcs.RingTime+lcs.ConnTime+lcs.ACW else 0 end,
       AON_TO,
       AON = 
				CASE
					WHEN AON LIKE 'UID%' THEN SUBSTRING(AON, CHARINDEX('#', AON)+1, LEN(AON))
					ELSE AON
				END,
       lcs.Queue_ID,
	   [Результат звонка] = cr.Caption,
       tr.TransferStatus,
       lcs.TransferTime,
       lcs.TransferNumber,
       [Инициатор разъединения] = ds.DInitiator,
	   [Комментарий] = isnull(lcs.Comment, '')+isnull(br.hangup, '')   

from report..LS lcs 
 
left join Report.dbo.Report_Templates_CallSources cs 
       on lcs.Source_ID = cs.ID
left join Report.dbo.Report_Templates_QueueStatusList qsl
       on qsl.QS_ID = lcs.QS_ID
left join Report.dbo.Report_Templates_OperStatusList osl 
       on osl.OS_ID = lcs.OS_ID
left join Report.dbo.Report_Templates_TransferStatus tr
       on tr.TransferStatus_ID = lcs.TransferStatus_ID
left join Report.dbo.Report_Templates_Disconnect_Initiator ds
       on ds.Disconnect_ID = lcs.Disconnect_ID
left join Control.dbo.AC_Project_Groups_Users_DT pgudt
  on pgudt.CL_ID = lcs.CL_ID
 and pgudt.user_id = lcs.User_ID
left join Control.dbo.UsersRoles_Entity en
  on en.UREn_ID = pgudt.UREn_ID

left join Control.dbo.AC_Calendar cal
  on cal.CL_ID = lcs.CL_ID
left join Control.dbo.Users u 
       on u.user_id = lcs.user_id
left join Control.dbo.AdminClient_field f 
       on f.field_ID = u.field_ID
left join Control.dbo.Aggregate15M_Spans sp
  on sp.SpanID = lcs.SpanID
outer apply
  (
   select top 1 Caption
   from CallCenter_new.dbo.Spr_CallResult 
   where Task_ID = lcs.Task_ID
     and Result_ID = lcs.Result_ID
	 and ED is null
  ) cr
 outer apply
  (
   select top 1 '| Нажималась кнопка Отбой' as hangup, nw.insert_date
   from Report.dbo.BreakDialByUserNew nw (nolock)
   where nw.Nausessionid = isnull(nullif(lcs.Session_id_linkto,''),lcs.Session_id)
     and nw.User_ID = lcs.User_ID
  ) br


where 1=1
 and lcs.Task_id = @Task_id
 and  lcs.CREATED between @sd and @ed 

order by lcs.CL_ID, lcs.session_id, lcs.LEG_ID