PHP-Yii CDbCriteria Select Inside Select Problem

$criteria = new CDbCriteria;
$criteria->select =  array(
    '(SELECT MAX(v.`update_date`)
    FROM `ccn_employer_vacancy` v
    WHERE v.`publish` = 1 AND v.`swt_users_id` = t.`swt_users_id` AND v.`is_closed` = 0)  AS `last_update`',
    '(SELECT COUNT(*) FROM `ccn_employer_vacancy`
    WHERE `is_closed` = 0 AND `employer_data_id` = t.`employer_data_id`) AS `total_vacancy`'
);
$criteria->with = array(
    'employer_data' => array(
        'alias'     => 'd',
        'select'    => 'd.id, d.name, d.company_logo'
    ),
    'employer_data.employer_industry' => array(
        'alias'     => 'i',
        'select'    => 'i.name'
    )
);
$criteria->compare('t.`is_closed`', 0);
$criteria->group = 't.`swt_users_id`';
$criteria->order = 'MAX(t.`update_date`) DESC';

$model = CcnEmployerVacancy::model()->findAll($criteria);