SELECT TOP 1
 * 
FROM dbo.Objects_tbl with (nolock) 
where 
      Objects_tbl.ProcStateColRf='M'
 And  Objects_tbl.ObjectClass='DS'
 And  Objects_tbl.ObjectFromSiteID='tceng'
 And Objects_tbl.ObjectOwningSiteID='tceng'
 And Objects_tbl.ObjectUgMaster_Type = 'SP'
 and Objects_tbl.ObjectType IN ('UGMASTER')
 And  Objects_tbl.ObjectUgMaster_CompCount<=6000
 And  Objects_tbl.ObjectUgMaster_CompCount>=0
 ORDER BY Objects_tbl.ObjectUgMaster_APLevels ASC, 
 Objects_tbl.ObjectUgMaster_CompCount ASC, 
 Objects_tbl.ObjectLastModDate DESC