Bodies of all revisions of the given post


Please login or register to vote for this query.

(click on this box to dismiss)

Politics Meta

Q&A about the site for people interested in governments, policies, and political processes

SELECT ph.Id, ph.Comment,
  LEN(ph.Text) AS [Length],
  ph.Text, ph.CreationDate, ph.UserId, ph.UserDisplayName, ph.PostHistoryTypeId, ph.RevisionGUID, ph.ContentLicense
FROM PostHistory ph
WHERE (ph.PostHistoryTypeId in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30)) AND (ph.PostId=##postid##)
ORDER BY ph.CreationDate
--- 2 = Initial Body - initial post raw body text
--- 5 = Edit Body - modified post body (raw markdown)
--- 8 = Rollback Body - reverted body (raw markdown)

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results