[Solved] Convert SQL query to Yii Criteria Query

Question

You can try this:

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

Accepted Answer

You can try this:

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