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 pasita » Sun Feb 13, 2011 6:03 pm
Why would I get count of 1883 when I run
- Code: Select all
select count(*) from
holdem_hand_player_detail
where id_player = 5
but count of 1515 with
- Code: Select all
select count(*) from
holdem_hand_player_combinations
where id_player = 5
5 is my id on a small test db, so it shouldn't be a matter of known holecards. Under what circumstaces the combinations table doesn't get data?
-
pasita
-
- Posts: 605
- Joined: Tue May 06, 2008 4:05 pm
by WhiteRider » Sun Feb 13, 2011 6:15 pm
holdem_hand_player_combinations is only populated when there is a flop.
-
WhiteRider
- Moderator
-
- Posts: 54025
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
by pasita » Sun Feb 13, 2011 6:19 pm
First I thought of that too, but I had less flops seen than the 1515 number and I got confused... but yeah makes sense now, any flop is good whether I saw it or not. Thanks.
-
pasita
-
- Posts: 605
- Joined: Tue May 06, 2008 4:05 pm
by WhiteRider » Mon Feb 14, 2011 4:50 am
Yes, that's right - the combinations table is populated whenever there is a flop, regardless of whether you saw it or not.
-
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