Latest Threads on Forum Page

[youssef87]

Yes but I can't really find anything.

What I want is to put on the right side of my forum "Latest Posts"

I have that now, but this is how it looks.

Topic 1
By: User1

Topic 1
By: User 2

I want it to just show the topic, with the latest user post. Not to keep showing the same thread by a different user. Such as,

Topic 1
By: User 1

Here is the query, if anyone knows how to edit this so that it can work how I want it, would really help

	$query = $vbulletin->db->query_read("
		SELECT post.postid, post.pagetext, post.userid, post.username, post.visible, thread.forumid, thread.title as thread_title, thread.threadid, forum.forumid, forum.title as forum_title
		FROM " . TABLE_PREFIX . "post as post
		LEFT JOIN " . TABLE_PREFIX . "thread as thread on (post.threadid = thread.threadid)
		LEFT JOIN " . TABLE_PREFIX . "forum as forum on (thread.forumid = forum.forumid)
		WHERE post.visible = 1 AND $latest_and AND $latest_and_1
		ORDER BY postid DESC
		LIMIT $limit"