/PHP/Laravel/Sort by number of views descending laravel

Sort by number of views descending laravel

$posts = Post::select(DB::raw('posts.*, count(*) as `aggregate`'))
    ->join('views', 'posts.id', '=', 'views.post_id')
    ->groupBy('post_id')
    ->orderBy('aggregate', 'desc')
    ->get();

Source: laravel.io

Similar codes

2 votes131 views4 answers
Laravel where in array
PHP Laravel
6 votes151 views1 answer
Insall laravel
PHP Laravel
31 votes144 views2 answers
Laravel sample controller
PHP Laravel
24 votes153 views4 answers
Laravel query not null
PHP Laravel
20 votes159 views2 answers
Schema error laravel
PHP Laravel
0 vote129 views4 answers
Join table laravel count
PHP Laravel
0 vote140 views2 answers
Laravel retain old value
PHP Laravel
0 vote141 views1 answer
Textarea laravel migration
PHP Laravel
33 votes142 views6 answers
Create migration command in laravel
PHP Laravel
0 vote153 views1 answer
Redirect to intent url after login laravel
PHP Laravel