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

Q&A about the site for musicians, students, and enthusiasts

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

select YEAR(v.creationdate) as YearB, 
  15 * count(case when (v.votetypeid = 1) and (p.posttypeid = 2) THEN 1 ELSE NULL END) as Accepts,
  10 * count(case when (v.votetypeid = 2 and p.posttypeid in (1, 2)) THEN 1 ELSE NULL END) as UpVotes,
  (-2) * count(case when (v.votetypeid = 3 and p.posttypeid in (1, 2)) THEN 1 ELSE NULL END) as DownVotes
  from posts p 
  inner join votes v on v.postid = p.id
  where v.votetypeid in (1, 2, 3)
  and p.posttypeid in (1, 2)
  and p.owneruserid = ##uid##
  group by YEAR(v.creationdate)

view current version

edited oct 11 PeterJames

created jun 22 14 rene