/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

4 votes302 views1 answer
Types of method in api
PHP
1 vote325 views1 answer
Require and require_once difference in php
PHP
0 vote255 views1 answer
Order by array like sql php
PHP
18 votes264 views1 answer
Hash a password php
PHP
5 votes302 views3 answers
Mobile number validation in laravel 8
PHP Laravel
0 vote343 views1 answer
Referencing constant in config laravel
PHP Laravel
0 vote287 views1 answer
Use font awesome in laravel 8
PHP
0 vote241 views1 answer
$usr= $_POST["user"]; $pswd= $_POST["pass"];
PHP
0 vote283 views1 answer
Php regex file extension
PHP
1 vote332 views1 answer
Laravel set config value dynamically
PHP Laravel