Recently closed questions I answered

2

Please login or register to vote for this query.

(click on this box to dismiss)

People keep closing old questions I answered that obviously I think are good questions, or at least salvageable. Since I get no notification of such closing, I created this query.

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 50
  question.ClosedDate as "Closed On",
  question.CreationDate as "Created On",
  answer.Id as [Post Link]
FROM 
  Posts answer 
JOIN 
  Posts question
ON
  answer.ParentId = question.Id
WHERE 
  answer.PostTypeId = 2 
AND
  answer.OwnerUserId = ##UserId##
AND
  question.ClosedDate IS NOT NULL
ORDER BY
  question.ClosedDate
DESC

Enter Parameters

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