/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

3 votes288 views1 answer
How do I make a redirect in PHP?
PHP
1 vote278 views1 answer
Laravel run query migration
PHP
29 votes262 views1 answer
Calculate date diff php
PHP
2 votes316 views1 answer
How to run multiple laravel projects at same time
PHP
0 vote376 views1 answer
WordPress Convert Object To Array
PHP Wordpress
7 votes316 views2 answers
How to start composer in laravel project on localhost
PHP Laravel
17 votes277 views6 answers
Update query laravel
PHP
2 votes332 views2 answers
Laravel 8 websockets
PHP Laravel
7 votes294 views3 answers
Php login system
PHP
0 vote272 views1 answer
How to access private and protected members in php
PHP