/PHP/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

1 vote324 views1 answer
Magento debug white page
PHP
0 vote338 views1 answer
Die laravel
PHP
1 vote314 views1 answer
Get specific columns using with() function in laravel eloquent
PHP
1 vote388 views1 answer
Use of segment in laravel 8
PHP Laravel
0 vote350 views2 answers
Laravel eloquent select case when
PHP
2 votes382 views3 answers
Laravel url with parameters blade
PHP Laravel
0 vote322 views1 answer
Php-array-delete-by-value-not-key
PHP
12 votes391 views2 answers
Laravel query with trashed
PHP Laravel
1 vote325 views2 answers
Show php modules installed
PHP
0 vote337 views4 answers
Form::select laravel
PHP