/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

1 vote396 views1 answer
Default index page for laravel in cpanel
PHP Laravel
0 vote355 views1 answer
Laravel create new file if not exists
PHP Laravel
18 votes349 views4 answers
Create model view controller laravel
PHP Laravel
2 votes326 views3 answers
Laravel fortify
PHP Laravel
1 vote354 views1 answer
Laravel validation required_if one parameter exist
PHP Laravel
23 votes361 views4 answers
Laravel change foreign key name
PHP Laravel
0 vote337 views1 answer
Laravel route not calling function of controller
PHP Laravel
7 votes389 views4 answers
Many to many relationship laravel
PHP Laravel
0 vote404 views1 answer
Laravel A row must be an array or a TableSeparator instance.
PHP Laravel
-3 votes342 views8 answers
@foreac laravel
PHP Laravel