Questions favorited by a user with a matching tag badge

1

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], 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.Score>=0
  and p.ClosedDate is Null
group by p.Id, p.Score, p.CommentCount, p.CreationDate, p.Tags
order by Users desc

Enter Parameters

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