CActiveFinder

public function __construct($model,$with)
{
    $this->_builder=$model->getCommandBuilder();
    $this->_joinTree=new CJoinElement($this,$model);
    $this->buildJoinTree($this->_joinTree,$with);
}

public function count($criteria)
{
    Yii::trace(get_class($this->_joinTree->model).'.count() eagerly','system.db.ar.CActiveRecord');
    $this->joinAll=$criteria->together!==true;

    $alias=$criteria->alias===null ? 't' : $criteria->alias;
    $this->_joinTree->tableAlias=$alias;
    $this->_joinTree->rawTableAlias=$this->_builder->getSchema()->quoteTableName($alias);

    $n=$this->_joinTree->count($criteria);
    $this->destroyJoinTree();
    return $n;
}

public function findAllBySql($sql,$params=array())
{
    Yii::trace(get_class($this->_joinTree->model).'.findAllBySql() eagerly','system.db.ar.CActiveRecord');
    if(($rows=$this->_builder->createSqlCommand($sql,$params)->queryAll())!==array())
    {
        $baseRecords=$this->_joinTree->model->populateRecords($rows,false);
        $this->_joinTree->findWithBase($baseRecords);
        $this->_joinTree->afterFind();
        $this->destroyJoinTree();
        return $baseRecords;
    }
    else
    {
        $this->destroyJoinTree();
        return array();
    }
}

public function findBySql($sql,$params=array())
{
    Yii::trace(get_class($this->_joinTree->model).'.findBySql() eagerly','system.db.ar.CActiveRecord');
    if(($row=$this->_builder->createSqlCommand($sql,$params)->queryRow())!==false)
    {
        $baseRecord=$this->_joinTree->model->populateRecord($row,false);
        $this->_joinTree->findWithBase($baseRecord);
        $this->_joinTree->afterFind();
        $this->destroyJoinTree();
        return $baseRecord;
    }
    else
        $this->destroyJoinTree();
}

public function getModel($className)
{
    return CActiveRecord::model($className);
}

public function lazyFind($baseRecord)
{
    $this->_joinTree->lazyFind($baseRecord);
    if(!empty($this->_joinTree->children))
    {
        foreach($this->_joinTree->children as $child)
            $child->afterFind();
    }
    $this->destroyJoinTree();
}

public function query($criteria,$all=false)
{
    $this->joinAll=$criteria->together===true;

    if($criteria->alias!='')
    {
        $this->_joinTree->tableAlias=$criteria->alias;
        $this->_joinTree->rawTableAlias=$this->_builder->getSchema()->quoteTableName($criteria->alias);
    }

    $this->_joinTree->find($criteria);
    $this->_joinTree->afterFind();

    if($all)
    {
        $result = array_values($this->_joinTree->records);
        if ($criteria->index!==null)
        {
            $index=$criteria->index;
            $array=array();
            foreach($result as $object)
                $array[$object->$index]=$object;
            $result=$array;
        }
    }
    elseif(count($this->_joinTree->records))
        $result = reset($this->_joinTree->records);
    else
        $result = null;

    $this->destroyJoinTree();
    return $result;
}