Most Closed, Reopened, Deleted, Undeleted, Locked, Unlocked posts, or Notice Added/Removed

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

Select top 30
  PostId [Post Link],
  count(PostId) CrazinessCount,
  Rank() over ( order by count(PostId) desc) Rank
from 
  postHistory 
where 
 posthistoryTypeid in (34) 
/*
   10 Post Closed 
   11 Post Reopened
   12 Post Deleted
   13 Post Undeleted
   14 Post Locked
   15 Post Unlocked
   33 Post Notice Added
   34 Post Notice Removed
 */
group by
  PostId
Order by  
 count(PostId) desc,
 PostId

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results