0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to bypass life's everyday problems with simple tricks

SELECT
    Posts.Id AS PostId,
    Posts.Title AS PostTitle,
    Posts.Body AS PostBody,
    Comments.Id AS CommentId,
    Comments.Text AS CommentText
FROM
    Posts
LEFT JOIN Comments ON Posts.Id = Comments.PostId
WHERE
    Posts.PostTypeId = 1 -- Assuming 1 is for questions; adjust if necessary
    AND Posts.Score > 50 -- Example criterion for "top" posts; adjust based on your needs
ORDER BY
    Posts.Score DESC, Comments.CreationDate

fork query

edited feb 27

created feb 20 anonymous