1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for designers and implementers of computer programming languages

--actions that can only be done by moderators
--answers can be made CW by regular users, but not questions
SELECT 
  ph.UserId AS [User Link],
  ph.UserDisplayName,
  COUNT(ph.Id) AS [Count]
FROM PostHistory ph INNER JOIN Posts p ON p.id=ph.postid
WHERE p.PostTypeId=1 
  AND ph.PostHistoryTypeId IN (##list?14,15,16,37,38,53##)
GROUP BY ph.UserId, ph.UserDisplayName
ORDER BY COUNT(ph.Id) DESC

--14 = Post Locked - post locked by moderator
--15 = Post Unlocked - post unlocked by moderator
--16 = Community Owned - post now community owned
--QUESTION can only be made CW by a moderator (so I look only at question; PostTypeId=1)
--37 = Post merge source
--38 = Post merge destination
--53 = Question removed from hot network questions by a moderator

fork query

edited apr 27

created apr 27 Martin20528