Size: a a a
RK
$users = \DB::table('results')
->select(\DB::raw('max(point) as max_point, user'))
->orderBy('point', 'desc')
->groupBy('user')
->limit(10);
$results = Result::()
->joinSub($users, 'users', function ($join) {
$join->on('users.user', '=', 'results.user');
$join->on('users.max_point', '=', 'results.point');
})->get();w
V
select max(id),user,max(point),max(created_at) from results group by user order by max(point) desc limit 10;
RK
RK
select max(id),user,max(point),max(created_at) from results group by user order by max(point) desc limit 10;
RK
RK
RK
S
select max(id),user,max(point),max(created_at) from results group by user order by max(point) desc limit 10;
RK
ИЛ
S
ИЛ
RK
S
V
RK
RK
