1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for professors, theologians, and those interested in exegetical analysis of biblical texts

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
WHERE (h.PostHistoryTypeId IN (##list?1,2,3,4,5,6,7,8,9##))
  AND (p.CommunityOwnedDate IS NULL)
  AND (p.PostTypeId IN (##types?1,2##))
---types=1: only questions
---types=2: only answers
---types=1,2: both questions and answers
GROUP BY h.PostId, p.OwnerUserId, p.OwnerDisplayName, p.Score, p.CreationDate, p.ViewCount, p.Tags, p.PostTypeId
ORDER BY COUNT(DISTINCT RevisionGUID) DESC

---1 = Initial Title - initial title (questions only)
---2 = Initial Body - initial post raw body text
---3 = Initial Tags - initial list of tags (questions only)
---4 = Edit Title - modified title (questions only)
---5 = Edit Body - modified post body (raw markdown)
---6 = Edit Tags - modified list of tags (questions only)
---7 = Rollback Title - reverted title (questions only)
---8 = Rollback Body - reverted body (raw markdown)
---9 = Rollback Tags - reverted list of tags (questions only)

fork query

created dec 19 22 Martin20528