SELECT DO.id, CON.oid as oid, DO.start, DO.stop, DO.outSms15 as sms15, DO.outSms30 as sms30, DO.outSms60 as sms60
   FROM Terminal.dbo.Connection  as CON
   LEFT JOIN Terminal.dbo.Downtime  as DO ON CON.OID = DO.oid
   LEFT JOIN Terminal.dbo.Downtime  as DDO ON CON.OID = DDO.oid
	  AND DO.start < DDO.start
   WHERE DDO.id is NULL

 SELECT ROW_NUMBER() OVER(PARTITION BY DO.oid ORDER BY DO.stop DESC) as R, DO.id, CON.oid as oid, DO.start, DO.stop, DO.outSms15 as sms15, DO.outSms30 as sms30, DO.outSms60 as sms60
   FROM Terminal.dbo.Connection  as CON
   LEFT JOIN Terminal.dbo.Downtime  as DO ON CON.OID = DO.oid
   WHERE R = '1'

 SET STATISTICS TIME ON;
 WITH tb (R, id, oid, start, stop, sms15, sms30, sms60)  
AS  
(  SELECT ROW_NUMBER() OVER(PARTITION BY DO.oid ORDER BY DO.start DESC) as R, DO.id, CON.oid as oid, DO.start, DO.stop, DO.outSms15 as sms15, DO.outSms30 as sms30, DO.outSms60 as sms60
   FROM Terminal.dbo.Connection  as CON
   LEFT JOIN Terminal.dbo.Downtime  as DO ON CON.OID = DO.oid
  
)  
SELECT id, oid, start, stop, sms15, sms30, sms60   
FROM tb
WHERE R = 1
SET STATISTICS TIME OFF; 

SET STATISTICS TIME ON; 
with tb (R, id, oid, start, stop, sms15, sms30, sms60)  
AS  
(  SELECT ROW_NUMBER() OVER(PARTITION BY DO.oid ORDER BY DO.start DESC) as R, DO.id, CON.oid as oid, DO.start, DO.stop, DO.outSms15 as sms15, DO.outSms30 as sms30, DO.outSms60 as sms60
   FROM Terminal.dbo.Connection  as CON
   LEFT JOIN Terminal.dbo.Downtime  as DO ON CON.OID = DO.oid
  
)

SELECT MAX(RF.Date) AS date
   ,CON.OID as oid
   ,TC.ProductCycle as cycl
   ,tb.id as downtime
   ,TC.Product as product
   ,tb.sms15
   ,tb.sms30
   ,tb.sms60
FROM EAM_test.dbo.RFIDData AS RF
LEFT JOIN EAM_test.dbo.RFIDReader AS RR ON RF.Reader = RR.Oid AND RR.Active = 1
LEFT JOIN Terminal.dbo.Connection AS CON ON CON.OID = RR.Asset
LEFT JOIN Terminal.dbo.Terminal1C AS TC ON CON.OID = TC.OID
   AND TC.Day = 'День'
   AND TC.status = 1
LEFT JOIN tb ON CON.OID = tb.oid and tb.stop is null AND tb.R = 1
WHERE TC.Date = '2019-03-09'
GROUP BY CON.OID, TC.ProductCycle, tb.id, TC.Product, tb.sms15, tb.sms30, tb.sms60

SET STATISTICS TIME OFF;