0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

Select top 20
  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

view current version

edited mar 27 13

created mar 27 13 conradfrix