0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for science fiction and fantasy enthusiasts

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 = ##UserId##
    AND v.VoteTypeId = 2 -- UpMod aka upvotes

fork query

edited nov 13 19

created nov 13 19 Mage Xy