Q&A for professional and enthusiast programmers
Select top 30 PostId [Post Link], count(PostId) CrazinessCount from postHistory where posthistoryTypeid in (10,11,12,13,14,15) /* 10 Post Closed 11 Post Reopened 12 Post Deleted 13 Post Undeleted 14 Post Locked 15 Post Unlocked */ group by PostId Order by count(PostId) desc, PostId