Let's say I have a definition of fish, say VPIP > 40.
I want to filter those hands which contain exactly 1 fish (or 2 fish, or 3 fish etc.).
Can I do this?
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
cash_hand_player_statistics.id_hand in (select chps.id_hand from cash_hand_player_statistics chps where chps.id_player in (select cc.id_player from cash_cache cc where true group by cc.id_player having ((sum(cc.cnt_vpip) * 1.0) / (sum(cc.cnt_hands) * 1.0) - sum(cc.cnt_walks) * 1.0) > .5))
cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p, notes n where p.id_player = chps.id_player and n.id_x = p.id_player and n.enum_type = 'P' and n.id_color = 2)
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 19 guests