/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

31 votes286 views4 answers
Laravel seed fresh
PHP
-1 vote215 views1 answer
Check request method laravel
PHP
0 vote257 views1 answer
The_post_thumbnail
PHP
1 vote372 views3 answers
Symfony datetime now
PHP Symfony
1 vote256 views1 answer
Persian error laravel
PHP
0 vote253 views1 answer
Php date in italiano
PHP
0 vote289 views1 answer
Remove repeated columns laravel
PHP Laravel
15 votes296 views3 answers
Laravel make model with migration 5.8
PHP Laravel
0 vote261 views1 answer
Php pdo error 500
PHP
0 vote250 views1 answer
Database connection in pdo php
PHP