[Carnage]

PHP Code:

$threads = $vbulletin->db->query_read("
    SELECT thread.threadid, thread.title, thread.iconid, thread.dateline, thread.postusername, thread.postuserid,
        post.pagetext
    FROM " . TABLE_PREFIX . "thread AS thread
    INNER JOIN " . TABLE_PREFIX . "post AS post ON (post.postid = thread.firstpostid)
    WHERE thread.forumid = <number>
    ORDER BY thread.dateline DESC
    LIMIT 5 "); 


the above code is slightly misleading; so i posted you the whole query. replace <number> with the forum id you want