UPDATE bb_team_finances f
SET league_today_revenue = league_today_revenue + (
        SELECT  CASE
                WHEN m.int_playoff_status = 'GROUP STAGE' THEN s.intleague_revenue_of_group_stage
                WHEN m.int_playoff_status = 'ROUND 1' THEN s.intleague_revenue_of_round_1
                WHEN m.int_playoff_status = 'ROUND 2' THEN s.intleague_revenue_of_round_2
                WHEN m.int_playoff_status = 'SEMI-FINAL' THEN s.intleague_revenue_of_semifinal
                WHEN m.int_playoff_status = 'FINAL' THEN s.intleague_revenue_of_champion
                WHEN m.int_playoff_status = 'CHAMPION' THEN s.intleague_revenue_of_final
                ELSE 0
                END
        FROM bb_level_settings s
                JOIN bb_manager m ON s.LEVEL = m.LEVEL
        WHERE m.bb_team_info_id = f.bb_team_info_id);