0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for musicians, students, and enthusiasts

Select top 20 id as [Post Link], owneruserid as [User Link], viewcount, answercount, commentcount, tags, creationdate, score from Posts
where AcceptedAnswerId is not null
AND tags like '%<' + ##tagname:string## + '>%'
AND ClosedDate is NULL
AND CommunityOwnedDate is null
order by viewcount desc, creationdate asc

fork query

created jan 17 18 anonymous