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