SQL to select posts and threads into one query?

M

Mave

Guest
Member
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!


free plugins
minecraft paid for free
mcmarket
mc-market
free minecraft paid plugins
free minecraft plugins
spigotmc
SpigotMC
aac free
ewg free
Minecraft Premium Plugins
ewg free download
litebans free
epicworldgenerator free
free schematics
leaked schematics minecraft
schematics
schematics leaked
schematics free
minecraft schematics free
paid minecraft schematics free
paid minecraft schematics for free
free cracked plugins
free cracked minecraft plugins
plugins
featherboard download
featherboard plugin download
antiaura download
xenforo leaked
xenforo for free
xenforo addons
 
BlackSpigot General Chat
Rules Help Users
    Dekomori @ Dekomori: Click on the “version history” tab of a resource to view older versiona
    Top