How to sort by related table field in laravel?

Question

Laravel

There are models - Post | Comment
Related respectively as Post.hasMany and Comment.belongsTo, how can I display all Post sorted by number of comments ?
+ pagination required

Answer 1

stackoverflow.com/questions/24208502/laravel-order...

Answer 2

You are trying to select a post with comments.
Do you need comments? So choose comments.

Comment::whereHas('post', function( $query ) use ($id) {
        $query->whereId($id);
})->orderBy('created_at')->paginate(0, 15);

Otherwise, output order can and can be handled, but not pagination.

Answer 3

Try like this:

$posts = Post::with('comments')
            ->join('comments', 'comments.post_id', '=', 'posts.id')
            ->select('posts.*', 'comments.*')
            ->groupBy('posts.id')
            ->orderBy(DB::raw('COUNT(`posts`.`id`)'), 'asc')
            ->paginate(10);