Questions answered by a user before they were closed

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Exchange

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

--https://meta.stackexchange.com/questions/332343/query-for-no-of-many-questions-i-have-answered-which-are-closed-later
--We want to include questions which have been reopened later.
--SELECT DISTINCT is used to prevent the same answer being shown multiple times (e.g., if there were several closures).
SELECT DISTINCT a.Id AS [Post Link]
  FROM PostHistory AS ph
  INNER JOIN Posts AS a
    ON a.ParentId = ph.PostId
   AND a.CreationDate < ph.CreationDate 
   AND ph.PostHistoryTypeId=10
  WHERE a.OwnerUserId = ##UserId:int##
ORDER BY a.Id ASC

Enter Parameters

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