Can someone more familiar with SQL construct a query that shows the top users (rep) over the past n days, similar to how this page does it.
You can't get the exact numbers from SEDE because its data is only refreshed once a week. Voting is anonymous also in SEDE so you can't retrieve the info on the downvotes casted by users.
I still think Top users rep per x weeks comes close to what you are looking for.
The query takes 3 steps:
- It sums the upvotes, downvotes and accepted rep gain per Post (questions and answers) from the votes cast in a period
- It then sums those grouped by user
- It outer joins the suggested edits and bounties for a user
The top 10 outcome per May 24th 2014 for a 2 week period based on the dump of May 16th:
User Link | SumRepPeriod ------------------------------ Arbel | 10352 Jon Skeet | 9314 Martijn Pieters | 4375 BalusC | 4370 Mathew MacLean | 3862 Darin Dimitrov | 3699 VonC | 3621 Gordon Linoff | 3569 CommonsWare | 3183 Hans Passant | 3014 Marc Gravell | 2791
NOTE: this query does not take into consideration the 200 rep/day limit.