/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 votes167 views4 answers
Codeigniter apache remove index.php
PHP
3 votes200 views2 answers
Current user laravel
PHP Laravel
1 vote193 views1 answer
/laravel-2020-07-27.log" could not be opened
PHP Laravel
18 votes169 views3 answers
Get first word from string php
PHP
2 votes220 views1 answer
Cakephp 2 savefield
PHP
6 votes170 views3 answers
Php request uri
PHP
3 votes185 views1 answer
Sms laravel
PHP
0 vote243 views1 answer
Php test if three values are equal
PHP
0 vote246 views1 answer
Onclick on image php
PHP
5 votes203 views3 answers
Return view controller laravel
PHP Laravel