Most viewed questions for specific tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

EOS.IO

Q&A for users and developers of distributed applications built on top of the blockchain operating system, EOS.IO

DECLARE @Tag VARCHAR(35) = 'pandas'

SELECT TOP 50 Q.Id AS [Post Link], 
    Q.Tags, Q.AnswerCount, Q.ViewCount
FROM Posts AS Q
INNER JOIN PostTags AS P ON P.PostId = Q.Id
INNER JOIN Tags AS T ON T.Id = P.TagId
WHERE T.TagName = @Tag ORDER BY Q.ViewCount DESC

Enter Parameters

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