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 50
    p.id as [Post Link],
    u.DisplayName as "User",
    count(h.id) as "Edit count",
    p.creationdate
from posts as p, posthistory as h, users as u
where h.postid = p.id
and (p.posttypeid = 1 or p.posttypeid = 2)
and u.Id = p.OwnerUserId
group by p.id, p.creationdate, u.DisplayName
order by "Edit count" desc

Enter Parameters

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