Number of mod actions of the given types per month

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

SELECT 
  eomonth(ph.CreationDate),
  COUNT (ph.Id)
FROM PostHistory ph  
WHERE ph.PostHistoryTypeId IN (##list?14,15,16,37,38,53##)
GROUP BY eomonth(ph.CreationDate)
ORDER BY eomonth(ph.CreationDate)

--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 to meta site
loading Hold tight while we fetch your results