Report vs Villains

[Bill_Balas]

Yes, it's taking me a while to populate too. Thank you potamino!

[WhiteRider]

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

Does this include only hands where all villains match the criteria as requested? I think it finds hands where any villain matches?

[Bill_Balas]

Hi White Rider,

I left my query running for 3 or 4 hours & it didn't finish, although I had further narrowing filters, so I can't answer you.
Being my objective to save time in going through some unwanted hands, once this type of filter seems to add quite some time to the populating process, I'll probably end up with the same length of time spent. Ence, I won't proceed in using it.

Thank you both potamino & WhiteRider anyway, for your time & effort.