SELECT TOP 1 * 
FROM dbo.Objects_tbl with (nolock) 
where 
 Objects_tbl.ObjectClass='DS'
 AND Objects_tbl.ProcStateCol09 = 'M'
 AND Objects_tbl.ObjectFromSiteID = 'Tc83'
 And Objects_tbl.ObjectOwningSiteID='Tc83'
 And Objects_tbl.ObjectUgMaster_Type = 'SP'
 AND Objects_tbl.ObjectType = 'UGPART'
 AND Objects_tbl.ObjectReleaseState In ('PF13','PF19','PF50','NORMTEIL','VERSUCH')
 ORDER BY
 Objects_tbl.ObjectLastModDate DESC
