/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

15 votes138 views3 answers
Pass data to blade laravel
PHP Laravel
0 vote125 views1 answer
Search a file name and open that file phpstrom
PHP
2 votes130 views2 answers
Remove every whitespace php
PHP
16 votes144 views2 answers
Laravel create or update eloquesnt
PHP Laravel
1 vote134 views1 answer
Php time ago
PHP
0 vote151 views1 answer
Multipart json test laravel
PHP Laravel
3 votes140 views2 answers
Wp do sql query from function
PHP Wordpress
0 vote120 views1 answer
Php registration form and login in same page
PHP
0 vote133 views2 answers
Concat in where clause laravel query builder
PHP Laravel
0 vote170 views1 answer
Php array json encode key and value
PHP