gistfile1.php

<?php

class Forum extends AppModel
{
    var $actsAs = array('Containable');
    
    var $hasMany = array(
        'Forums' => array(
            'className' => 'Forum',
            'foreignKey' => 'parent_id',
            'fields' => array(
                'Forums.*',
                '(SELECT sum(ForumPost.comment_count) FROM forum_posts as ForumPost WHERE ForumPost.forum_id = Forums.id GROUP BY ForumPost.forum_id) AS forum_post_comment_count',
            ),
        ),
    );
}

?>