All hot network 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
  DISTINCT p.CreationDate, p.OwnerUserId AS [User Link], p.Id AS [Post Link]
FROM Posts p JOIN PostHistory ph ON p.Id=ph.PostId
WHERE (ph.PostHistoryTypeId=52)
ORDER BY p.CreationDate DESC

Enter Parameters

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