>SELECT forum_categories.id AS `id` , forum_categories.name AS `name` , >forum_categories.createdby AS `createdby` , >forum_categories.order AS `order` ,DATE_FORMAT( forum_categories.created,"%m/%d/%y >%l:%i %p" ) AS `created` , >COUNT( forum_topics.id ) AS `topics`, SUM(forum_posts.id) AS `posts` >FROM forum_categories >LEFT JOIN forum_topics ON forum_categories.id = forum_topics.category >LEFT JOIN forum_posts ON forum_topics.id = forum_posts.topic >WHERE forum_categories.domain = 000001 >GROUP BY forum_categories.id >ORDER BY forum_categories.order ASC
imho, you should have a reference field in table topics to table categories so you wont end up with cross table query (multiplying the result) LEFT JOIN forum_posts ON forum_topics.id = forum_posts.topic left join forum_categories on forum_categories.id=forum_posts.id -Leo-
