PDA

View Full Version : Calculation VPIP using the _month tables



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!