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 30
  PostId [Post Link],
  count(PostId) CrazinessCount,
  Rank() over ( order by count(PostId) desc) Rank
from 
  postHistory 
where 
 posthistoryTypeid in (10,11,12,13,14,15, 33,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

view current version

edited mar 27 13

created mar 27 13 conradfrix