/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 vote147 views1 answer
Wp safe redirect
PHP Wordpress
-1 vote166 views1 answer
Create user with tinker php laravel
PHP Laravel
16 votes131 views2 answers
Php print object
PHP
0 vote144 views1 answer
Upgrade php linux
PHP
6 votes150 views4 answers
Install laravel on windows
PHP Laravel
16 votes141 views3 answers
Make a forign key in migrations using laravel 8
PHP
0 vote153 views2 answers
Only Show Specific Countries In Caldera Forms Phone Field
PHP
8 votes155 views3 answers
Laravel model::query
PHP Laravel
0 vote128 views1 answer
Laravel nova resolveUsing
PHP
-2 votes127 views2 answers
Upgrade php 5.6 to 7 centos 7
PHP