DECLARE @UserId int = ##UserId## SELECT --TOP 20 a.id as...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

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.Id = q.AcceptedAnswerId
Where a.OwnerUserId = @UserId AND q.ClosedDate IS NOT NULL
ORDER BY a.CreationDate Desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results