dave2085 wrote:Why is this not working?
tourney_hand_player_statistics.amt_expected_won is not in the correct place:
- Code: Select all
sum(if[tourney_hand_summary.cnt_players = 3 AND tourney_hand_summary.str_actors_p LIKE '9%' AND tourney_hand_player_statistics.position = 8 and exists (select 1 from tourney_hand_player_statistics hero where hero.id_hand = tourney_hand_player_statistics.id_hand and hero.flg_hero and hero.flg_p_open_opp and hero.position = 9), tourney_hand_player_statistics.amt_expected_won, 0])
