Top 20 AcceptedAnswers by Tag w Body

0

Please login or register to vote for this query.

(click on this box to dismiss)

Quantitative Finance

Q&A for finance professionals and academics

Select top 20 

q.title, u.displayname, a.id, a.parentid, au.id, au.displayname, a.body, a.commentcount, a.creationdate, a.lastactivitydate, a.score

From Posts q 

join Posts a on q.acceptedanswerid = a.id
join Users u ON q.OwnerUserId = u.Id
join Users au ON a.OwnerUserId = au.Id

Where q.posttypeid = 1
  and q.tags like '%<' + ##tagname:string## + '>%'
  and q.ClosedDate is NULL
  and q.CommunityOwnedDate is null
  and a.posttypeid = 2
  
  
Order by a.score desc, a.creationdate asc

Enter Parameters

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