won hand after calling flopraise (validate plz!)

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

won hand after calling flopraise (validate plz!)

Postby js2002 » Mon Mar 26, 2012 6:45 am

sum(if[cash_hand_player_statistics.flg_f_cbet AND cash_hand_player_statistics.flg_won_hand AND
cash_hand_player_statistics.flg_f_3bet_opp AND NOT(cash_hand_player_statistics.flg_f_3bet OR cash_hand_player_statistics.flg_f_4bet OR cash_hand_player_statistics.flg_f_fold) AND cash_hand_player_statistics.flg_t_saw, 1, 0])

= cbet and won and 3bet_opp and NOT(3bet or 4ber or fold) AND saw turn

Do u think this is ok?
(maybe the saw turn is obsolete but to be save i let it in)
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: won hand after calling flopraise (validate plz!)

Postby kraada » Mon Mar 26, 2012 10:23 am

That looks like it should work.
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 4 guests