/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

37 votes318 views6 answers
Laravel create or update
PHP
0 vote348 views1 answer
Laravel validating birthdate by 13 years old
PHP Laravel
0 vote297 views1 answer
How to pass value in app.blade
PHP
1 vote287 views1 answer
Drupal 8 show php errors settings.php
PHP
4 votes393 views6 answers
Remove index.php in codeigniter
PHP CodeIgniter
2 votes301 views2 answers
Laravel now date
PHP
9 votes325 views4 answers
Laravel time format
PHP Laravel
0 vote296 views1 answer
Like %% inside the array php
PHP
0 vote307 views1 answer
Drupal 8 / 9 entityTypeManager get multiple comments by cid
PHP
0 vote303 views1 answer
Get record of last 24 hours in laravel
PHP