I am not sure where to post this so I figured here was as good as any as what I am trying to do is directly related to altering playing strategy. I'll go ahead and ask my question and then I'll explain what I am doing and then I would love to head what others think (and if they can help). 

Question: Does anyone know how to write Pokertracker queries, specifically can you write two statistical catagories that show VP$IP and PFR sorted by hands involving the hero.

Reasoning Behind the Inquiry: After reading through the multitude of hand histories and beats as well as seeing and experiencing my own I started to wonder if the generalized statistics that HM and PT accumulate may be insufficient for the conclusions we are trying to draw. Taking that and thinking about things a little more I started to stumble onto what I think is the more relevant information, statistics about what players hand playing tendencies are versus the hero.

Hypothesis #1: People (and poker players) are in general creatures of habit.

Hypothesis #2: Players tend to play other players (over cards and boards) after the first couple of encounters.

So the first hypothesis isn't too much of a stretch, it is what all of the statistical collection is based on, that over a large enough sample you will be able to extract trend information about what to expect in general. The second hypothesis is a little more of a leap, but I don't think it is unreasonable. After we (the hero) run into a particular villain several times (I am not sure what this is yet for statistical convergence so I will start with 30 as the base and have to explore this figure further) the confrontations tend to become less about the cards and all about playing the situations/player. This is the specific information I am trying to extract as the long run statistical information is interesting for getting an idea about what people will tend to do when they play in general, but what is much more interesting is what is the range a player is willing to play over time against us as we build history. I am convinced that within this information we will be able to extract much more interesting information about potential holdings, whether or not players tend to be just plain aggro against us, or they are meek. 

I am interested to explore if this information and I think it will aid us in making better plays and avoiding potentially nasty beats because we can gain better insight into how players play us (i.e. a guy may run 35/20 in general, but may only run 9/9 against us, leading us to be more cautious when playing pots with them vs. the players who play 20/15 in general vs 40/5 against us.). I am not sure what they statistics will look like, and i am not sure I will see players enough to glean the information I am looking for, but I think it could be potentially insightful. 

I am interested to hear what people think about the idea and if anyone knows how to do this (I will be working on trying to figure it out and will post if i do solve it).

Lespaulgman