Jon Skeet Answers Edited By Me

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

SELECT 
   p.Id AS [Post Link]
  ,u.DisplayName
  ,pht.Name
  ,ph.CreationDate
  ,p.Id AS PostId
  ,p.Title
FROM PostHistory ph
JOIN PostHistoryTypes pht ON ph.PostHistoryTypeId = pht.Id 
JOIN Posts p ON ph.PostId = p.Id 
JOIN Users u ON ph.UserId = u.Id 
WHERE ph.UserId = ##userId##
AND p.OwnerUserId = 22656 -- Skeet, skeet 
AND pht.Id IN (
  4, -- Edit Title
  5, -- Edit Body
  6  -- Edit Tags
);

Enter Parameters

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