/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 vote181 views1 answer
Laravel update method resource
PHP Laravel
2 votes155 views1 answer
Call model function in controller laravel
PHP
0 vote130 views1 answer
Check custom post type post exists
PHP
45 votes330 views6 answers
Laravel run seeder
PHP Laravel
0 vote241 views1 answer
Ubuntu 7.2 deleted php
PHP
0 vote165 views1 answer
Send emails with runtime configurations in laravelk
PHP
21 votes185 views2 answers
Php delete element by value
PHP
0 vote197 views1 answer
Double in migration laravel
PHP Laravel
0 vote155 views1 answer
How to create pdf with doompdf in php
PHP
0 vote126 views1 answer
Laravel migrate test environment
PHP