/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 vote130 views1 answer
How match array in laravel collection
PHP Laravel
8 votes127 views2 answers
Laravel drop multiple columns
PHP Laravel
0 vote113 views1 answer
Populate old value of dropdown laravel
PHP Laravel
0 vote113 views1 answer
How to wirte laravel dd function in php
PHP Laravel
0 vote111 views3 answers
Laravel 'Choice question must have at least 1 choice available.'
PHP Laravel
0 vote108 views1 answer
How to login laravel passport with postman
PHP Laravel
48 votes196 views6 answers
Laravel joins
PHP Laravel
-1 vote115 views1 answer
When to create a service in laravel
PHP Laravel
0 vote109 views1 answer
Get post data in laravel
PHP Laravel
4 votes114 views5 answers
Laravel storage
PHP Laravel