tables not matching

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

tables not matching

Postby 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

Re: tables not matching

Postby 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

Re: tables not matching

Postby 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

Re: tables not matching

Postby 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]

Who is online

Users browsing this forum: No registered users and 0 guests