/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 vote162 views1 answer
How to make a simple mail system in Laravel without view or notification
PHP Laravel
0 vote182 views1 answer
Laravel collection min
PHP Laravel
1 vote142 views1 answer
Call metho din config laravel
PHP Laravel
-2 votes161 views1 answer
Errno: 150 foreign key constraint is incorrectly formed laravel 8
PHP Laravel
0 vote145 views1 answer
Laravel select custom column
PHP Laravel
13 votes144 views3 answers
How to change existing migration laravel
PHP Laravel
1 vote141 views1 answer
How to check exist in array in rule validation laravel
PHP Laravel
1 vote158 views1 answer
Update many laravel
PHP Laravel
1 vote134 views1 answer
Laravel websockets onsubscribe
PHP Laravel
0 vote131 views1 answer
Laravel eloquent select one column
PHP Laravel