[Solved] Convert SQL query to Yii Criteria Query

You can try this:

$data = Yii::app()->db->createCommand('Your query here')->queryAll();
var_dump($data);