/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

9 votes295 views2 answers
Use resource in laravel 8
PHP
22 votes302 views6 answers
Php get array key
PHP
-1 vote331 views1 answer
Laravel orderby with relation
PHP Laravel
3 votes324 views2 answers
Get the string after a character in php
PHP
0 vote302 views2 answers
How to save array of inputs in php
PHP
1 vote288 views2 answers
Phpmailer addAttachment
PHP
5 votes331 views3 answers
Drop column table in migration if exist in laravel
PHP Laravel
-1 vote319 views1 answer
Laravel set production
PHP Laravel
0 vote367 views1 answer
Db connection postgres laravel
PHP
-1 vote350 views1 answer
Turn error log WP
PHP Wordpress