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 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
by 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
by 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]
Users browsing this forum: No registered users and 0 guests