Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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);
Advertisement
Add Comment
Please, Sign In to add comment