SELECT TOP 4 * FROM [Content] AS at WHERE 1=1 AND at.[ParentID] = 16 AND at.[Active] = 'yes' ORDER BY at.[Rank]