UPDATE bb_team_finances f
SET league_today_revenue = league_today_revenue + (
    SELECT CASE WHEN m.playoff_status = 'SIX PLACE' THEN s.league_revenue_of_6th_team
            WHEN m.playoff_status = 'FINAL' THEN s.league_final_revenue
            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)