/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

1 vote139 views1 answer
Foreign key nullable in laravel
PHP Laravel
5 votes165 views2 answers
How to get the index in foreach loop in laravel
PHP Laravel
19 votes123 views4 answers
Remove first letter php
PHP
0 vote126 views1 answer
Modal align center yii2
PHP
2 votes120 views1 answer
Foreign key constraint is incorrectly formed laravel
PHP
11 votes131 views2 answers
Woocommerce get product id
PHP
1 vote119 views1 answer
Bindparam php
PHP
0 vote147 views1 answer
Php remove utf non breaking space
PHP
0 vote128 views2 answers
Laravel logout all users
PHP
4 votes127 views1 answer
Laravel install production
PHP