select
 coalesce(sum(RF.Status),0) as status,
 RFR.Asset as oid
from
database1 AS RFR
left join database2 AS RR ON RR.Asset = RFR.Asset
left join database3 AS RF ON RF.Reader = RR.Oid 
and RF.Date between dateadd(hour, 7, cast(cast(getdate() as date) as datetime)) and dateadd(hour, 19, cast(cast(getdate() as date) as datetime))
where RFR.Asset IS NOT NULL
group by RFR.Asset

with tb as
(
   select sum(TC.ProductPlan) AS prplan, TC.OID, MAX(CASE WHEN TC.status = 1 THEN TC.ProductCycle END) AS cycle
   from database1  AS RFR
   left join database7  TC ON TC.OID = RFR.Asset
   WHERE RFR.Asset IS NOT NULL
   AND TC.Date = '2019-21-03 00:00:00.000'
   group by TC.OID
)

select
 coalesce(sum(case when tb.TPA_ior is null then RF.Status else 0 end),0) as status,
 RFR.Asset as oid, 
 RO.Наименование AS [name],
 TS.Наименование AS [state],
 TC.prplan AS [plan],
 TC.cycle
from
database1 AS RFR
left join database2  AS RR ON RR.Asset = RFR.Asset
left join database3  AS RF ON RF.Reader = RR.Oid 
and RF.Date between dateadd(hour, 7, cast(cast(getdate() as date) as datetime)) and dateadd(hour, 19, cast(cast(getdate() as date) as datetime))
left join database4  as tb on tb.TPA_ior = RFR.Asset and tb.View_problem = 'Плановый простой' and RF.Date between tb.Start_date and isnull(tb.End_date, null)
left join database5  RO ON RO.Oid = RFR.Asset
left join database6  TS ON TS.Oid = RO.ТехСостояние
left join tb AS TC ON TC.OID = RFR.Asset
where RFR.Asset IS NOT NULL
group by RFR.Asset, RO.Наименование, TS.Наименование, TC.prplan, TC.cycle
order by RO.Наименование ASC

tb2 as
(
   select
   RFR.Asset as oid,
   coalesce(MAX(RF.Date),0) as [date]
   from
   database1 AS RFR
   left join database2  AS RR ON RR.Asset = RFR.Asset
   left join database3  AS RF ON RF.Reader = RR.Oid 
   where RFR.Asset IS NOT NULL
   group by RFR.Asset
)