/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

8 votes222 views4 answers
Php carbon get timestamp
PHP
63 votes327 views6 answers
Laravel artisan clear cache
PHP Laravel
-4 votes262 views2 answers
Why we use pusher in laravel
PHP
2 votes282 views2 answers
Laravel migration remove unique
PHP Laravel
6 votes258 views3 answers
Format and show date PHP
PHP
5 votes234 views3 answers
PHP Fatal error: Allowed memory size of 1610612736 bytes exhausted (tried to allocate 4096 bytes)
PHP
21 votes320 views6 answers
Do shortcode wordpress
PHP Wordpress
0 vote206 views1 answer
Magento2 memory limit
PHP
1 vote220 views1 answer
Drupal 8 show php errors settings.php
PHP
8 votes242 views6 answers
PHP Fatal error: Allowed memory size of 134217728 bytes exhausted
PHP