I am running this query on the Stack Exchange Data Explorer (for Stack Overflow):
select owneruserid , row_number() over(order by rep desc) as ranking , rep from ( select p.owneruserid ,sum(case v.votetypeid when 2 then -- upvote case p.posttypeid when 1 then 5 -- Q else 10 end -- A else 0 end) + sum(case v.votetypeid when 3 then -2 else 0 end) -- downvote + sum(case v.votetypeid when 1 then 15 else 0 end) as rep -- accept from posts p inner join votes v on v.postid = p.id inner join users u on u.id = p.owneruserid where v.creationdate between ##start:string?2018-01-01## and ##end:string?2018-12-31## and v.votetypeid in (1,2,3) and p.owneruserid is not null group by p.owneruserid ) as rawdata order by ranking
I aim to get the users ordered by their reputation on year 2018.
The problem is that the Stack Exchange website that corresponds on year 2018 returns quite different results. Top Users of 2018
Am I doing something wrong here or is it an issue on Data Explorer?