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

Software Engineering

Q&A for professionals, academics, and students working within the systems development life cycle

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

select YEAR(v.creationdate), 'UP', 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), 'DOWN', 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), 'ACC', 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)
union  
select YEAR(approvaldate), 'EDS', sum(count(*) * 2) over (order by YEAR(approvaldate)) as score
     from suggestededits
      where approvaldate is not null
      and owneruserid = ##uid## 
      group by YEAR(approvaldate)

Enter Parameters

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