Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.
Moderator: Moderators
by pccarballo » Mon May 17, 2010 9:00 pm
Hi
I want to know the % a player sees faces a 3bet and with no money put voluntarily into the put he calls. Ive tried with "facing a 3bet" and cold called but does not work...
-
pccarballo
-
- Posts: 360
- Joined: Wed Mar 05, 2008 6:33 pm
- Location: Spain
by kraada » Tue May 18, 2010 9:03 am
That should work - keep in mind though that you cannot cold call from a blind as the blinds already have money in the pot and thus cannot call cold.
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by pccarballo » Tue May 18, 2010 1:52 pm
well. The facing a 3bet and cold called shows me hands like: UTG raises, I cold called a player 3bets and I call again.
I would also like to include the hands where im on the blinds and the action arrives with a 3bet and I call (just the hands where I did not put money voluntarily in the pot and i face a 3bet)
-
pccarballo
-
- Posts: 360
- Joined: Wed Mar 05, 2008 6:33 pm
- Location: Spain
by kraada » Tue May 18, 2010 2:18 pm
Good point. You can add holdem_hand_player_statistics.enum_p_3bet_action = 'C' which specifies that you call the 3bet. If you want to restrict to hands you only called once preflop if you add in lookup_actions_p.action = 'C' then you can actually do that instead and then you can't have faced more than one raise.
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 0 guests