fold to resteal vs hero

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

fold to resteal vs hero

Postby Huttydr » Tue Feb 23, 2021 9:02 am

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
 
Posts: 15
Joined: Tue Jan 12, 2021 3:35 pm

Re: fold to resteal vs hero

Postby Huttydr » Tue Feb 23, 2021 12:27 pm

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?
Huttydr
 
Posts: 15
Joined: Tue Jan 12, 2021 3:35 pm

Re: fold to resteal vs hero

Postby Flag_Hippo » Tue Feb 23, 2021 1:49 pm

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
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 22 guests

cron
highfalutin