Page 1 of 1

is there a way to filter for actions of one player if ...?

PostPosted: Thu Jan 15, 2026 12:15 pm
by ommaha
is there a way to filter for actions of one player if the players after him are structured in a certain way?

f.e. I would like to see how often a player openraises from CO if a player from a certain group (that I can identify myself already by using player_id in () ) is sitting on the button.

So, is there an expression for a player out of a list of player IDs that is not active player sits on the button in this hand? I don´t mind whether I use expression filter or program a stat. The player list contains a few thousand players, though. So, it might be a bit much for creating a statistic I guess


Any help would be very appreciated

Re: is there a way to filter for actions of one player if ..

PostPosted: Fri Jan 16, 2026 7:08 am
by Flag_Hippo
Try this:

Code: Select all
cash_hand_player_statistics.position = 1 AND cash_hand_player_statistics.flg_p_open_opp AND EXISTS (SELECT 1 FROM cash_hand_player_statistics chps WHERE chps.id_hand = cash_hand_player_statistics.id_hand AND chps.position = 0 AND chps.id_player IN (12888, 13627))

Re: is there a way to filter for actions of one player if ..

PostPosted: Fri Jan 16, 2026 8:25 am
by ommaha
that works!! That´s really great. Thank you very much

is there also a way to do a certain stacksize (f.e. 30-50bb) instead of a player from a list of ID´s?

Re: is there a way to filter for actions of one player if ..

PostPosted: Sat Jan 17, 2026 6:26 am
by Flag_Hippo
Code: Select all
cash_hand_player_statistics.position = 1 AND cash_hand_player_statistics.flg_p_open_opp AND EXISTS (SELECT 1 FROM cash_hand_player_statistics chps JOIN cash_limit cl ON chps.id_limit = cl.id_limit WHERE chps.id_hand = cash_hand_player_statistics.id_hand AND chps.position = 0 AND (chps.amt_before / cl.amt_bb) BETWEEN 30 AND 50)