SELECT c.`name` as catname, c.`safe_name` as catsname, c.`id` as catid, f.`name`, f.`safe_name`, f.`id` as forumid, COUNT(t.`id`) as countid
FROM `kb_categories` c
LEFT OUTER JOIN `kb_forums` f
ON f.`catid` = c.`id`
LEFT OUTER JOIN `kb_topics` t
ON t.`forumid` = f.`id`
WHERE t.`updated` > 1185223985
GROUP BY f.`id`
ORDER BY c.`posid`, f.`posid` ASC