Answers on Closed Question by a User

0

Please login or register to vote for this query.

(click on this box to dismiss)

shows all closed answers for the specified user

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT p.id as [Post Link]
FROM Posts p, PostHistory ph
WHERE p.OwnerUserId = ##USERID##
AND p.PostTypeId = 2
AND ph.id = p.ParentId
AND ph.PostHistoryTypeId = '10'

Enter Parameters

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