Новое на форуме из одной темы

 
$tsql = "SELECT t.*, COUNT(p.id) as postsnum, f.id as fid, f.title as forum, u.id as uid, u.nickname as starter, u.login as login, f.auth_group as auth_group
						 FROM cms_forum_threads t, cms_forum_posts p, cms_forums f, cms_users u
						 WHERE p.thread_id = t.id AND t.user_id = u.id AND t.forum_id = f.id $groupsql
						 GROUP BY p.thread_id
						 ORDER BY t.pubdate DESC
						 LIMIT ".$cfg['shownum'];