/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

1 vote231 views1 answer
Laravel best practices
PHP Laravel
0 vote254 views1 answer
Entrust laravel
PHP Laravel
2 votes226 views1 answer
Set session after login with laravel
PHP Laravel
15 votes228 views4 answers
Laravel session flash 2020
PHP Laravel
4 votes238 views3 answers
Laravel on delete set null
PHP Laravel
1 vote250 views2 answers
Get database name laravel
PHP Laravel
2 votes280 views3 answers
Call stored procedure in laravel
PHP Laravel
0 vote262 views1 answer
Laravel add package without updating
PHP Laravel
10 votes229 views6 answers
Table laravel
PHP Laravel
0 vote249 views2 answers
Laravel log could not be opened fix
PHP Laravel