Expression filter for opponent holecards in HU sngs?

[erdnase17]

I would like to make an expression filter for hand report where I could filter for the opponent holecards but I can't figure the appropriate SQL expression for this.
When I make the hand report for hero and use id_holecard it refers to hero's holecards obviously, how can I refer to the opponent's holecards?

Thanks.

[kraada]

This should do it, but this will cause the report to take considerably longer to run than a normal report:

tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps where not(thps.flg_hero) and thps.id_holecard = X)