0

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.

Improve this question
6
  • The SEDE doesn't support history as far as I know.
    – Anonymous Penguin
    Commented May 10, 2014 at 20:40
  • @AnnonomusPenguin: It is the history!
    – Werner
    Commented May 11, 2014 at 6:56
  • @Werner I meant as far as I know you can't view reputation history with a SEDE query but I'm not sure.
    – Anonymous Penguin
    Commented May 11, 2014 at 14:00
  • @AnnonomusPenguin: The requested query should aggregate this information from the database; it wouldn't be a look-up of reputation for some period.
    – Werner
    Commented May 11, 2014 at 15:56
  • @Werner as in you can only do an average over the entire rep history? So this query, rep gained over the past n days, is not supported?
    – tshepang
    Commented May 11, 2014 at 16:42
  • @Tshepang: No, an aggregation doesn't necessarily refer to an average. It will be fully possible (for someone with the SQL skills).
    – Werner
    Commented May 11, 2014 at 16:43

1 Answer 1

Reset to default
4
+100

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:

  1. It sums the upvotes, downvotes and accepted rep gain per Post (questions and answers) from the votes cast in a period
  2. It then sums those grouped by user
  3. 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.

Improve this answer
3
  • Does this query take the 200 rep/day limit into consideration?
    – tshepang
    Commented Jun 3, 2014 at 11:04
  • No, it does not. It would complicate matters immensely...
    – rene Mod
    Commented Jun 3, 2014 at 11:05
  • And it already is a hectic query. Anyways, that would explain why, for example, John Skeet ranks higher than Martijn Peters, which contrasts with what we see here: stackoverflow.com/users?tab=Reputation&filter=week.
    – tshepang
    Commented Jun 3, 2014 at 11:53

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .