select top 1000 a.CreatedOn,a.MachineIP,a.Description,a1.ControlName,b.Name
from [dbo].[UBF_Log_OperateLog] a
join [dbo].[UBF_Log_OperateLog_Trl] a1 on a1.id=a.id
join Base_User b on b.id=a.LoginUser
where a.Org=1001108069071869
and a.CreatedOn>='2018-04-18 17:10:29.000'
and a1.ControlName='删除'
and a.Description like '%TJ-000280-17%'
order by a.ID