select
  ...
  
  tu_ct.CONTRACT_ID,
  tu_ct.CONTRACT_LS_NM,
  es_ct.ES_CONTRACT_KD,

  tu_ctg.CONTRAGENT_ID,
  tu_ctg.CONTRAGENT_NM,

  analytic.TARIF_ANALYTICS_ABBR,

  case
    when
      isnull(tso.CONTRAGENT_ID, 0) = isnull(es_delivery.ES_TSO_ID, 0)
      or isnull(es_delivery.ES_TSO_ID, 0) = -1
      or
        (
        es_delivery.ES_TSO_Code = '0'
        and tso.SUBJECT_TYPE_KD = 3
        )
      then isnull(tso.CONTRAGENT_NM, '')
    else isnull(es_delivery.ES_TSO_NM, '')
  end,

  case
    when
      isnull(ivs.CONTRAGENT_ID, 0) = isnull(es_delivery.ES_IVS_ID, 0)
      or isnull(es_delivery.ES_IVS_ID, 0) = -1
      then isnull(ivs.CONTRAGENT_NM, '')
    else isnull(es_delivery.ES_IVS_NM, '')
  end,

  null,

  sum
    (
    case
      when es_delivery.ES_TSO_ID = -1 then delivery.VN_Delivery
    end
    ),

  sum
    (
    case
      when
        (
          (
          isnull(tso.CONTRAGENT_ID, 0) = isnull(es_delivery.ES_TSO_ID, 0)
          and isnull(ivs.CONTRAGENT_ID, 0) = isnull(es_delivery.ES_IVS_ID, 0)
          )
          or
          (
          isnull(tso.CONTRAGENT_ID, 0) <> isnull(es_delivery.ES_TSO_ID, 0)
          or isnull(ivs.CONTRAGENT_ID, 0) <> isnull(es_delivery.ES_IVS_ID, 0)
          )
        )
        and isnull(es_delivery.ES_TSO_ID, 0) <> -1
      then es_delivery.VN_Delivery
    end
    ),

  ...
from
  dbo.RNC_CONTRACT_TU tu
  join dbo.RNC_CONTRACT_TU_PARAMS tu_p on tu_p.CONTRACT_TU_ID = tu.CONTRACT_TU_ID

  left join dbo.NSI_ADDRESS_PART tu_address on tu_address.ADDRESS_PART_ID = tu_p.address_part_id

  join dbo.RNC_CONTRACT tu_ct on tu_ct.CONTRACT_ID = tu.CONTRACT_ID
  join dbo.RNC_CONTRAGENT tu_ctg on tu_ctg.CONTRAGENT_ID = tu_ct.CONTRAGENT_ID

  join dbo.CALC_PERIOD period on 1 = 1

  left join
    (
    select
      calc_l.CALC_PERIOD_ID,
      ce.CONTRACT_TU_ID,

      sum( isnull(ce.CALC_DELIVERY, 0) ) as Sum_Delivery,

      sum
        (
        case @VoltageLevel
          when 1 then
            case ce.FACT_VOLT_LEVEL_KD
              when 1 then isnull(ce.CALC_DELIVERY, 0)
              else 0
            end
          else
            case (ce.CALC_VOLT_LEVEL_KD)
              when 1 then isnull(ce.CALC_DELIVERY, 0)
              else 0
            end
        end
        ) as VN_Delivery,

      ...
    from
      dbo.CALC_LIST calc_l
      join dbo.CALC_ELEMENT ce on ce.CALC_LIST_ID = calc_l.CALC_LIST_ID
    group by
      calc_l.CALC_PERIOD_ID,
      ce.CONTRACT_TU_ID
    ) delivery on delivery.CALC_PERIOD_ID = period.CALC_PERIOD_ID
                  and delivery.CONTRACT_TU_ID = tu.CONTRACT_TU_ID

  left join dbo.ES_CONTRACT es_ct on es_ct.CONTRACT_ID = tu_ct.CONTRACT_ID
                                     and es_ct.ES_CONTRACT_LAST_UPD_DT =
                                       (
                                       select
                                         max(last_es_ct.ES_CONTRACT_LAST_UPD_DT)
                                       from
                                         dbo.ES_CONTRACT last_es_ct
                                       where
                                         last_es_ct.CONTRACT_ID = es_ct.CONTRACT_ID
                                       )

  join dbo.NSI_TARIF tu_tarif on tu_tarif.Tarif_ID = tu_p.Tarif_ID
  join dbo.NSI_TARIF_ANALYTICS analytic on analytic.TARIF_ANALYTICS_KD = tu_tarif.TARIF_ANALYTICS_KD

  left join dbo.RNC_DELIVERY_POINT dp on dp.DELIVERY_POINT_ID = tu.DELIVERY_POINT_ID
  left join dbo.RNC_CONTRAGENT tso on tso.CONTRAGENT_ID = dp.CONTRAGENT_DELIV_ID
  left join dbo.RNC_CONTRAGENT ivs on ivs.CONTRAGENT_ID = dp.CONTRAGENT_NETWORK_ID

  left join
    (
    select
      null as CONTRACT_TU_ID,

      -1 as ES_TSO_ID,
      null as ES_TSO_Code,
      null as ES_TSO_NM,

      -1 as ES_IVS_ID,
      null as ES_IVS_Code,
      null as ES_IVS_NM,

      null as CALC_PERIOD_ID,

      null as Sum_Delivery,
      null as VN_Delivery,
      
      ...

    union all

    select
      es_calc.CONTRACT_TU_ID,

      tso.CONTRAGENT_ID as ES_TSO_ID,
      tso.CTG_REG_CODE as ES_TSO_Code,
      tso.CONTRAGENT_NM as ES_TSO_NM,

      ivs.CONTRAGENT_ID as ES_IVS_ID,
      ivs.CTG_REG_CODE as ES_IVS_Code,
      ivs.CONTRAGENT_NM as ES_IVS_NM,

      es_calc.CALC_PERIOD_ID,

      sum(es_calc.ALL_CONSUMPTION) as Sum_Delivery,

      sum
        (
        case isnull(es_volt_level.VOLTAGE_LEVEL_KD, tu_p.CALC_VOLT_LEVEL_KD)
          when 1 then es_calc.ALL_CONSUMPTION
        end
        ) as VN_Delivery,

      ...
    from
      dbo.ES_TU_Calcs es_calc

      join dbo.RNC_CONTRACT_TU_PARAMS tu_p on tu_p.CONTRACT_TU_ID = es_calc.CONTRACT_TU_ID
      left join dbo.NSI_VOLTAGE_LEVEL es_volt_level on es_volt_level.VOLTAGE_LEVEL_KD =
        (
        select top 1
          volt_level.VOLTAGE_LEVEL_KD
        from
          dbo.NSI_VOLTAGE_LEVEL volt_level
        where
          upper(volt_level.VOLTAGE_LEVEL_NM) = upper( ltrim(rtrim(es_calc.CALC_TARIF_LEV)) )
          or upper(volt_level.VOLTAGE_LEVEL_ABBR) = upper( ltrim(rtrim(es_calc.CALC_TARIF_LEV)) )
        )

      left join dbo.RNC_CONTRAGENT tso on tso.CONTRAGENT_ID =
        (
        select top 1
          ctg.CONTRAGENT_ID
        from
          dbo.RNC_CONTRAGENT ctg
        where
          ctg.CTG_REG_CODE <> ''
          and isnull(es_calc.TSO_Code, '') <> ''

          and ctg.CTG_REG_CODE = es_calc.TSO_Code
          and ctg.SUBJECT_TYPE_KD in (3, 31)
        )
        
      ...
    group by
      es_calc.CONTRACT_TU_ID,

      tso.CONTRAGENT_ID,
      tso.CTG_REG_CODE,
      tso.CONTRAGENT_NM,

      ivs.CONTRAGENT_ID,
      ivs.CTG_REG_CODE,
      ivs.CONTRAGENT_NM,

      es_calc.CALC_PERIOD_ID

    ) es_delivery on
     (
     es_delivery.CALC_PERIOD_ID is null
     or es_delivery.CALC_PERIOD_ID = period.CALC_PERIOD_ID
     )
     and
     (
     es_delivery.CONTRACT_TU_ID is null
     or es_delivery.CONTRACT_TU_ID = tu.CONTRACT_TU_ID
     )

where
  tu.CONTRACT_TU_ID in (select TU_ID from @tu_list)
  and ( @CalcRangeBeg <= period.CALC_PERIOD_BEGIN and period.CALC_PERIOD_END <= @CalcRangeEnd )
  
  ...

group by
  tu_ct.CONTRACT_ID,
  tu_ct.CONTRACT_LS_NM,
  es_ct.ES_CONTRACT_KD,

  case
    when
      isnull(tso.CONTRAGENT_ID, 0) = isnull(es_delivery.ES_TSO_ID, 0)
      or isnull(es_delivery.ES_TSO_ID, 0) = -1
      or
        (
        es_delivery.ES_TSO_Code = '0'
        and tso.SUBJECT_TYPE_KD = 3
        )
      then isnull(tso.CONTRAGENT_NM, '')
    else isnull(es_delivery.ES_TSO_NM, '')
  end,

  ...

having
  count(delivery.CONTRACT_TU_ID) > 0
  or count(es_delivery.CONTRACT_TU_ID) > 1