/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 vote218 views1 answer
Find curren monday in laravel carbon
PHP Laravel
2 votes270 views4 answers
Foreach in laravel
PHP Laravel
0 vote232 views1 answer
Get basename without extension Laravel
PHP Laravel
0 vote326 views2 answers
Array collapse laravel
PHP Laravel
0 vote242 views1 answer
Undefined offset: 0 at laravel\framework\src\Illuminate\Routing\Router.php
PHP Laravel
5 votes219 views2 answers
How to make model and controller in laravel
PHP Laravel
0 vote302 views1 answer
Dummy data in laravel
PHP Laravel
2 votes248 views1 answer
Redirect from controller in laravel
PHP Laravel
6 votes210 views4 answers
Enset laravel session
PHP Laravel
2 votes237 views1 answer
Laravel get only relationship
PHP Laravel