Stats sens

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

Stats sens

Postby raph156 » Sun Sep 25, 2011 6:23 am

Hi,
What difference between:
holdem_hand_player_statistics.flg_f_face_raise AND holdem_hand_player_statistics.cnt_f_call > 0
holdem_hand_player_statistics.enum_f_3bet_action='C'
Thanks for help
raph156
 
Posts: 159
Joined: Tue Feb 09, 2010 3:22 pm

Re: Stats sens

Postby raph156 » Sun Sep 25, 2011 7:18 am

I would like: number of time bet river then face raise then reraise and not face reraise.
holdem_hand_player_statistics.flg_r_bet AND holdem_hand_player_statistics.enum_r_3bet_action='R' AND...
I thought that could work: AND not(holdem_hand_player_detail.amt_r_4bet_facing >0)

Thanks for help
raph156
 
Posts: 159
Joined: Tue Feb 09, 2010 3:22 pm

Re: Stats sens

Postby kraada » Sun Sep 25, 2011 9:04 am

In "holdem_hand_player_statistics.flg_f_face_raise AND holdem_hand_player_statistics.cnt_f_call > 0" you both faced a flop raise and called the flop.
In "holdem_hand_player_statistics.enum_f_3bet_action='C'" you called a flop 3bet. These may often not be the same - if you called a flop bet then faced a flop raise, the former would trigger, but the latter would not.

For your last stat you want flg_r_bet and flg_r_3bet and not(flg_r_4bet_def_opp) - you bet, you 3bet (reraised a raise) and did not get reraised again (didn't have a chance to face a 4bet).
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 0 guests