Select e.entityId,
a.name,
a.title,
a.address,
e.rank
From (
	Select entityId, max(Rank) Rank
	from (
		Select
		Top(50)
		e.entityId
		keyTable.Rank
		From
		entity e
		inner join ContainsTable(srch_param, param_val, @contains_srch_param) as keyTable on e.entityId = keyTable.key
		-- Order by keyTable.Rank desc (probably not needed)
		Union
		Select
		Top(50)
		e.entityId
		keyTable.Rank
		From
		entity e
		inner join FreeTextTable(srch_param, param_val, @freetext_srch_param) as keyTable on e.entityId = keyTable.key
		-- Order by keyTable.Rank desc (probably not needed)
		) ranking_subquery
	Group by entityId
	) e
join
	entity a
on
	e.entityId = a.entityId
Order by rank desc, name;