/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

2 votes177 views3 answers
Php laravel dump
PHP Laravel
13 votes133 views3 answers
Php rtrim comma
PHP
1 vote150 views1 answer
Get user with role laravel
PHP
0 vote304 views1 answer
Create model for existing table in laravel
PHP Laravel
4 votes374 views6 answers
Laravel jwt
PHP Laravel
1 vote168 views2 answers
Google api for language translation in php
PHP
9 votes158 views6 answers
Laravel current url
PHP
0 vote196 views1 answer
Laravel eloquent where value less then 5 and greter then 0
PHP Laravel
0 vote206 views1 answer
Wp query meta in array
PHP Wordpress
74 votes162 views6 answers
Php string to int
PHP