Questions with a tag favorited by users with matching tag badge

0

Please login or register to vote for this query.

(click on this box to dismiss)

Psychology & Neuroscience Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

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

Enter Parameters

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