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)

Network Engineering

Q&A for network engineers

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

select top 200
    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 meta site
loading Hold tight while we fetch your results