Simple search for answers that may have useful comments

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

-- Simple search for answers that may have useful comments
select a.id as [Post Link], a.score, count(c.id) as [Comment Count]
from posts q
  inner join postTags pt on pt.postid = q.id
  inner join tags on tags.id = pt.tagid
  inner join posts a on q.id = a.parentid
  inner join comments c on c.postid = a.id 
where tags.tagname like ##tag:string##
  and a.score > 1
  and c.score > 1
group by a.id, a.score
order by [Comment Count] desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results