Svip

SELECT f.`name`, f.`safe_name`, f.`id`, t.`id`,t.`title`, t.`updated`, u.`name` as last_user, t.`date`FROM `kb_forums` f LEFT OUTER JOIN `kb_topics` tON t.`forumid` = f.`id`LEFT OUTER JOIN `kb_users` uON t.`userid` = u.`id`WHERE f.`catid` = '1' ORDER BY f.`posid` ASC, t.`updated` DESC