mathrawka
08-28-2010, 09:00 PM
Hello,
I tried to calculate the VPIP using the _month tables with a query like this:
select sum(totalhands), sum(vpiphands) from compiledplayerresults_month cpr join compiledresults_month cr ON (cr.compiledplayerresults_id = cpr.compiledplayerresults_id) where cr.player_id = 1;
But the totalhands in this table includes hands where it folded to the player when he was in the BB. I know you can filter that out by using the playerhandscashkeycolumns, but I want to use the compiledplayerresults_month table as it is much faster.
So... how can I do this? :confused:
Thanks!
I tried to calculate the VPIP using the _month tables with a query like this:
select sum(totalhands), sum(vpiphands) from compiledplayerresults_month cpr join compiledresults_month cr ON (cr.compiledplayerresults_id = cpr.compiledplayerresults_id) where cr.player_id = 1;
But the totalhands in this table includes hands where it folded to the player when he was in the BB. I know you can filter that out by using the playerhandscashkeycolumns, but I want to use the compiledplayerresults_month table as it is much faster.
So... how can I do this? :confused:
Thanks!