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.
SELECT TOP 10
Tags.TagName, Posts.ViewCount, Posts.FavoriteCount
FROM Tags
INNER JOIN PostTags ON PostTags.TagId = Tags.Id
INNER JOIN Posts ON Posts.ParentId = PostTags.PostId
INNER JOIN Votes ON Votes.PostId = Posts.Id And VoteTypeId = 2

Enter Parameters

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