Don't touch my junk.

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ebooks

Q&A for ebook publishers and readers

-- 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

Enter Parameters

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