Openlimp then Call or Raise a shove

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

Openlimp then Call or Raise a shove

Postby preparac » Mon Jan 18, 2010 3:21 pm

If I want to ses how often a player openlimps ant then calls or raises a shove of a player acting after him, ist this the way to go?

cnt_p_openlimp_callallin
sum(if[tourney_holdem_hand_player_statistics.flg_p_limp AND tourney_holdem_hand_player_statistics.flg_p_open_opp AND tourney_holdem_hand_player_statistics.enum_face_allin = 'P' AND NOT substring(lookup_actions_p.action from 2 for 1)='F'

cnt_p_openlimp_faceallin
sum( if[tourney_holdem_hand_player_statistics.flg_p_limp AND tourney_holdem_hand_player_statistics.flg_p_open AND tourney_holdem_hand_player_statistics.enum_face_allin = 'P'

thanx
prep
preparac
 
Posts: 323
Joined: Thu May 15, 2008 6:23 am

Re: Openlimp then Call or Raise a shove

Postby WhiteRider » Mon Jan 18, 2010 4:09 pm

That looks good.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Openlimp then Call or Raise a shove

Postby preparac » Tue Jan 19, 2010 4:25 am

Hm, what if I openlimp, somebody raises behind me, a third player 3 bets, I call, second player shoves, 3 player overshoves, I fold ... then my concition expression would also be set to true, no? How I can avoid this? More flexible substring?
preparac
 
Posts: 323
Joined: Thu May 15, 2008 6:23 am

Re: Openlimp then Call or Raise a shove

Postby kraada » Tue Jan 19, 2010 11:22 am

Do you want him never folding preflop? If so, just use this expression instead of your substring:
holdem_hand_player_statistics.enum_folded NOT LIKE 'P'
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