/PHP/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

6 votes264 views2 answers
Php cut off first x characters
PHP
9 votes260 views3 answers
Prepend 0 to number php
PHP
1 vote271 views1 answer
File get content using call api in php
PHP
0 vote254 views1 answer
Add data in textarea with php variable
PHP
0 vote260 views1 answer
Laravel child relation get max value
PHP
0 vote264 views1 answer
Laravel phpdoc collection of model
PHP
2 votes275 views2 answers
In PackageManifest.php line 131: Undefined index: name laravel 7
PHP
0 vote277 views2 answers
Laravel sortby varchar date
PHP Laravel
1 vote298 views1 answer
Using middleware auth laravel in controller constructor
PHP Laravel
0 vote280 views1 answer
Don't have xdebgu ini file
PHP