SELECT Posts.Id AS [Post Link], PostHistory.CreationDate ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

SELECT 
  Posts.Id AS [Post Link],
  PostHistory.CreationDate AS 'Edit date',
  PostHistory.UserId AS [User Link]
FROM PostHistory
JOIN Posts ON Posts.Id = PostHistory.PostId
WHERE Posts.Tags LIKE '%<resource-recommendations>%'
  AND PostHistory.PostHistoryTypeId =  5 --Edit Body
ORDER BY PostHistory.CreationDate DESC

Enter Parameters

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