$pop = $db->query("SELECT bb".$n."_threads.topic, bb".$n."_threads.threadid, bb".$n."_threads.lastposttime, bb".$n."_threads.replycount, bb".$n."_threads.views, bb".$n."_users.userid, bb".$n."_threads.boardid as parentid, bb".$n."_users.username FROM bb".$n."_threads LEFT JOIN bb".$n."_users ON (bb".$n."_users.userid=bb".$n."_threads.lastposterid) LEFT JOIN bb".$n."_boards ON (bb".$n."_boards.boardid=bb".$n."_threads.boardid) WHERE bb".$n."_threads.boardid NOT IN(23,44,67) && bb".$n."_threads.boardid IN (0".getSearchableBoards().") ORDER BY bb".$n."_threads.lastposttime DESC LIMIT 5"); |