title: Yii CDbCriteria select with AS alias
body: <p>I'm joining <code>page_content</code> table with the same and after that both have column named <code>sef_url</code>
  Following code returns an error.
  Is there any possibility to get the AS 'alias_name' use inside of <code>CDbCriteria-&gt;select</code></p>
  
  <pre><code>$criteria=new CDbCriteria;
  $criteria-&gt;alias = 'p';
  $criteria-&gt;select = array('p.sef_url, p.date_last_modified, pc.sef_url AS parent_sef_url');
  $criteria-&gt;join = 'LEFT JOIN page_content pc ON p.parent_pageid = pc.pageid';
  
  $criteria-&gt;condition = 'p.published=:published AND p.sitemap_index=:sitemap_index';
  $criteria-&gt;params = array(':published'=&gt;1,':sitemap_index'=&gt;0); 
  
  $result_arr = parent::model()-&gt;findAll($criteria);
  
  echo '&lt;pre&gt;';
  print_r($result_arr);
  
  foreach($result_arr as $row) {
    echo $row['parent_sef_url'];
  }
  </code></pre>