1

Please login or register to vote for this query.

(click on this box to dismiss)

Shows the top 50 editors by number of edits. Excludes: Tag-only edits, edits to own posts, rollbacks. Multiple edits to the same posts are only counted once. This should be the same count as the Copy Editor badge stat.

Q&A for scientists using computers to solve scientific problems

SELECT TOP 50
    Id AS [User Link],
    (
    SELECT COUNT(DISTINCT ph.PostId) FROM PostHistory ph
        WHERE
            ph.UserId = u.Id AND
            ph.PostHistoryTypeId IN (4, 5) AND
            ph.PostId NOT IN (SELECT p.Id FROM Posts p WHERE p.OwnerUserId = u.Id)
    ) AS TotalEdits
    FROM Users u
    ORDER BY TotalEdits DESC

fork query

created may 30 Vincent.Thacker