Recent edit of old posts

1

Please login or register to vote for this query.

(click on this box to dismiss)

Open Data

Q&A for developers and researchers interested in open data

---the parameter min can be used to change the treshold
---it is the minimum number of days between the post creation and the edit
SELECT DISTINCT TOP(##num?1000##)
  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

Options:
Switch sites:
loading Hold tight while we fetch your results