Top editors

1

Please login or register to vote for this query.

(click on this box to dismiss)

This only counts the last editor on non-deleted posts, so it's very incomplete.

Stack Overflow

Q&A for programmers

select top ##Limit##
  rank() over (order by count(*) desc),
  lasteditoruserid as "User Link",
  count(*) as "Edits"
from posts
where posttypeid = 1
  and lasteditoruserid is not null
group by lasteditoruserid
order by count(*) desc
;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached