0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited jul 16 14

created jul 16 14 anonymous