/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 vote155 views1 answer
Wp change num words exerpct
PHP Wordpress
9 votes164 views4 answers
Php end session
PHP
0 vote141 views2 answers
How make custom menu in wordpress
PHP
0 vote124 views1 answer
Laravel many to many relation update
PHP
0 vote152 views1 answer
Check if constant is defined php
PHP
1 vote153 views2 answers
Laravel throttle
PHP
2 votes219 views2 answers
Open php.ini in ubuntu
PHP
1 vote148 views1 answer
Laravel carbon time format AM PM
PHP
4 votes162 views4 answers
Get file size in php
PHP
0 vote135 views2 answers
Php string max length
PHP