Find top posts with a certain tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Robotics Meta

Q&A about the site for professional robotic engineers, hobbyists, researchers and students

declare @tag_id int = (select id from tags where tagname = '##TagName##');

SELECT TOP ##Limit##
     Id AS [Post Link], Body, Score, Tags
FROM
    posts
JOIN
    posttags ON posts.id = posttags.postid
WHERE
    posttags.tagid = @tag_id
ORDER BY
    Score DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results