Answers on closed questions

1

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

-- Answers that were posted on currently closed questions

   SELECT DISTINCT 
          a.CreationDate as [Answered],
          a.Id as [Post Link],
          q.ClosedDate as [Question Close Date]
     FROM POSTS as a
LEFT JOIN Posts AS q ON q.Id = a.ParentId
    WHERE a.PostTypeId = 2  --answers
      AND a.OwnerUserId = ##UserId:int##
      AND q.ClosedDate IS NOT NULL
 ORDER BY a.CreationDate DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results