Svip

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 countidFROM `kb_categories` cLEFT OUTER JOIN `kb_forums` fON f.`catid` = c.`id`LEFT OUTER JOIN `kb_topics` tON t.`forumid` = f.`id`GROUP BY f.`id`ORDER BY c.`posid`, f.`posid` ASC