Estimated Rep Bump from Question Upvote Change

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

SELECT p.OwnerUserId AS [User Link], COUNT(1) AS 'Total Upvotes On Questions', COUNT(1) * 5 AS 'Estimated Rep Gain'
  FROM Posts p 
    INNER JOIN Votes v ON p.Id = v.PostId
  WHERE p.PostTypeId = 1 -- Question
    AND v.VoteTypeId = 2 -- UpMod aka upvotes
    GROUP BY p.OwnerUserId
    ORDER BY 3 DESC

Enter Parameters

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