0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Enter Query Title
-- Enter Query Description

select TOP 500
    Posts.ID as [Post Link],
    Count(distinct RevisionGUID) as [Revisions]
from Posts inner join PostHistory on Posts.Id = PostHistory.PostId
           and DateAdd(minute, ##Minutes:int?5##, Posts.CreationDate) > PostHistory.CreationDate
where PostTypeId = 1 -- question
  and Posts.Id >= 57000
group by Posts.Id
order by Count(distinct RevisionGUID) desc

view current version

edited jul 23 14

created jan 17 14 rolfl