/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

3 votes188 views2 answers
Cannot create an instance of class viewmodel
PHP
24 votes193 views6 answers
For each php
PHP
0 vote181 views1 answer
Remove symbolsand spaces php
PHP
0 vote216 views1 answer
Laravel datepicker date format
PHP Laravel
0 vote166 views1 answer
Php replace blackslash
PHP
0 vote170 views1 answer
Cashier mollie
PHP
0 vote183 views1 answer
Set character set utf8 in pdo php
PHP
0 vote200 views1 answer
Orwherebetween laravel
PHP Laravel
0 vote209 views1 answer
Laravel - access file from storage path - alternative to symlink
PHP Laravel
3 votes179 views2 answers
Php get date from day of year
PHP