Q&A for professional and enthusiast programmers
--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
WHERE a.OwnerUserId = ##UserId:int##
ORDER BY a.Id ASC