Unanswered questions favorited by a user with a matching tag badge


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for people studying math at any level and professionals in related fields

select p.CreationDate, p.Id as [Post Link], p.Score, count(b.UserId) as Users, p.Tags from Posts p, Badges b, Votes v  
where v.VoteTypeId=5 
  and v.PostId=p.Id 
  and v.UserId=b.UserId 
  and p.Tags like '%'+b.Name+'%' 
  and p.AnswerCount = 0 
  and p.ClosedDate is Null
group by p.Id, p.Score, p.CreationDate, p.Tags
order by Users desc

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results