Solana Top Questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Drupal Answers

Q&A for Drupal developers and administrators

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results