/PHP/Yii/Activerecord yii2 select with limit(start,end) not working

Activerecord yii2 select with limit(start,end) not working

$Query = new Query;
$Query->select(['um.id as USERid', 'um.first_name', 'um.last_name','um.email','COUNT(g.id) as guestCount'])
->from('user_master um')
->join('LEFT JOIN', 'guest g', 'g.user_id = um.id')
->limit(20)
->offset(12)
->groupBy('um.id')
->orderBy(['um.id' => SORT_DESC]);

Source: stackoverflow.com

Similar codes

0 vote395 views1 answer
Dropdown in crud application YII
PHP Yii
0 vote442 views1 answer
Yii2 arraydataprovider
PHP Yii
0 vote389 views1 answer
Yii2 label of ActiveField
PHP Yii
1 vote463 views2 answers
Yii1 set flash
PHP Yii
2 votes475 views1 answer
Yii2 migration add column
PHP Yii
0 vote424 views2 answers
Yii2 get cookie
PHP Yii
0 vote465 views1 answer
Yii 2 create migration with fields
PHP Yii
0 vote380 views2 answers
Yii1 refresh cache schema
PHP Yii
0 vote439 views1 answer
Yii 1 clear cache
PHP Yii
0 vote435 views1 answer
Yii1 findall as array listData
PHP Yii