Top 50 Editors by edits made

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. Otherwise multiple edits to the same post are counted. This should match with the "Posts Edited" stat on one's profile.

DevOps Meta

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

SELECT TOP 50
    Id AS [User Link],
    (
        SELECT COUNT(DISTINCT ph.RevisionGUID) 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 = UserId)
    ) AS TotalEdits
    FROM Users u
    ORDER BY TotalEdits DESC

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results