/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 vote283 views1 answer
Filter child table data from parent laravel eloquent
PHP Laravel
0 vote285 views1 answer
How to increase request timeout in laravel
PHP Laravel
0 vote358 views1 answer
Failed to open stream permission denied laravel
PHP Laravel
0 vote301 views1 answer
Laravel db query log string replacements
PHP Laravel
4 votes340 views2 answers
Pass parameter to view laravel
PHP Laravel
0 vote284 views2 answers
Laravel apiresource
PHP Laravel
0 vote323 views1 answer
Undefined offset: 0 at laravel\framework\src\Illuminate\Routing\Router.php
PHP Laravel
3 votes256 views1 answer
Current time stamp in laravel
PHP Laravel
0 vote321 views1 answer
Laravel update single field
PHP Laravel
14 votes281 views6 answers
Laravel debug
PHP Laravel