Recent edit of old posts


Please login or register to vote for this query.

(click on this box to dismiss)

Blender Meta

Q&A about the site for people who use Blender to create 3D graphics, animations, or games

---the parameter min can be used to change the treshold
---it is the minimum number of days between the post creation and the edit
  ph.PostId AS [Post Link],
  'site://posts/' + CAST(ph.PostId AS varchar)+'/revisions' AS [Revisions],
  ph.CreationDate, p.CreationDate, ph.Comment,
  ph.UserId AS [User Link], ph.UserDisplayName
FROM PostHistory ph INNER JOIN Posts p ON p.Id=ph.PostId
WHERE DATEDIFF(Day, p.CreationDate, ph.CreationDate)>=##min?100##
ORDER BY ph.CreationDate DESC

Enter Parameters

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