/PHP/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 vote167 views1 answer
Curl error (code 3) url malformed laravel
PHP
0 vote183 views1 answer
"customer" attribute not getting saved from admin magento 2
PHP
2 votes147 views2 answers
Php unique string
PHP
0 vote173 views1 answer
Laravel new line in language file
PHP
0 vote176 views1 answer
Acho in php
PHP
0 vote173 views1 answer
Slim disable display error details
PHP
0 vote161 views2 answers
Laravel apiresource
PHP
4 votes173 views4 answers
Delete all rows from table laravel
PHP Laravel
14 votes191 views5 answers
Laravel model tablename
PHP Laravel
31 votes172 views3 answers
Carbon laravel use
PHP