statistics.cnt_players and summary.cnt_players

[ibyoar]

Thanks for your help,
in PT3 cnt_players give 2 differents stats(players dealt and players in the hand)
i have created 2 queries in pt4 using both and the result is the same. maybe in pt4 statistics.cnt_players and summary.cnt_players are the same data?

[kraada]

I'm not sure what you mean - the number of players dealt in are the number of players who are in the hand. Could you give me an example hand of when these would differ?

[ibyoar]

the numbers of players dealt in the hand is supposed to be initial numbers of players in the table, players in the hand is supposed to be reamining players in the hand.
for example: 4 players in a table-->4 players dealt, player 1 folds-->3 players in the hand

Extract from PT3 Database schema:
Table Statistics-->cnt_players small integer The number of players in the hand.
Table summary-->cnt_players small integer The number of players who were dealt into the hand.

[kraada]

As far as I'm aware those should both be the number of players dealt in - cnt_players_f, cnt_players_t and cnt_players_r (in the hand_summary table) are the number of players who saw those streets and those would differ from cnt_players as obviously people don't all make it to the various postflop streets.

[ibyoar]

ok, so both are the same data...is there any way to obtain the number of players who remain active preflop in certain moment?
lets suppose i want to know % of times a player pushes preflop when there are 3 players active in the hand and 6 players were dealt(3 have folded)

summary.cnt_players =6 AND statistics.flg_p_open AND (statistics.amt_before = statistics.amt_bet_p) AND???

[kraada]

Well, if you want open shoves without limpers you can just check position - as long as position is between 1 and 7 you're good (BB = 9, SB = 8, BTN = 0). If you allow limps or 3betting/4betting it gets quite a bit more complicated . . .

[js2002]

Is there still a difference in PT4 between:

cash_hand_player_statistics.cnt_players = 4
cash_hand_summary.cnt_players = 4

I dont see one in my DB

[kraada]

No, there isn't. The data is stored in both places as it allows us to optimize some queries.