1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT TOP 250 Posts.Id AS [Post Link], ViewCount, OwnerDisplayName
FROM Posts
INNER JOIN PostTags ON Posts.Id = PostTags.PostId
INNER JOIN Tags ON Tags.Id = PostTags.TagId
WHERE PostTypeId = 1
AND TagName = '##TagName##'
ORDER BY Posts.ViewCount DESC

fork query

created aug 12 13 BlueRaja - Danny Pflughoeft