Posts with most revisions - with more data about the post

1

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

SELECT TOP(##num?100##)
  h.PostId AS [Post Link],
  COUNT(DISTINCT h.RevisionGUID) AS Count,
  revisions = 'site://posts/' + CAST(h.PostId AS varchar)+'/revisions',
---  timeline = 'site://posts/' + CAST(PostId AS varchar)+'/timeline'
  p.OwnerUserId AS [User Link], p.OwnerDisplayName,
  p.Score, p.CreationDate, p.ViewCount, p.Tags,
  CASE p.PostTypeId
    WHEN 1 THEN 'Question'
    WHEN 2 THEN 'Answer'
  END
FROM PostHistory h INNER JOIN Posts p ON h.PostId=p.Id
GROUP BY h.PostId, p.OwnerUserId, p.OwnerDisplayName, p.Score, p.CreationDate, p.ViewCount, p.Tags, p.PostTypeId
ORDER BY COUNT(DISTINCT RevisionGUID) DESC

Enter Parameters

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