/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

13 votes399 views5 answers
How to change validation message in laravel
PHP Laravel
3 votes363 views6 answers
Php hello world
PHP
2 votes330 views1 answer
Attach multiple files in laravel mailable
PHP
5 votes335 views6 answers
Hello world php
PHP
3 votes304 views1 answer
Php stric type
PHP
0 vote389 views1 answer
Language_attributes for wordpress
PHP Wordpress
0 vote356 views1 answer
Multiplication des variables sur laravel
PHP Laravel
0 vote377 views1 answer
Laravel 8 db like query
PHP Laravel
14 votes369 views3 answers
Unset php return array
PHP
7 votes340 views3 answers
Wordpress custom loop
PHP