Q&A for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
-- This is a simplified example and might need adjustments SELECT Q.Id AS QuestionId, Q.Title, A.Id AS AnswerId, QC.Text AS QuestionComment, AC.Text AS AnswerComment FROM Posts Q LEFT JOIN Posts A ON Q.Id = A.ParentId LEFT JOIN Comments QC ON Q.Id = QC.PostId LEFT JOIN Comments AC ON A.Id = AC.PostId WHERE Q.Tags LIKE '%<gxt>%' AND Q.PostTypeId = 1 -- Questions ORDER BY Q.Id, A.Id