How to: check how many active players are still playing?

[warrior04]

i'm having some problem writing an SQL statement...

I wanna write a query that check how many players are still in the game when it's the Hero's turn. (let's say on Pre-flop)

the general idea would be something like...
(number of players that where dealt a hand) - (sum of players that fold until Hero)

[kraada]

That's not going to be possible in a way that would work as a custom statistic due to the way that PT3 stores data on the hand.

You can see how many players reached each street though using holdem_hand_summary.cnt_players_f (and _t and _r).

[warrior04]

i don't wanna built it as custom statistic i'm using PostgreSQL Query tool directly...

[kraada]

I think that should be doable though I'd need to give it some thought in order to come up with it.

[i3bet4fun]

Hi is there a stat that will show how many players were dealt into a current hand for tourneys?

Thanks.

[WhiteRider]

No - PT3 does not have any information about the current hand. All information is read from the hand history which is written when the hand completes.