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
by MrBug » Tue Mar 17, 2009 3:38 pm
Under holdem cash player statistics, the cnt_sb column (number of times player was in the sb) is defined as:
- Code: Select all
sum( if[holdem_hand_player_statistics.flg_blind_b=false AND holdem_hand_player_statistics.flg_blind_s,1,0])
Why is the first part necessary? Is the following not acceptable?
- Code: Select all
sum( if[holdem_hand_player_statistics.flg_blind_s,1,0])
-
MrBug
-
- Posts: 34
- Joined: Mon Feb 18, 2008 12:45 am
by WhiteRider » Tue Mar 17, 2009 7:12 pm
I don't know...
That does seem a bit strange.
I'll report this to the development team.
Thanks.
-
WhiteRider
- Moderator
-
- Posts: 54025
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 0 guests
