Need some help with making a custom stat.

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

Need some help with making a custom stat.

Postby JackHighFTW » Wed Dec 01, 2010 11:10 am

Can someone help me make the following stats. I looked into making these stats myself but it's going way over my head (all these database schema things :oops: ).
These stats would help me know how light or tight someone is pushing/calling in a tournament and adjust my calling pushing/calling range.

% of showdowns won after calling an all in preflop from BB (independent of raiser position)
% of showdowns won after calling an all in preflop from SB (independent of raiser position)
% of showdowns won after calling an all in preflop from BU (independent of raiser position)
% of showdowns won after calling an all in preflop from CO (independent of raiser position)
% of showdowns won after calling an all in preflop from MP (independent of raiser position)
% of showdowns won after calling an all in preflop from EP (independent of raiser position)
% of showdowns won after raising all in preflop from BB
% of showdowns won after raising all in preflop from SB
% of showdowns won after raising all in preflop from BU
% of showdowns won after raising all in preflop from CO
% of showdowns won after raising all in preflop from MP
% of showdowns won after raising all in preflop from EP

Thanks a bunch.

PS - It would be even more awesome if the actions could be further classified by stack size like 1-5bb, 5-10bb, 10-15bb etc.
JackHighFTW
 
Posts: 11
Joined: Wed Dec 01, 2010 10:25 am

Re: Need some help with making a custom stat.

Postby kraada » Wed Dec 01, 2010 11:14 am

Are these only for 6 max tournaments?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Need some help with making a custom stat.

Postby JackHighFTW » Wed Dec 01, 2010 12:00 pm

kraada wrote:Are these only for 6 max tournaments?


Actually no, they are for only 9 max tournaments, MP including MP1 and MP2 and EP including UTG and UTG+1. I should have mentioned that, my bad.

Cheers
JackHighFTW
 
Posts: 11
Joined: Wed Dec 01, 2010 10:25 am

Re: Need some help with making a custom stat.

Postby kraada » Wed Dec 01, 2010 12:46 pm

How do you want it to work as the tables get shorter?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Need some help with making a custom stat.

Postby JackHighFTW » Wed Dec 01, 2010 8:54 pm

For 9 max
EP = UTG UTG+1
MP = MP1,MP2,HJ
CO
BU
SB
BB

For 8
EP = UTG UTG+1
MP = MP1,MP2
CO
BU
SB
BB

For 7
EP = UTG
MP = MP1,MP2
CO
BU
SB
BB

For 6
EP = UTG
MP = MP1
CO
BU
SB
BB

For 5
EP = Not available
MP
CO
BU
SB
BB

For 4
EP = Not available
MP = Not available
CO
BU
SB
BB

For 3
EP = Not available
MP = Not available
CO = Not available
BU
SB
BB

For 2
EP = Not available
MP = Not available
CO = Not available
BU = Not available
SB
BB

I am sorry if I am making this bigger/more complicated than necessary, kinda new with the whole HUD thing.
JackHighFTW
 
Posts: 11
Joined: Wed Dec 01, 2010 10:25 am

Re: Need some help with making a custom stat.

Postby kraada » Thu Dec 02, 2010 10:28 am

What I'm going to do is give you the pieces you need and show you how to put them together. This will require making a whole lot of custom columns and custom stats, and it will be tedious. Unfortunately there is no other way.

Based on your definitions here is EP:

(((tourney_holdem_hand_player_statistics.position = 5 OR tourney_holdem_hand_player_statistics.position = 6) AND tourney_holdem_hand_summary.cnt_players = 9) OR ((tourney_holdem_hand_player_statistics.position = 4 OR tourney_holdem_hand_player_statistics.position = 5) AND tourney_holdem_hand_summary.cnt_players BETWEEN 7 AND 8) OR (tourney_holdem_hand_player_statistics.position = 3 AND tourney_holdem_hand_summary.cnt_players = 6))

Here is MP:

(NOT(((tourney_holdem_hand_player_statistics.position = 5 OR tourney_holdem_hand_player_statistics.position = 6) AND tourney_holdem_hand_summary.cnt_players = 9) OR ((tourney_holdem_hand_player_statistics.position = 4 OR tourney_holdem_hand_player_statistics.position = 5) AND tourney_holdem_hand_summary.cnt_players BETWEEN 7 AND 8) OR (tourney_holdem_hand_player_statistics.position = 3 AND tourney_holdem_hand_summary.cnt_players = 6)) AND tourney_holdem_hand_player_statistics.position > 1)

CO is: (tourney_holdem_hand_player_statistics.position = 1)
BTN is: (tourney_holdem_hand_player_statistics.position = 0)
SB is: (tourney_holdem_hand_player_statistics.position = 9)
BB is: (tourney_holdem_hand_player_statistics.position = 8)

That's one piece. You're going to combine each one with 4 different other pieces.

First for % showdowns won after calling an all-in preflop. You have two pieces here the # of times you called an all in preflop and got to showdown and won, and the # of times you called an all in preflop and went to showdown. Putting the former over the latter and multiplying by 100 will give you your percentage.

% showdowns won after calling an all-in preflop: (tourney_holdem_hand_player_statistics.enum_face_allin_action = 'C' AND lookup_actions_f.action = '' AND tourney_holdem_hand_player_statistics.flg_f_saw AND tourney_holdem_hand_player_statistics.flg_won_hand)

We called an all in, made no flop action but did see the flop (hence were all in pre-flop) and won the hand.

% showdowns seen after calling an all-in preflop: (tourney_holdem_hand_player_statistics.enum_face_allin_action = 'C' AND lookup_actions_f.action = '' AND tourney_holdem_hand_player_statistics.flg_f_saw AND tourney_holdem_hand_player_statistics.flg_showdown)

Same, just instead of winning the hand, we saw showdown.

% of showdowns won after raising all in preflop: (tourney_holdem_hand_player_statistics.enum_allin = 'P' and tourney_holdem_hand_player_statistics.flg_showdown and tourney_holdem_hand_player_statistics.flg_won_hand)

and

% of showdowns seen after raising all in preflop: (tourney_holdem_hand_player_statistics.enum_allin = 'P' and tourney_holdem_hand_player_statistics.flg_showdown)

Now for each one of those you combine it with one of the pieces above in the following way in a new column:
sum(if[position_piece AND stat_piece, 1, 0])

where position_piece is the position you care about and the stat_piece is the bit of stat you care about. For more on creating custom statistics please see the Tutorial: Using Custom Statistics and Reports.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Need some help with making a custom stat.

Postby JackHighFTW » Thu Dec 02, 2010 11:12 am

Thanks so much for taking the time to reply and helping me to make the stats. (Which I haven't yet made at the time of this post, however i'm sure i will be thanks to you)
JackHighFTW
 
Posts: 11
Joined: Wed Dec 01, 2010 10:25 am

Re: Need some help with making a custom stat.

Postby kraada » Thu Dec 02, 2010 11:18 am

No problem - we'd also be happy to host the results in the repository when they're ready.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Need some help with making a custom stat.

Postby JackHighFTW » Thu Dec 02, 2010 1:35 pm

Well my first attempt kinda failed.

Here is what I did.

I made columns for each position like EP MP CO etc.

Then I made columns called AIPFCallTotal and AIPFCallwin and made a statistic called AIPFCallWin% by (AIPFCallWin / AIPFCallTotal) * 100

And then I used sum if to close the position piece (EP,MP etc) and stat piece (AIPFCallWin%) and PT3 declared it invalid.

I know I goofed up, can you tell me where ?

Thanks
JackHighFTW
 
Posts: 11
Joined: Wed Dec 01, 2010 10:25 am

Re: Need some help with making a custom stat.

Postby JackHighFTW » Thu Dec 02, 2010 1:42 pm

Looks like I screwed something else up as well, last import caused this error in PT3.

There were errors during the housekeeping process:
Unable to execute query: CREATE TABLE holdem_cache (id_player integer NOT NULL, id_limit integer NOT NULL, cnt_players integer NOT NULL, position_type integer, amt_bb_won numeric(11,2), amt_blind numeric(11,2), amt_mgr numeric(11,2), amt_rake numeric(11,2), amt_won numeric(11,2), amt_won_curr_conv numeric(11,2), amt_won_curr_raw numeric(11,2), cnt_bb integer, cnt_bb_steal_call integer, cnt_bb_steal_fold integer, cnt_bb_steal_raise integer, cnt_blind integer, cnt_f_3bet integer, cnt_f_3bet_def_action_call integer, cnt_f_3bet_def_action_fold integer, cnt_f_3bet_def_action_raise integer, cnt_f_3bet_def_opp integer, cnt_f_3bet_opp integer, cnt_f_4bet integer, cnt_f_4bet_def_action_call integer, cnt_f_4bet_def_action_fold integer, cnt_f_4bet_def_action_raise integer, cnt_f_4bet_def_opp integer, cnt_f_4bet_opp integer, cnt_f_bet integer, cnt_f_bet_def_action_call integer, cnt_f_bet_def_action_fold integer, cnt_f_bet_def_action_raise integer, cnt_f_bet_def_opp integer, cnt_f_bet_raise_hands integer, cnt_f_call integer, cnt_f_call_hands integer, cnt_f_cbet integer, cnt_f_cbet_def_action_call integer, cnt_f_cbet_def_action_call_in_pos integer, cnt_f_cbet_def_action_call_out_of_pos integer, cnt_f_cbet_def_action_fold integer, cnt_f_cbet_def_action_fold_in_pos integer, cnt_f_cbet_def_action_fold_out_of_pos integer, cnt_f_cbet_def_action_raise integer, cnt_f_cbet_def_action_raise_in_pos integer, cnt_f_cbet_def_action_raise_out_of_pos integer, cnt_f_cbet_def_opp integer, cnt_f_cbet_face_raise integer, cnt_f_cbet_fold_to_raise integer, cnt_f_cbet_opp integer, cnt_f_cbet_success integer, cnt_f_check integer, cnt_f_check_raise integer, cnt_f_check_raise_opp integer, cnt_f_donk integer, cnt_f_donk_def_opp integer, cnt_f_donk_def_opp_action_call integer, cnt_f_donk_def_opp_action_fold integer, cnt_f_donk_def_opp_action_raise integer, cnt_f_donk_opp integer, cnt_f_face_xr integer, cnt_f_face_xr_call integer, cnt_f_face_xr_fold integer, cnt_f_face_xr_raise integer, cnt_f_float integer, cnt_f_float_def_opp integer, cnt_f_float_def_opp_action_call integer, cnt_f_float_def_opp_action_fold integer, cnt_f_float_def_opp_action_raise integer, cnt_f_float_opp integer, cnt_f_fold integer, cnt_f_raise integer, cnt_f_raise_def_action_call integer, cnt_f_raise_def_action_fold integer, cnt_f_raise_def_opp integer, cnt_f_saw integer, cnt_f_saw_won integer, cnt_f_total_actions integer, cnt_first_limp integer, cnt_fold_when_f_bet_raise integer, cnt_fold_when_f_call integer, cnt_fold_when_p_bet_raise integer, cnt_fold_when_p_call integer, cnt_fold_when_r_bet_raise integer, cnt_fold_when_r_call integer, cnt_fold_when_t_bet_raise integer, cnt_fold_when_t_call integer, cnt_hands integer, cnt_hands_raked integer, cnt_hands_with_flop integer, cnt_hands_won integer, cnt_p_3b_face_4b integer, cnt_p_3bet integer, cnt_p_3bet_def_action_call integer, cnt_p_3bet_def_action_fold integer, cnt_p_3bet_def_action_fold_when_open_raised integer, cnt_p_3bet_def_action_raise integer, cnt_p_3bet_def_opp integer, cnt_p_3bet_def_opp_when_open_raised integer, cnt_p_3bet_f_cbet_def_action_call integer, cnt_p_3bet_f_cbet_def_action_fold integer, cnt_p_3bet_f_cbet_def_action_raise integer, cnt_p_3bet_f_cbet_def_opp integer, cnt_p_3bet_fold integer, cnt_p_3bet_opp integer, cnt_p_4bet integer, cnt_p_4bet_def_action_call integer, cnt_p_4bet_def_action_fold integer, cnt_p_4bet_def_action_raise integer, cnt_p_4bet_def_opp integer, cnt_p_4bet_opp integer, cnt_p_bb_fold_to_sb integer, cnt_p_bb_fold_to_sb_opp integer, cnt_p_bb_v_sb_steal_call integer, cnt_p_bb_v_sb_steal_fold integer, cnt_p_bb_v_sb_steal_raise integer, cnt_p_bet_raise_hands integer, cnt_p_call integer, cnt_p_call_hands integer, cnt_p_ccall integer, cnt_p_ccall_opp integer, cnt_p_check integer, cnt_p_face_raise integer, cnt_p_facing_limpers integer, cnt_p_first_raise integer, cnt_p_fold integer, cnt_p_limp integer, cnt_p_limp_after_limpers_opp integer, cnt_p_limp_call integer, cnt_p_limp_faceraise integer, cnt_p_limp_fold integer, cnt_p_limp_opp integer, cnt_p_limp_raise integer, cnt_p_open_opp integer, cnt_p_pfr_call integer, cnt_p_pfr_call_opp integer, cnt_p_raise integer, cnt_p_raise_first_in integer, cnt_p_raise_limpers integer, cnt_p_squeeze integer, cnt_p_squeeze_def_call integer, cnt_p_squeeze_def_fold integer, cnt_p_squeeze_def_opp integer, cnt_p_squeeze_def_raise integer, cnt_p_squeeze_opp integer, cnt_p_total_actions integer, cnt_pfr integer, cnt_pfr_f_bet integer, cnt_pfr_f_call integer, cnt_pfr_f_check integer, cnt_pfr_f_checkraise integer, cnt_pfr_f_fold integer, cnt_pfr_f_none integer, cnt_pfr_f_raise integer, cnt_prev_callers_limp integer, cnt_prev_callers_raise integer, cnt_r_3bet integer, cnt_r_3bet_def_action_call integer, cnt_r_3bet_def_action_fold integer, cnt_r_3bet_def_action_raise integer, cnt_r_3bet_def_opp integer, cnt_r_3bet_opp integer, cnt_r_4bet integer, cnt_r_4bet_def_action_call integer, cnt_r_4bet_def_action_fold integer, cnt_r_4bet_def_action_raise integer, cnt_r_4bet_def_opp integer, cnt_r_4bet_opp integer, cnt_r_bet integer, cnt_r_bet_def_action_call integer, cnt_r_bet_def_action_fold integer, cnt_r_bet_def_action_raise integer, cnt_r_bet_def_opp integer, cnt_r_bet_raise_hands integer, cnt_r_call integer, cnt_r_call_hands integer, cnt_r_cbet integer, cnt_r_cbet_def_action_call integer, cnt_r_cbet_def_action_fold integer, cnt_r_cbet_def_action_raise integer, cnt_r_cbet_def_opp integer, cnt_r_cbet_face_raise integer, cnt_r_cbet_fold_to_raise integer, cnt_r_cbet_opp integer, cnt_r_check integer, cnt_r_check_raise integer, cnt_r_check_raise_opp integer, cnt_r_donk integer, cnt_r_donk_def_action_call integer, cnt_r_donk_def_action_fold integer, cnt_r_donk_def_action_raise integer, cnt_r_donk_def_opp integer, cnt_r_donk_opp integer, cnt_r_face_xr integer, cnt_r_face_xr_call integer, cnt_r_face_xr_fold integer, cnt_r_face_xr_raise integer, cnt_r_float integer, cnt_r_float_def_action_call integer, cnt_r_float_def_action_fold integer, cnt_r_float_def_action_raise integer, cnt_r_float_def_opp integer, cnt_r_float_opp integer, cnt_r_fold integer, cnt_r_probe integer, cnt_r_probe_opp integer, cnt_r_raise integer, cnt_r_raise_def_action_call integer, cnt_r_raise_def_action_fold integer, cnt_r_raise_def_opp integer, cnt_r_raise_wtsd integer, cnt_r_raise_wtsd_won integer, cnt_r_saw integer, cnt_r_total_actions integer, cnt_sb integer, cnt_sb_steal_call integer, cnt_sb_steal_fold integer, cnt_sb_steal_raise integer, cnt_sessions integer, cnt_sessions_won integer, cnt_steal_att integer, cnt_steal_att_btn integer, cnt_steal_att_cutoff integer, cnt_steal_att_fold integer, cnt_steal_att_no_sd integer, cnt_steal_att_sb integer, cnt_steal_att_wtsd integer, cnt_steal_def_opp_bb integer, cnt_steal_def_opp_bb_nosd integer, cnt_steal_def_opp_bb_win_sd integer, cnt_steal_def_opp_bb_win_wo_sd integer, cnt_steal_def_opp_bb_wtsd integer, cnt_steal_def_opp_sb integer, cnt_steal_def_opp_sb_nosd integer, cnt_steal_def_opp_sb_win_sd integer, cnt_steal_def_opp_sb_win_wo_sd integer, cnt_steal_def_opp_sb_wtsd integer, cnt_steal_opp integer, cnt_steal_opp_btn integer, cnt_steal_opp_cutoff integer, cnt_steal_opp_sb integer, cnt_steal_reraise_def_action_fold integer, cnt_steal_reraise_def_opp integer, cnt_steal_success integer, cnt_steal_win_sd integer, cnt_steal_win_wo_sd integer, cnt_t_3bet integer, cnt_t_3bet_def_action_call integer, cnt_t_3bet_def_action_fold integer, cnt_t_3bet_def_action_raise integer, cnt_t_3bet_def_opp integer, cnt_t_3bet_opp integer, cnt_t_4bet integer, cnt_t_4bet_def_action_call integer, cnt_t_4bet_def_action_fold integer, cnt_t_4bet_def_action_raise integer, cnt_t_4bet_def_opp integer, cnt_t_4bet_opp integer, cnt_t_bet integer, cnt_t_bet_def_action_call integer, cnt_t_bet_def_action_fold integer, cnt_t_bet_def_action_raise integer, cnt_t_bet_def_opp integer, cnt_t_bet_raise_hands integer, cnt_t_call integer, cnt_t_call_hands integer, cnt_t_cbet integer, cnt_t_cbet_def_action_call integer, cnt_t_cbet_def_action_fold integer, cnt_t_cbet_def_action_raise integer, cnt_t_cbet_def_opp integer, cnt_t_cbet_face_raise integer, cnt_t_cbet_fold_to_raise integer, cnt_t_cbet_opp integer, cnt_t_check integer, cnt_t_check_raise integer, cnt_t_check_raise_opp integer, cnt_t_donk integer, cnt_t_donk_def_action_call integer, cnt_t_donk_def_action_fold integer, cnt_t_donk_def_action_raise integer, cnt_t_donk_def_opp integer, cnt_t_donk_opp integer, cnt_t_face_xr integer, cnt_t_face_xr_call integer, cnt_t_face_xr_fold integer, cnt_t_face_xr_raise integer, cnt_t_float integer, cnt_t_float_def_action_call integer, cnt_t_float_def_action_fold integer, cnt_t_float_def_action_raise integer, cnt_t_float_def_opp integer, cnt_t_float_opp integer, cnt_t_fold integer, cnt_t_probe integer, cnt_t_probe_opp integer, cnt_t_raise integer, cnt_t_raise_def_action_call integer, cnt_t_raise_def_action_fold integer, cnt_t_raise_def_opp integer, cnt_t_raise_wtsd integer, cnt_t_raise_wtsd_won integer, cnt_t_saw integer, cnt_t_total_actions integer, cnt_total_actions integer, cnt_vpip integer, cnt_vpip_sb integer, cnt_won_hand integer, cnt_won_showdown integer, cnt_wtsd integer, cnt_wtsd_when_f_bet_raise integer, cnt_wtsd_when_f_call integer, cnt_wtsd_when_p_bet_raise integer, cnt_wtsd_when_p_call integer, cnt_wtsd_when_r_bet_raise integer, cnt_wtsd_when_r_call integer, cnt_wtsd_when_t_bet_raise integer, cnt_wtsd_when_t_call integer, cnt_wtsd_won integer, cnt_wtsd_won_when_f_bet_raise integer, cnt_wtsd_won_when_f_call integer, cnt_wtsd_won_when_p_bet_raise integer, cnt_wtsd_won_when_p_call integer, cnt_wtsd_won_when_r_bet_raise integer, cnt_wtsd_won_when_r_call integer, cnt_wtsd_won_when_t_bet_raise integer, cnt_wtsd_won_when_t_call integer, cnt_wwosd_f_bet_raise integer, cnt_wwosd_f_call integer, cnt_wwosd_p_bet_raise integer, cnt_wwosd_p_call integer, cnt_wwosd_r_bet_raise integer, cnt_wwosd_r_call integer, cnt_wwosd_t_bet_raise integer, cnt_wwosd_t_call integer, pfr_4_numerator integer, pfr_5_numerator integer, pfr_6_numerator integer, pfr_7_numerator integer, pfr_bb_numerator integer, pfr_button_numerator integer, pfr_co_numerator integer, pfr_hijack_numerator integer, pfr_sb_numerator integer, pfr_utg_numerator integer, vpip_4_denominator integer, vpip_4_numerator integer, vpip_5_denominator integer, vpip_5_numerator integer, vpip_6_denominator integer, vpip_6_numerator integer, vpip_7_denominator integer, vpip_7_numerator integer, vpip_bb_denominator integer, vpip_bb_numerator integer, vpip_co_numerator integer, vpip_hijack_denominator integer, vpip_hijack_numerator integer, vpip_sb_denominator integer, vpip_sb_numerator integer, vpip_utg_denominator integer, vpip_utg_numerator integer, vpip_button_denominator integer, vpip_button_numerator integer, vpip_from_co_demoninator integer, amt_total_avg_f_bet numeric(11,2), amt_total_avg_r_bet numeric(11,2), amt_total_avg_t_bet numeric(11,2), amt_won_no_sd numeric(11,2), cnt_bb_steal_call_vs_bu integer, cnt_bb_steal_call_vs_co integer, cnt_bb_steal_call_vs_sb integer, cnt_ccpf_4 integer, cnt_ccpf_4_opp integer, cnt_ccpf_5 integer, cnt_ccpf_5_opp integer, cnt_ccpf_6 integer, cnt_ccpf_6_opp integer, cnt_ccpf_btn integer, cnt_ccpf_btn_opp integer, cnt_ccpf_co integer, cnt_ccpf_co_opp integer, cnt_ccpf_hj integer, cnt_ccpf_hj_opp integer, cnt_ccpf_utg integer, cnt_ccpf_utg_opp integer, cnt_db_ep_mp integer, cnt_f_allin integer, cnt_f_bet_def_action_call2 integer, cnt_f_bet_def_action_fold2 integer, cnt_f_bet_def_action_raise2 integer, cnt_f_bet_wtsd integer, cnt_f_bet_wtsd_won integer, cnt_f_cbet_ip integer, cnt_f_cbet_oop integer, cnt_f_cbet_opp_ip integer, cnt_f_cbet_opp_oop integer, cnt_f_cbet_wtsd integer, cnt_f_cbet_wtsd_won integer, cnt_f_cbetraise_def_action_call integer, cnt_f_cbetraise_def_action_fold integer, cnt_f_cbetraise_def_opp integer, cnt_f_check_raise_wtsd integer, cnt_f_check_raise_wtsd_won integer, cnt_f_donk_bet_t integer, cnt_f_donk_bet_t_def_opp integer, cnt_f_donk_bet_t_def_opp_action_fold integer, cnt_f_donk_bet_t_opp integer, cnt_f_donk_custom integer, cnt_f_donk_fold integer, cnt_f_donk_fold_opp integer, cnt_f_donk_opp_custom integer, cnt_f_face_allin integer, cnt_f_face_allin_call integer, cnt_f_face_allin_fold integer, cnt_f_face_allin_raise integer, cnt_f_face_minraise integer, cnt_f_face_minraise_call integer, cnt_f_face_minraise_fold integer, cnt_f_face_minraise_raise integer, cnt_f_minraise integer, cnt_f_probe_bet_raised_pot integer, cnt_f_probe_bet_raised_pot_def_opp integer, cnt_f_probe_bet_raised_pot_def_opp_action_fold integer, cnt_f_probe_bet_raised_pot_opp integer, cnt_f_raise_wtsd integer, cnt_f_raise_wtsd_won integer, cnt_f_saw_blinds integer, cnt_f_saw_ep integer, cnt_f_saw_lp integer, cnt_f_saw_mp integer, cnt_f_saw_wo_ur integer, cnt_f_saw_won_wo_ur integer, cnt_hands_blinds integer, cnt_hands_custom integer, cnt_hands_ep integer, cnt_hands_lp integer, cnt_hands_mp integer, cnt_limp_face_raise integer, cnt_limp_fold integer, cnt_p_3bet_4 integer, cnt_p_3bet_5 integer, cnt_p_3bet_6 integer, cnt_p_3bet_7 integer, cnt_p_3bet_bb integer, cnt_p_3bet_bu integer, cnt_p_3bet_co integer, cnt_p_3bet_hj integer, cnt_p_3bet_sb integer, cnt_p_3bet_utg integer, cnt_p_3bet_blinds integer, cnt_p_3bet_def_action_fold_when_open_raised_blinds integer, cnt_p_3bet_def_action_fold_when_open_raised_ep integer, cnt_p_3bet_def_action_fold_when_open_raised_lp integer, cnt_p_3bet_def_action_fold_when_open_raised_mp integer, cnt_p_3bet_def_opp_when_open_raised_blinds integer, cnt_p_3bet_def_opp_when_open_raised_ep integer, cnt_p_3bet_def_opp_when_open_raised_lp integer, cnt_p_3bet_def_opp_when_open_raised_mp integer, cnt_p_3bet_ep integer, cnt_p_3bet_f_cbet integer, cnt_p_3bet_f_cbet_def_opp_custom integer, cnt_p_3bet_f_cbet_opp integer, cnt_p_3bet_fold_blinds integer, cnt_p_3bet_fold_ep integer, cnt_p_3bet_fold_lp integer, cnt_p_3bet_fold_mp integer, cnt_p_3bet_lp integer, cnt_p_3bet_mp integer, cnt_p_3bet_nvs_bs integer, cnt_p_3bet_opp_4 integer, cnt_p_3bet_opp_5 integer, cnt_p_3bet_opp_6 integer, cnt_p_3bet_opp_7 integer, cnt_p_3bet_opp_bb integer, cnt_p_3bet_opp_bu integer, cnt_p_3bet_opp_co integer, cnt_p_3bet_opp_hj integer, cnt_p_3bet_opp_sb integer, cnt_p_3bet_opp_utg integer, cnt_p_3bet_opp_blinds integer, cnt_p_3bet_opp_ep integer, cnt_p_3bet_opp_lp integer, cnt_p_3bet_opp_mp integer, cnt_p_3bet_opp_nvs_bs integer, cnt_p_3bet_opp_when_not_faced_steal integer, cnt_p_3bet_opp_when_faced_steal integer, cnt_p_3bet_t_cbet integer, cnt_p_3bet_t_cbet_def_action_fold integer, cnt_p_3bet_t_cbet_def_opp integer, cnt_p_3bet_t_cbet_opp integer, cnt_p_3bet_when_not_faced_steal integer, cnt_p_3bet_when_faced_steal integer, cnt_p_4bet_blinds integer, cnt_p_4bet_ep integer, cnt_p_4bet_lp integer, cnt_p_4bet_mp integer, cnt_p_4bet_opp_blinds integer, cnt_p_4bet_opp_ep integer, cnt_p_4bet_opp_lp integer, cnt_p_4bet_opp_mp integer, cnt_p_facing_limpers_4 integer, cnt_p_facing_limpers_5 integer, cnt_p_facing_limpers_6 integer, cnt_p_facing_limpers_7 integer, cnt_p_facing_limpers_bb integer, cnt_p_facing_limpers_bu integer, cnt_p_facing_limpers_co integer, cnt_p_facing_limpers_hj integer, cnt_p_facing_limpers_sb integer, cnt_p_facing_limpers_utg integer, cnt_p_facing_limpers_debug integer, cnt_p_limp_call_f_face_cbet integer, cnt_p_limp_call_f_face_cbet_def_action_fold integer, cnt_p_limp_faceraise_blinds integer, cnt_p_limp_faceraise_ep integer, cnt_p_limp_faceraise_lp integer, cnt_p_limp_faceraise_mp integer, cnt_p_limp_raise_blinds integer, cnt_p_limp_raise_ep integer, cnt_p_limp_raise_lp integer, cnt_p_limp_raise_mp integer, cnt_p_limp_success integer, cnt_p_open_opp_4 integer, cnt_p_open_opp_5 integer, cnt_p_open_opp_6 integer, cnt_p_open_opp_7 integer, cnt_p_open_opp_bb integer, cnt_p_open_opp_bu integer, cnt_p_open_opp_co integer, cnt_p_open_opp_hj integer, cnt_p_open_opp_sb integer, cnt_p_open_opp_utg integer, cnt_p_pfr_call_4 integer, cnt_p_pfr_call_5 integer, cnt_p_pfr_call_6 integer, cnt_p_pfr_call_7 integer, cnt_p_pfr_call_bb integer, cnt_p_pfr_call_bu integer, cnt_p_pfr_call_co integer, cnt_p_pfr_call_mp integer, cnt_p_pfr_call_sb integer, cnt_p_pfr_call_utg integer, cnt_p_pfr_call_blinds integer, cnt_p_pfr_call_ep integer, cnt_p_pfr_call_lp integer, cnt_p_pfr_call_mp integer, cnt_p_pfr_call_opp_4 integer, cnt_p_pfr_call_opp_5 integer, cnt_p_pfr_call_opp_6 integer, cnt_p_pfr_call_opp_7 integer, cnt_p_pfr_call_opp_bb integer, cnt_p_pfr_call_opp_bu integer, cnt_p_pfr_call_opp_co integer, cnt_p_pfr_call_opp_mp integer, cnt_p_pfr_call_opp_sb integer, cnt_p_pfr_call_opp_utg integer, cnt_p_pfr_call_opp_blinds integer, cnt_p_pfr_call_opp_ep integer, cnt_p_pfr_call_opp_lp integer, cnt_p_pfr_call_opp_mp integer, cnt_p_raise_first_in_4 integer, cnt_p_raise_first_in_5 integer, cnt_p_raise_first_in_6 integer, cnt_p_raise_first_in_7 integer, cnt_p_raise_first_in_bb integer, cnt_p_raise_first_in_bu integer, cnt_p_raise_first_in_co integer, cnt_p_raise_first_in_hj integer, cnt_p_raise_first_in_sb integer, cnt_p_raise_first_in_utg integer, cnt_p_raise_limpers_4 integer, cnt_p_raise_limpers_5 integer, cnt_p_raise_limpers_6 integer, cnt_p_raise_limpers_7 integer, cnt_p_raise_limpers_bb integer, cnt_p_raise_limpers_bu integer, cnt_p_raise_limpers_co integer, cnt_p_raise_limpers_hj integer, cnt_p_raise_limpers_sb integer, cnt_p_raise_limpers_utg integer, cnt_pfr_blinds integer, cnt_pfr_ep integer, cnt_pfr_lp integer, cnt_pfr_mp integer, cnt_r_allin integer, cnt_r_bet_def_action_call2 integer, cnt_r_bet_def_action_fold2 integer, cnt_r_bet_def_action_raise2 integer, cnt_r_bet_wtsd integer, cnt_r_bet_wtsd_won integer, cnt_r_cbet_ip integer, cnt_r_cbet_oop integer, cnt_r_cbet_opp_ip integer, cnt_r_cbet_opp_oop integer, cnt_r_cbet_wtsd integer, cnt_r_cbet_wtsd_won integer, cnt_r_cbetraise_def_action_fold integer, cnt_r_cbetraise_def_opp integer, cnt_r_check_raise_wtsd integer, cnt_r_check_raise_wtsd_won integer, cnt_r_donk_fold integer, cnt_r_donk_fold_opp integer, cnt_r_face_allin integer, cnt_r_face_allin_call integer, cnt_r_face_allin_fold integer, cnt_r_face_allin_raise integer, cnt_r_face_minraise integer, cnt_r_face_minraise_call integer, cnt_r_face_minraise_fold integer, cnt_r_face_minraise_raise integer, cnt_r_minraise integer, cnt_sb_steal_call_vs_bu integer, cnt_sb_steal_call_vs_co integer, cnt_showdown_when_raised integer, cnt_steal_att_bu integer, cnt_steal_att_co integer, cnt_steal_def_opp_bb_vs_bu integer, cnt_steal_def_opp_bb_vs_co integer, cnt_steal_def_opp_bb_vs_sb integer, cnt_steal_def_opp_sb_vs_bu integer, cnt_steal_def_opp_sb_vs_co integer, cnt_steal_opp_bu integer, cnt_steal_opp_co integer, cnt_steal_reraise_def_action_fold_bu integer, cnt_steal_reraise_def_action_fold_co integer, cnt_steal_reraise_def_action_fold_sb integer, cnt_steal_reraise_def_opp_bu integer, cnt_steal_reraise_def_opp_co integer, cnt_steal_reraise_def_opp_sb integer, cnt_steal_unraised_pot integer, cnt_steal_unraised_pot_ip integer, cnt_steal_unraised_pot_ip_players_2 integer, cnt_steal_unraised_pot_opp integer, cnt_steal_unraised_pot_opp_ip integer, cnt_steal_unraised_pot_opp_ip_players_2 integer, cnt_steal_unraised_pot_opp_players_2 integer, cnt_steal_unraised_pot_players_2 integer, cnt_t_allin integer, cnt_t_bet_def_action_call2 integer, cnt_t_bet_def_action_fold2 integer, cnt_t_bet_def_action_raise2 integer, cnt_t_bet_wtsd integer, cnt_t_bet_wtsd_won integer, cnt_t_cbet_ip integer, cnt_t_cbet_oop integer, cnt_t_cbet_opp_ip integer, cnt_t_cbet_opp_oop integer, cnt_t_cbet_wtsd integer, cnt_t_cbet_wtsd_won integer, cnt_t_cbetraise_def_action_fold integer, cnt_t_cbetraise_def_opp integer, cnt_t_check_raise_wtsd integer, cnt_t_check_raise_wtsd_won integer, cnt_t_donk_fold integer, cnt_t_donk_fold_opp integer, cnt_t_face_allin integer, cnt_t_face_allin_call integer, cnt_t_face_allin_fold integer, cnt_t_face_allin_raise integer, cnt_t_face_minraise integer, cnt_t_face_minraise_call integer, cnt_t_face_minraise_fold integer, cnt_t_face_minraise_raise integer, cnt_t_minraise integer, cnt_vpip_blinds integer, cnt_vpip_ep integer, cnt_vpip_lp integer, cnt_vpip_mp integer, cnt_won_when_raised integer, cnt_wtsd_3bp integer, cnt_wtsd_3bp_opp integer, cnt_wtsd_blinds integer, cnt_wtsd_ep integer, cnt_wtsd_lp integer, cnt_wtsd_mp integer, cnt_wtsd_wo_unraised_pots integer, cnt_wtsd_wo_unraised_pots_opp integer, cnt_wtsd_won_3bp integer, cnt_wtsd_won_blinds integer, cnt_wtsd_won_ep integer, cnt_wtsd_won_lp integer, cnt_wtsd_won_mp integer, cnt_wtsd_won_wo_unraised_pots integer, js2002_cnt_f_autobet_hu_ur integer, js2002_cnt_f_autobet_hu_ur_def_action_fold integer, js2002_cnt_f_autobet_hu_ur_def_action_fold_ip integer, js2002_cnt_f_autobet_hu_ur_def_opp integer, js2002_cnt_f_autobet_hu_ur_def_opp_ip integer, js2002_cnt_f_autobet_hu_ur_ip integer, js2002_cnt_f_autobet_hu_ur_opp integer, js2002_cnt_f_autobet_hu_ur_opp_ip integer, js2002_cnt_f_check_call integer, js2002_cnt_f_check_fold integer, js2002_cnt_f_checkbehind_after_call_preflop integer, js2002_cnt_f_checkbehind_after_call_preflop_opp integer, js2002_cnt_f_checkbehind_after_raise_preflop integer, js2002_cnt_f_checkbehind_after_raise_preflop_opp integer, js2002_cnt_f_probe_bet_3bet_pot integer, js2002_cnt_f_probe_bet_3bet_pot_def_opp integer, js2002_cnt_f_probe_bet_3bet_pot_def_opp_action_fold integer, js2002_cnt_f_probe_bet_3bet_pot_opp integer, js2002_cnt_p_3bet_def_action_4bet integer, js2002_cnt_p_3bet_def_action_fold integer, js2002_cnt_p_3bet_def_action_fold_4 integer, js2002_cnt_p_3bet_def_action_fold_5 integer, js2002_cnt_p_3bet_def_action_fold_6 integer, js2002_cnt_p_3bet_def_action_fold_7 integer, js2002_cnt_p_3bet_def_action_fold_bb integer, js2002_cnt_p_3bet_def_action_fold_bu integer, js2002_cnt_p_3bet_def_action_fold_co integer, js2002_cnt_p_3bet_def_action_fold_hj integer, js2002_cnt_p_3bet_def_action_fold_sb integer, js2002_cnt_p_3bet_def_action_fold_utg integer, js2002_cnt_p_3bet_def_opp integer, js2002_cnt_p_3bet_def_opp_4 integer, js2002_cnt_p_3bet_def_opp_5 integer, js2002_cnt_p_3bet_def_opp_6 integer, js2002_cnt_p_3bet_def_opp_7 integer, js2002_cnt_p_3bet_def_opp_bb integer, js2002_cnt_p_3bet_def_opp_bu integer, js2002_cnt_p_3bet_def_opp_co integer, js2002_cnt_p_3bet_def_opp_hj integer, js2002_cnt_p_3bet_def_opp_sb integer, js2002_cnt_p_3bet_def_opp_utg integer, js2002_cnt_p_3bet_f_cbet_and_allin_def_action_fold integer, js2002_cnt_p_3bet_f_cbet_and_allin_def_opp integer, js2002_cnt_p_3bet_f_cbet_def_action_raisecb integer, js2002_cnt_p_3bet_f_cbet_def_opp integer, js2002_cnt_p_3bet_f_cbet_raise_def_action_fold integer, js2002_cnt_p_3bet_f_cbet_raise_def_opp integer, js2002_cnt_p_4betplus_def_action_fold integer, js2002_cnt_p_4betplus_def_opp integer, js2002_cnt_p_4bet_def_action_fold integer, js2002_cnt_p_4bet_def_action_fold_4 integer, js2002_cnt_p_4bet_def_action_fold_5 integer, js2002_cnt_p_4bet_def_action_fold_6 integer, js2002_cnt_p_4bet_def_action_fold_7 integer, js2002_cnt_p_4bet_def_action_fold_bb integer, js2002_cnt_p_4bet_def_action_fold_bu integer, js2002_cnt_p_4bet_def_action_fold_co integer, js2002_cnt_p_4bet_def_action_fold_hj integer, js2002_cnt_p_4bet_def_action_fold_sb integer, js2002_cnt_p_4bet_def_action_fold_utg integer, js2002_cnt_p_4bet_def_opp integer, js2002_cnt_p_4bet_def_opp_4 integer, js2002_cnt_p_4bet_def_opp_5 integer, js2002_cnt_p_4bet_def_opp_6 integer, js2002_cnt_p_4bet_def_opp_7 integer, js2002_cnt_p_4bet_def_opp_bb integer, js2002_cnt_p_4bet_def_opp_bu integer, js2002_cnt_p_4bet_def_opp_co integer, js2002_cnt_p_4bet_def_opp_hj integer, js2002_cnt_p_4bet_def_opp_sb integer, js2002_cnt_p_4bet_def_opp_utg integer, js2002_cnt_p_bb_3bet_to_bu_steal integer, js2002_cnt_p_bb_3bet_to_co_steal integer, js2002_cnt_p_bb_3bet_to_sb_steal integer, js2002_cnt_p_bb_fold_to_bu integer, js2002_cnt_p_bb_fold_to_bu_opp integer, js2002_cnt_p_bb_fold_to_co integer, js2002_cnt_p_bb_fold_to_co_opp integer, js2002_cnt_p_bb_fold_to_sb_opp integer, js2002_cnt_p_sb_3bet_to_bu_steal integer, js2002_cnt_p_sb_3bet_to_co_steal integer, js2002_cnt_p_sb_fold_to_bu integer, js2002_cnt_p_sb_fold_to_bu_opp integer, js2002_cnt_p_sb_fold_to_co integer, js2002_cnt_p_sb_fold_to_co_opp integer, js2002_cnt_p_allin_def_action_fold integer, js2002_cnt_p_allin_def_opp integer, js2002_cnt_p_squeeze_def_action_fold integer, js2002_cnt_p_squeeze_def_opp integer, js2002_cnt_r_cbet_float integer, js2002_cnt_r_cbet_float_def_action_call integer, js2002_cnt_r_cbet_float_def_action_fold integer, js2002_cnt_r_cbet_float_def_action_raise integer, js2002_cnt_r_cbet_float_def_opp integer, js2002_cnt_r_cbet_float_opp integer, js2002_cnt_r_check_call integer, js2002_cnt_r_check_fold integer, js2002_cnt_r_checkbehind_after_bet_turn integer, js2002_cnt_r_checkbehind_after_bet_turn_opp integer, js2002_cnt_r_checkbehind_after_call_turn integer, js2002_cnt_r_checkbehind_after_call_turn_opp integer, js2002_cnt_r_checkbehind_after_raise_turn integer, js2002_cnt_r_checkbehind_after_raise_turn_opp integer, js2002_cnt_r_pbet_a_s_cb_t_def_action_fold integer, js2002_cnt_r_pbet_a_s_cb_t_def_opp integer, js2002_cnt_r_probebet_after_seeing_checkbehind_t integer, js2002_cnt_r_probebet_after_seeing_checkbehind_t_opp integer, js2002_cnt_sb_openlimp_fold integer, js2002_cnt_sb_openlimp_fold_opp integer, js2002_cnt_steal_att_sb integer, js2002_cnt_steal_opp_sb integer, js2002_cnt_t_cbet_float integer, js2002_cnt_t_cbet_float_3bp integer, js2002_cnt_t_cbet_float_def_action_call integer, js2002_cnt_t_cbet_float_def_action_fold integer, js2002_cnt_t_cbet_float_def_action_raise integer, js2002_cnt_t_cbet_float_def_opp integer, js2002_cnt_t_cbet_float_opp integer, js2002_cnt_t_cbet_float_opp_3bp integer, js2002_cnt_t_check_call integer, js2002_cnt_t_check_fold integer, js2002_cnt_t_checkbehind_after_bet_flop integer, js2002_cnt_t_checkbehind_after_bet_flop_opp integer, js2002_cnt_t_checkbehind_after_call_flop integer, js2002_cnt_t_checkbehind_after_call_flop_opp integer, js2002_cnt_t_checkbehind_after_raise_flop integer, js2002_cnt_t_checkbehind_after_raise_flop_opp integer, js2002_cnt_t_pbet_a_s_cb_f_def_action_fold integer, js2002_cnt_t_pbet_a_s_cb_f_def_opp integer, js2002_cnt_t_probebet_after_seeing_checkbehind_f integer, js2002_cnt_t_probebet_after_seeing_checkbehind_f_opp integer, walks integer);; Reason: Fatal Error (ERROR: column "cnt_p_pfr_call_mp" specified more than once )
JackHighFTW
 
Posts: 11
Joined: Wed Dec 01, 2010 10:25 am

Next

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

Who is online

Users browsing this forum: No registered users and 7 guests

cron
highfalutin