PokerTracker

This SQL statment have an error, this vector column count how many times a player fold to resteal from hero where is the error?
sum(if[cash_hand_player_statistics.enum_p_3bet_action = 'F' and exists
(select 1
from cash_hand_player_statistics hero
where hero.id_hand = cash_hand_player_statistics.id_hand
and hero.flg_hero
AND hero.flg_blind_def_opp
AND hero.flg_p_3bet), 1, 0])

Huttydr wrote:This SQL statment have an error, this vector column count how many times a player fold to resteal from hero where is the error?
sum(if[cash_hand_player_statistics.enum_p_3bet_action = 'F' and exists
(select 1
from cash_hand_player_statistics hero
where hero.id_hand = cash_hand_player_statistics.id_hand
and hero.flg_hero
AND hero.flg_blind_def_opp
AND hero.flg_p_3bet), 1, 0])

Now the SQL statement is run but i dont know if the stat could be fine.
what do you think?

You are not testing for the player making the initial 2Bet so it will count all players folding to heros 3Bet. For example if BTN steals, Hero 3Bets from SB and BB folds it would also be counted for the BB. For this column you could use either of the following if you don't want that:

Code: Select all

cash_hand_player_statistics.flg_p_first_raise

or

Code: Select all

cash_hand_player_statistics.flg_steal_att