/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

31 votes353 views4 answers
Php generate random string of characters
PHP
3 votes351 views2 answers
Get details of user using token in laravel passport
PHP Laravel
0 vote337 views1 answer
Laravel disable config cache
PHP Laravel
1 vote376 views3 answers
Php hide errors
PHP
0 vote263 views0 answer
PHP
2 votes328 views3 answers
Clear composer cache
PHP
1 vote360 views1 answer
Autoload file in laravel
PHP
0 vote356 views1 answer
Installation request for phpoffice/phpspreadsheet 1.4.0 -> satisfiable by phpoffice/phpspreadsheet[1.4.0]
PHP
8 votes350 views6 answers
Laravel collection sum
PHP
3 votes319 views2 answers
Laravel disable csrf token
PHP