Recent hot network questions


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 TOP(##num?100##)
  p.Id AS [Post Link], p.OwnerUserId as [User Link], ph.CreationDate, p.Score, p.AnswerCount, p.Tags
FROM Posts p JOIN PostHistory ph ON p.Id=ph.PostId
WHERE ph.PostHistoryTypeId=52
ORDER BY ph.CreationDate DESC

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results