Top 10 most revised Posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

Q&A about the site for Joomla! administrators, users, developers and designers

SELECT TOP 10
  PostID [Post Link],
  Count(Id) RevisionCount
FROM 
  PostHistory ph
WHERE 
  PostHistoryTypeID in 
  (4,5,6,7,8,9)
/*
4  Edit Title               

5  Edit Body                

6  Edit Tags                

7  Rollback Title           

8  Rollback Body            

9  Rollback Tags     
*/
GROUP BY   
  PostID 
ORDER BY 
    Count(Id) desc

Enter Parameters

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