sb limp
bb isolate
sb push
bb fold
- Code: Select all
sum(if[tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.cnt_players = 2
AND tourney_hand_player_statistics.cnt_p_face_limpers = 1
AND (tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) BETWEEN 2 AND 3.5
AND (tourney_hand_player_statistics.amt_p_3bet_facing + tourney_hand_player_statistics.amt_p_raise_made) >= tourney_hand_player_statistics.amt_p_effective_stack
AND lookup_actions_p.action = '%F%', 1, 0])
- Code: Select all
sum(if[tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.cnt_players = 2
AND tourney_hand_player_statistics.cnt_p_face_limpers = 1
AND (tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) BETWEEN 2 AND 3.5
AND (tourney_hand_player_statistics.amt_p_3bet_facing + tourney_hand_player_statistics.amt_p_raise_made) >= tourney_hand_player_statistics.amt_p_effective_stack', 1, 0])
what's wrong?
Looks like I found a mistake. I need to replace AND lookup_actions_p.action = '%F%' on
AND tourney_hand_player_statistics.enum_p_3bet_action = 'F'