Problem Updating Cache PT3, I need backup!

Experiencing technical difficulties? Think you've found a problem with PokerTracker 3? Report it here.

Moderator: Moderators

Problem Updating Cache PT3, I need backup!

Postby parraka » Thu Aug 16, 2012 9:05 pm

Hi, its not the first time i receive this error updating the cache, its fucking dissapointing because i have to rebuild the cache and you know that it takes a lot to make it (more than a day),
reindexing doesnt work for this, i have the same error. What can i do? Any suggestion?
Take a look at end the end Reason: Fatal Error (ERROR: division by zero )
Can it be a error in a custom stat? Please take a look. I send it in 2 msgs.

There were errors during the housekeeping process:
Unable to execute query:
SELECT holdem_hand_player_statistics.id_player, holdem_hand_player_statistics.id_limit, 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 ( (holdem_limit.amt_bb *holdem_limit.val_nlpl_mult)) 0 THEN ((holdem_hand_player_statistics.amt_won * 1.0 )/( (holdem_limit.amt_bb *holdem_limit.val_nlpl_mult))) ELSE 0 END) )), (sum(holdem_hand_player_detail.amt_blind)), (sum(holdem_hand_summary.amt_mgr)), (sum( (case when(holdem_hand_player_statistics.flg_won_hand AND holdem_hand_summary.amt_rake>.001) then (holdem_hand_summary.amt_rake * ( (holdem_hand_player_statistics.amt_won + holdem_hand_player_detail.amt_bet_ttl) * 1.0 / (holdem_hand_summary.amt_pot - holdem_hand_summary.amt_rake)) ) else 0 end))), (sum(holdem_hand_player_statistics.amt_won)), (sum( (case when( holdem_hand_player_statistics.val_curr_conv != 0) then holdem_hand_player_statistics.val_curr_conv*holdem_hand_player_statistics.amt_won else 0 end) )), (sum( (case when( holdem_hand_player_statistics.val_curr_conv = 0) then holdem_hand_player_statistics.amt_won else 0 end) )), (sum( (case when(holdem_hand_player_statistics.flg_blind_b and holdem_hand_player_statistics.flg_blind_s = false) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action LIKE 'C') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_bb_steal_fold) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))), (sum( (case when(holdem_hand_player_statistics.flg_blind_b OR holdem_hand_player_statistics.flg_blind_s OR holdem_hand_player_statistics.flg_blind_db OR holdem_hand_player_statistics.flg_blind_ds) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_3bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_f_3bet_action='C') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_f_3bet_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_f_3bet_action='R') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_3bet_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_3bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_4bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_f_4bet_action='C') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_f_4bet_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_f_4bet_action='R') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_4bet_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_4bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))), (sum((case when(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(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(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(holdem_hand_player_detail.amt_f_bet_facing > 0) then 1 else 0 end))), (sum((case when( (holdem_hand_player_statistics.flg_f_bet OR holdem_hand_player_statistics.cnt_f_raise > 0)) then 1 else 0 end))), (sum(holdem_hand_player_statistics.cnt_f_call)), (sum((case when(holdem_hand_player_statistics.cnt_f_call > 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_cbet) then 1 else 0 end))), (sum((case when(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 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 holdem_hand_player_statistics.enum_f_cbet_action='C') then 1 else 0 end))), (sum((case when(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 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 holdem_hand_player_statistics.enum_f_cbet_action='F') then 1 else 0 end))), (sum((case when(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 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 holdem_hand_player_statistics.enum_f_cbet_action='R') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_cbet_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_cbet and holdem_hand_player_statistics.flg_f_face_raise) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_cbet and lookup_actions_f.action LIKE 'BF') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_cbet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_cbet AND NOT(holdem_hand_player_statistics.flg_t_saw) AND NOT(holdem_hand_player_statistics.flg_f_face_raise)) then 1 else 0 end)) ), (sum((case when(holdem_hand_player_statistics.flg_f_check) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_check_raise) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_check AND (holdem_hand_player_statistics.cnt_f_raise > 0 OR holdem_hand_player_statistics.cnt_f_call > 0 OR holdem_hand_player_statistics.flg_f_fold)) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_face_raise AND NOT(holdem_hand_player_statistics.flg_p_3bet OR holdem_hand_player_statistics.flg_p_4bet) AND holdem_hand_player_statistics.flg_f_bet AND NOT(holdem_hand_player_statistics.flg_f_cbet_opp) AND ((holdem_hand_summary.cnt_players > 2 and holdem_hand_player_detail.val_p_raise_aggressor_pos 0 AND NOT(holdem_hand_player_detail.flg_f_open_opp)) then 1 else 0 end))), (sum((case when(lookup_actions_p.action LIKE '%R' and holdem_hand_player_detail.amt_f_bet_facing > 0 and NOT(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 holdem_hand_player_detail.amt_f_bet_facing > 0 and NOT(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 holdem_hand_player_detail.amt_f_bet_facing > 0 and NOT(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( holdem_hand_player_statistics.flg_p_face_raise AND NOT(holdem_hand_player_statistics.flg_p_3bet OR holdem_hand_player_statistics.flg_p_4bet) AND (holdem_hand_player_detail.flg_f_open_opp) AND NOT(holdem_hand_player_statistics.flg_f_cbet_opp) AND ((holdem_hand_summary.cnt_players > 2 and holdem_hand_player_detail.val_p_raise_aggressor_pos holdem_hand_player_statistics.position)OR (holdem_hand_summary.cnt_players = 2 AND holdem_hand_player_statistics.flg_blind_s))) then 1 else 0 end) ) ), (sum ( (case when( lookup_actions_f.action LIKE 'BC' and holdem_hand_player_statistics.flg_f_face_raise AND ((holdem_hand_player_detail.val_f_raise_aggressor_pos > holdem_hand_player_statistics.position) OR (holdem_hand_summary.cnt_players = 2 AND holdem_hand_player_statistics.flg_blind_s))) then 1 else 0 end) ) ), (sum ( (case when( lookup_actions_f.action LIKE 'BF' and holdem_hand_player_statistics.flg_f_face_raise AND ((holdem_hand_player_detail.val_f_raise_aggressor_pos > holdem_hand_player_statistics.position) OR (holdem_hand_summary.cnt_players = 2 AND holdem_hand_player_statistics.flg_blind_s))) then 1 else 0 end) ) ), (sum ( (case when( lookup_actions_f.action LIKE 'BR' and holdem_hand_player_statistics.flg_f_face_raise AND ((holdem_hand_player_detail.val_f_raise_aggressor_pos > holdem_hand_player_statistics.position) OR (holdem_hand_summary.cnt_players = 2 AND holdem_hand_player_statistics.flg_blind_s))) then 1 else 0 end) ) ), (sum((case when( holdem_hand_player_statistics.flg_p_face_raise and holdem_hand_player_statistics.cnt_p_raise = 0 and holdem_hand_player_statistics.cnt_p_call = 1 and holdem_hand_player_detail.flg_f_open_opp and holdem_hand_player_statistics.flg_f_bet and holdem_hand_player_detail.val_p_raise_aggressor_pos > holdem_hand_player_statistics.position) then 1 else 0 end))), (sum((case when( not(holdem_hand_player_statistics.flg_p_face_raise) and lookup_actions_p.action LIKE '%R' and holdem_hand_player_detail.flg_f_open_opp and holdem_hand_player_statistics.flg_f_check and holdem_hand_player_detail.amt_f_bet_facing > 0) then 1 else 0 end))), (sum((case when( not(holdem_hand_player_statistics.flg_p_face_raise) and lookup_actions_p.action LIKE '%R' and holdem_hand_player_detail.flg_f_open_opp and 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(holdem_hand_player_statistics.flg_p_face_raise) and lookup_actions_p.action LIKE '%R' and holdem_hand_player_detail.flg_f_open_opp and 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(holdem_hand_player_statistics.flg_p_face_raise) and lookup_actions_p.action LIKE '%R' and holdem_hand_player_detail.flg_f_open_opp and 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( holdem_hand_player_statistics.flg_p_face_raise and holdem_hand_player_statistics.cnt_p_raise = 0 and holdem_hand_player_statistics.cnt_p_call = 1 and holdem_hand_player_detail.flg_f_open_opp and holdem_hand_player_detail.val_p_raise_aggressor_pos > holdem_hand_player_statistics.position) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))), (sum(holdem_hand_player_statistics.cnt_f_raise)), (sum((case when(holdem_hand_player_statistics.flg_f_face_raise AND holdem_hand_player_statistics.cnt_f_call > 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_face_raise AND holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_face_raise) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_won_hand AND holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_f_call)) + (sum((case when(holdem_hand_player_statistics.flg_f_check) then 1 else 0 end))) + (sum((case when(holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_f_raise)), (sum( (case when(holdem_hand_player_statistics.flg_p_open AND holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))), (sum( (case when( (holdem_hand_player_statistics.flg_f_bet OR holdem_hand_player_statistics.cnt_f_raise > 0) and NOT(holdem_hand_player_statistics.flg_won_hand) and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))), (sum( (case when( holdem_hand_player_statistics.cnt_f_call > 0 and NOT(holdem_hand_player_statistics.flg_won_hand) and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))), (sum( (case when( (holdem_hand_player_statistics.cnt_p_raise > 0) and NOT(holdem_hand_player_statistics.flg_won_hand) and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))), (sum( (case when( holdem_hand_player_statistics.cnt_p_call > 0 and NOT(holdem_hand_player_statistics.flg_won_hand) and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))), (sum( (case when( (holdem_hand_player_statistics.flg_r_bet OR holdem_hand_player_statistics.cnt_r_raise > 0) and NOT(holdem_hand_player_statistics.flg_won_hand) and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))), (sum( (case when( holdem_hand_player_statistics.cnt_r_call > 0 and NOT(holdem_hand_player_statistics.flg_won_hand) and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))), (sum( (case when( (holdem_hand_player_statistics.flg_t_bet OR holdem_hand_player_statistics.cnt_t_raise > 0) and NOT(holdem_hand_player_statistics.flg_won_hand) and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))), (sum( (case when( holdem_hand_player_statistics.cnt_t_call > 0 and NOT(holdem_hand_player_statistics.flg_won_hand) and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))), (sum((case when(holdem_hand_summary.amt_rake > 0) then 1 else 0 end))), (sum((case when(holdem_hand_summary.cnt_players_f > 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_p_4bet_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_p_3bet_action='C') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_p_3bet_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_p_3bet_action='F' and holdem_hand_player_statistics.flg_p_first_raise and not(holdem_hand_player_statistics.flg_steal_att)) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_p_3bet_action='R') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet_def_opp and holdem_hand_player_statistics.flg_p_first_raise and not(holdem_hand_player_statistics.flg_steal_att)) then 1 else 0 end))), (sum((case when( (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.enum_f_cbet_action='C') then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.cnt_p_raise > 0 AND holdem_hand_player_statistics.flg_p_3bet_def_opp AND holdem_hand_player_statistics.enum_f_cbet_action='F') then 1 else 0 end))), (sum((case when( (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.enum_f_cbet_action='R') then 1 else 0 end))), (sum((case when( (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.flg_f_cbet_def_opp) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_3bet and holdem_hand_player_statistics.enum_p_4bet_action = 'F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_4bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_p_4bet_action='C') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_p_4bet_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_p_4bet_action='R') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_4bet_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_4bet_opp) then 1 else 0 end))), (sum((case when(substring(lookup_actions_p.action from 1 for 1)='F' AND holdem_hand_player_statistics.position = 8 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 9 AND holdem_hand_player_statistics.flg_blind_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 8 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 9 AND holdem_hand_player_statistics.flg_blind_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 8 AND holdem_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action='C' AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 9) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 8 AND holdem_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action='F' AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 9) then 1 else 0 end))), (sum((case when(lookup_actions_p.action LIKE 'R%' AND holdem_hand_player_statistics.position = 8 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 9 AND holdem_hand_player_statistics.flg_blind_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))), (sum(holdem_hand_player_statistics.cnt_p_call)), (sum((case when(holdem_hand_player_statistics.cnt_p_call > 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))), (sum( (case when( NOT(NOT(holdem_hand_player_statistics.flg_p_face_raise) OR (holdem_hand_player_statistics.flg_p_limp) OR (holdem_hand_player_statistics.flg_p_first_raise)) AND (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(holdem_hand_player_statistics.flg_p_face_raise) then 1 else 0 end))), (sum( (case when( ((NOT holdem_hand_player_statistics.flg_p_face_raise) OR holdem_hand_player_statistics.flg_p_limp OR holdem_hand_player_statistics.flg_p_first_raise) AND NOT holdem_hand_player_statistics.flg_p_open_opp AND lookup_actions_p.action '') then 1 else 0 end) )), (sum( (case when(holdem_hand_player_statistics.flg_p_first_raise) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))), (sum( (case when(holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end) )), (sum( (case when( (NOT(holdem_hand_player_statistics.flg_p_face_raise) OR (holdem_hand_player_statistics.flg_p_limp) OR (holdem_hand_player_statistics.flg_p_first_raise)) AND NOT(holdem_hand_player_statistics.flg_blind_b) AND NOT(holdem_hand_player_statistics.flg_p_open_opp)) then 1 else 0 end) )), (sum( (case when(holdem_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'CC%') then 1 else 0 end) )), (sum( (case when(holdem_hand_player_statistics.flg_p_limp AND holdem_hand_player_statistics.flg_p_face_raise = true) then 1 else 0 end) )), (sum( (case when(holdem_hand_player_statistics.flg_p_limp AND lookup_actions_p.action = 'CF') then 1 else 0 end) )), (sum( (case when( (NOT(holdem_hand_player_statistics.flg_p_face_raise) OR (holdem_hand_player_statistics.flg_p_limp) OR (holdem_hand_player_statistics.flg_p_first_raise)) AND NOT(holdem_hand_player_statistics.flg_blind_b)) then 1 else 0 end) )), (sum( (case when(holdem_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'CR%') then 1 else 0 end) )), (sum((case when(holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end))), (sum((case when( (holdem_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'C%C%') OR ((NOT holdem_hand_player_statistics.flg_p_limp) AND lookup_actions_p.action LIKE '%C%') ) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_face_raise) then 1 else 0 end))), (sum(holdem_hand_player_statistics.cnt_p_raise)), (sum( (case when(holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end)) ), (sum( (case when( holdem_hand_player_statistics.flg_p_first_raise AND NOT holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end) )), (sum( (case when(holdem_hand_player_statistics.flg_p_squeeze) then 1 else 0 end) )), (sum( (case when(holdem_hand_player_statistics.flg_p_squeeze_def_opp AND holdem_hand_player_statistics.enum_p_squeeze_action = 'C') then 1 else 0 end) )), (sum( (case when(holdem_hand_player_statistics.flg_p_squeeze_def_opp AND holdem_hand_player_statistics.enum_p_squeeze_action = 'F') then 1 else 0 end) )), (sum( (case when(holdem_hand_player_statistics.flg_p_squeeze_def_opp) then 1 else 0 end) )), (sum( (case when(holdem_hand_player_statistics.flg_p_squeeze_def_opp AND holdem_hand_player_statistics.enum_p_squeeze_action = 'R') then 1 else 0 end) )), (sum( (case when( holdem_hand_player_statistics.flg_p_squeeze_opp) then 1 else 0 end) )), (sum(holdem_hand_player_statistics.cnt_p_call)) + (sum((case when(holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))) + (sum(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(holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0 AND 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(holdem_hand_player_statistics.cnt_p_raise > 0 AND 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(holdem_hand_player_statistics.cnt_p_raise > 0 AND 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(holdem_hand_player_statistics.cnt_p_raise > 0 AND 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(holdem_hand_player_statistics.cnt_p_raise > 0 AND 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(holdem_hand_player_statistics.cnt_p_raise > 0 AND (NOT 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(holdem_hand_player_statistics.cnt_p_raise > 0 AND 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(holdem_hand_player_statistics.flg_p_open = false AND holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))), (sum( (case when(holdem_hand_player_statistics.flg_p_open = false AND holdem_hand_player_statistics.cnt_p_raise > 0 AND holdem_hand_player_statistics.flg_p_limp = false AND holdem_hand_player_statistics.flg_p_ccall = false) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_3bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_r_3bet_action='C') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_r_3bet_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_r_3bet_action='R') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_3bet_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_3bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_4bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_r_4bet_action='C') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_r_4bet_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_r_4bet_action='R') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_4bet_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_4bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))), (sum((case when(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(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(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(holdem_hand_player_detail.amt_r_bet_facing > 0) then 1 else 0 end))), (sum((case when( (holdem_hand_player_statistics.flg_r_bet OR holdem_hand_player_statistics.cnt_r_raise > 0)) then 1 else 0 end))), (sum(holdem_hand_player_statistics.cnt_r_call)), (sum((case when(holdem_hand_player_statistics.cnt_r_call > 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_cbet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_r_cbet_action='C') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_r_cbet_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_r_cbet_action='R') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_cbet_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_cbet and holdem_hand_player_statistics.flg_r_face_raise) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_cbet and lookup_actions_r.action LIKE 'BF') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_cbet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_check) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_check_raise) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_check AND (holdem_hand_player_statistics.cnt_r_raise > 0 OR holdem_hand_player_statistics.cnt_r_call > 0 OR holdem_hand_player_statistics.flg_r_fold)) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_donk) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_r_donk_action='C') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_r_donk_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_r_donk_action='R') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_donk_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_donk_opp) then 1 else 0 end))), (sum ( (case when( flg_r_bet AND holdem_hand_player_statistics.flg_r_face_raise AND ((holdem_hand_player_detail.val_r_raise_aggressor_pos > holdem_hand_player_statistics.position) OR (holdem_hand_summary.cnt_players = 2 AND holdem_hand_player_statistics.flg_blind_s))) then 1 else 0 end) ) ), (sum ( (case when( lookup_actions_r.action LIKE 'BC' and holdem_hand_player_statistics.flg_r_face_raise AND ((holdem_hand_player_detail.val_r_raise_aggressor_pos > holdem_hand_player_statistics.position) OR (holdem_hand_summary.cnt_players = 2 AND holdem_hand_player_statistics.flg_blind_s))) then 1 else 0 end) ) ), (sum ( (case when( lookup_actions_r.action LIKE 'BF' and holdem_hand_player_statistics.flg_r_face_raise AND ((holdem_hand_player_detail.val_r_raise_aggressor_pos > holdem_hand_player_statistics.position) OR (holdem_hand_summary.cnt_players = 2 AND holdem_hand_player_statistics.flg_blind_s))) then 1 else 0 end) ) ), (sum ( (case when( lookup_actions_r.action LIKE 'BR' and holdem_hand_player_statistics.flg_r_face_raise AND ((holdem_hand_player_detail.val_r_raise_aggressor_pos > holdem_hand_player_statistics.position) OR (holdem_hand_summary.cnt_players = 2 AND holdem_hand_player_statistics.flg_blind_s))) then 1 else 0 end) ) ), (sum((case when(holdem_hand_player_statistics.flg_r_float) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_r_float_action='C') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_r_float_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_r_float_action='R') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_float_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_float_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_bet and lookup_actions_t.action LIKE 'X' and 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(holdem_hand_player_detail.flg_r_open_opp and lookup_actions_t.action LIKE 'X' and holdem_hand_player_statistics.enum_f_cbet_action = 'C' and NOT(lookup_actions_f.action LIKE '%R')) then 1 else 0 end)) ), (sum(holdem_hand_player_statistics.cnt_r_raise)), (sum((case when(holdem_hand_player_statistics.flg_r_face_raise AND holdem_hand_player_statistics.cnt_r_call > 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_face_raise AND holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_face_raise) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.cnt_r_raise > 0 AND holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.cnt_r_raise > 0 AND holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_saw) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_r_call)) + (sum((case when(holdem_hand_player_statistics.flg_r_check) then 1 else 0 end))) + (sum((case when(holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_r_raise)), (sum( (case when(holdem_hand_player_statistics.flg_blind_b = false AND holdem_hand_player_statistics.flg_blind_s) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_s AND lookup_actions_p.action LIKE 'C') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_sb_steal_fold) then 1 else 0 end))), (sum( (case when( holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))), (count(distinct holdem_hand_player_statistics.id_session)), (count( (SELECT (case when(sum(hhps_s.amt_won) > 0) then 1 else 0 end) FROM holdem_hand_player_statistics hhps_s WHERE id_session = holdem_hand_player_statistics.id_session) )), (sum((case when(holdem_hand_player_statistics.flg_steal_att) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.position=0) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.position=1) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.enum_folded'N') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_steal_att AND NOT holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.position=9) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when(holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_b) then 1 else 0 end))), (sum( (case when(holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_b) then 1 else 0 end))) - (sum((case when(holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_won_hand AND holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_won_hand AND NOT holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when(holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_s) then 1 else 0 end))), (sum( (case when(holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_s) then 1 else 0 end))) - (sum((case when(holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.flg_won_hand AND holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.flg_won_hand AND NOT holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_steal_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_steal_opp AND holdem_hand_player_statistics.position=0) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_steal_opp AND holdem_hand_player_statistics.position=1) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_steal_opp AND holdem_hand_player_statistics.position=9) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.flg_p_3bet_def_opp AND holdem_hand_player_statistics.enum_p_3bet_action='F') then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.flg_p_3bet_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_steal_att AND NOT(holdem_hand_player_statistics.flg_f_saw) AND NOT(holdem_hand_player_statistics.flg_p_face_raise)) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.flg_won_hand AND holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.flg_won_hand AND NOT holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_3bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_t_3bet_action='C') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_t_3bet_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_t_3bet_action='R') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_3bet_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_3bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_4bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_t_4bet_action='C') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_t_4bet_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_t_4bet_action='R') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_4bet_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_4bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))), (sum((case when(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(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(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(holdem_hand_player_detail.amt_t_bet_facing > 0) then 1 else 0 end))), (sum((case when( (holdem_hand_player_statistics.flg_t_bet OR holdem_hand_player_statistics.cnt_t_raise > 0)) then 1 else 0 end))), (sum(holdem_hand_player_statistics.cnt_t_call)), (sum((case when(holdem_hand_player_statistics.cnt_t_call > 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_cbet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_t_cbet_action='C') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_t_cbet_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_t_cbet_action='R') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_cbet_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_cbet and holdem_hand_player_statistics.flg_t_face_raise) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_cbet and lookup_actions_t.action LIKE 'BF') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_cbet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_check) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_check_raise) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_check AND (holdem_hand_player_statistics.cnt_t_raise > 0 OR holdem_hand_player_statistics.cnt_t_call > 0 OR holdem_hand_player_statistics.flg_t_fold)) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_donk) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_t_donk_action='C') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_t_donk_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_t_donk_action='R') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_donk_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_donk_opp) then 1 else 0 end))), (sum ( (case when( flg_t_bet AND holdem_hand_player_statistics.flg_t_face_raise AND ((holdem_hand_player_detail.val_t_raise_aggressor_pos > holdem_hand_player_statistics.position) OR (holdem_hand_summary.cnt_players = 2 AND holdem_hand_player_statistics.flg_blind_s))) then 1 else 0 end) ) ), (sum ( (case when( lookup_actions_t.action LIKE 'BC' and holdem_hand_player_statistics.flg_t_face_raise AND ((holdem_hand_player_detail.val_t_raise_aggressor_pos > holdem_hand_player_statistics.position) OR (holdem_hand_summary.cnt_players = 2 AND holdem_hand_player_statistics.flg_blind_s))) then 1 else 0 end) ) ), (sum ( (case when( lookup_actions_t.action LIKE 'BF' and holdem_hand_player_statistics.flg_t_face_raise AND ((holdem_hand_player_detail.val_t_raise_aggressor_pos > holdem_hand_player_statistics.position) OR (holdem_hand_summary.cnt_players = 2 AND holdem_hand_player_statistics.flg_blind_s))) then 1 else 0 end) ) ), (sum ( (case when( lookup_actions_t.action LIKE 'BR' and holdem_hand_player_statistics.flg_t_face_raise AND ((holdem_hand_player_detail.val_t_raise_aggressor_pos > holdem_hand_player_statistics.position) OR (holdem_hand_summary.cnt_players = 2 AND holdem_hand_player_statistics.flg_blind_s))) then 1 else 0 end) ) ), (sum((case when(holdem_hand_player_statistics.flg_t_float) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_t_float_action='C') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_t_float_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_t_float_action='R') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_float_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_float_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_bet and lookup_actions_f.action LIKE 'X' and lookup_actions_p.action NOT LIKE '%R' and holdem_hand_player_statistics.flg_p_face_raise and not(holdem_hand_player_detail.flg_t_has_position)) then 1 else 0 end)) ), (sum((case when(holdem_hand_player_detail.flg_t_open_opp and lookup_actions_f.action LIKE 'X' and lookup_actions_p.action NOT LIKE '%R' and holdem_hand_player_statistics.flg_p_face_raise and not(holdem_hand_player_detail.flg_t_has_position)) then 1 else 0 end)) ), (sum(holdem_hand_player_statistics.cnt_t_raise)), (sum((case when(holdem_hand_player_statistics.flg_t_face_raise AND holdem_hand_player_statistics.cnt_t_call > 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_face_raise AND holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_face_raise) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.cnt_t_raise > 0 AND holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.cnt_t_raise > 0 AND holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_saw) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_t_call)) + (sum((case when(holdem_hand_player_statistics.flg_t_check) then 1 else 0 end))) + (sum((case when(holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_t_raise)), (sum(holdem_hand_player_statistics.cnt_p_call)) + (sum((case when(holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))) + (sum(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(holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_f_call)) + (sum((case when(holdem_hand_player_statistics.flg_f_check) then 1 else 0 end))) + (sum((case when(holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_f_raise)) + (sum((case when(holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_t_call)) + (sum((case when(holdem_hand_player_statistics.flg_t_check) then 1 else 0 end))) + (sum((case when(holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_t_raise)) + (sum((case when(holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_r_call)) + (sum((case when(holdem_hand_player_statistics.flg_r_check) then 1 else 0 end))) + (sum((case when(holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_r_raise)), (sum((case when(holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))), (sum( (case when(holdem_hand_player_statistics.flg_blind_b = false AND holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.flg_vpip) then 1 else 0 end) )), (sum((case when(holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))), (sum( (case when(holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when((holdem_hand_player_statistics.flg_f_bet OR holdem_hand_player_statistics.cnt_f_raise > 0) and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when( holdem_hand_player_statistics.cnt_f_call > 0 and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when(holdem_hand_player_statistics.cnt_p_raise > 0 and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when( holdem_hand_player_statistics.cnt_p_call > 0 and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when((holdem_hand_player_statistics.flg_r_bet OR holdem_hand_player_statistics.cnt_r_raise > 0) and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when( holdem_hand_player_statistics.cnt_r_call > 0 and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when((holdem_hand_player_statistics.flg_t_bet OR holdem_hand_player_statistics.cnt_t_raise > 0) and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when( holdem_hand_player_statistics.cnt_t_call > 0 and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when(holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))), (sum( (case when( (holdem_hand_player_statistics.flg_f_bet OR holdem_hand_player_statistics.cnt_f_raise > 0) and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when( holdem_hand_player_statistics.cnt_f_call > 0 and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when( holdem_hand_player_statistics.cnt_p_raise > 0 and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when( holdem_hand_player_statistics.cnt_p_call > 0 and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when( (holdem_hand_player_statistics.flg_r_bet OR holdem_hand_player_statistics.cnt_r_raise > 0) and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when( holdem_hand_player_statistics.cnt_r_call > 0 and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when( (holdem_hand_player_statistics.flg_t_bet OR holdem_hand_player_statistics.cnt_t_raise > 0) and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when( holdem_hand_player_statistics.cnt_t_call > 0 and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when( (holdem_hand_player_statistics.flg_f_bet OR holdem_hand_player_statistics.cnt_f_raise > 0) and holdem_hand_player_statistics.flg_won_hand and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))), (sum( (case when( holdem_hand_player_statistics.cnt_f_call > 0 and holdem_hand_player_statistics.flg_won_hand and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))), (sum( (case when( holdem_hand_player_statistics.cnt_p_raise > 0 and holdem_hand_player_statistics.flg_won_hand and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))), (sum( (case when( holdem_hand_player_statistics.cnt_p_call > 0 and holdem_hand_player_statistics.flg_won_hand and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))), (sum( (case when( (holdem_hand_player_statistics.flg_r_bet OR holdem_hand_player_statistics.cnt_r_raise > 0) and holdem_hand_player_statistics.flg_won_hand and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))), (sum( (case when( holdem_hand_player_statistics.cnt_r_call > 0 and holdem_hand_player_statistics.flg_won_hand and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))), (sum( (case when( (holdem_hand_player_statistics.flg_t_bet OR holdem_hand_player_statistics.cnt_t_raise > 0) and holdem_hand_player_statistics.flg_won_hand and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))), (sum( (case when( holdem_hand_player_statistics.cnt_t_call > 0 and holdem_hand_player_statistics.flg_won_hand and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet and not(holdem_hand_player_statistics.flg_p_4bet) and holdem_hand_player_statistics.flg_f_cbet and lookup_actions_f.action LIKE 'B_%') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet and not(holdem_hand_player_statistics.flg_p_4bet) and holdem_hand_player_statistics.flg_f_cbet and lookup_actions_f.action = 'BF') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_f_cbet_action='F' AND holdem_hand_player_detail.flg_f_has_position AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_f_cbet_action='F' AND NOT holdem_hand_player_detail.flg_f_has_position AND
parraka
 
Posts: 79
Joined: Tue Jan 04, 2011 2:49 pm

Re: Problem Updating Cache PT3, I need backup!

Postby parraka » Thu Aug 16, 2012 9:06 pm

NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_f_cbet_action='R' AND NOT holdem_hand_player_detail.flg_f_has_position AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_cbet_def_opp AND holdem_hand_player_detail.flg_f_has_position AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_cbet_def_opp AND NOT holdem_hand_player_detail.flg_f_has_position AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_cbet and holdem_hand_player_statistics.flg_f_face_raise AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp)) ) then 1 else 0 end)) ), (sum((case when(holdem_hand_player_statistics.flg_f_cbet and lookup_actions_f.action LIKE 'BF' AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp)) ) then 1 else 0 end)) ), (sum((case when(holdem_hand_player_detail.flg_f_has_position AND holdem_hand_player_statistics.flg_f_cbet AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when(NOT holdem_hand_player_detail.flg_f_has_position AND holdem_hand_player_statistics.flg_f_cbet AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when(holdem_hand_player_detail.flg_f_has_position AND holdem_hand_player_statistics.flg_f_cbet_opp AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_cbet_opp AND NOT holdem_hand_player_detail.flg_f_has_position AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_detail.flg_f_open and substring(lookup_actions_f.action from 1 for 2) = 'BF' AND NOT holdem_hand_player_statistics.flg_f_cbet_opp AND (holdem_hand_player_detail.val_p_raise_aggressor_pos 0 and substring(lookup_actions_f.action from 1 for 2) = 'XF' AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when( not(holdem_hand_player_statistics.flg_p_face_raise) and lookup_actions_p.action LIKE '%R' and holdem_hand_player_detail.flg_f_open_opp and holdem_hand_player_statistics.flg_f_check and holdem_hand_player_detail.amt_f_bet_facing > 0 AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), ( sum((case when( holdem_hand_player_statistics.flg_p_face_raise and holdem_hand_player_statistics.cnt_p_raise = 0 and holdem_hand_player_statistics.cnt_p_call = 1 and holdem_hand_player_detail.flg_f_open_opp and holdem_hand_player_detail.val_p_raise_aggressor_pos > holdem_hand_player_statistics.position AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_face_raise and holdem_hand_player_statistics.cnt_p_raise = 0 and holdem_hand_player_statistics.cnt_p_call = 1 and holdem_hand_player_detail.flg_f_open_opp and holdem_hand_player_statistics.flg_f_bet and holdem_hand_player_detail.val_p_raise_aggressor_pos > holdem_hand_player_statistics.position AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet and holdem_hand_player_statistics.position = 8) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet and holdem_hand_player_statistics.position = 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet and holdem_hand_player_statistics.position = 1) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet and holdem_hand_player_statistics.position = 2) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet and holdem_hand_player_statistics.position = 9) then 1 else 0 end))), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.enum_p_3bet_action='F')) then 1 else 0 end)) ), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.flg_p_fold) and (holdem_hand_player_statistics.position = 0)) then 1 else 0 end)) ), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.flg_p_fold) and (holdem_hand_player_statistics.position = 1)) then 1 else 0 end)) ), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.flg_p_fold) and (holdem_hand_player_statistics.position = 2)) then 1 else 0 end)) ), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.flg_p_fold) and (holdem_hand_player_statistics.position = 9)) then 1 else 0 end)) ), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.flg_p_fold) and (holdem_hand_player_statistics.position = 3)) then 1 else 0 end))), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.enum_p_3bet_action='C')) then 1 else 0 end)) ), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.enum_p_3bet_action='C' and (holdem_hand_player_statistics.position = 0))) then 1 else 0 end)) ), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.enum_p_3bet_action='C' and (holdem_hand_player_statistics.position = 1))) then 1 else 0 end)) ), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.enum_p_3bet_action='C' and (holdem_hand_player_statistics.position = 9))) then 1 else 0 end)) ), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.enum_p_3bet_action='C' and (holdem_hand_player_statistics.position = 3))) then 1 else 0 end)) ), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.enum_p_3bet_action='C' and (holdem_hand_player_statistics.position = 2))) then 1 else 0 end)) ), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.flg_p_face_raise) ) then 1 else 0 end))), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.flg_p_face_raise) and (holdem_hand_player_statistics.position = 0) ) then 1 else 0 end))), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.flg_p_face_raise) and (holdem_hand_player_statistics.position = 1) ) then 1 else 0 end))), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.flg_p_face_raise) and (holdem_hand_player_statistics.position = 2) ) then 1 else 0 end))), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.flg_p_face_raise) and (holdem_hand_player_statistics.position = 9) ) then 1 else 0 end))), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.flg_p_face_raise) and (holdem_hand_player_statistics.position = 3) ) then 1 else 0 end))), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.enum_p_3bet_action='R')) then 1 else 0 end)) ), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.enum_p_3bet_action='R' and (holdem_hand_player_statistics.position = 0))) then 1 else 0 end)) ), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.enum_p_3bet_action='R' and (holdem_hand_player_statistics.position = 1))) then 1 else 0 end)) ), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.enum_p_3bet_action='R' and (holdem_hand_player_statistics.position = 9))) then 1 else 0 end)) ), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.enum_p_3bet_action='R' and (holdem_hand_player_statistics.position = 3))) then 1 else 0 end)) ), (sum((case when((holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.enum_p_3bet_action='R' and (holdem_hand_player_statistics.position = 2))) then 1 else 0 end)) ), (sum((case when( holdem_hand_player_statistics.flg_p_3bet_def_opp AND holdem_hand_player_statistics.enum_f_cbet_action='F' AND holdem_hand_player_detail.flg_f_has_position) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_3bet_def_opp AND holdem_hand_player_statistics.enum_f_cbet_action='F' AND NOT holdem_hand_player_detail.flg_f_has_position) then 1 else 0 end))), (sum((case when( (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.enum_f_cbet_action='R' AND holdem_hand_player_detail.flg_f_has_position) then 1 else 0 end))), (sum((case when( (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.enum_f_cbet_action='R' AND NOT holdem_hand_player_detail.flg_f_has_position) then 1 else 0 end))), (sum((case when( (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.flg_f_cbet_def_opp AND holdem_hand_player_detail.flg_f_has_position ) then 1 else 0 end))), (sum((case when( (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.flg_f_cbet_def_opp AND NOT holdem_hand_player_detail.flg_f_has_position ) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_f_cbet AND holdem_hand_player_detail.flg_f_has_position) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_f_cbet AND NOT holdem_hand_player_detail.flg_f_has_position) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_f_cbet_opp AND holdem_hand_player_detail.flg_f_has_position) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_f_cbet_opp AND NOT holdem_hand_player_detail.flg_f_has_position) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet_opp and holdem_hand_player_statistics.position=8) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet_opp and holdem_hand_player_statistics.position=0) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet_opp and holdem_hand_player_statistics.position=1) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet_opp and holdem_hand_player_statistics.position=2) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet_opp and holdem_hand_player_statistics.position=9) then 1 else 0 end))), (sum((case when( (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.enum_t_cbet_action='F' AND holdem_hand_player_detail.flg_t_has_position) then 1 else 0 end))), (sum((case when( (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.enum_t_cbet_action='F' AND NOT holdem_hand_player_detail.flg_t_has_position) then 1 else 0 end))), (sum((case when( (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.enum_t_cbet_action='R' AND holdem_hand_player_detail.flg_t_has_position) then 1 else 0 end))), (sum((case when( (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.enum_t_cbet_action='R' AND NOT holdem_hand_player_detail.flg_t_has_position) then 1 else 0 end))), (sum((case when( (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.flg_t_cbet_def_opp AND holdem_hand_player_detail.flg_t_has_position) then 1 else 0 end))), (sum((case when( (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.flg_t_cbet_def_opp AND NOT holdem_hand_player_detail.flg_t_has_position) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_t_cbet AND holdem_hand_player_detail.flg_t_has_position) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_t_cbet AND NOT holdem_hand_player_detail.flg_t_has_position) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_t_cbet_opp AND holdem_hand_player_detail.flg_t_has_position) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_t_cbet_opp AND NOT holdem_hand_player_detail.flg_t_has_position) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 8 AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 AND lookup_actions_p.action='C') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 8 AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 AND lookup_actions_p.action='F') then 1 else 0 end))), (sum((case when(lookup_actions_p.action LIKE 'R%' AND holdem_hand_player_statistics.position = 8 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 AND holdem_hand_player_statistics.flg_blind_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 8 AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 1 AND lookup_actions_p.action='C') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 8 AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 1 AND lookup_actions_p.action='F') then 1 else 0 end))), (sum((case when(lookup_actions_p.action LIKE 'R%' AND holdem_hand_player_statistics.position = 8 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 1 AND holdem_hand_player_statistics.flg_blind_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 8 AND holdem_hand_player_statistics.flg_blind_def_opp AND (holdem_hand_player_detail.val_p_raise_aggressor_pos = 9 OR holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 OR holdem_hand_player_detail.val_p_raise_aggressor_pos = 1) AND lookup_actions_p.action='C') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 8 AND holdem_hand_player_statistics.flg_blind_def_opp AND (holdem_hand_player_detail.val_p_raise_aggressor_pos = 9 OR holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 OR holdem_hand_player_detail.val_p_raise_aggressor_pos = 1) AND lookup_actions_p.action='F') then 1 else 0 end))), (sum((case when(lookup_actions_p.action LIKE 'R%' AND holdem_hand_player_statistics.position = 8 AND (holdem_hand_player_detail.val_p_raise_aggressor_pos = 9 OR holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 OR holdem_hand_player_detail.val_p_raise_aggressor_pos = 1) AND holdem_hand_player_statistics.flg_blind_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 9 AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 AND lookup_actions_p.action='C') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 9 AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 AND lookup_actions_p.action='F') then 1 else 0 end))), (sum((case when(lookup_actions_p.action LIKE 'R%' AND holdem_hand_player_statistics.position = 9 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 AND holdem_hand_player_statistics.flg_blind_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 9 AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 1 AND lookup_actions_p.action='C') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 9 AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 1 AND lookup_actions_p.action='F') then 1 else 0 end))), (sum((case when(lookup_actions_p.action LIKE 'R%' AND holdem_hand_player_statistics.position = 9 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 1 AND holdem_hand_player_statistics.flg_blind_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 9 AND holdem_hand_player_statistics.flg_blind_def_opp AND (holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 OR holdem_hand_player_detail.val_p_raise_aggressor_pos = 1) AND lookup_actions_p.action='C') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 9 AND holdem_hand_player_statistics.flg_blind_def_opp AND (holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 OR holdem_hand_player_detail.val_p_raise_aggressor_pos = 1) AND lookup_actions_p.action='F') then 1 else 0 end))), (sum((case when(lookup_actions_p.action LIKE 'R%' AND holdem_hand_player_statistics.position = 9 AND (holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 OR holdem_hand_player_detail.val_p_raise_aggressor_pos = 1) AND holdem_hand_player_statistics.flg_blind_def_opp) then 1 else 0 end))), (sum( (case when( ((NOT holdem_hand_player_statistics.flg_p_face_raise) OR holdem_hand_player_statistics.flg_p_limp OR holdem_hand_player_statistics.flg_p_first_raise) AND NOT holdem_hand_player_statistics.flg_p_open_opp AND lookup_actions_p.action '' AND holdem_hand_player_statistics.position = 0) then 1 else 0 end) )), (sum( (case when( ((NOT holdem_hand_player_statistics.flg_p_face_raise) OR holdem_hand_player_statistics.flg_p_limp OR holdem_hand_player_statistics.flg_p_first_raise) AND NOT holdem_hand_player_statistics.flg_p_open_opp AND lookup_actions_p.action '' AND holdem_hand_player_statistics.position = 1) then 1 else 0 end) )), (sum( (case when( ((NOT holdem_hand_player_statistics.flg_p_face_raise) OR holdem_hand_player_statistics.flg_p_limp OR holdem_hand_player_statistics.flg_p_first_raise) AND NOT holdem_hand_player_statistics.flg_p_open_opp AND lookup_actions_p.action '' AND holdem_hand_player_statistics.position = 9) then 1 else 0 end) )), (sum((case when(holdem_hand_player_statistics.flg_p_open_opp AND holdem_hand_player_statistics.position = 3) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_open_opp AND holdem_hand_player_statistics.position = 2) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.flg_p_fold = false AND holdem_hand_player_statistics.cnt_p_raise=0 AND holdem_hand_player_statistics.position = 8) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.position = 8) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.flg_p_fold = false AND holdem_hand_player_statistics.cnt_p_raise=0 AND holdem_hand_player_statistics.position = 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.position = 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.flg_p_fold = false AND holdem_hand_player_statistics.cnt_p_raise=0 AND holdem_hand_player_statistics.position = 1) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.position = 1) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.flg_p_fold = false AND holdem_hand_player_statistics.cnt_p_raise=0 AND holdem_hand_player_statistics.position = 9) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.position = 9) then 1 else 0 end))), (sum( (case when(holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open_opp AND holdem_hand_player_statistics.position = 3) then 1 else 0 end)) ), (sum( (case when(holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open_opp AND holdem_hand_player_statistics.position = 2) then 1 else 0 end)) ), (sum( (case when( holdem_hand_player_statistics.flg_p_first_raise AND NOT holdem_hand_player_statistics.flg_p_open_opp AND holdem_hand_player_statistics.position = 0) then 1 else 0 end))), (sum( (case when( holdem_hand_player_statistics.flg_p_first_raise AND NOT holdem_hand_player_statistics.flg_p_open_opp AND holdem_hand_player_statistics.position = 1) then 1 else 0 end))), (sum( (case when( holdem_hand_player_statistics.flg_p_first_raise AND NOT holdem_hand_player_statistics.flg_p_open_opp AND holdem_hand_player_statistics.position = 9) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_t_cbet_action='F' AND holdem_hand_player_detail.flg_t_has_position AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_t_cbet_action='F' AND NOT holdem_hand_player_detail.flg_t_has_position AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_t_cbet_action='R' AND holdem_hand_player_detail.flg_t_has_position AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_t_cbet_action='R' AND NOT holdem_hand_player_detail.flg_t_has_position AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_cbet_def_opp AND holdem_hand_player_detail.flg_t_has_position AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_cbet_def_opp AND NOT holdem_hand_player_detail.flg_t_has_position AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_cbet and holdem_hand_player_statistics.flg_t_face_raise AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp)) ) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_cbet and lookup_actions_t.action LIKE 'BF' AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp)) ) then 1 else 0 end)) ), (sum((case when(holdem_hand_player_detail.flg_t_has_position AND holdem_hand_player_statistics.flg_t_cbet AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when(NOT holdem_hand_player_detail.flg_t_has_position AND holdem_hand_player_statistics.flg_t_cbet AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when(holdem_hand_player_detail.flg_t_has_position AND holdem_hand_player_statistics.flg_t_cbet_opp AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_cbet_opp AND NOT holdem_hand_player_detail.flg_t_has_position AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_t_float_action='F' AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_float_def_opp AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), ( sum((case when(holdem_hand_player_statistics.flg_t_float_opp AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_float AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp))) then 1 else 0 end))), (sum( (case when((holdem_hand_player_statistics.flg_f_bet) and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when((holdem_hand_player_statistics.cnt_f_raise > 0) and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when((holdem_hand_player_statistics.flg_r_bet) and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when((holdem_hand_player_statistics.flg_t_bet) and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when((holdem_hand_player_statistics.cnt_t_raise > 0) and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when( (holdem_hand_player_statistics.flg_f_bet) and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when( (holdem_hand_player_statistics.cnt_f_raise > 0) and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when( (holdem_hand_player_statistics.flg_r_bet) and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when( (holdem_hand_player_statistics.flg_t_bet) and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when( (holdem_hand_player_statistics.cnt_t_raise > 0) and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_4bet AND holdem_hand_player_statistics.flg_p_4bet_def_opp AND holdem_hand_player_statistics.enum_p_4bet_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_4bet AND holdem_hand_player_statistics.flg_p_4bet_def_opp ) then 1 else 0 end))) FROM holdem_hand_player_statistics , holdem_hand_player_detail, holdem_hand_summary, holdem_limit, lookup_positions, lookup_actions lookup_actions_p, lookup_actions lookup_actions_f, lookup_actions lookup_actions_r, lookup_actions lookup_actions_t WHERE (holdem_hand_player_statistics.id_hand = holdem_hand_player_detail.id_hand AND holdem_hand_player_statistics.id_player = holdem_hand_player_detail.id_player) AND (holdem_hand_summary.id_hand = holdem_hand_player_statistics.id_hand) AND (holdem_limit.id_limit = holdem_hand_player_statistics.id_limit) AND (lookup_positions."position"=holdem_hand_player_statistics."position" AND lookup_positions.cnt_players=holdem_hand_player_statistics.cnt_players) AND (holdem_hand_summary.id_hand = holdem_hand_player_detail.id_hand) AND (lookup_actions_p.id_action=holdem_hand_player_detail.id_action_p) AND (lookup_actions_f.id_action=holdem_hand_player_detail.id_action_f) AND (lookup_actions_r.id_action=holdem_hand_player_detail.id_action_r) AND (lookup_actions_t.id_action=holdem_hand_player_detail.id_action_t) AND (holdem_limit.id_limit = holdem_hand_summary.id_limit) AND ((holdem_hand_player_statistics.id_hand > 10830737)) AND ((holdem_hand_player_statistics.id_player = 62353)) GROUP BY holdem_hand_player_statistics.id_player, holdem_hand_player_statistics.id_limit, 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)) ; Reason: Fatal Error (ERROR: division by zero )
parraka
 
Posts: 79
Joined: Tue Jan 04, 2011 2:49 pm

Re: Problem Updating Cache PT3, I need backup!

Postby parraka » Thu Aug 16, 2012 9:08 pm

Some question for a possible future, if i backup a database and later i recover it, will be this database with the cache status equal from the previous one, i hope you understand me. I think i spend less time making backups and recovering than making a rebuild cache, i really need help with this.
parraka
 
Posts: 79
Joined: Tue Jan 04, 2011 2:49 pm

Re: Problem Updating Cache PT3, I need backup!

Postby WhiteRider » Fri Aug 17, 2012 3:59 am

That error could be caused by a custom stat, or it could be caused by a session or hand which was imported incorrectly with a 0 big blind for instance.

Before you continue, please make a Backup of your database.
(To answer your other question while we're on the subject of backups - the backup makes an exact copy of your database, including the cache, so when you restore that everything would be back to exactly as it was when you made the backup.)

Please import and run the attached report - extract the .pt3rpt file from the .zip to your computer and then on the Holdem > Cash Games > Reports tab click Import and select the saved file.
Run the report, and it should list any hands played which have a zero big blind amount.

From that you should be able to see which sessions the hands are in.
Make sure that you have the original hand history files for those sessions - these will be in the PokerTracker 3\Processed folder by default.
If you don't have the original hand histories for any reason, please export the affected sessions before continuing - we will need a hand history to re-import from.

Once you are sure you have the hand history files for all of the affected sessions, purge those sessions, and then re-import them.
Tutorial: Purging Sessions
Manual Import

If you still have zero blinds after re-importing, please compress and attach the original hand history files to a Support Ticket with a link to this thread so that I can investigate further.
Attachments
Zero BB.zip
(843 Bytes) Downloaded 150 times
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Problem Updating Cache PT3, I need backup!

Postby parraka » Fri Aug 17, 2012 5:49 am

I have a 9M Hands database. Its not the first time i receive this error, this makes my database crash and i have to rebuild the cache, more than a day. Really i dont like/understand your solution, if i make a purge, my cache status is in 0 and i have to rebuild it again.

After 2 years playing with PT its the time to move to HEM, i cant have failures like this.
parraka
 
Posts: 79
Joined: Tue Jan 04, 2011 2:49 pm

Re: Problem Updating Cache PT3, I need backup!

Postby kraada » Fri Aug 17, 2012 8:25 am

Have you considered trying PT4? Cache functionality is much improved there and works behind the scenes always; you never need to manually update the cache and you only need to rebuild in very specific support situations.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Problem Updating Cache PT3, I need backup!

Postby parraka » Fri Aug 17, 2012 9:14 am

Kraada, finally i had a recent backup for this database, i have restored it, but now it seem that all is okey, but it doesnt import hands!!! Please Kraada, lets talk via Skype, Teamviewer or whatever, this is so slow.
parraka
 
Posts: 79
Joined: Tue Jan 04, 2011 2:49 pm

Re: Problem Updating Cache PT3, I need backup!

Postby parraka » Fri Aug 17, 2012 9:19 am

I want to show you how PT4 is slower than PT3 in my case. Lets do all this work, i want to start playing without problems, i like PT, but im losing the patience, i need a particular support, im not the typical guy who only uses the hud or import 1K hands one day, if i cant get solutions for my problems i ll have to leave the ship.
parraka
 
Posts: 79
Joined: Tue Jan 04, 2011 2:49 pm

Re: Problem Updating Cache PT3, I need backup!

Postby kraada » Fri Aug 17, 2012 1:25 pm

As I said via PM, if you are not willing to answer the questions that I have for you, then I won't be able to help you.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests