0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for administrators, end users, developers and designers for Craft CMS

SELECT TOP 10
    Users.DisplayName,
    Users.Reputation,
    COUNT(Posts.Id) AS ContributionCount
FROM 
    Users
LEFT JOIN 
    Posts ON Users.Id = Posts.OwnerUserId
GROUP BY 
    Users.DisplayName, Users.Reputation
ORDER BY 
    Reputation DESC

fork query

edited dec 3

created dec 3 anonymous