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.

Drones and Model Aircraft Meta

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

SELECT TOP 20
    Id AS [User Link],
    (
        SELECT COUNT(*) FROM PostHistory
        WHERE
            UserId = Users.Id AND
            PostHistoryTypeId >= 4 AND
            PostHistoryTypeId <= 5 AND
            (SELECT OwnerUserId FROM Posts WHERE Id = PostId) <> Users.Id
        
    ) AS TotalEdits
    FROM Users
    ORDER BY TotalEdits DESC

Enter Parameters

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