select Item,itemid,averate,tally, COUNT(*) AS hits 
FROM (SELECT	Item, itemid,averate,tally 
FROM	Items 
WHERE	Item LIKE '%nokia%' 
UNION ALL 
SELECT	Item, itemid,averate,tally 
FROM	Items WHERE	Item LIKE '%tablet%') AS d 
GROUP BY	Item, itemid,averate,tally 
order by hits desc

;WITH SearchConds(SearchText)
AS
(
	SELECT 'nokia'
	UNION ALL SELECT 'tablet'
)
,ItemHits
AS
(
	SELECT Item, itemid, averate, tally
		,COUNT(*) AS hits
	FROM Items I
		JOIN SearchConds S
			ON I.Item LIKE '%' + S.SearchText + '%'
	GROUP BY Item, itemid, averate, tally
)
,TotalCount
AS
(
	SELECT COUNT(*) As TotalHits
	FROM Items I
		JOIN SearchConds S
			ON I.Item LIKE '%' + S.SearchText + '%'
)
SELECT TOP 100 *
FROM ItemHits
	CROSS JOIN TotalCount
ORDER BY hits DESC