Unnamed

SELECT SUM(value) FROM players INNER JOIN  match_data ON (match_data.player_id = players.id) WHERE team_id = 1 AND players.id IN(select player_id from match_data where match_id = 12) GROUP BY team_id


SELECT SUM(value) FROM players INNER JOIN  match_data ON (match_data.player_id = players.id) WHERE team_id = 3 AND players.id IN(select player_id from match_data where match_id = 12) GROUP BY team_id