/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 votes199 views3 answers
Laravel model particular column
PHP Laravel
1 vote185 views1 answer
How validate the becrypt password in laravel
PHP Laravel
0 vote195 views1 answer
Laravel download file change name
PHP Laravel
7 votes202 views1 answer
Rollback laravel transaction
PHP Laravel
0 vote153 views1 answer
Singular from table laravel
PHP Laravel
0 vote198 views2 answers
Laravel file path
PHP Laravel
0 vote231 views1 answer
Set custome table laravel eloquent
PHP Laravel
0 vote232 views1 answer
Edit items in Laravel collection
PHP Laravel
2 votes180 views2 answers
Laravel migration remove unique constraint
PHP Laravel
3 votes192 views1 answer
Laravel validation greater than or equal to
PHP Laravel