Filter my stats against one specific villain

[Link23]

Hey,

I play Heads Up cashgame. I want to show my stats vs one specific villain over a period of time/hands. How can I do that?

Best regards,
Link.

[WhiteRider]

Check out this post which explains how to do that.

[Link23]

Thank you for your reply but I play Cashgames and not tourneys. If I change "Villain" to my preferred villain I want to filter, I can´t see any hands displayed.

[kraada]

Change the two instances of "tourney" to "cash" and it will work for cash games then.

[Link23]

I´ve done that. I still don´t get a report.

( 0 < (SELECT count(hhps2.id_hand) FROM cash_hand_player_statistics hhps2 WHERE hhps2.id_hand = cash_hand_player_statistics.id_hand AND hhps2.id_player = (SELECT p.id_player FROM player p WHERE player_name='villain')) )

I changed the bolt part into villains ID.

[kraada]

Try this instead:

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p WHERE chps.id_player = p.id_player and p.player_name='villain')