/PHP/Laravel/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

46 votes181 views6 answers
Laravel make controller with model
PHP Laravel
1 vote207 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel_api.sessions' doesn't exist (SQL: select * from `sessions` where `id` = sXWuwluhxC2HlCzzq7jDyPGJFriLGdxQj8bPtcgC limit 1)
PHP Laravel
8 votes185 views3 answers
What is route namespace in laravel
PHP Laravel
0 vote186 views7 answers
Laravel eloquent tricks
PHP Laravel
12 votes211 views4 answers
Count in laravel'
PHP Laravel
0 vote184 views1 answer
Laravel request input default value
PHP Laravel
10 votes186 views2 answers
Try and catch laravel
PHP Laravel
0 vote194 views2 answers
Maatwebsite/excel package 5.2 laravel
PHP Laravel
6 votes200 views3 answers
Disable foreign key laravel
PHP Laravel
19 votes177 views6 answers
Laravel Route Group
PHP Laravel