/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

11 votes105 views5 answers
PHP array sum
PHP
1 vote110 views1 answer
Laravel stoage link brakes when pushed on production
PHP Laravel
2 votes103 views3 answers
Laravel env production
PHP
1 vote99 views1 answer
WP Uploads Media Path
PHP
0 vote125 views1 answer
Laravel run seeder enter timestamps
PHP Laravel
0 vote96 views1 answer
Custom my account page woocommerce
PHP
1 vote127 views2 answers
Laravel model is dirty
PHP Laravel
2 votes100 views1 answer
End session variable php
PHP
0 vote104 views1 answer
Lewin muzvonda
PHP
0 vote172 views1 answer
Veue laravel remove #/
PHP Laravel