/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

-1 vote200 views5 answers
Php version 7.4
PHP
4 votes185 views1 answer
Laravel relation of relation
PHP
0 vote160 views1 answer
PHP Resize
PHP
0 vote147 views3 answers
Laravel transform object to array
PHP
0 vote168 views1 answer
Add floater to open a modal in wordpress
PHP
1 vote153 views3 answers
Create services in laravel with command line
PHP
0 vote184 views1 answer
Expression #1 of ORDER BY contains aggregate function and applies to the result of a non-aggregated query laravel
PHP Laravel
1 vote145 views2 answers
Laravel get data from request
PHP
0 vote154 views1 answer
Set php path in ubuntu
PHP
0 vote292 views1 answer
Main features of php
PHP