/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

0 vote362 views2 answers
Laravel store file
PHP Laravel
21 votes378 views2 answers
Long text in laravel migration
PHP Laravel
13 votes363 views6 answers
Composer create project laravel
PHP Laravel
0 vote370 views1 answer
Laravel maintenance mode custom class
PHP Laravel
28 votes355 views6 answers
Laravel change column type
PHP Laravel
0 vote362 views1 answer
Laravel max length format
PHP Laravel
0 vote362 views1 answer
Raw query in laravel with parameters
PHP Laravel
0 vote386 views1 answer
Laravel eloquent difference create and insert
PHP Laravel
0 vote371 views1 answer
How to get private images in s3 laravel
PHP Laravel
4 votes361 views2 answers
Laravel eloquent get data without duplicates
PHP Laravel