Код: Выделить всё
$rows = (new \yii\db\Query())
->select('{{%movie}}.*,TRUNCATE(AVG( {{%rating}}.rating),2) as rating, {{%rating}}.publisher')
Код: Выделить всё
$rows = (new \yii\db\Query())
->select('{{%movie}}.*,TRUNCATE(AVG( {{%rating}}.rating),2) as rating, {{%rating}}.publisher')
Код: Выделить всё
->select([
'{{%movie}}.*',
'rating' => new Expression('TRUNCATE(AVG( {{%rating}}.rating),2)',
'{{%rating}}.publisher'
]);