Q&A about the site for members of the workforce navigating the professional setting
Select top 20 q.id, q.id as [Post Link], u.id as "Asked", u.id as [User Link], q.creationdate as "When Asked", a.creationdate as "When Answered", q.lastactivitydate as "Last Active", q.commentcount as "Q Comments", q.answercount as "Q Answers", q.tags, q.viewcount, q.score, au.id as "Answered", au.id as [User Link], a.id as [Post Link], a.commentcount as "A Comments" 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.acceptedanswerid is not null and q.tags like '%<' + ##tagname:string## + '>%' and q.ClosedDate is NULL and q.CommunityOwnedDate is null order by q.score desc