select top 125 count(PostTags.PostId), Tags.TagName from ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top 125 count(PostTags.PostId), Tags.TagName
from PostTags
  inner join Tags on Tags.Id = PostTags.TagId
  inner join Posts on Posts.Id = PostTags.PostId
where Posts.PostTypeId = 1
group by PostTags.tagid, Tags.TagName
order by count(PostTags.PostId) desc

Enter Parameters

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