[RSS Feed/News] SQL to select posts and threads into one query?

[XenForo]

I'd like to select posts that are threads and posts that are just posts into one query.

For the threads I have:

Code:

SELECT * FROM xf_thread A INNER JOIN xf_post B ON A.post_date = B.post_date WHERE prefix_id IN (1,3,5,6,7) ORDER BY A.thread_id DESC LIMIT 10

And for the posts I have:

Code:

SELECT * FROM xf_post A WHERE thread_id = 12841 AND user_id = 1 ORDER BY post_id DESC LIMIT 10

How can I merge these together?
Thanks in advance!

ادامه مطلب...