/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 vote450 views1 answer
Laravel imap - Set message flags
PHP Laravel
-1 vote424 views1 answer
Create user with tinker php laravel
PHP Laravel
2 votes305 views1 answer
Laravel get file name
PHP Laravel
2 votes392 views3 answers
Laravel model particular column
PHP Laravel
0 vote462 views1 answer
Laravel npm run deve error mix
PHP Laravel
8 votes387 views2 answers
Store file into specific directory laravel using storage facade
PHP Laravel
0 vote406 views1 answer
Laravel make:action
PHP Laravel
50 votes494 views6 answers
Laravel migration add column to existing table
PHP Laravel
3 votes356 views1 answer
Collection empty laravel
PHP Laravel
6 votes384 views1 answer
Laravel route param blade
PHP Laravel