RepChange

0

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

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

SELECT 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 p.OwnerUserId = 207421
    AND v.VoteTypeId = 2 -- UpMod aka upvotes

Enter Parameters

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