Question : activerecord yii2 select with limit(start,end) not working
Answered by : shiny-stag-hjhvhcmelb51
$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 : https://stackoverflow.com/questions/32155900/use-limit-range-in-yii2/32156285 | Last Update : Wed, 23 Sep 20