declare @userId int = ##userId##; select a.Id ,q.Title ,...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

declare @userId int = ##userId##;

select
 a.Id
,q.Title
,a.Score
from Posts as a
  join Posts as q      
  on q.Id = a.ParentId
  and q.AcceptedAnswerId is null
where a.OwnerUserId = @userId
and a.PostTypeId = 2 -- answer
and a.Score > 0
order by a.Score desc

Enter Parameters

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