/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 vote259 views3 answers
Get next month first day php
PHP
7 votes267 views1 answer
Laravel eloquent date range
PHP
0 vote264 views3 answers
Php serialize()
PHP
0 vote245 views2 answers
HTML and PHP enquiry form
PHP
5 votes240 views1 answer
How to get variable from url in laravel
PHP
-1 vote260 views4 answers
Laravel collection find
PHP Laravel
0 vote242 views1 answer
How do i implement blockchain payments on laravel website
PHP
0 vote285 views1 answer
Laravel count data wise
PHP Laravel
0 vote245 views1 answer
Twig is in string
PHP
0 vote250 views1 answer
How exactly works prompt parameter wp skipping password
PHP