Select top 20 q.id, q.id as [Post Link], u.id as "Asked"...

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results