Database query failed: Subquery returns more than 1 row

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