Find answers by a given user to closed questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

Q&A about the site for music historians, critics, and fans

SELECT 
  a.ParentId AS "Question ID", 
  a.Id AS "Answer ID",
  q.ClosedDate AS "Closed Date",
  ph.Comment AS "Closed Reason",
  q.Title AS [Title]
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

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