Find answers by a given user to closed questions


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

  a.ParentId AS "Question ID", 
  a.Id AS "Answer ID",
  q.ClosedDate AS "Closed Date",
  ph.Comment AS "Closed Reason",
  q.Title AS [Post Link]
FROM Posts a
  JOIN Posts q ON a.ParentId = q.Id
  JOIN PostHistory ph on ph.PostId = q.Id 
WHERE a.PostTypeId = 2 -- answer
  AND a.OwnerUserId = ##UserId:int##
  AND ph.PostHistoryTypeId = 10 -- closed
ORDER BY q.ClosedDate DESC

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results