0

Please login or register to vote for this query.

(click on this box to dismiss)

casperOne's answers aggregated by tag.

Q&A for anime and manga fans

-- Enter Query Title
-- Enter Query Description

select
    t.TagName, count(t.Id) as AnswersForTag
from
    Posts as q
        inner join PostTags as pt on pt.PostId = q.Id
        inner join Tags as t on t.Id = pt.TagId
        inner join Posts as a on a.ParentId = q.Id
where
    --- Provided by casperOne.
    a.OwnerUserId = 50776
group by
    t.TagName
order by
    2 desc

fork query

created nov 8 11 casperOne