/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

0 vote150 views4 answers
How to use sweetalert in laravel controller
PHP Laravel
0 vote134 views1 answer
Php artisan tinker encription cmd
PHP
0 vote126 views1 answer
Bu7scador con laravel
PHP
12 votes135 views3 answers
Php order array by specific key
PHP
2 votes131 views2 answers
Laravel/ui for laravel 7
PHP
22 votes136 views6 answers
Php artisan make:auth laravel 8
PHP
1 vote124 views1 answer
Php namespace class
PHP
0 vote153 views1 answer
Agregar clases de rol al body en WordPress
PHP Wordpress
0 vote170 views1 answer
Wordpress change language of specific text php
PHP Wordpress
0 vote132 views1 answer
Remove default product data tabs
PHP