Top 50 Most Prolific Editors

0

Please login or register to vote for this query.

(click on this box to dismiss)

Shows the top 50 post editors, where the user was the most recent editor (meaning the results are conservative compared to the actual number of edits).

LEGO® Answers Meta

Q&A for LEGO® and building block enthusiasts

-- Top 50 Most Prolific Editors
-- Shows the top 50 post editors, where the user was the most recent editor
-- (meaning the results are conservative compared to the actual number of edits).


        SELECT COUNT(*) AS TotalEdits,
               'site://users/' + cast(LastEditorUserId as nvarchar)
        FROM Posts
        WHERE OwnerUserId != LastEditorUserId
        GROUP BY LastEditorUserId

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results