Latest Edits By Community

0

Please login or register to vote for this query.

(click on this box to dismiss)

Returns the latest edits by the community user.

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT Posts.Id AS [Post Link],
       PostHistory.CreationDate AS [Edit Date],
       PostHistory.Comment
FROM PostHistory
LEFT JOIN Posts ON PostHistory.PostId = Posts.Id
WHERE PostHistory.UserId = -1 AND Posts.ClosedDate = ''
ORDER BY PostHistory.CreationDate DESC

Enter Parameters

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