0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in conceptual questions about life and challenges in a world where "cognitive" functions can be mimicked in purely digital environment

-- 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

fork query

created dec 15 11 camccann