/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 votes163 views3 answers
Pdo close connection
PHP
0 vote156 views1 answer
Docker compose php
PHP
0 vote171 views1 answer
Convertir date php en français
PHP
0 vote177 views1 answer
Laravel create pivot migration
PHP
0 vote162 views1 answer
Php 8 constructor promotion
PHP
0 vote153 views1 answer
Lazy loading vs eager loading laravel
PHP
0 vote181 views1 answer
Laravel Undefined index: token on reset
PHP Laravel
0 vote192 views1 answer
Comment supprimer les onglets WooCommerce dans WordPress
PHP Wordpress
0 vote205 views1 answer
Laravel blade php variable concatenate javascript variable
PHP Laravel
1 vote162 views2 answers
Php xml string
PHP