All tag creators

1

Please login or register to vote for this query.

(click on this box to dismiss)

Shows all tags in the system, ordered by the most popular, and who made them

Magento

Q&A for users of the Magento e-Commerce platform

-- show all tags, ordered by most popular, and who made them

;with AllTagsCount 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
    group by t.Id
)
select t.TagName, u.DisplayName, u.Id [UserIdLink], atc.[count] [QuestionCount]
from AllTagsCount atc
inner join Tags t on t.Id = atc.tagId
inner join Posts p on p.Id = t.WikiPostId
inner join Users u on u.Id = p.OwnerUserId
order by u.DisplayName, atc.[count] desc

Enter Parameters

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