Your visible reputation history

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

WITH VoteRep AS (
  SELECT 1 AS PostTypeId, 2 AS VoteTypeId, 5 AS RepGain
  UNION
  SELECT 1, 3, -2
  UNION
  SELECT 2, 1, 15
  UNION
  SELECT 2, 2, 10
  UNION
  SELECT 2, 3, -2
)
SELECT
  --Posts.OwnerUserId AS UserId,
  Votes.CreationDate,
  --VoteRep.RepGain,
  SUM(VoteRep.RepGain) OVER (ORDER BY Votes.CreationDate, Votes.Id
    ROWS UNBOUNDED PRECEDING) AS Rep
FROM Votes, Posts, VoteRep, Users
WHERE
  Votes.PostId = Posts.Id
  AND
  Votes.VoteTypeId = VoteRep.VoteTypeId
  AND
  Posts.PostTypeId = VoteRep.PostTypeId
  AND
  Users.AccountId = ##SEAccountId:int##
  AND
  Posts.OwnerUserId = Users.Id
ORDER BY Votes.CreationDate, Votes.Id

Enter Parameters

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