My edits on answers to a specific question

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

SELECT 
  p.Id AS [Post Link],
  'site://posts/' + CAST(p.Id AS varchar)+'/revisions' AS [Revision History],
  ph.Comment, ph.PostHistoryTypeId, ph.CreationDate
FROM Posts p INNER JOIN PostHistory ph ON ph.PostId=p.Id
WHERE (p.ParentId=##questionid?31879##) and (ph.UserId=##userid##) and (p.PostTypeId = 2)
ORDER BY ph.CreationDate DESC

Enter Parameters

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