public function teams_entry($id)
 {
     $competitiongroup = Competitiongroup::whereId($id)->firstOrFail();
     //Versenyzők a listába
     $result_list = Result::where('competitiongroup_id', '=', $id)->get()->lists('competitor_id', 'competitor_id');
     $already_in1 = Results_team::select('competitor1_id')->where('competitiongroup_id', '=', $id)->get()->lists('competitor1_id', 'competitor1_id');
     $already_in2 = Results_team::select('competitor2_id')->where('competitiongroup_id', '=', $id)->get()->lists('competitor2_id', 'competitor2_id');
     $already_in3 = Results_team::select('competitor3_id')->where('competitiongroup_id', '=', $id)->get()->lists('competitor3_id', 'competitor3_id');
     foreach ($already_in1 as $remove) {
         $result_list->forget($remove);
     }
     foreach ($already_in2 as $remove) {
         $result_list->forget($remove);
     }
     foreach ($already_in3 as $remove) {
         $result_list->forget($remove);
     }
     $competitors = [];
     foreach ($result_list as $comp) {
         $temp_comp = Competitor::whereId($comp)->first();
         $competitors[$comp] = $temp_comp->full_name_birthday;
     }
     natsort($competitors);
     //Benevezett versenyzők
     $competitor_list = Result::select('results.*')->where('competitiongroup_id', '=', $id)->join('competitors', 'results.competitor_id', '=', 'competitors.id')->orderBy('full_name', 'asc')->get();
     $competitor_in = [];
     foreach ($competitor_list as $comp) {
         $competitor_in[$comp->id] = $comp->competitor->full_name;
     }
     natsort($competitor_in);
     $comp_count = count($competitor_in);
     //Benevezett csapatok
     $team_list = Results_team::where('competitiongroup_id', '=', $id)->orderBy('name')->get();
     $team_in = [];
     foreach ($team_list as $team) {
         $team_in[$team->id] = $team->name;
     }
     natsort($team_in);
     $team_count = count($team_in);
     return view('backend.competitiongroups.teams_entry', compact('competitiongroup', 'competitors', 'team_in', 'team_list', 'team_count', 'competitor_in', 'competitor_list', 'comp_count'));
 }