0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for biology researchers, academics, and students

SELECT
    Q.Id AS QuestionId,
    Q.Title,
    Q.Body AS QuestionBody,
    A.Id AS AnswerId,
    A.Body AS AnswerBody,
    QC.Text AS QuestionComment,
    AC.Text AS AnswerComment
FROM
    Posts Q
LEFT JOIN
    Posts A ON Q.Id = A.ParentId AND A.PostTypeId = 2 -- 2 for Answers
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 -- 1 for Questions
ORDER BY
    Q.Id, A.Id

fork query

edited apr 19

created apr 19 anonymous