Taxonomist Badges for a user

3

Please login or register to vote for this query.

(click on this box to dismiss)

Shows the tags a user has created where that tag has been used in at least 50 questions.

Ask Ubuntu

Q&A for Ubuntu users and developers

;with CountOfCreatedTags as
(
    select t.Id [tagId], count(1) [count]
    from Tags t
    inner join Posts p on p.Id = t.WikiPostId
    inner join PostTags pt on pt.TagId = t.Id
    where p.OwnerUserId = ##UserId##
    group by t.Id
    having count(1) >= 50
)
select t.TagName, coct.[count] [QuestionCount]
from CountOfCreatedTags coct
inner join Tags t on coct.tagId = t.Id
order by coct.[count] desc

Enter Parameters

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