bet turn after check-check on flop when last in mway

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

bet turn after check-check on flop when last in mway

Postby marvin » Tue Oct 13, 2009 6:07 am

after check behind on flop, i wanna count how much the villain will bet to my check:

cnt_bet_noaggr_previous_t
sum(if[ holdem_hand_player_statistics.flg_t_bet and (lookup_actions_f.action = 'X') , 1, 0])
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: bet turn after check-check on flop when last in mway

Postby kraada » Tue Oct 13, 2009 9:03 am

The column you built is a count of how often a player both (a) checked the flop and (b) bet the turn. Can you give me a more specific case and I'll be glad to help you build what you're looking for.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: bet turn after check-check on flop when last in mway

Postby marvin » Tue Oct 13, 2009 9:30 am

no more problem about that, i post it why it seemed strange to me, (too long explain) but i fixed what was wrong, so i correct my post leaving the right column if anyone needed it. you can remove the psot if you want.
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests