Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
--Querying Posts that contain "architecture" term
-- and Comments with contain "useful" or "helpful"
select top 100 p.Id as [Post Link],p.body, c.Id as [Comment Link],c.Text
from Posts p
JOIN Comments c ON p.Id = c.PostId
where p.body like '%architect%' and AnswerCount <>0 and
(Text like '%useless%' or Text like '%unhelpful%')