Div by 0 error at import :(

[ind0ril]

This is the error message I get when the cache is updated after the import. I tried again a housekeeping, but got the same error again when the cache is updateing. What to do?

Code: Select all

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_face_raise AND holdem_hand_player_statistics.flg_p_fold = false AND holdem_hand_player_statistics.cnt_p_raise=0) 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_f_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_f_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_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.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_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))) 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 > 2505273)) AND ((holdem_hand_player_statistics.id_player = 17881)) 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]

Have you imported or built any custom stats lately?

[ind0ril]

No, I have not

[kraada]

How large is the database? What version of PT3 are you currently using?

[ind0ril]

I messed around in PostgreSQL (for 3 years I worked in SQL Server ;)) and found the problem. A single hand is causing a problem:
holdem_hand_summary.amt_pot is equal to holdem_hand_summary.amt_rake so (holdem_hand_summary.amt_pot - holdem_hand_summary.amt_rake) = 0 which causes the division by 0 error. If I modifiy the holdem_hand_summary.amt_rake value, that will fix the problem. Is it ok to modify that value?

[kraada]

Yes that's fine but please submit the original hand history to a support ticket so that we can determine why the hand imported with that error and make sure it does not happen again to anybody else (since most of our users won't be able to do what you just did! :)).