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.

Q&A for users and developers of distributed applications built on top of the blockchain operating system, EOS.IO

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

fork query

edited may 30 Vincent.Thacker

created jul 8 10 Jon Seigel