/PHP/Laravel/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

6 votes281 views4 answers
Laravel create project command
PHP Laravel
0 vote295 views1 answer
Laravel create pivot migration
PHP Laravel
-1 vote295 views2 answers
Laravel updateorcreate multiple records
PHP Laravel
4 votes275 views5 answers
Laravel get first record
PHP Laravel
0 vote327 views1 answer
Trying to get property 'id' of non object in laravel api
PHP Laravel
0 vote311 views1 answer
Hasmany relationship with created at in laravel example
PHP Laravel
14 votes354 views4 answers
Laravel set timezone dynamically
PHP Laravel
13 votes279 views4 answers
Laravel login by id
PHP Laravel
0 vote308 views1 answer
Foreach empty laravel
PHP Laravel
0 vote307 views1 answer
How to set up the laravel ssh keygen
PHP Laravel