rrylee
9/11/2016 - 8:38 AM

learn eloquent query.

learn eloquent query.

$posts = Post::leftJoin('comments', 'comments.post_id', '=', 'posts.id')
    ->selectRaw(
        'posts.*,
        count(comments.id) as comments_count'
    )
    ->groupBy('posts.id')
    ->orderBy('comments_count', 'desc')
    ->get();