/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 vote141 views1 answer
How to call controller in view laravel
PHP
11 votes168 views2 answers
Php string filter email
PHP
0 vote164 views1 answer
Tina4 generate crud
PHP
0 vote195 views1 answer
Install phpstorm in ubuntu stable
PHP
0 vote237 views1 answer
Form validation for file type in codeigniter
PHP
0 vote189 views1 answer
Test a single file laravel
PHP
0 vote215 views1 answer
Laravel relationship retrieve data
PHP Laravel
0 vote213 views1 answer
Update onlu one column laravel
PHP Laravel
0 vote192 views1 answer
Install phpredis MAC OSX
PHP
11 votes196 views6 answers
Laravel create resource
PHP