Top questions with the given tag by views

1

Please login or register to vote for this query.

(click on this box to dismiss)

Webmasters

Q&A for pro webmasters

DECLARE @Tag NVARCHAR(50) = ##Tag:string##
SELECT TOP 15000 q.Id AS [Post Link],
    q.ViewCount,
    q.Tags
FROM Posts AS q
LEFT JOIN Posts AS pq ON q.ParentId = pq.Id
WHERE q.PostTypeId = 1 -- Only retrieve questions
    AND q.Tags LIKE '%' + @Tag + '%' -- Filter by the provided tag
ORDER BY q.ViewCount DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results