Listo, ya lo logre con esta consulta:
Código sql:
Ver originalSELECT tema.id AS id_tema, USER.nick AS autor, USER.id AS uid, tema.contenido AS contenido, tema.title AS title, tema.TIME AS TIME, USER.mensajes AS mensajes, rank.cargo AS cargo
FROM (
half_ranks AS rank
INNER JOIN half_users AS USER ON rank.rank = USER.rank
)
INNER JOIN half_temas AS tema ON tema.autor = USER.id
WHERE tema.foro =2
AND (
tema.tema =1
OR tema.id =1
)