'Aggregate and list withCount by grouped column

I want to make 24-hour trend posts. My intention is to collect all the likes in the posts.slug column that I have grouped and list them accordingly.

$trends = Post::withCount('likes')
    ->orderByDesc('likes_count')
    ->where('created_at', '>=', Carbon::now()->subDay())
    ->groupBy('posts.slug')
    ->get();
phpmysqllaraveleloquenteloquent-relationship


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions