user reputation history

0

Please login or register to vote for this query.

(click on this box to dismiss)

http://meta.stackexchange.com/questions/144716/reputation-history-from-data-explorer

Mythology Meta

Q&A about the site for enthusiasts and scholars of mythology and folklore

-- uid:Enter your UserId  "As found in the url of your profile"

select YEAR(v.creationdate), sum(count(*)*10) over (order by YEAR(v.creationdate)) as score
  from posts p 
  inner join votes v on v.postid = p.id
  where v.votetypeid = 2 --UpVote
  and p.posttypeid in (1, 2)
  and p.owneruserid = ##uid##
  group by YEAR(v.creationdate)
union   
select YEAR(v.creationdate), sum(count(*)*-2) over (order by YEAR(v.creationdate)) as score
  from posts p 
  inner join votes v on v.postid = p.id
  where v.votetypeid = 3 --DownVote
  and p.posttypeid in (1,2) -- Q and A
  and p.owneruserid = ##uid##
  group by YEAR(v.creationdate)
union
select YEAR(v.creationdate), sum(count(*) * 15) over (order by YEAR(v.creationdate)) as score -- every accepted answer 15 fep
  from posts p 
  inner join votes v on v.postid = p.id
  where v.votetypeid = 1 -- Accept
  and p.posttypeid = 2 -- Answer 
  and  p.owneruserid = ##uid##
  group by  YEAR(v.creationdate)

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results