- Code: Select all
sum(if[tourney_hand_player_statistics.flg_blind_s and tourney_hand_player_statistics.cnt_p_face_limpers <= 2
and tourney_hand_summary.str_actors_p LIKE '0%'
AND tourney_hand_player_statistics.amt_f_bet_facing > 0
AND (lookup_actions_f.action SIMILAR TO '(F|XF)')
AND lookup_actions_p.action SIMILAR TO '(C|X)'
and not (tourney_hand_player_statistics.flg_p_first_raise), 1, 0])
problem i have is, that on the flop also BB could bet/lead and SB folds versus such a bet. How can I exclude this event?
So SB fold on the flop, only counts if the Button (firstin limper) bets the flop.
Just to be clear the action is as follow;
Preflop: BU limp first-in. SB completes. BB checks.
Postflop: SB & BB checks, BU bets.