We walk in the dark places no others will enter
We stand on the bridge and no one may pass

;WITH CTE AS (

	SELECT TOP (@page*20) Sites.SiteUrl,Sites.Title, Sites.SiteID
	FROM Sites WITH(nolock)
		INNER JOIN #t WITH(nolock) ON Sites.SiteID = #t.SiteID
)
INSERT #t2
SELECT C.*, SUBSTRING(S.Description,1,500)
FROM CTE AS C
	INNER JOIN Sites AS S
		ON C.SiteID = S.SiteID

Declare @StartRow int, @EndRow Int

Set @StartRow=@page*20
Set @EndRow=@StartRow+19

With CTE as(
	SELECT 
		ROW_NUMBER() OVER(ORDER BY sites.siteUrl) Rn
		,Sites.SiteUrl
		,Sites.Title
		,LEFT(Sites.Description,500)	
--		,CONVERT(Nvarchar(500),Sites.Description)
	from Sites 
		INNER JOIN SiteTags t ON Sites.SiteID = t.SiteID
)
Select * from CTE
Where Rn Between @StartRow and @EndRow