Q&A about the site for people organizing, marketing or licensing open source development projects
Select Top 400 p.Id as [Post Link], p.title as "QuestionTitle", c.text, c.id as [Comment Link] from posts p JOIN Comments c ON p.Id = c.PostId where (p.body like '%architectural%' or body like '%design%') AND (posttypeid = 1 and (c.text like '%edit%'))