Latest Edits By Community


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],
FROM PostHistory
LEFT JOIN Posts ON PostHistory.PostId = Posts.Id
WHERE PostHistory.UserId = -1 AND
      Posts.ClosedDate IS NULL AND
      Posts.PostTypeId = (SELECT Id from PostTypes WHERE Name = 'Question')
ORDER BY PostHistory.CreationDate DESC

Enter Parameters

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