/**
* Get the top Podcasts.
*
* @param int $count
* @return List
*/
public static function getTop($count)
{
$podcasts = Podcast::join('podcast_user', 'podcast_user.podcast_id', '=', 'podcasts.id')->groupBy('podcasts.id')->orderBy(DB::raw('count(podcast_user.id)'), 'desc')->take($count)->get(['podcasts.name', 'podcasts.url', 'podcasts.feed', 'podcasts.coverimage', 'podcasts.description', DB::raw('count(podcast_user.id) as podcast_user_count')]);
return $podcasts;
}
