Database query failed: Subquery returns more than 1 row

Last SQL query: SELECT p.id AS person_id, p.fname, p.lname, (SELECT t.name AS team_name FROM game_players AS tp INNER JOIN teams AS t ON t.id = tp.team_id inner join games as g on g.id=tp.game_id WHERE tp.person_id = p.id and g.comp_id=310 and tp.team_id IN (SELECT gp.team_id from games as g INNER join game_participants as gp on gp.game_id=g.id where g.comp_id=310 group by team_id) group by t.id) AS team_name FROM game_players AS gp INNER JOIN games AS g ON gp.game_id = g.id INNER JOIN people AS p ON gp.person_id = p.id WHERE g.comp_id = 310 AND gp.in_play = 'IN_PLAY' GROUP BY p.id