HowTo: Working Tournament M Values + Get M Specific Stats

[MixMastaPJ]

All of this computer stuff is over my head, but I REALLY want M for my HUD.

Does any1 have the time to kinda "walk me through" this?

Will prob take a cpl replies back and forth, as I am pretty clueless right now.

Here? Or, I can start a new thread? Or skype, AIM, yahoo, mssgrs...

Would be greatly appreciated. Help, anyone, please?

TYVM

If anyone PMs you are gets you through this, I hope you PM me and spread the wealth. I'm pretty tech savvy, but I don't understand postgres or database software very well.

[AAA Donnie]

I will def let you know. It is my "new mission" to figure out how, and... I do NOT fail "missions."

You can PM me, IM me, or email me.... I WILL have answers/solutions soon. This may take me a wk or so, w/ everything I have going on.... but I'll be around. This is now #1 on my list to accomplish THIS week , so...

killahcloser on skype (there 60% of the time)

brasco702@yahoo.com

There is NO reason we should have to purchase HEM just to add this feature!

I will switch if I have to, but I'm sure we can figure this out if we work together. I have been using PT for years, I have always figured out everything I have needed. But, I would be VERY appreciative if someone/anyone could walk me through this. It's a little more complicated than just setting up a HUD obviously...

Then, I can effectively communicate for "computer newb's" like myself how to do the same. I believe this will be helpful to the entire PT3 community. For goodness sake... I'm a poker player, NOT a computer programmer "Jim". (*Scottish- Star Wars accent) HELP!

TYVM

[MixMastaPJ]

I'm housekeeping now, hopefully this works when I get back to playing.

[MixMastaPJ]

been updating the cache for more than 24 hours

[kraada]

From posts earlier in this thread, adding this function seems to increase cache time by a fairly large amount . . . if you have logging enabled you can at least see how far along it is.

[MixMastaPJ]

Gave up, just restarted and ran rebuild instead of update, here's my log after 10 minutes:

Code: Select all

...........................................
2010/06/15 21:38:38.391: [00001114][StatManager] Cache update is 1 percent complete (162/16,148).
2010/06/15 21:38:42.679: [00001114][StatManager] Cache update is 2 percent complete (323/16,148).
2010/06/15 21:38:46.540: [00001114][StatManager] Cache update is 3 percent complete (485/16,148).
2010/06/15 21:38:50.321: [00001114][StatManager] Cache update is 4 percent complete (646/16,148).
2010/06/15 21:38:54.265: [00001114][StatManager] Cache update is 5 percent complete (808/16,148).
2010/06/15 21:38:57.572: [00001114][StatManager] Cache update is 6 percent complete (969/16,148).
2010/06/15 21:39:00.452: [00001114][StatManager] Cache update is 7 percent complete (1,131/16,148).
2010/06/15 21:39:03.835: [00001114][StatManager] Cache update is 8 percent complete (1,292/16,148).
2010/06/15 21:39:07.224: [00001114][StatManager] Cache update is 9 percent complete (1,454/16,148).
2010/06/15 21:39:11.016: [00001114][StatManager] Cache update is 10 percent complete (1,615/16,148).
2010/06/15 21:39:16.804: [00001114][StatManager] Cache update is 11 percent complete (1,777/16,148).
2010/06/15 21:39:22.959: [00001114][StatManager] Cache update is 12 percent complete (1,938/16,148).
2010/06/15 21:39:29.495: [00001114][StatManager] Cache update is 13 percent complete (2,100/16,148).
2010/06/15 21:39:33.961: [00001114][StatManager] Cache update is 14 percent complete (2,261/16,148).
2010/06/15 21:39:39.060: [00001114][StatManager] Cache update is 15 percent complete (2,423/16,148).
2010/06/15 21:39:43.757: [00001114][StatManager] Cache update is 16 percent complete (2,584/16,148).
2010/06/15 21:39:49.612: [00001114][StatManager] Cache update is 17 percent complete (2,746/16,148).
2010/06/15 21:39:54.225: [00001114][StatManager] Cache update is 18 percent complete (2,907/16,148).
2010/06/15 21:39:59.472: [00001114][StatManager] Cache update is 19 percent complete (3,069/16,148).
2010/06/15 21:40:02.765: [00001114][StatManager] Cache update is 20 percent complete (3,230/16,148).
2010/06/15 21:40:11.091: [00001114][StatManager] Cache update is 21 percent complete (3,392/16,148).
2010/06/15 21:40:15.578: [00001114][StatManager] Cache update is 22 percent complete (3,553/16,148).
2010/06/15 21:40:20.219: [00001114][StatManager] Cache update is 23 percent complete (3,715/16,148).
2010/06/15 21:40:26.383: [00001114][StatManager] Cache update is 24 percent complete (3,876/16,148).
2010/06/15 21:40:31.991: [00001114][StatManager] Cache update is 25 percent complete (4,037/16,148).
2010/06/15 21:40:36.193: [00001114][StatManager] Cache update is 26 percent complete (4,199/16,148).
2010/06/15 21:40:39.819: [00001114][StatManager] Cache update is 27 percent complete (4,360/16,148).
2010/06/15 21:40:43.654: [00001114][StatManager] Cache update is 28 percent complete (4,522/16,148).
2010/06/15 21:40:48.482: [00001114][StatManager] Cache update is 29 percent complete (4,683/16,148).
2010/06/15 21:40:53.741: [00001114][StatManager] Cache update is 30 percent complete (4,845/16,148).
2010/06/15 21:40:59.095: [00001114][StatManager] Cache update is 31 percent complete (5,006/16,148).
2010/06/15 21:41:03.176: [00001114][StatManager] Cache update is 32 percent complete (5,168/16,148).
2010/06/15 21:41:07.613: [00001114][StatManager] Cache update is 33 percent complete (5,329/16,148).
2010/06/15 21:41:12.224: [00001114][StatManager] Cache update is 34 percent complete (5,491/16,148).
2010/06/15 21:41:16.457: [00001114][StatManager] Cache update is 35 percent complete (5,652/16,148).
2010/06/15 21:41:19.675: [00001114][StatManager] Cache update is 36 percent complete (5,814/16,148).
2010/06/15 21:41:23.934: [00001114][StatManager] Cache update is 37 percent complete (5,975/16,148).
2010/06/15 21:41:27.002: [00001114][StatManager] Cache update is 38 percent complete (6,137/16,148).
2010/06/15 21:41:30.690: [00001114][StatManager] Cache update is 39 percent complete (6,298/16,148).
2010/06/15 21:41:34.285: [00001114][StatManager] Cache update is 40 percent complete (6,460/16,148).
2010/06/15 21:41:37.521: [00001114][StatManager] Cache update is 41 percent complete (6,621/16,148).
2010/06/15 21:41:41.048: [00001114][StatManager] Cache update is 42 percent complete (6,783/16,148).
2010/06/15 21:41:44.208: [00001114][StatManager] Cache update is 43 percent complete (6,944/16,148).
2010/06/15 21:41:47.135: [00001114][StatManager] Cache update is 44 percent complete (7,106/16,148).
2010/06/15 21:41:50.400: [00001114][StatManager] Cache update is 45 percent complete (7,267/16,148).
2010/06/15 21:41:53.276: [00001114][StatManager] Cache update is 46 percent complete (7,429/16,148).
2010/06/15 21:41:56.745: [00001114][StatManager] Cache update is 47 percent complete (7,590/16,148).
2010/06/15 21:42:00.122: [00001114][StatManager] Cache update is 48 percent complete (7,752/16,148).
2010/06/15 21:42:03.188: [00001114][StatManager] Cache update is 49 percent complete (7,913/16,148).
2010/06/15 21:42:06.118: [00001114][StatManager] Cache update is 50 percent complete (8,074/16,148).
2010/06/15 21:42:09.401: [00001114][StatManager] Cache update is 51 percent complete (8,236/16,148).
2010/06/15 21:42:12.627: [00001114][StatManager] Cache update is 52 percent complete (8,397/16,148).
2010/06/15 21:42:16.121: [00001114][StatManager] Cache update is 53 percent complete (8,559/16,148).
2010/06/15 21:42:19.307: [00001114][StatManager] Cache update is 54 percent complete (8,720/16,148).
2010/06/15 21:42:22.101: [00001114][StatManager] Cache update is 55 percent complete (8,882/16,148).
2010/06/15 21:42:25.067: [00001114][StatManager] Cache update is 56 percent complete (9,043/16,148).
2010/06/15 21:42:27.702: [00001114][StatManager] Cache update is 57 percent complete (9,205/16,148).
2010/06/15 21:42:30.940: [00001114][StatManager] Cache update is 58 percent complete (9,366/16,148).
2010/06/15 21:42:34.349: [00001114][StatManager] Cache update is 59 percent complete (9,528/16,148).
2010/06/15 21:42:37.157: [00001114][StatManager] Cache update is 60 percent complete (9,689/16,148).
2010/06/15 21:42:40.141: [00001114][StatManager] Cache update is 61 percent complete (9,851/16,148).
2010/06/15 21:42:42.488: [00001114][StatManager] Cache update is 62 percent complete (10,012/16,148).
2010/06/15 21:42:45.744: [00001114][StatManager] Cache update is 63 percent complete (10,174/16,148).
2010/06/15 21:42:48.848: [00001114][StatManager] Cache update is 64 percent complete (10,335/16,148).
2010/06/15 21:42:52.025: [00001114][StatManager] Cache update is 65 percent complete (10,497/16,148).
2010/06/15 21:42:54.622: [00001114][StatManager] Cache update is 66 percent complete (10,658/16,148).
2010/06/15 21:42:57.808: [00001114][StatManager] Cache update is 67 percent complete (10,820/16,148).
2010/06/15 21:43:01.048: [00001114][StatManager] Cache update is 68 percent complete (10,981/16,148).
2010/06/15 21:43:04.839: [00001114][StatManager] Cache update is 69 percent complete (11,143/16,148).
2010/06/15 21:43:07.925: [00001114][StatManager] Cache update is 70 percent complete (11,304/16,148).
2010/06/15 21:43:11.025: [00001114][StatManager] Cache update is 71 percent complete (11,466/16,148).
2010/06/15 21:43:14.167: [00001114][StatManager] Cache update is 72 percent complete (11,627/16,148).
2010/06/15 21:43:17.423: [00001114][StatManager] Cache update is 73 percent complete (11,789/16,148).
2010/06/15 21:43:20.075: [00001114][StatManager] Cache update is 74 percent complete (11,950/16,148).
2010/06/15 21:43:22.706: [00001114][StatManager] Cache update is 75 percent complete (12,111/16,148).
2010/06/15 21:43:26.277: [00001114][StatManager] Cache update is 76 percent complete (12,273/16,148).
2010/06/15 21:43:29.011: [00001114][StatManager] Cache update is 77 percent complete (12,434/16,148).
2010/06/15 21:43:31.649: [00001114][StatManager] Cache update is 78 percent complete (12,596/16,148).
2010/06/15 21:43:34.507: [00001114][StatManager] Cache update is 79 percent complete (12,757/16,148).
2010/06/15 21:43:37.913: [00001114][StatManager] Cache update is 80 percent complete (12,919/16,148).
2010/06/15 21:43:40.553: [00001114][StatManager] Cache update is 81 percent complete (13,080/16,148).
2010/06/15 21:43:43.591: [00001114][StatManager] Cache update is 82 percent complete (13,242/16,148).
2010/06/15 21:43:46.547: [00001114][StatManager] Cache update is 83 percent complete (13,403/16,148).
2010/06/15 21:43:50.548: [00001114][StatManager] Cache update is 84 percent complete (13,565/16,148).
2010/06/15 21:43:53.761: [00001114][StatManager] Cache update is 85 percent complete (13,726/16,148).
2010/06/15 21:43:56.900: [00001114][StatManager] Cache update is 86 percent complete (13,888/16,148).
2010/06/15 21:44:00.184: [00001114][StatManager] Cache update is 87 percent complete (14,049/16,148).
2010/06/15 21:44:02.774: [00001114][StatManager] Cache update is 88 percent complete (14,211/16,148).
2010/06/15 21:44:05.929: [00001114][StatManager] Cache update is 89 percent complete (14,372/16,148).
2010/06/15 21:44:08.689: [00001114][StatManager] Cache update is 90 percent complete (14,534/16,148).
2010/06/15 21:44:11.321: [00001114][StatManager] Cache update is 91 percent complete (14,695/16,148).
2010/06/15 21:44:14.240: [00001114][StatManager] Cache update is 92 percent complete (14,857/16,148).
2010/06/15 21:44:16.753: [00001114][StatManager] Cache update is 93 percent complete (15,018/16,148).
2010/06/15 21:44:19.398: [00001114][StatManager] Cache update is 94 percent complete (15,180/16,148).
2010/06/15 21:44:22.069: [00001114][StatManager] Cache update is 95 percent complete (15,341/16,148).
2010/06/15 21:44:24.668: [00001114][StatManager] Cache update is 96 percent complete (15,503/16,148).
2010/06/15 21:44:26.937: [00001114][StatManager] Cache update is 97 percent complete (15,664/16,148).
2010/06/15 21:44:29.877: [00001114][StatManager] Cache update is 98 percent complete (15,826/16,148).
2010/06/15 21:44:32.053: [00001114][StatManager] Cache update is 99 percent complete (15,987/16,148).
2010/06/15 21:44:34.518: [00001114][StatManager] Population of table complete.
2010/06/15 21:44:35.025: [00001114][StatManager] Cache successfully updated.
2010/06/15 21:44:35.124: [00001114][StatManager] Create SQL: CREATE TABLE tourney_holdem_cache (id_player integer NOT NULL, id_blinds integer NOT NULL, cnt_players integer NOT NULL, position_type integer, amt_bb_won numeric(11,2), amt_blind numeric(11,2), amt_won 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_with_flop 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_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_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, val_m numeric(11,2));
2010/06/15 21:44:35.153: [00001114][StatManager] Dropping existing cache
2010/06/15 21:44:35.253: [00001114][StatManager] Creating new cache


[MixMastaPJ]

Followed by:

Code: Select all

2010/06/15 21:44:39.126: [00001114][StatManager] Executing Cache Query: INSERT INTO tourney_holdem_cache SELECT tourney_holdem_hand_player_statistics.id_player, tourney_holdem_hand_player_statistics.id_blinds, tourney_holdem_hand_summary.cnt_players, ((case when( lookup_positions.flg_blinds) then  0 else  (case when( lookup_positions.flg_ep) then  1 else  (case when( lookup_positions.flg_mp) then  2 else  3  end)  end)  end)), (sum( (CASE WHEN ( (tourney_holdem_blinds.amt_bb *tourney_holdem_blinds.val_nlpl_mult)) <> 0 THEN ((tourney_holdem_hand_player_statistics.amt_won * 1.0 )/( (tourney_holdem_blinds.amt_bb *tourney_holdem_blinds.val_nlpl_mult))) ELSE 0 END) )), (sum(tourney_holdem_hand_player_detail.amt_blind)), (sum(tourney_holdem_hand_player_statistics.amt_won)), (sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_b and tourney_holdem_hand_player_statistics.flg_blind_s = false) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_blind_b AND tourney_holdem_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action LIKE 'C') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_bb_steal_fold) then  1 else  0 end))), (sum((case when( tourney_holdem_hand_player_statistics.flg_blind_b AND tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.cnt_p_raise > 0) then  1  else  0  end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_b OR tourney_holdem_hand_player_statistics.flg_blind_s) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_3bet) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_f_3bet_action='C') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_f_3bet_action='F') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_f_3bet_action='R') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_3bet_def_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_3bet_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_4bet) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_f_4bet_action='C') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_f_4bet_action='F') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_f_4bet_action='R') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_4bet_def_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_4bet_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_bet) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(C|XC)%')) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(F|XF)%')) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(R|XR)%')) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_detail.amt_f_bet_facing > 0) then  1 else  0 end))), (sum((case when( (tourney_holdem_hand_player_statistics.flg_f_bet OR tourney_holdem_hand_player_statistics.cnt_f_raise > 0)) then  1 else  0 end))), (sum(tourney_holdem_hand_player_statistics.cnt_f_call)), (sum((case when(tourney_holdem_hand_player_statistics.cnt_f_call > 0) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_cbet) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_f_cbet_action='C') then  1 else  0 end))), (sum((case when(substring(lookup_actions_f.action from 1 for 1)<>'X' AND tourney_holdem_hand_player_statistics.enum_f_cbet_action='C') then  1 else  0 end))), (sum((case when(substring(lookup_actions_f.action from 1 for 1)='X' AND tourney_holdem_hand_player_statistics.enum_f_cbet_action='C') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_f_cbet_action='F') then  1 else  0 end))), (sum((case when(substring(lookup_actions_f.action from 1 for 1)<>'X' AND tourney_holdem_hand_player_statistics.enum_f_cbet_action='F') then  1 else  0 end))), (sum((case when(substring(lookup_actions_f.action from 1 for 1)='X' AND tourney_holdem_hand_player_statistics.enum_f_cbet_action='F') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_f_cbet_action='R') then  1 else  0 end))), (sum((case when(substring(lookup_actions_f.action from 1 for 1)<>'X' AND tourney_holdem_hand_player_statistics.enum_f_cbet_action='R') then  1 else  0 end))), (sum((case when(substring(lookup_actions_f.action from 1 for 1)='X' AND tourney_holdem_hand_player_statistics.enum_f_cbet_action='R') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_cbet_def_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_cbet and tourney_holdem_hand_player_statistics.flg_f_face_raise) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_cbet and lookup_actions_f.action LIKE 'BF') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_cbet_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_cbet AND NOT(tourney_holdem_hand_player_statistics.flg_t_saw) AND NOT(tourney_holdem_hand_player_statistics.flg_f_face_raise)) then  1 else  0 end))  ), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_check) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_check_raise) then  1 else   0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_check AND (tourney_holdem_hand_player_statistics.cnt_f_raise > 0 OR tourney_holdem_hand_player_statistics.cnt_f_call > 0 OR tourney_holdem_hand_player_statistics.flg_f_fold)) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_face_raise AND NOT(tourney_holdem_hand_player_statistics.flg_p_3bet OR tourney_holdem_hand_player_statistics.flg_p_4bet) AND tourney_holdem_hand_player_statistics.flg_f_bet AND NOT(tourney_holdem_hand_player_statistics.flg_f_cbet_opp) AND ((tourney_holdem_hand_summary.cnt_players > 2 and tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos < tourney_holdem_hand_player_statistics.position) or (tourney_holdem_hand_summary.cnt_players = 2 and tourney_holdem_hand_player_statistics.flg_blind_b))) then 1 else 0 end))), (sum((case when(lookup_actions_p.action LIKE '%R' and tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 AND NOT(tourney_holdem_hand_player_detail.flg_f_open_opp)) then  1 else  0 end))), (sum((case when(lookup_actions_p.action LIKE '%R'  and tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 and NOT(tourney_holdem_hand_player_detail.flg_f_open_opp) AND substring(lookup_actions_f.action from 1 for 1) = 'C') then  1 else  0 end))), (sum((case when(lookup_actions_p.action LIKE '%R'  and tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 and NOT(tourney_holdem_hand_player_detail.flg_f_open_opp) AND substring(lookup_actions_f.action from 1 for 1) = 'F') then  1 else  0 end))), (sum((case when(lookup_actions_p.action LIKE '%R'  and tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 and NOT(tourney_holdem_hand_player_detail.flg_f_open_opp) AND substring(lookup_actions_f.action from 1 for 1) = 'R') then  1 else  0 end))), (sum((case when( tourney_holdem_hand_player_statistics.flg_p_face_raise AND NOT(tourney_holdem_hand_player_statistics.flg_p_3bet OR tourney_holdem_hand_player_statistics.flg_p_4bet) AND (tourney_holdem_hand_player_detail.flg_f_open_opp) AND NOT(tourney_holdem_hand_player_statistics.flg_f_cbet_opp) AND ((tourney_holdem_hand_summary.cnt_players > 2 and tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos < tourney_holdem_hand_player_statistics.position) or (tourney_holdem_hand_summary.cnt_players = 2 and tourney_holdem_hand_player_statistics.flg_blind_b)) ) then  1  else  0  end))), (sum ( (case when( flg_f_bet AND tourney_holdem_hand_player_statistics.flg_f_face_raise AND (tourney_holdem_hand_player_detail.val_f_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then  1 else  0  end) ) ), (sum ( (case when( lookup_actions_f.action LIKE 'BC' and tourney_holdem_hand_player_statistics.flg_f_face_raise AND (tourney_holdem_hand_player_detail.val_f_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then  1 else  0  end) ) ), (sum ( (case when( lookup_actions_f.action LIKE 'BF' and tourney_holdem_hand_player_statistics.flg_f_face_raise AND (tourney_holdem_hand_player_detail.val_f_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then  1 else  0  end) ) ), (sum ( (case when( lookup_actions_f.action LIKE 'BR' and tourney_holdem_hand_player_statistics.flg_f_face_raise AND (tourney_holdem_hand_player_detail.val_f_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then  1 else  0  end) ) ), (sum((case when( tourney_holdem_hand_player_statistics.flg_p_face_raise and tourney_holdem_hand_player_statistics.cnt_p_raise = 0 and tourney_holdem_hand_player_statistics.cnt_p_call = 1 and tourney_holdem_hand_player_detail.flg_f_open_opp and tourney_holdem_hand_player_statistics.flg_f_bet and tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position) then  1 else  0 end))), (sum((case when( not(tourney_holdem_hand_player_statistics.flg_p_face_raise) and lookup_actions_p.action LIKE '%R' and  tourney_holdem_hand_player_detail.flg_f_open_opp and tourney_holdem_hand_player_statistics.flg_f_check and tourney_holdem_hand_player_detail.amt_f_bet_facing > 0) then  1 else  0 end))), (sum((case when( not(tourney_holdem_hand_player_statistics.flg_p_face_raise) and lookup_actions_p.action LIKE '%R' and  tourney_holdem_hand_player_detail.flg_f_open_opp and tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 and substring(lookup_actions_f.action from 1 for 2) = 'XC') then  1 else  0 end))), (sum((case when( not(tourney_holdem_hand_player_statistics.flg_p_face_raise) and lookup_actions_p.action LIKE '%R' and  tourney_holdem_hand_player_detail.flg_f_open_opp and tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 and substring(lookup_actions_f.action from 1 for 2) = 'XF') then  1 else  0 end))), (sum((case when( not(tourney_holdem_hand_player_statistics.flg_p_face_raise) and lookup_actions_p.action LIKE '%R' and  tourney_holdem_hand_player_detail.flg_f_open_opp and tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 and substring(lookup_actions_f.action from 1 for 2) = 'XR') then  1 else  0 end))), (sum((case when( tourney_holdem_hand_player_statistics.flg_p_face_raise and tourney_holdem_hand_player_statistics.cnt_p_raise = 0 and tourney_holdem_hand_player_statistics.cnt_p_call = 1 and tourney_holdem_hand_player_detail.flg_f_open_opp and tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_fold) then  1 else  0 end))), (sum(tourney_holdem_hand_player_statistics.cnt_f_raise)), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_face_raise AND tourney_holdem_hand_player_statistics.cnt_f_call > 0) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_face_raise AND tourney_holdem_hand_player_statistics.flg_f_fold) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_face_raise) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_saw) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_won_hand AND tourney_holdem_hand_player_statistics.flg_f_saw) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_bet) then  1 else  0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_f_call)) + (sum((case when(tourney_holdem_hand_player_statistics.flg_f_check) then  1 else  0 end))) + (sum((case when(tourney_holdem_hand_player_statistics.flg_f_fold) then  1 else  0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_f_raise)), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_open AND tourney_holdem_hand_player_statistics.flg_p_limp) then  1 else  0 end))), (sum( (case when(  (tourney_holdem_hand_player_statistics.flg_f_bet OR tourney_holdem_hand_player_statistics.cnt_f_raise > 0)  and NOT(tourney_holdem_hand_player_statistics.flg_won_hand)  and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then  1 else  0 end))), (sum( (case when( tourney_holdem_hand_player_statistics.cnt_f_call > 0 and NOT(tourney_holdem_hand_player_statistics.flg_won_hand)  and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then  1 else  0 end))), (sum( (case when(  (tourney_holdem_hand_player_statistics.cnt_p_raise > 0)  and NOT(tourney_holdem_hand_player_statistics.flg_won_hand)  and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then  1 else  0 end))), (sum( (case when( tourney_holdem_hand_player_statistics.cnt_p_call > 0 and NOT(tourney_holdem_hand_player_statistics.flg_won_hand)  and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then  1 else  0 end))), (sum( (case when(  (tourney_holdem_hand_player_statistics.flg_r_bet OR tourney_holdem_hand_player_statistics.cnt_r_raise > 0)  and NOT(tourney_holdem_hand_player_statistics.flg_won_hand)  and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then  1 else  0 end))), (sum( (case when( tourney_holdem_hand_player_statistics.cnt_r_call > 0 and NOT(tourney_holdem_hand_player_statistics.flg_won_hand)  and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then  1 else  0 end))), (sum( (case when(  (tourney_holdem_hand_player_statistics.flg_t_bet OR tourney_holdem_hand_player_statistics.cnt_t_raise > 0)  and NOT(tourney_holdem_hand_player_statistics.flg_won_hand)  and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then  1 else  0 end))), (sum( (case when( tourney_holdem_hand_player_statistics.cnt_t_call > 0 and NOT(tourney_holdem_hand_player_statistics.flg_won_hand)  and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.id_hand > 0) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_summary.cnt_players_f > 0) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_3bet AND tourney_holdem_hand_player_statistics.flg_p_4bet_def_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_3bet) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_p_3bet_action='C') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_p_3bet_action='F') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_p_3bet_action='F' and tourney_holdem_hand_player_statistics.flg_p_first_raise and not(tourney_holdem_hand_player_statistics.flg_steal_att)) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_p_3bet_action='R') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp and tourney_holdem_hand_player_statistics.flg_p_first_raise and not(tourney_holdem_hand_player_statistics.flg_steal_att)) then  1 else  0 end))), (sum((case when( (tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp OR tourney_holdem_hand_player_statistics.flg_p_4bet_def_opp) AND tourney_holdem_hand_player_statistics.enum_f_cbet_action='C') then  1  else  0  end))), (sum((case when( tourney_holdem_hand_player_statistics.cnt_p_raise > 0 AND tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp AND tourney_holdem_hand_player_statistics.enum_f_cbet_action='F') then  1  else  0  end))), (sum((case when( (tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp OR tourney_holdem_hand_player_statistics.flg_p_4bet_def_opp) AND tourney_holdem_hand_player_statistics.enum_f_cbet_action='R') then  1  else  0  end))), (sum((case when( (tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp OR tourney_holdem_hand_player_statistics.flg_p_4bet_def_opp)  AND tourney_holdem_hand_player_statistics.flg_f_cbet_def_opp) then  1  else  0  end))), (sum((case when( tourney_holdem_hand_player_statistics.flg_p_3bet and tourney_holdem_hand_player_statistics.enum_p_4bet_action = 'F') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_3bet_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_4bet) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_p_4bet_action='C') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_p_4bet_action='F') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_p_4bet_action='R') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_4bet_def_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_4bet_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_fold AND tourney_holdem_hand_player_statistics.position = 8 AND (tourney_holdem_hand_summary.cnt_players - tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos) = 1 AND tourney_holdem_hand_player_statistics.flg_blind_def_opp) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.position = 8 AND (tourney_holdem_hand_summary.cnt_players - tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos) = 1 AND tourney_holdem_hand_player_statistics.flg_blind_def_opp) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.position = 8 AND tourney_holdem_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action='C' AND tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 9) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.position = 8 AND tourney_holdem_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action='F' AND tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 9) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.position = 8 AND tourney_holdem_hand_player_statistics.flg_blind_def_opp AND substring(lookup_actions_p.action from 1 for 1)='R' AND ((tourney_holdem_hand_player_statistics.flg_f_saw AND tourney_holdem_hand_player_detail.flg_f_has_position ) OR ( NOT substring(lookup_actions_p.action from 2 for 1)='R' AND tourney_holdem_hand_player_detail.val_p_raise_facing_pct=tourney_holdem_hand_player_detail.amt_p_raise_facing* 1.0 /(tourney_holdem_hand_player_detail.amt_p_raise_facing+tourney_holdem_hand_player_detail.amt_blind)) OR (substring(lookup_actions_p.action from 1 for 2)='RR' AND NOT substring(lookup_actions_p.action from 3 for 1)='R' AND tourney_holdem_hand_player_detail.val_p_raise_facing_pct=tourney_holdem_hand_player_detail.amt_p_raise_facing* 1.0 /(tourney_holdem_hand_player_detail.amt_p_raise_facing+tourney_holdem_hand_player_detail.amt_blind+tourney_holdem_hand_player_detail.amt_p_raise_made)))) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0) then  1 else  0 end))), (sum(tourney_holdem_hand_player_statistics.cnt_p_call)), (sum((case when(tourney_holdem_hand_player_statistics.cnt_p_call > 0) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_ccall) then  1 else  0 end))), (sum( (case when( NOT(NOT(tourney_holdem_hand_player_statistics.flg_p_face_raise) OR (tourney_holdem_hand_player_statistics.flg_p_limp) OR (tourney_holdem_hand_player_statistics.flg_p_first_raise)) AND (tourney_holdem_hand_player_detail.amt_blind=0)) then  1  else  0  end) )), (sum((case when(substring(lookup_actions_p.action from 1 for 1)='X') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_face_raise) then  1 else  0 end))), (sum( (case when( ((NOT tourney_holdem_hand_player_statistics.flg_p_face_raise) OR tourney_holdem_hand_player_statistics.flg_p_limp OR tourney_holdem_hand_player_statistics.flg_p_first_raise) AND NOT tourney_holdem_hand_player_statistics.flg_p_open_opp     AND lookup_actions_p.action <> '') then  1  else  0  end) )), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_first_raise) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_fold) then  1 else  0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_limp) then  1 else  0 end) )), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'CC%') then  1 else  0 end) )), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_limp AND tourney_holdem_hand_player_statistics.flg_p_face_raise = true) then  1 else  0 end) )), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_limp AND lookup_actions_p.action = 'CF') then  1 else  0 end) )), (sum( (case when( (NOT(tourney_holdem_hand_player_statistics.flg_p_face_raise) OR (tourney_holdem_hand_player_statistics.flg_p_limp) OR (tourney_holdem_hand_player_statistics.flg_p_first_raise)) AND NOT(tourney_holdem_hand_player_statistics.flg_blind_b)) then  1  else  0  end) )), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'CR%') then  1 else  0 end) )), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_open_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_face_raise AND tourney_holdem_hand_player_statistics.flg_p_fold = false AND tourney_holdem_hand_player_statistics.cnt_p_raise=0) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_face_raise) then  1 else  0 end))), (sum(tourney_holdem_hand_player_statistics.cnt_p_raise)), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_first_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp) then  1 else  0 end)) ), (sum( (case when( tourney_holdem_hand_player_statistics.flg_p_first_raise AND NOT tourney_holdem_hand_player_statistics.flg_p_open_opp) then  1  else  0  end) )), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_squeeze) then  1 else  0 end) )), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_squeeze_def_opp AND tourney_holdem_hand_player_statistics.enum_p_squeeze_action = 'C') then  1 else  0 end) )), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_squeeze_def_opp AND tourney_holdem_hand_player_statistics.enum_p_squeeze_action = 'F') then  1 else  0 end) )), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_squeeze_def_opp) then  1 else  0 end) )), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_squeeze_def_opp AND tourney_holdem_hand_player_statistics.enum_p_squeeze_action = 'R') then  1 else  0 end) )), (sum( (case when( tourney_holdem_hand_player_statistics.flg_p_squeeze_opp) then  1 else  0 end) )), (sum(tourney_holdem_hand_player_statistics.cnt_p_call)) + (sum((case when(tourney_holdem_hand_player_statistics.flg_p_fold) then  1 else  0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_p_raise)) + (sum((case when(substring(lookup_actions_p.action from 1 for 1)='X') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0 AND tourney_holdem_hand_player_statistics.flg_f_saw AND substring(lookup_actions_f.action from 1 for 1)='B') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0 AND tourney_holdem_hand_player_statistics.flg_f_saw AND substring(lookup_actions_f.action from 1 for 1)='C') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0 AND tourney_holdem_hand_player_statistics.flg_f_saw AND substring(lookup_actions_f.action from 1 for 1)='X') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0 AND tourney_holdem_hand_player_statistics.flg_f_saw AND substring(lookup_actions_f.action from 1 for 2)='XR') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0 AND tourney_holdem_hand_player_statistics.flg_f_saw AND substring(lookup_actions_f.action from 1 for 1)='F') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0 AND (NOT tourney_holdem_hand_player_statistics.flg_f_saw OR substring(lookup_actions_f.action from 1 for 1)='')) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0 AND tourney_holdem_hand_player_statistics.flg_f_saw AND substring(lookup_actions_f.action from 1 for 1)='R') then  1 else  0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_open = false AND tourney_holdem_hand_player_statistics.flg_p_limp) then  1 else  0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_open = false AND tourney_holdem_hand_player_statistics.cnt_p_raise > 0 AND tourney_holdem_hand_player_statistics.flg_p_limp = false AND tourney_holdem_hand_player_statistics.flg_p_ccall = false) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_3bet) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_r_3bet_action='C') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_r_3bet_action='F') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_r_3bet_action='R') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_3bet_def_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_3bet_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_4bet) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_r_4bet_action='C') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_r_4bet_action='F') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_r_4bet_action='R') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_4bet_def_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_4bet_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_bet) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_detail.amt_r_bet_facing > 0 AND (lookup_actions_r.action SIMILAR TO '(C|XC)%')) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_detail.amt_r_bet_facing > 0 AND (lookup_actions_r.action SIMILAR TO '(F|XF)%')) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_detail.amt_r_bet_facing > 0 AND (lookup_actions_r.action SIMILAR TO '(R|XR)%')) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_detail.amt_r_bet_facing > 0) then  1 else  0 end))), (sum((case when( (tourney_holdem_hand_player_statistics.flg_r_bet OR tourney_holdem_hand_player_statistics.cnt_r_raise > 0)) then  1 else  0 end))), (sum(tourney_holdem_hand_player_statistics.cnt_r_call)), (sum((case when(tourney_holdem_hand_player_statistics.cnt_r_call > 0) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_cbet) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_r_cbet_action='C') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_r_cbet_action='F') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_r_cbet_action='R') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_cbet_def_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_cbet and tourney_holdem_hand_player_statistics.flg_r_face_raise) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_cbet and lookup_actions_r.action LIKE 'BF') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_cbet_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_check) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_check_raise) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_check AND (tourney_holdem_hand_player_statistics.cnt_r_raise > 0 OR tourney_holdem_hand_player_statistics.cnt_r_call > 0 OR tourney_holdem_hand_player_statistics.flg_r_fold)) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_donk) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_r_donk_action='C') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_r_donk_action='F') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_r_donk_action='R') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_donk_def_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_donk_opp) then  1 else  0 end))), (sum ( (case when( flg_r_bet AND tourney_holdem_hand_player_statistics.flg_r_face_raise AND (tourney_holdem_hand_player_detail.val_r_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then  1 else  0  end) ) ), (sum ( (case when( lookup_actions_r.action LIKE 'BC' and tourney_holdem_hand_player_statistics.flg_r_face_raise AND (tourney_holdem_hand_player_detail.val_r_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then  1 else  0  end) ) ), (sum ( (case when( lookup_actions_r.action LIKE 'BF' and tourney_holdem_hand_player_statistics.flg_r_face_raise AND (tourney_holdem_hand_player_detail.val_r_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then  1 else  0  end) ) ), (sum ( (case when( lookup_actions_r.action LIKE 'BR' and tourney_holdem_hand_player_statistics.flg_r_face_raise AND (tourney_holdem_hand_player_detail.val_r_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then  1 else  0  end) ) ), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_float) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_r_float_action='C') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_r_float_action='F') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_r_float_action='R') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_float_def_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_float_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_fold) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_bet and lookup_actions_t.action LIKE 'X' and tourney_holdem_hand_player_statistics.enum_f_cbet_action = 'C' and NOT(lookup_actions_f.action LIKE '%R')) then  1 else  0 end)) ), (sum((case when(tourney_holdem_hand_player_detail.flg_r_open_opp and lookup_actions_t.action LIKE 'X' and tourney_holdem_hand_player_statistics.enum_f_cbet_action = 'C' and NOT(lookup_actions_f.action LIKE '%R')) then  1 else  0 end)) ), (sum(tourney_holdem_hand_player_statistics.cnt_r_raise)), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_face_raise AND tourney_holdem_hand_player_statistics.cnt_r_call > 0) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_face_raise AND tourney_holdem_hand_player_statistics.flg_r_fold) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_face_raise) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.cnt_r_raise > 0 AND tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.cnt_r_raise > 0 AND tourney_holdem_hand_player_statistics.flg_showdown AND tourney_holdem_hand_player_statistics.flg_won_hand) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_saw) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_bet) then  1 else  0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_r_call)) + (sum((case when(tourney_holdem_hand_player_statistics.flg_r_check) then  1 else  0 end))) + (sum((case when(tourney_holdem_hand_player_statistics.flg_r_fold) then  1 else  0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_r_raise)), (sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_b = false AND tourney_holdem_hand_player_statistics.flg_blind_s) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_s AND lookup_actions_p.action LIKE 'C') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_sb_steal_fold) then  1 else  0 end))), (sum( (case when( tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_s AND tourney_holdem_hand_player_statistics.cnt_p_raise > 0) then  1 else  0  end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.position=0) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.position=1) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.enum_folded<>'N') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att AND  NOT tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.position=9) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_b) then  1 else  0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_b) then  1 else  0 end))) - (sum((case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_b AND tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_b AND tourney_holdem_hand_player_statistics.flg_won_hand AND tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_b AND tourney_holdem_hand_player_statistics.flg_won_hand AND NOT tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_b AND tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_s) then  1 else  0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_s) then  1 else  0 end))) - (sum((case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_s AND tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_s AND tourney_holdem_hand_player_statistics.flg_won_hand AND tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_s AND tourney_holdem_hand_player_statistics.flg_won_hand AND NOT tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_s AND tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_steal_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_steal_opp AND tourney_holdem_hand_player_statistics.position=0) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_steal_opp AND tourney_holdem_hand_player_statistics.position=1) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_steal_opp AND tourney_holdem_hand_player_statistics.position=9) then  1 else  0 end))), (sum((case when( tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp AND tourney_holdem_hand_player_statistics.enum_p_3bet_action='F') then  1  else  0  end))), (sum((case when( tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp) then  1  else  0  end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att AND NOT(tourney_holdem_hand_player_statistics.flg_f_saw) AND NOT(tourney_holdem_hand_player_statistics.flg_p_face_raise)) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.flg_won_hand AND tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.flg_won_hand AND NOT tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_3bet) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_t_3bet_action='C') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_t_3bet_action='F') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_t_3bet_action='R') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_3bet_def_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_3bet_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_4bet) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_t_4bet_action='C') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_t_4bet_action='F') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_t_4bet_action='R') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_4bet_def_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_4bet_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_bet) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_detail.amt_t_bet_facing > 0 AND (lookup_actions_t.action SIMILAR TO '(C|XC)%')) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_detail.amt_t_bet_facing > 0 AND (lookup_actions_t.action SIMILAR TO '(F|XF)%')) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_detail.amt_t_bet_facing > 0 AND (lookup_actions_t.action SIMILAR TO '(R|XR)%')) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_detail.amt_t_bet_facing > 0) then  1 else  0 end))), (sum((case when( (tourney_holdem_hand_player_statistics.flg_t_bet OR tourney_holdem_hand_player_statistics.cnt_t_raise > 0)) then  1 else  0 end))), (sum(tourney_holdem_hand_player_statistics.cnt_t_call)), (sum((case when(tourney_holdem_hand_player_statistics.cnt_t_call > 0) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_cbet) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_t_cbet_action='C') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_t_cbet_action='F') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_t_cbet_action='R') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_cbet_def_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_cbet and tourney_holdem_hand_player_statistics.flg_t_face_raise) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_cbet and lookup_actions_t.action LIKE 'BF') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_cbet_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_check) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_check_raise) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_check AND (tourney_holdem_hand_player_statistics.cnt_t_raise > 0 OR tourney_holdem_hand_player_statistics.cnt_t_call > 0 OR tourney_holdem_hand_player_statistics.flg_t_fold)) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_donk) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_t_donk_action='C') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_t_donk_action='F') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_t_donk_action='R') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_donk_def_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_donk_opp) then  1 else  0 end))), (sum ( (case when( flg_t_bet AND tourney_holdem_hand_player_statistics.flg_t_face_raise AND (tourney_holdem_hand_player_detail.val_t_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then  1 else  0  end) ) ), (sum ( (case when( lookup_actions_t.action LIKE 'BC' and tourney_holdem_hand_player_statistics.flg_t_face_raise AND (tourney_holdem_hand_player_detail.val_t_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then  1 else  0  end) ) ), (sum ( (case when( lookup_actions_t.action LIKE 'BF' and tourney_holdem_hand_player_statistics.flg_t_face_raise AND (tourney_holdem_hand_player_detail.val_t_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then  1 else  0  end) ) ), (sum ( (case when( lookup_actions_t.action LIKE 'BR' and tourney_holdem_hand_player_statistics.flg_t_face_raise AND (tourney_holdem_hand_player_detail.val_t_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then  1 else  0  end) ) ), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_float) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_t_float_action='C') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_t_float_action='F') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_t_float_action='R') then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_float_def_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_float_opp) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_fold) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_bet and lookup_actions_f.action LIKE 'X' and lookup_actions_p.action NOT LIKE '%R' and tourney_holdem_hand_player_statistics.flg_p_face_raise and not(tourney_holdem_hand_player_detail.flg_t_has_position)) then  1 else  0 end)) ), (sum((case when(tourney_holdem_hand_player_detail.flg_t_open_opp and lookup_actions_f.action LIKE 'X' and lookup_actions_p.action NOT LIKE '%R' and tourney_holdem_hand_player_statistics.flg_p_face_raise and not(tourney_holdem_hand_player_detail.flg_t_has_position)) then  1 else  0 end)) ), (sum(tourney_holdem_hand_player_statistics.cnt_t_raise)), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_face_raise AND tourney_holdem_hand_player_statistics.cnt_t_call > 0) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_face_raise AND tourney_holdem_hand_player_statistics.flg_t_fold) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_face_raise) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.cnt_t_raise > 0 AND tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.cnt_t_raise > 0 AND tourney_holdem_hand_player_statistics.flg_showdown AND tourney_holdem_hand_player_statistics.flg_won_hand) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_saw) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_bet) then  1 else  0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_t_call)) + (sum((case when(tourney_holdem_hand_player_statistics.flg_t_check) then  1 else  0 end))) + (sum((case when(tourney_holdem_hand_player_statistics.flg_t_fold) then  1 else  0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_t_raise)), (sum(tourney_holdem_hand_player_statistics.cnt_p_call)) + (sum((case when(tourney_holdem_hand_player_statistics.flg_p_fold) then  1 else  0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_p_raise)) + (sum((case when(substring(lookup_actions_p.action from 1 for 1)='X') then  1 else  0 end))) + (sum((case when(tourney_holdem_hand_player_statistics.flg_f_bet) then  1 else  0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_f_call)) + (sum((case when(tourney_holdem_hand_player_statistics.flg_f_check) then  1 else  0 end))) + (sum((case when(tourney_holdem_hand_player_statistics.flg_f_fold) then  1 else  0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_f_raise)) + (sum((case when(tourney_holdem_hand_player_statistics.flg_t_bet) then  1 else  0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_t_call)) + (sum((case when(tourney_holdem_hand_player_statistics.flg_t_check) then  1 else  0 end))) + (sum((case when(tourney_holdem_hand_player_statistics.flg_t_fold) then  1 else  0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_t_raise)) + (sum((case when(tourney_holdem_hand_player_statistics.flg_r_bet) then  1 else  0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_r_call)) + (sum((case when(tourney_holdem_hand_player_statistics.flg_r_check) then  1 else  0 end))) + (sum((case when(tourney_holdem_hand_player_statistics.flg_r_fold) then  1 else  0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_r_raise)), (sum((case when(tourney_holdem_hand_player_statistics.flg_vpip) then  1 else  0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_b = false AND tourney_holdem_hand_player_statistics.flg_blind_s AND tourney_holdem_hand_player_statistics.flg_vpip) then  1 else  0 end) )), (sum((case when(tourney_holdem_hand_player_statistics.flg_won_hand) then  1 else  0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_showdown AND tourney_holdem_hand_player_statistics.flg_won_hand) then  1 else  0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum( (case when((tourney_holdem_hand_player_statistics.flg_f_bet OR tourney_holdem_hand_player_statistics.cnt_f_raise > 0)  and tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum( (case when( tourney_holdem_hand_player_statistics.cnt_f_call > 0 and tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0  and tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum( (case when( tourney_holdem_hand_player_statistics.cnt_p_call > 0 and tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum( (case when((tourney_holdem_hand_player_statistics.flg_r_bet OR tourney_holdem_hand_player_statistics.cnt_r_raise > 0)  and tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum( (case when( tourney_holdem_hand_player_statistics.cnt_r_call > 0 and tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum( (case when((tourney_holdem_hand_player_statistics.flg_t_bet OR tourney_holdem_hand_player_statistics.cnt_t_raise > 0)  and tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum( (case when( tourney_holdem_hand_player_statistics.cnt_t_call > 0 and tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_showdown AND tourney_holdem_hand_player_statistics.flg_won_hand) then  1 else  0 end))), (sum( (case when( (tourney_holdem_hand_player_statistics.flg_f_bet OR tourney_holdem_hand_player_statistics.cnt_f_raise > 0) and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum( (case when( tourney_holdem_hand_player_statistics.cnt_f_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum( (case when( tourney_holdem_hand_player_statistics.cnt_p_raise > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum( (case when( tourney_holdem_hand_player_statistics.cnt_p_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum( (case when( (tourney_holdem_hand_player_statistics.flg_r_bet OR tourney_holdem_hand_player_statistics.cnt_r_raise > 0) and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum( (case when( tourney_holdem_hand_player_statistics.cnt_r_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum( (case when( (tourney_holdem_hand_player_statistics.flg_t_bet OR tourney_holdem_hand_player_statistics.cnt_t_raise > 0) and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum( (case when( tourney_holdem_hand_player_statistics.cnt_t_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then  1 else  0 end))), (sum( (case when( (tourney_holdem_hand_player_statistics.flg_f_bet OR tourney_holdem_hand_player_statistics.cnt_f_raise > 0) and tourney_holdem_hand_player_statistics.flg_won_hand  and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then  1 else  0 end))), (sum( (case when( tourney_holdem_hand_player_statistics.cnt_f_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand  and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then  1 else  0 end))), (sum( (case when( tourney_holdem_hand_player_statistics.cnt_p_raise > 0 and tourney_holdem_hand_player_statistics.flg_won_hand  and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then  1 else  0 end))), (sum( (case when( tourney_holdem_hand_player_statistics.cnt_p_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand  and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then  1 else  0 end))), (sum( (case when( (tourney_holdem_hand_player_statistics.flg_r_bet OR tourney_holdem_hand_player_statistics.cnt_r_raise > 0) and tourney_holdem_hand_player_statistics.flg_won_hand  and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then  1 else  0 end))), (sum( (case when( tourney_holdem_hand_player_statistics.cnt_r_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand  and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then  1 else  0 end))), (sum( (case when( (tourney_holdem_hand_player_statistics.flg_t_bet OR tourney_holdem_hand_player_statistics.cnt_t_raise > 0) and tourney_holdem_hand_player_statistics.flg_won_hand  and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then  1 else  0 end))), (sum( (case when( tourney_holdem_hand_player_statistics.cnt_t_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand  and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then  1 else  0 end))), (sum((SELECT Tourney_GetM(tourney_holdem_hand_player_statistics.id_hand, tourney_holdem_hand_player_statistics.id_player, 0)))) FROM    tourney_holdem_hand_player_statistics , tourney_holdem_hand_player_detail, tourney_holdem_hand_summary, lookup_actions lookup_actions_p, lookup_actions lookup_actions_f, tourney_holdem_blinds, lookup_positions, lookup_actions lookup_actions_r, lookup_actions lookup_actions_t WHERE (tourney_holdem_hand_player_statistics.id_hand = tourney_holdem_hand_player_detail.id_hand AND tourney_holdem_hand_player_statistics.id_player = tourney_holdem_hand_player_detail.id_player)  AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_statistics.id_hand)  AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds)  AND (lookup_positions."position"=tourney_holdem_hand_player_statistics."position" AND lookup_positions.cnt_players=tourney_holdem_hand_player_statistics.cnt_players)  AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_detail.id_hand)  AND (lookup_actions_p.id_action=tourney_holdem_hand_player_detail.id_action_p)  AND (lookup_actions_f.id_action=tourney_holdem_hand_player_detail.id_action_f)  AND (lookup_actions_r.id_action=tourney_holdem_hand_player_detail.id_action_r)  AND (lookup_actions_t.id_action=tourney_holdem_hand_player_detail.id_action_t)  AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_summary.id_blinds)  AND (tourney_holdem_hand_player_statistics.id_player = {1})    GROUP BY tourney_holdem_hand_player_statistics.id_player, tourney_holdem_hand_player_statistics.id_blinds, tourney_holdem_hand_summary.cnt_players,  ((case when( lookup_positions.flg_blinds) then  0 else  (case when( lookup_positions.flg_ep) then  1 else  (case when( lookup_positions.flg_mp) then  2 else  3  end)  end)  end))

[kraada]

That's odd - nothing in between those bits? It should be going all the way to 100% first . . .

[MixMastaPJ]

got to 100% finally, configuring the HUD tonight

[WhiteRider]

Great - let us know how it goes.