Server: Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l mod_autoindex_color PHP/5.3.1 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1
browser: Chrome 6.0.472.63
Yii version: 1.1.4
$criteria=new CDbCriteria;
$criteria->select='t.*, COUNT(t.Id) as numTweet';
$criteria->condition='t.Status= :status AND DATE(t.CreatedTime) = CURRENT_DATE()';
$criteria->params = array(
':status'=>Tweet::STATUS_PUBLIC,
);
$criteria->group='t.UserId';
$criteria->order='numTweet DESC';
$tweetCount=Tweet::model()->count($criteria);
Yii generate sql:
SELECT
COUNT(DISTINCT t.UserId)
FROM `stt_tweets` `t`
WHERE
t.Status= :status AND DATE(t.CreatedTime) = CURRENT_DATE()
GROUP BY t.UserId
Bind with parameter :status=0
Expected
SELECT
COUNT(DISTINCT t.UserId)
FROM `stt_tweets` `t`
WHERE
t.Status= :status AND DATE(t.CreatedTime) = CURRENT_DATE()