public function club()
{
$users = DB::select('select users.*,count(posts.id) as p_count, ' . '(select count(id) from subs where subs.sub_fp = users.user_fp) as s_count ' . 'from posts left join users on posts.user_fp = users.user_fp ' . 'where posts.parent_id = 0 and users.id != 1 group by posts.user_fp order by p_count desc');
$groups = DB::select('select groups.*,count(posts.id) as p_count, ' . '(select count(id) from gsubs where gsubs.group_name = groups.group_name) as s_count ' . 'from posts left join groups on posts.group_name = groups.group_name ' . 'where posts.parent_id = 0 and posts.group_name != "" and groups.is_featured = 1 ' . 'group by posts.group_name order by p_count desc');
$chans = Chan::all();
return View::make('meta.club', ['users' => $users, 'chans' => $chans, 'groups' => $groups]);
}
public function chansAll()
{
return Response::json(Chan::all());
}
