SELECT a.topic_id, a.topic_forum, a.topic_title,  (SELECT count(*) FROM a) as amount
	FROM  (
                SELECT topic.id AS topic_id, topic.forum AS topic_forum, topic.title AS topic_title, parent as forum_parent
                FROM topic
                LEFT JOIN forumparents ON topic.forum = forumparents.forum
            ) a