0

Please login or register to vote for this query.

(click on this box to dismiss)

Dirty query to find out who's the most community minded :)

Q&A for anime and manga fans

-- Community Wiki Questions per user

SELECT 
    Users.Id as [User Link],
    COUNT(OwnerUserId) as num
FROM Posts

INNER JOIN
    Users ON Users.Id = OwnerUserId

WHERE
    CommunityOwnedDate is not null and
    ClosedDate is null and
    OwnerUserId is not null

GROUP BY Users.Id

ORDER BY
    num desc

fork query

created may 27 11 Oli