SELECT a.postid,a.threadid,a.pagetext,a.title,a.visible
FROM jos_bb_post AS a
WHERE a.visible = 1 AND (SELECT `forumid` FROM `jos_bb_thread` as `b` WHERE `b`.`threadid` = `a`.`threadid`)=3
ORDER BY a.postid desc