/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

3 votes238 views6 answers
Laravel jwt token
PHP Laravel
2 votes209 views1 answer
Laravel carbon human readable
PHP Laravel
0 vote244 views1 answer
Back() with errors in laravel
PHP Laravel
0 vote220 views1 answer
Stripe laravel usage-based metered billing
PHP Laravel
11 votes226 views6 answers
Datetime validation in laravel
PHP Laravel
0 vote221 views1 answer
Spatie/laravel-health
PHP Laravel
0 vote215 views1 answer
Show sender name laravel
PHP Laravel
0 vote202 views4 answers
Laravel 8: bootstrap
PHP Laravel
0 vote229 views1 answer
Laravel get file to browser send
PHP Laravel
15 votes194 views6 answers
Laravel custom validation message
PHP Laravel