/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 votes217 views2 answers
{{Str::limit laravel
PHP Laravel
1 vote220 views4 answers
Laravel create multiple rows
PHP Laravel
15 votes183 views6 answers
Transaction laravel
PHP Laravel
0 vote200 views1 answer
Laravel 5.7
PHP Laravel
2 votes179 views3 answers
Laravel url with parameters blade
PHP Laravel
31 votes170 views6 answers
Laravel update
PHP Laravel
0 vote218 views1 answer
Laravel reload relationship
PHP Laravel
1 vote186 views3 answers
Laravel function to check if image exist or not
PHP Laravel
0 vote174 views1 answer
How to stop message of laravel mix
PHP Laravel
1 vote179 views2 answers
Laravel blade dump
PHP Laravel