1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users and developers of hardware and software for Raspberry Pi

-- UserId: User ID
DECLARE @UserId int = ##UserId:int##;

SELECT
  answers.Id as [Post Link]
FROM
  Posts as answers
INNER JOIN Posts as questions ON
  answers.ParentId = questions.Id
WHERE
  answers.OwnerUserId = @UserId AND
  questions.ClosedDate IS NOT NULL
ORDER BY
  answers.CreationDate DESC

fork query

created jul 8 jon.doe33355