/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 vote178 views1 answer
Php sort multidimensional array by child value
PHP
34 votes211 views6 answers
Random number generator in php
PHP
2 votes220 views2 answers
Laravel websockets
PHP Laravel
4 votes179 views2 answers
Signup API in laravel
PHP
0 vote389 views2 answers
How make factory and seeder in laravel 8
PHP Laravel
0 vote230 views1 answer
Exclude row from clooection laravel
PHP Laravel
0 vote202 views1 answer
Wordpress add sitemap.xml to robots.txt dynamically
PHP
25 votes224 views2 answers
Clear cache without using composer in laravel 8
PHP Laravel
7 votes195 views4 answers
$errors show this error in laravel
PHP
0 vote202 views2 answers
From user id to user role wordpress
PHP