Edits to closed questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT p.Id AS [Post Link], ph.CreationDate
  FROM PostHistory AS ph INNER JOIN Posts AS p ON p.Id = ph.PostId
  WHERE ph.UserId = ##UserId:int##
    AND ph.PostHistoryTypeId = 5 -- Edit Body
    AND p.ClosedDate < ph.CreationDate
  ORDER BY ph.CreationDate DESC

Enter Parameters

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