SELECT c.`name` as catname, c.`safe_name` as catsname, c.`id` as catid, f.`name`, f.`safe_name`, f.`id` as forumid, COUNT(CASE WHEN t.`updated` > 1185223985 THEN 1 ELSE 0 END CASE) 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`
GROUP BY f.`id`
ORDER BY c.`posid`, f.`posid` ASC