0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT TOP 20
    OwnerUserId AS [User Link],
    TopBadge,
    SUM(Score) AS TotalScore,
    COUNT(*) AS NofAnswers
FROM Posts P
    INNER JOIN PostTags PT ON PT.PostId = P.ParentId
    INNER JOIN Tags T ON T.Id = PT.TagId
    INNER JOIN (
        SELECT
            B.UserId,
            MIN(B.Class) AS TopBadge
        FROM Badges B
        WHERE
            B.Name = '##TagName##' AND
            B.TagBased > 0
        GROUP BY B.UserId
    ) BB ON BB.UserId = P.OwnerUserId
WHERE
    T.TagName = '##TagName##' AND
    P.OwnerUserId IS NOT null AND
    P.CommunityOwnedDate IS null AND
    P.PostTypeId = 2
GROUP BY P.OwnerUserId, TopBadge
ORDER BY TopBadge, TotalScore DESC

fork query

edited sep 14 18 anonymous

created sep 14 18 Reinier Torenbeek