/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

0 vote192 views1 answer
Php print string as bytes
PHP
50 votes227 views6 answers
Laravel add column to table
PHP Laravel
0 vote161 views1 answer
Merge two objects php laravel
PHP Laravel
12 votes162 views3 answers
Php shortcode wordpress return content with shortcodes
PHP
0 vote158 views1 answer
How to read data from curl php
PHP
7 votes161 views4 answers
Many to many relationship laravel
PHP
4 votes201 views2 answers
Auth guard (admin) is not defined laravel 8
PHP Laravel
7 votes149 views2 answers
Laravel encrypt database fields
PHP Laravel
2 votes177 views3 answers
Multiple primary key defined laravel
PHP Laravel
0 vote197 views1 answer
Laravel get all vendor files
PHP Laravel