use bn
select org.ShortName,o.ObjectGarNum,d.code,
otpr.Command Command
,otpr.State      
,proverka.Answer proverka
,cd.tele_time last_data
from dbo.FLEET_Object as O
inner join dbo.SYS_DEV_Device as D on d.id=o.Device_ID
left join dbo.SYS_OrgRequisite as org on org.id=o.OrganizationId
left join -- данные о последней отправленной команды изменения параметра
      (select ou.dev_code, ou.ObjectID, ou.Command, ou.state from [BN].[dbo].[FLEET_OutCome] ou
      inner join      
       (SELECT [dev_code]
          ,[ObjectID]
          ,MAX(idrec) idrec
          FROM [dbo].[FLEET_OutCome]
          where Command like '%cmd number=9616%'
          group by [dev_code]
          ,[ObjectID])      
       as otpravleno on otpravleno.idrec=ou.IDRec)
      as otpr on otpr.ObjectID=o.ObjectID and otpr.dev_code=d.code

left join -- данные о последней отправленной команды ЧТЕНИЯ параметра
      (select ou.dev_code, ou.ObjectID, ou.Answer from [BN].[dbo].[FLEET_OutCome] ou
      inner join      
       (SELECT [dev_code]
         ,[ObjectID]
         ,MAX(idrec) idrec
        FROM [dbo].[FLEET_OutCome]
        where Command like '%cmd number?%'
        group by [dev_code]
         ,[ObjectID])      
      as otpravleno on otpravleno.idrec=ou.IDRec)
as proverka on proverka.ObjectID=o.ObjectID and proverka.dev_code=d.code
                
left join dbo.SYS_DEV_CurrentData as CD on cd.ObjectID=o.ObjectID -- данные о последней связи
where o.ObjectActive=1
--and Command is null -- фильтр по не отправленным командам
and State=2 -- фильтр по сотоянию отправленой команды
order by org.ShortName,o.ObjectGarNum