I'm trying to write a query that determines the potential villains involved in a hand. A potential villain would be anyone who:
- enters a hand before hero (i.e. VPIPs) or
- is left to act after hero enters hand.
I know I can get the villains' player_ids for a hand using the playervsplayer table, but this won't tell me anything about their positions or actions in the hand. Am I going to have to manually extract this information by looking at each villain's hand in the playerhandscashkeycolumns table or is there an easier way to do this?