My Edit History


Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

-- My edit history
-- Shows edits to posts I did not originally create

    WHEN (P.PostTypeId = 1) THEN P.Title 
    ELSE (SELECT TOP 1 Title FROM Posts WHERE Posts.Id = P.ParentId)
  END AS [Question Title], 
    WHEN (P.PostTypeId = 1) THEN 'Question' 
    ELSE 'Answer' 
  END AS [Edit To], 
  PHT.Name + CASE WHEN P.PostTypeId = 1 THEN ' of question' ELSE ' of answer' END AS [Edit Type],
  PH.CreationDate AS [Edit Date],
  'site://questions/' + CONVERT(VARCHAR, P.Id)+'|Post #' + CONVERT(VARCHAR, P.Id) AS [Link]
FROM PostHistory AS PH, Posts AS P, PostHistoryTypes AS PHT
  (P.Id = PH.PostId AND PH.PostHistoryTypeId = PHT.Id) -- joins
  AND PH.UserId = ##UserId## AND P.OwnerUserId <> ##UserId##
ORDER BY PH.CreationDate ASC

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results