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).
Q&A about the site for amateur radio 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 TOP 50 Id AS [User Link], ( SELECT COUNT(*) FROM Posts WHERE PostTypeId = 1 AND LastEditorUserId = Users.Id AND OwnerUserId != Users.Id ) AS QuestionEdits, ( SELECT COUNT(*) FROM Posts WHERE PostTypeId = 2 AND LastEditorUserId = Users.Id AND OwnerUserId != Users.Id ) AS AnswerEdits, ( SELECT COUNT(*) FROM Posts WHERE LastEditorUserId = Users.Id AND OwnerUserId != Users.Id ) AS TotalEdits FROM Users where Users.Id = 11208 ORDER BY TotalEdits DESC