Q&A for users and developers of distributed applications built on top of the blockchain operating system, EOS.IO
-- How high would my reputation approximately be when there was no cap or CW?
DECLARE @UserId int = ##UserId##
WHEN VoteTypeId = 1 THEN 15 -- Accepted answer.
WHEN VoteTypeId = 2 AND PostTypeId = 1 THEN 10 -- Upvoted question
WHEN VoteTypeId = 2 AND PostTypeId = 2 THEN 10 -- Upvoted answer.
WHEN VoteTypeId = 3 THEN -2 -- Downvote.
WHEN VoteTypeId = 9 THEN BountyAmount -- Earned Bounty
END) AS UncappedReputation,
Posts ON Posts.Id = Votes.PostId join users u on u.id = @UserId
Posts.OwnerUserId = @UserId
group by reputation