activerecord yii2 select with limit 28start 2cend 29 not working

Solutions on MaxInterview for activerecord yii2 select with limit 28start 2cend 29 not working by the best coders in the world

we are a community of more than 2 million smartest coders
registration for
employee referral programs
are now open
get referred to google, amazon, flipkart and more
register now
  
showing results for - "activerecord yii2 select with limit 28start 2cend 29 not working"
Paul
21 Aug 2019
1$Query = new Query;
2$Query->select(['um.id as USERid', 'um.first_name', 'um.last_name','um.email','COUNT(g.id) as guestCount'])
3->from('user_master um')
4->join('LEFT JOIN', 'guest g', 'g.user_id = um.id')
5->limit(20)
6->offset(12)
7->groupBy('um.id')
8->orderBy(['um.id' => SORT_DESC]);