0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

SELECT u.Id, u.DisplayName, u.Reputation
FROM (
    SELECT a.OwnerUserId, pt.TagId
    FROM PostTags pt
    JOIN Posts q ON pt.PostId = q.Id
    JOIN Posts a ON a.ParentId = q.Id
    GROUP BY a.OwnerUserId, pt.TagId
    HAVING SUM(a.Score) > 1) s
JOIN Users u ON u.Id = s.OwnerUserId
GROUP BY u.Id, u.DisplayName, u.Reputation
HAVING COUNT(s.TagId) > 50
ORDER BY u.Reputation

view current version

edited may 12 13

created may 12 13 jon.doe10762