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 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 = u.Id)
    ) AS TotalEdits
    FROM Users u
    ORDER BY TotalEdits DESC

Enter Parameters

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