BB Facing Steal

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

BB Facing Steal

Postby pr1mo » Sun Nov 30, 2008 12:31 am

this stat only has BU and CO? and not SB? i think i split the stat up correctly positionally and SB returns 0 while BU and CO add up the rest of the hands

it reads the column: cnt_steal_def_opp_bb which then reads the expression holdem_hand_player_statistics.flg_blind_def_opp

but attempt to steal the blinds stat uses combination of CO/BU/SB.
pr1mo
 
Posts: 192
Joined: Tue Apr 29, 2008 10:22 pm

Re: BB Facing Steal

Postby WhiteRider » Sun Nov 30, 2008 6:19 am

Do you mean "BB Faced Steal"?

This is just a pure count, and uses the column:
cnt_steal_def_opp_bb = sum( if[holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_b, 1, 0])
..so doesn't depend on the steal raiser's position at all.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests