Hi,
I would like to create a Hand Report but only with players I played 300 hands against.
Is this possible?
NOTE: I don't mean ALL PLAYERS REPORT, I mean specifically Hand Report in which I will only have 300 hands in the HUD.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
player.id_player in (SELECT p.id_player from player p, tourney_cache tc where p.id_player = tc.id_player group by p.id_player HAVING (( CASE WHEN (sum(tc.cnt_hands)) <> 0 THEN (sum(tc.cnt_hands)) ELSE 0 END > 300)))
tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, tourney_cache tc where thps.id_player = tc.id_player group by thps.id_hand, thps.id_player having ((((sum(tc.cnt_hands))) between 300 and Y)))
HYPERION666 wrote:I would like to know the same expression for cash if possible thk
Flag_Hippo wrote:...you will need to replace "tourney" with "cash" if you are in a cash report.
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 32 guests