100 Hottest Tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

It returns the hottest tags, by assigning points for creation, upvotes, favorites.

Stack Overflow

Q&A for professional and enthusiast programmers

-- 100 Hottest Tags
-- It returns the hottest tags, by assigning points for creation, upvotes, favorites.

-- Favorite: 20 points
-- Upvote: 10 points
-- Downvote: -10 points
-- Answer: 10 points
-- Creation: 10 points
-- Views: 1 point

SELECT TOP 10
Tags.TagName, Posts.ViewCount, Posts.FavoriteCount, Posts.PostTypeID, Posts.AnswerCount
FROM Tags
INNER JOIN PostTags ON PostTags.TagId = Tags.Id
INNER JOIN Posts ON Posts.ParentId = PostTags.PostId And Posts.PostTypeID = 2
INNER JOIN Votes ON Votes.PostId = Posts.Id And VoteTypeId = 2

Enter Parameters

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