gistfile1.aw

<?php
    public function searchStarredMembers( $tag=null, $keyword=null, $myStar = true)
    {
        $with = array('myMemberStar');
        if(isset($tag)) {
            if($tag) {
                $with = array(
                    'myMemberStar'=>array(
                        'with'=> array(
                            'starToTags'=>array(
                                'joinType'=>'INNER JOIN',
                                'condition'=>'starToTags.member_star_tag_id =:tagId',
                                'params'=>array(':tagId'=>$tag),
                                'together'=>true,
                            )
                        )
                     )
                );
            } else {
                $with = array(
                    'myMemberStar'=>array(
                        'with'=>array(
                            'starToTags'=>array(
                                'condition'=>'starToTags.member_star_tag_id IS NULL',
                                'together'=>true,
                            )
                        )
                     )
                );
            }
            $member = Members::model()->with(array(
                'stars'=>array(
                    'together'=>true,
                    'with'=>$with
                )
            ))->find();
            $stars = (isset($member)) ? $member->stars : array();
        } else {
            $stars = $this->stars;
        }
        return new CArrayDataProvider($stars, array('keyField'=>'mem_id'));
    }
?>