Limp and holds AA

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

Limp and holds AA

Postby Messaa » Sun Jan 11, 2009 8:16 pm

Hello, I'm trying to create a stat which counts the number of times a player limped and was holding AA. The definition below doesn't seem to work, what is wrong?

sum(if[holdem_hand_player_statistics.flg_p_limp AND lookup_from_id(id_holecard, 'cardpair') = 'AA', 1, 0])
Messaa
 
Posts: 36
Joined: Tue May 27, 2008 1:55 am

Re: Limp and holds AA

Postby WhiteRider » Mon Jan 12, 2009 6:14 am

I think this is because you can't use look_from_id in columns, only in Statistics.
This works:
sum( if[ holdem_hand_player_statistics.flg_p_limp AND holdem_hand_player_statistics.id_holecard=1, 1, 0 ] )

See this post for card values.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 1 guest