Q&A for science fiction and fantasy enthusiasts
DECLARE @UserId INT = ##UserId:INT?9814069## -- How to return Yes/No if AID=MID? SELECT TOP ##TopCount:INT?10## q.Id AS [Post Link], u.Id AS [User Link], q.CreationDate AS Created, q.ViewCount AS Views, q.AnswerCount AS AC, q.AcceptedAnswerId AS AID, a.Id AS MID, q.Score AS QS, a.Score AS MS, q.CommentCount AS QC, a.CommentCount AS MC, q.Tags FROM Posts a JOIN Posts q ON a.ParentID=q.Id JOIN Users u ON q.OwnerUserId=u.Id WHERE a.OwnerUserId=@UserId -- Ideas: -- AND q.CreationDate >= '2024-01-01' -- AND q.AcceptedAnswerId=a.Id ORDER BY Views DESC