Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
DECLARE @UserId int = ##UserId## SELECT --TOP 20 a.id as [Post Link] from Posts a INNER JOIN Posts q on a.ParentId = q.Id Where a.OwnerUserId = @UserId AND q.ClosedDate IS NOT NULL ORDER BY a.CreationDate Desc