STAT OF pfr BY SMALL BLIND IN TABLE 2-MAX

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

STAT OF pfr BY SMALL BLIND IN TABLE 2-MAX

Postby marvin » Mon Dec 14, 2009 11:21 am

I HAVE tried to do this:
1) sum(if[tourney_holdem_hand_player_statistics.position =0 AND tourney_holdem_hand_summary.cnt_players =2 AND lookup_actions_p.action = 'R%',1,0])

and i have tried also
2) sum(if[tourney_holdem_hand_player_statistics.position =9 AND tourney_holdem_hand_summary.cnt_players =2 AND lookup_actions_p.action = 'R%',1,0])
why i remember that was written (dont remember where) that in table 2-max position of default were 9 (sb-dealer) and 8 (bb).

in each of theese cases it give me 0 raises (but real it was a big number). where is the bug? TY
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: STAT OF pfr BY SMALL BLIND IN TABLE 2-MAX

Postby kraada » Mon Dec 14, 2009 11:36 am

There is no position 0 in heads up games. The easiest way to get PFR for heads up games is simply to use the Attempt To Steal stat - the only way you can attempt to steal when heads up is to be on the small blind and open raising, which is going to be the same as PFR.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: STAT OF pfr BY SMALL BLIND IN TABLE 2-MAX

Postby marvin » Mon Dec 14, 2009 11:46 am

ok, but what is wrong about my stat defined on #2? (i need help for the implemantation used why it is used in other stats similar, like raise on flop in particular situation ecc)
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: STAT OF pfr BY SMALL BLIND IN TABLE 2-MAX

Postby WhiteRider » Mon Dec 14, 2009 11:47 am

lookup_actions_p.action = 'R%'

..isn't valid.
"=" means that the strings match exactly. The actions string will never be exactly 'R%'.
If you want to check for a pattern like that then you need to use LIKE.

lookup_actions_p.action LIKE 'R%'

..is fine.
See this tutorial for more info.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: STAT OF pfr BY SMALL BLIND IN TABLE 2-MAX

Postby marvin » Mon Dec 14, 2009 11:49 am

GREAT!!!! TY
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am


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

Who is online

Users browsing this forum: No registered users and 0 guests