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).

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

-- 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).
DECLARE @UserId int = ##UserId##
SELECT TOP 50
    Id AS [User Link],    
    (
        SELECT COUNT(*) FROM Posts
        WHERE
            LastEditorUserId = Users.Id AND
            OwnerUserId != Users.Id
    ) AS TotalEdits
    FROM Users
    WHERE Users.Id = @UserId
    ORDER BY TotalEdits DESC

Enter Parameters

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