Housekeeping Error

[oracle3001]

I have just imported some new hands and run housekeeping afterwards...At the end of the update cache operation I get the following error...I have made no changes to settings / stats since last doing any housekeeping. I have tried rerunning this 3 times and getting the same error. Am I going to have to rebuild the cache from scratch? Or is there something else I can do?

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_summary.id_site=200 AND flg_nlpl=FALSE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=500)) then 1.667 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=FALSE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=200)) then 1.667 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=FALSE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=100)) then 1.429 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=FALSE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=60)) then 0.909 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=FALSE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=40)) then 0.8333 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=FALSE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=30)) then 0.8333 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=FALSE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=20)) then 0.8333 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=FALSE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=10)) then 0.7692 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=FALSE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=6)) then 0.7143 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=FALSE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=4)) then 0.5556 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=FALSE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=2)) then 0.1754 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=FALSE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=1)) then 0.1754 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=FALSE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=0.5)) then 0.05 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=FALSE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=0.3)) then 0.0277 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=FALSE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=0.2)) then 0.02 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=FALSE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=0.1)) then 0.0189 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=TRUE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=50)) then 1.429 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=TRUE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=30)) then 0.909 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=TRUE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=20)) then 0.909 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=TRUE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=10)) then 0.769 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=TRUE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=6)) then 0.714 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=TRUE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=4)) then 0.588 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=TRUE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=2)) then 0.4 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=TRUE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=1)) then 0.25 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=TRUE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=0.5)) then 0.149 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=TRUE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=0.25)) then 0.1 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=TRUE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=0.1)) then 0.0263 else (case when((holdem_hand_summary.id_site=200 AND flg_nlpl=TRUE AND holdem_hand_summary.amt_rake>0 AND holdem_limit.amt_bb=0.04)) then 0.0172 else 0 end) end) end) end) end) end) end) end) end) end) end) end) end) end) end) end) end) end) end) end) end) end) end) end) end) end) end) end)) ), ((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))) * 0.27), (sum((case when(holdem_hand_summary.id_site=400 AND holdem_hand_player_detail.amt_bet_ttl > 0) then (holdem_hand_player_detail.amt_bet_ttl * 1.0 / holdem_hand_summary.amt_pot) * holdem_hand_summary.amt_rake else 0 end))), (sum((case when(holdem_hand_summary.id_site=300 AND holdem_hand_summary.amt_rake > 0) then (holdem_hand_summary.amt_rake * 10) * 1.0 / holdem_hand_summary.cnt_players else 0 end))), (count(holdem_hand_player_statistics.id_hand)), (sum((case when(holdem_hand_player_statistics.flg_p_3bet_def_opp AND 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_3bet_def_opp AND holdem_hand_player_statistics.flg_p_first_raise) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_f_cbet) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_f_cbet_opp) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_r_cbet) 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_r_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.flg_r_cbet_def_opp) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_r_cbet_opp) then 1 else 0 end)) ), (sum((case when( holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_t_cbet) 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') 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) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_t_cbet_opp) then 1 else 0 end)) ), (sum((case when(holdem_hand_player_detail.amt_r_bet_facing > 0 and holdem_hand_player_statistics.flg_t_cbet_opp and not(holdem_hand_player_statistics.flg_t_cbet) and (holdem_hand_player_detail.val_r_bet_aggressor_pos > holdem_hand_player_statistics.position) and lookup_actions_r.action = 'F') then 1 else 0 end))), (sum((case when(holdem_hand_player_detail.amt_r_bet_facing > 0 and holdem_hand_player_statistics.flg_t_cbet_opp and not(holdem_hand_player_statistics.flg_t_cbet) and holdem_hand_player_detail.val_r_bet_aggressor_pos > holdem_hand_player_statistics.position) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_cbet and (holdem_hand_player_statistics.flg_p_3bet or holdem_hand_player_statistics.flg_p_3bet_def_opp) AND NOT (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 (holdem_hand_player_statistics.flg_p_3bet or holdem_hand_player_statistics.flg_p_3bet_def_opp) AND NOT (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.amt_t_bet_facing > 0 and holdem_hand_player_statistics.flg_f_cbet_opp and not(holdem_hand_player_statistics.flg_f_cbet) and (holdem_hand_player_detail.val_t_bet_aggressor_pos > holdem_hand_player_statistics.position) and lookup_actions_t.action = 'F') then 1 else 0 end))), (sum((case when(holdem_hand_player_detail.amt_t_bet_facing > 0 and holdem_hand_player_statistics.flg_f_cbet_opp and

[oracle3001]

not(holdem_hand_player_statistics.flg_f_cbet) and holdem_hand_player_detail.val_t_bet_aggressor_pos > holdem_hand_player_statistics.position) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_4bet AND holdem_hand_player_statistics.flg_p_first_raise) 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) 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.flg_f_cbet_def_opp AND holdem_hand_player_statistics.enum_f_cbet_action='R') 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.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.flg_f_cbet AND holdem_hand_player_statistics.flg_f_face_raise AND lookup_actions_f.action LIKE 'BF') 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_statistics.flg_f_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_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 > 1852478)) AND ((holdem_hand_player_statistics.id_player = 7580)) 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 )

[kraada]

How many new hands did you import?

[oracle3001]

I don't know exactly 100k or so.

[kraada]

What site were these hands from? Were they new hands or old hands? It seems most likely from the error that something imported improperly which is what is causing the division by zero error - otherwise you would've seen it before with the other data you had in your database

[oracle3001]

iPoker...is there any way we can find the problematic hand? Or am I going to have re-import my whole DB?

[WhiteRider]

This could be caused by a hand imported as having a zero big blind. Extract and import the attached custom report and run it - this should list any hands like that. If it does - identify the session and purge it and see if that helps.

[oracle3001]

Ran that report and nothing came back.

[WhiteRider]

Are you seeing any errors in reports, or just when you run housekeeping?
e.g. In the Sessions By Time report?

If you're not getting errors in reports then I think the easiest solution is likely to be to purge the hands you just imported and see if you can then do housekeeping.
You could experiment first importing the same set of hands into another database and see if you get the same error there?

[oracle3001]

No I wasn't getting any errors when I tried to view session data.

In the end, I did a full cache rebuild (no purging of data etc), and it completed without any errors.