0

Please login or register to vote for this query.

(click on this box to dismiss)

Returns the latest edits by the community user.

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

fork query

edited jun 13 12 George_Edison

created jun 13 12 anonymous