Database query failed: Subquery returns more than 1 row<br /><br />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