/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 vote186 views2 answers
Laravel debugbar not showing
PHP Laravel
2 votes195 views1 answer
Laravel instal
PHP Laravel
-1 vote197 views3 answers
Laravel except route
PHP Laravel
0 vote206 views1 answer
Show float laravel blade
PHP Laravel
-1 vote136 views1 answer
Validate rule if row exist laravel
PHP Laravel
11 votes186 views3 answers
Laravel running a specific migration on different path
PHP Laravel
10 votes182 views4 answers
Import session laravel
PHP Laravel
42 votes192 views6 answers
Laravel 8 foreign key
PHP Laravel
4 votes196 views3 answers
Laravel use config
PHP Laravel
1 vote200 views1 answer
Run jobs laravel
PHP Laravel