Yes, SQL aggregates multiply across multiple joins. So, try to use temp tables or subqueries, such as:
SELECT
f.*,
(SELECT COUNT(t.topic_id) FROM mt_forum_topics t WHERE t.forum_id=f.forum_id),
(SELECT COUNT(f.post_id) FROM mt_forum_posts f WHERE p.forum_id=f.forum_id),
FROM mt_forums f;
-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --