Counts of recent moderator actions

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

--actions that can only be done by moderators
--see also: https://data.stackexchange.com/politics/revision/1078526/1332520/recent-mod-actions-on-questions
SELECT
  ph.UserId AS [User Link], COUNT(ph.Id)
  FROM PostHistory ph INNER JOIN Posts p
  ON ph.PostId=p.Id
  AND ph.PostHistoryTypeId IN (14,15,16,37,38,53)
  AND p.PostTypeId=1
  WHERE (ph.CreationDate>='##Date1?2019-01-01##') AND (ph.CreationDate<='##Date2?2020-01-01##')
GROUP BY ph.UserId
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

Enter Parameters

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