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.

Science Fiction and Fantasy Meta

Q&A about the site for science fiction and fantasy enthusiasts

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 IS NULL AND
      Posts.PostTypeId = (SELECT Id from PostTypes WHERE Name = 'Question')
ORDER BY PostHistory.CreationDate DESC

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results