Posts with the highest revision counts

0

Please login or register to vote for this query.

(click on this box to dismiss)

top 50 posts in descending order of number of edits (questions and answers only)

Drupal Answers Meta

Q&A about the site for Drupal developers and administrators

-- Posts with the highest revision counts
-- top 50 posts in descending order of number of edits
-- (questions and answers only)

select top 50
    p.id as [Post Link],
    count(h.id) as "Edit count",
    p.creationdate
from posts as p, posthistory as h
where h.postid = p.id
and (p.posttypeid = 1 or p.posttypeid = 2)
group by p.id, p.creationdate
order by "Edit count" desc

Enter Parameters

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