Good voters

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT      TOP 500
            u.id            AS [User Link],
            u.Reputation,
            u.UpVotes,
            u.DownVotes,
            COUNT (p.id)    AS [Num Posts]
FROM        users u
INNER JOIN  Posts p         ON p.OwnerUserId = u.id
WHERE       u.Reputation > 1
AND         (u.UpVotes + u.DownVotes) * 10  >  u.Reputation
AND         u.UpVotes  >  u.DownVotes * 2
AND         p.PostTypeId    IN (1, 2)
GROUP BY    u.id,
            u.Reputation,
            u.UpVotes,
            u.DownVotes,
            u.DisplayName
ORDER BY    (u.UpVotes + u.DownVotes) * 10.0 / u.Reputation  DESC,
            [Num Posts]  DESC,
            u.DisplayName

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results