Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs
SELECT p.Id AS [Post Link], v.VoteTypeId, CASE WHEN v.VoteTypeId = 1 THEN 15 WHEN v.VoteTypeId = 2 AND p.PostTypeId = 1 THEN 5 WHEN v.VoteTypeId = 2 AND p.PostTypeId = 2 THEN 10 WHEN v.VoteTypeId = 3 THEN -2 END AS ReputationChange FROM Posts p INNER JOIN Votes v ON p.Id = v.PostId INNER JOIN Users u ON p.OwnerUserId = u.Id WHERE v.VoteTypeId IN (1,2,3) -- accepts,ups,downs AND p.OwnerUserId = ##UserId:int?456814## ORDER BY p.Id DESC