/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

8 votes149 views6 answers
Isset php
PHP
1 vote149 views1 answer
Allowed memory size of bytes exhausted composer
PHP
0 vote137 views2 answers
Php xml to json
PHP
20 votes163 views6 answers
Cmd run php file
PHP
0 vote156 views1 answer
Meta_value wordpress
PHP Wordpress
4 votes358 views6 answers
Laravel jwt
PHP Laravel
10 votes160 views3 answers
For loop in laravel
PHP Laravel
0 vote192 views1 answer
Symfony flash message
PHP Symfony
0 vote159 views1 answer
Laravel chain query builder
PHP Laravel
4 votes143 views3 answers
Php str_replace multiple
PHP