/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

45 votes262 views6 answers
Laravel run seeder
PHP
0 vote179 views1 answer
Reindex array php
PHP
3 votes181 views3 answers
How to get last id in database codeigniter 4
PHP
0 vote235 views2 answers
Get http referer php
PHP
3 votes169 views3 answers
Php stdclass to array
PHP
0 vote179 views1 answer
Php pdo check if execution worked
PHP
0 vote173 views1 answer
Php sort array by value length
PHP
2 votes229 views3 answers
How to change the colum type in migration laravel
PHP Laravel
1 vote185 views1 answer
Php text colors
PHP
57 votes181 views6 answers
File_get_contents php
PHP