new* Fold BB to BU 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

new* Fold BB to BU Steal

Postby js2002 » Thu Apr 09, 2009 5:48 am

js2002_cnt_p_BB_fold_to_BU
sum(if[substring(lookup_actions_p.action from 1 for 1)='F' AND
holdem_hand_player_statistics.position = 8 AND Is 8 always the BB or should I better use: holdem_hand_player_statistics.flg_blind_b
holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 AND
holdem_hand_player_statistics.flg_blind_def_opp,1,0])

js2002_cnt_p_BB_fold_to_BU_opp
sum(if[holdem_hand_player_statistics.position = 8 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 AND holdem_hand_player_statistics.flg_blind_def_opp,1,0])

Everything fine?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: new* Fold BB to BU Steal

Postby WhiteRider » Thu Apr 09, 2009 6:42 pm

That looks ok - yes, the BB is always pos 8.
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