1

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.Id as [Post Link], p.Score, p.CommentCount, p.CreationDate, b.Name as [Tag] 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.CommentCount, p.CreationDate, b.Name
order by p.CreationDate desc

view current version

edited nov 7 14

created oct 31 14 jon.doe14699