Don't touch my junk.


Please login or register to vote for this query.

(click on this box to dismiss)

Christianity Meta

Q&A about the site for committed Christians, experts in Christianity and those interested in learning more

-- Enter Query Title
-- Enter Query Description

select TOP 500
    Posts.ID as [Post Link],
    Count(distinct RevisionGUID) as [Revisions in first ##Minutes:int?5##]
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

Switch sites:
loading Hold tight while we fetch your results