title: Yii ActiveRecord using scope with another scope
body: <p>i want to use some scope if yii active record model in same model's another scope
  see the following code, you will understand what i want to say?</p>
  
  <pre><code>public function scopes() {
      return array(
          'avg_all'=&gt;array(
              'select'=&gt;array(
                  'avg_fp_1'=&gt;'AVG(CASE when t.fp_1&gt;=0 then t.fp_1 ELSE NULL END)',
                  'avg_fp_2'=&gt;'AVG(CASE when t.fp_2&gt;=0 then t.fp_1 ELSE NULL END)',
                  'avg_fp_3'=&gt;'AVG(CASE when t.fp_3&gt;=0 then t.fp_1 ELSE NULL END)',
                  'avg_fp_4'=&gt;'AVG(CASE when t.fp_4&gt;=0 then t.fp_1 ELSE NULL END)',
                  'avg_fp_5'=&gt;'AVG(CASE when t.fp_5&gt;=0 then t.fp_1 ELSE NULL END)',
              ),
          ),
          'avg_feedback'=&gt;array(
              'with'=&gt;array('avg_all'),
              'select'=&gt;array(
                  'avg_feedback'=&gt;'ROUND((avg_fp_1+avg_fp_2+avg_fp_3+avg_fp_4+avg_fp_5)/5,2)'
              )
          )
      );
  }
  </code></pre>
  
  <p>main problem <code>'with'=&gt;array('avg_all'),</code></p>
  
  <p>is it possible to use another scope inside a scope.</p>