Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by 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
by 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
by 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
Users browsing this forum: No registered users and 22 guests