/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

0 vote247 views2 answers
Yii2 activerecord bulk insert
PHP
10 votes260 views6 answers
Laravel Pagination
PHP Laravel
1 vote242 views1 answer
Write test case in react native
PHP
0 vote262 views1 answer
Adding field to array on condition laravel
PHP Laravel
1 vote267 views1 answer
Laravel get first letter of each word
PHP Laravel
3 votes278 views1 answer
Laravel validate max file size
PHP Laravel
0 vote246 views1 answer
Laravel components scripts
PHP
0 vote253 views1 answer
Php post self
PHP
0 vote239 views1 answer
Php print character x times
PHP
0 vote235 views1 answer
Only get selected value from has many ralation laravel
PHP