Report vs Villains

[Bill_Balas]

Hi,

would you please code, if possible, a hands Reports filter where Villains have VPIP < 30 & Stack >= 2/3 full buy-in?

Thanks

[potamito]

Stack >= 2/3 full buy-in?

What you mean by this?

[Bill_Balas]

A Stack of at least 2/3 of the stakes buy-in (usually 100 BBs).

Thanks

[Bill_Balas]

---So at least 63 BBs.

[WhiteRider]

Do you mean all villains, or one villain in the hand meets that criteria?

[Bill_Balas]

I mean all. I'll then select Villain's name in the "Player:" box.

Thanks

[Bill_Balas]

Hero's name in the "player:" box, I mean. Just happens I'm targeting Villain vs Villain hands.

Thanks

[WhiteRider]

I've been experimenting with this, but unfortunately it's beyond my query skills at the moment - hopefully one of our PostgreSQL experts will be able to help you.

[Bill_Balas]

Thanks for your effort anyway WhiteRider!

[potamito]

It takes a while to populate but it works for me...

Code: Select all

cash_hand_player_statistics.id_hand in (SELECT thps.id_hand from cash_hand_player_statistics thps, cash_cache tc where thps.id_player = tc.id_player group by thps.id_hand, thps.id_player HAVING ((((sum(tc.cnt_vpip) / (sum(tc.cnt_hands) - sum(tc.cnt_walks)))) BETWEEN 0.15 and 0.25))) and #Chips in BBs#>= 63