/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

4 votes130 views2 answers
Php $randomUA[rand(0, count($randomUA) 1)
PHP
0 vote231 views1 answer
Php get first element of iterator class
PHP
4 votes150 views4 answers
Wordpress get theme uri
PHP Wordpress
5 votes88 views1 answer
Branch from another branch
PHP
2 votes133 views1 answer
How get all files name in one folder in laravel
PHP
3 votes127 views1 answer
You may need an appropriate loader to handle this file type, currently no loaders are configured to process this file laravel
PHP
0 vote137 views1 answer
Php howto
PHP
2 votes148 views1 answer
Count() parameter must be an array or an object that implements countable laravel
PHP Laravel
0 vote115 views1 answer
Bu7scador con laravel
PHP
0 vote127 views2 answers
Nested array in laravel
PHP