Custom Query Help

[stillnaive]

First of all, I want to say that you guys have done a great job creating what is, in my mind, the strongest product on the market. I'm thoroughly enjoying beta testing PT3 for you, and it's already become my #1 tracking program.

With that being said, I'm very interested in creating some custom queries against the PT3 database. One I've been particularly interested in is % of the time villain overbets the pot; being that I'm a uNL player, it could be a decent indicator of which players I should isolate preflop. What would the SQL query look like for that sort of a stat?

Thanks for your help!

[Josh]

Unfortunately, I don't have time right now to write all the details, but the information you want is stored in the holdem_hand_player_details table (the amt_p_raise_made and amt_p_raise_made_pct). You can find more details in our documentation (the custom stats docs, as well as the database schema docs). Give it a shot and if you still need some help, let us know.

[stillnaive]

thanks man, i'll give it a shot. never tried coding sql queries before, but now's as good a time as any :)