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

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
  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 > 2
  order by a.Score desc

Enter Parameters

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