/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

2 votes265 views1 answer
Laravel scheduler every 2 hours
PHP Laravel
18 votes284 views4 answers
Create model view controller laravel
PHP Laravel
0 vote281 views1 answer
Laravel mix disable notifications
PHP Laravel
16 votes265 views4 answers
Wherenotnull laravel
PHP Laravel
0 vote295 views1 answer
Laravel list all tbales
PHP Laravel
0 vote308 views1 answer
Call variable from inside a collection laravel
PHP Laravel
0 vote290 views3 answers
Permissions for laravel deployment
PHP Laravel
33 votes254 views6 answers
Laravel query builder
PHP Laravel
-1 vote301 views1 answer
Echo in console command laravel
PHP Laravel
0 vote274 views1 answer
Laravel make view command
PHP Laravel