RFI but not Openshove

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

RFI but not Openshove

Postby preparac » Wed Jan 20, 2010 7:45 pm

I try to build a stat that shows me, when a player RFI (whitout shoving) regardless if he shoves later in the hand preflop ... is this the way to go?

[tourney_holdem_hand_player_statistics.flg_p_first_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp AND NOT (tourney_holdem_hand_player_statistics.enum_allin = 'P' AND tourney_holdem_hand_player_statistics.flg_p_open_opp AND lookup_actions_p.action LIKE 'R')
preparac
 
Posts: 323
Joined: Thu May 15, 2008 6:23 am

Re: RFI but not Openshove

Postby WhiteRider » Thu Jan 21, 2010 5:38 am

That looks good, but I don't think you need the "AND tourney_holdem_hand_player_statistics.flg_p_open_opp" in the NOT(...) section.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: RFI but not Openshove

Postby preparac » Thu Jan 21, 2010 9:26 am

You are right.
preparac
 
Posts: 323
Joined: Thu May 15, 2008 6:23 am


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

Who is online

Users browsing this forum: No registered users and 0 guests