Housekeeping problem

by **monarco** » Fri Aug 29, 2008 3:06 pm

OK, i think i removed the cloumns containing "holdem_table_session_summary.id_session", but still get an error after caching.

Here it is:

Code: Select all: There were errors during the housekeeping process: Unable to prepare query: INSERT INTO holdem_cache SELECT holdem_hand_player_statistics.id_player, holdem_hand_player_statistics.id_limit, holdem_hand_summary.cnt_players, (count(holdem_hand_player_statistics.id_hand)), (sum((case when(holdem_hand_player_statistics.flg_vpip) 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_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 = false AND holdem_hand_player_statistics.flg_blind_s) 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_sb_steal_fold) 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_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_b) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_steal_att) 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_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_p_open 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.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_won_hand AND holdem_hand_player_statistics.flg_f_saw) 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_showdown AND holdem_hand_player_statistics.flg_won_hand) 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_t_saw) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_saw) then 1 else 0 end))), (sum(holdem_hand_player_statistics.cnt_p_raise)), (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.flg_p_ccall) 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_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((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_f_bet) then 1 else 0 end))), (sum(holdem_hand_player_statistics.cnt_f_raise)), (sum(holdem_hand_player_statistics.cnt_f_call)), (sum((case when(holdem_hand_player_statistics.flg_f_fold) 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_bet) then 1 else 0 end))), (sum(holdem_hand_player_statistics.cnt_t_raise)), (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(holdem_hand_player_statistics.cnt_t_call)), (sum((case when(holdem_hand_player_statistics.flg_t_fold) 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_bet) then 1 else 0 end))), (sum(holdem_hand_player_statistics.cnt_r_raise)), (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(holdem_hand_player_statistics.cnt_r_call)), (sum((case when(holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))), (sum(holdem_hand_player_statistics.amt_won)), (sum( (case when(holdem_hand_player_statistics.flg_won_hand) then holdem_hand_summary.amt_rake else 0 end) )), (sum(holdem_hand_summary.amt_mgr)), (sum(holdem_hand_player_detail.amt_blind)), (sum((case when(holdem_hand_player_statistics.flg_p_3bet) 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_3bet_def_opp) 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='C') 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_f_3bet) 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_3bet_def_opp) 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='C') 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.flg_t_3bet_opp) 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.enum_t_3bet_action='F') 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='R') 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_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_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(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_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_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(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(holdem_hand_player_statistics.flg_f_cbet_def_opp) 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_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_opp) 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_opp) 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_detail.amt_f_bet_facing > 0 AND holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))), (sum((case when(holdem_hand_player_detail.amt_f_bet_facing > 0 AND holdem_hand_player_statistics.cnt_f_call > 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_detail.amt_f_bet_facing > 0 AND holdem_hand_player_statistics.cnt_f_raise > 0) 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_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 AND holdem_hand_player_statistics.cnt_f_call > 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_detail.amt_t_bet_facing > 0 AND holdem_hand_player_statistics.cnt_t_call > 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_detail.amt_t_bet_facing > 0 AND holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))), (sum((case when(holdem_hand_player_detail.amt_t_bet_facing > 0 AND holdem_hand_player_statistics.cnt_t_raise > 0) 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_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_detail.amt_r_bet_facing > 0 AND holdem_hand_player_statistics.cnt_r_call > 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_detail.amt_r_bet_facing > 0 AND holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))), (sum((case when(holdem_hand_player_detail.amt_r_bet_facing > 0 AND holdem_hand_player_statistics.cnt_r_raise > 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_detail.amt_r_bet_facing > 0) then 1 else 0 end))), (sum(holdem_hand_player_statistics.amt_won * 1.0 / (holdem_limit.amt_bb *holdem_limit.val_nlpl_mult))), (sum( (case when(holdem_hand_player_statistics.flg_p_first_raise) then 1 else 0 end))), (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.enum_f_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_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_def_opp AND holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.cnt_p_raise > 0) 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_r_float) 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.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_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_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(holdem_hand_player_statistics.flg_r_donk_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_t_float_opp) 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_won_hand) 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_p_face_raise) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.flg_p_limp = false) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 0 AND 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.position = 0 AND 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='R' ) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 0 AND holdem_hand_player_statistics.cnt_p_raise > 0 ) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 1 AND holdem_hand_player_statistics.cnt_p_raise > 0 ) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 2 AND holdem_hand_player_statistics.cnt_p_raise > 0 ) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.id_hand > 0 AND holdem_hand_player_statistics.position = 0 ) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.id_hand > 0 AND holdem_hand_player_statistics.position = 1 ) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.id_hand > 0 AND holdem_hand_player_statistics.position = 2 ) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.id_hand > 0 AND holdem_hand_player_statistics.position = 3 ) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 3 AND 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_3bet_def_opp ) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_squeeze_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.position = 1 AND holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.flg_f_cbet_def_opp) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 0 AND holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.flg_f_cbet_def_opp) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.flg_f_cbet_def_opp) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.enum_f_cbet_action='F') then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 1 AND holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.enum_f_cbet_action='F') then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 0 AND holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.enum_f_cbet_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.enum_f_cbet_action='F' ) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.flg_f_cbet_def_opp ) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.cnt_f_raise > 0 AND holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.cnt_f_raise > 0 AND holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))), (sqrt(sum( (holdem_hand_player_statistics.amt_won * 1.0 / (holdem_limit.amt_bb *holdem_limit.val_nlpl_mult))^2 ))), (sqrt(count(holdem_hand_player_statistics.id_hand))), (sum((case when(holdem_hand_player_statistics.flg_vpip AND holdem_hand_player_statistics.position = 0) then 1 else 0 end))), (SUM((case when(holdem_hand_player_statistics.position = 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_vpip AND holdem_hand_player_statistics.position = 1) then 1 else 0 end))), (SUM((case when(holdem_hand_player_statistics.position = 1) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_vpip AND holdem_hand_player_statistics.position = 2) then 1 else 0 end))), (SUM((case when(holdem_hand_player_statistics.position = 2) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_vpip AND holdem_hand_player_statistics.position = 6) then 1 else 0 end))), (SUM((case when(holdem_hand_player_statistics.position = 6) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_vpip AND holdem_hand_player_statistics.position = 5) then 1 else 0 end))), (SUM((case when(holdem_hand_player_statistics.position = 5) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_vpip AND holdem_hand_player_statistics.position = 4) then 1 else 0 end))), (SUM((case when(holdem_hand_player_statistics.position = 4) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 0 AND holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 1 AND holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 2 AND holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 3 AND holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 3 AND holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))), (holdem_hand_player_detail.amt_before), (sum((case when(holdem_hand_player_statistics.position = 0 AND holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 1 AND holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 2 AND holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 3 AND holdem_hand_player_statistics.flg_p_3bet) 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_p_3bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_blind_b and holdem_hand_player_statistics.flg_blind_s = false AND holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 0 AND holdem_hand_player_statistics.flg_p_3bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 1 AND holdem_hand_player_statistics.flg_p_3bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 2 AND holdem_hand_player_statistics.flg_p_3bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 3 AND holdem_hand_player_statistics.flg_p_3bet_opp) 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_p_3bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_blind_s = false AND holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_p_3bet_opp) then 1 else 0 end))), (sum( (case when(holdem_hand_player_statistics.flg_blind_s = false AND holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_vpip) then 1 else 0 end) )), (sum( (case when(holdem_hand_player_statistics.flg_blind_s = false AND holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.cnt_p_raise > 0) 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.cnt_p_raise > 0) then 1 else 0 end) )), (sum((case when( holdem_hand_player_statistics.position = 3 AND holdem_hand_player_statistics.cnt_p_raise > 0 ) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.id_hand > 0 AND holdem_hand_player_statistics.position = 3 ) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 0 AND holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.flg_p_limp = false) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 1 AND holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.flg_p_limp = false) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 2 AND holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.flg_p_limp = false) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 3 AND holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.flg_p_limp = false) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 0 AND holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 1 AND holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 2 AND holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 3 AND holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 0 AND 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.position = 1 AND 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.position = 2 AND 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.position = 3 AND 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_blind_s AND holdem_hand_player_statistics.flg_blind_b = false AND 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_blind_b AND holdem_hand_player_statistics.flg_blind_s = false AND 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.position = 0 AND holdem_hand_player_statistics.flg_p_face_raise) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 1 AND holdem_hand_player_statistics.flg_p_face_raise) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 2 AND holdem_hand_player_statistics.flg_p_face_raise) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 3 AND holdem_hand_player_statistics.flg_p_face_raise) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.flg_blind_b = false AND holdem_hand_player_statistics.flg_p_face_raise) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_blind_s = false AND 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.position = 9) 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_opp AND holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.flg_blind_b = false) then 1 else 0 end))), (SUM((case when(holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.flg_blind_b = false) 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_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_p_3bet AND holdem_hand_player_statistics.enum_f_cbet_action='C') then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_3bet 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_t_cbet_action='C') then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_t_cbet_def_opp) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_detail.flg_f_open_opp AND NOT holdem_hand_player_statistics.flg_f_cbet_opp AND (holdem_hand_player_detail.val_p_raise_aggressor_pos (sum((case when( holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_detail.flg_f_open AND NOT holdem_hand_player_statistics.flg_f_cbet_opp AND (holdem_hand_player_detail.val_p_raise_aggressor_pos (sum((case when( holdem_hand_player_statistics.flg_p_3bet 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 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 AND holdem_hand_player_statistics.enum_t_cbet_action='R') then 1 else 0 end))), (sum( (case when(holdem_hand_summary.amt_rake>0.4) then (case when(holdem_hand_summary.amt_rake=3) then 2 else 1 end) 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 AND holdem_hand_player_statistics.flg_t_cbet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.enum_t_cbet_action='F' ) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.flg_t_cbet_def_opp ) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.flg_t_cbet_def_opp ) then 1 else 0 end))), ((case when( (sum((case when(holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))) > 0 ) then sum(holdem_hand_player_detail.val_f_bet_made_pct) * 1.0 / (sum((case when(holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))) else 0 end)), ((case when( (sum((case when(holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))) > 0 ) then sum(holdem_hand_player_detail.val_r_bet_made_pct) * 1.0 / (sum((case when(holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))) else 0 end)), ((case when( (sum((case when(holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))) > 0 ) then sum(holdem_hand_player_detail.val_t_bet_made_pct) * 1.0 / (sum((case when(holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))) else 0 end)) FROM holdem_hand_player_statistics, holdem_hand_summary, holdem_hand_player_detail, holdem_limit WHERE (holdem_hand_summary.id_hand = holdem_hand_player_statistics.id_hand) AND (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_limit.id_limit = holdem_hand_player_statistics.id_limit) AND (holdem_hand_summary.id_hand = holdem_hand_player_detail.id_hand) AND (holdem_limit.id_limit = holdem_hand_summary.id_limit) AND (holdem_hand_player_statistics.id_player = $1) GROUP BY holdem_hand_player_statistics.id_player, holdem_hand_player_statistics.id_limit, holdem_hand_summary.cnt_players; Reason: Fatal Error (ERROR: column "holdem_hand_player_detail.amt_before" must appear in the GROUP BY clause or be used in an aggregate function ) Unable to prepare query: INSERT INTO holdem_cache SELECT holdem_hand_player_statistics.id_player, holdem_hand_player_statistics.id_limit, holdem_hand_summary.cnt_players, (count(holdem_hand_player_statistics.id_hand)), (sum((case when(holdem_hand_player_statistics.flg_vpip) 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_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 = false AND holdem_hand_player_statistics.flg_blind_s) 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_sb_steal_fold) 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_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_b) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_steal_att) 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_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_p_open 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.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_won_hand AND holdem_hand_player_statistics.flg_f_saw) 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_showdown AND holdem_hand_player_statistics.flg_won_hand) 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_t_saw) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_saw) then 1 else 0 end))), (sum(holdem_hand_player_statistics.cnt_p_raise)), (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.flg_p_ccall) 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_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((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_f_bet) then 1 else 0 end))), (sum(holdem_hand_player_statistics.cnt_f_raise)), (sum(holdem_hand_player_statistics.cnt_f_call)), (sum((case when(holdem_hand_player_statistics.flg_f_fold) 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_bet) then 1 else 0 end))), (sum(holdem_hand_player_statistics.cnt_t_raise)), (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(holdem_hand_player_statistics.cnt_t_call)), (sum((case when(holdem_hand_player_statistics.flg_t_fold) 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_bet) then 1 else 0 end))), (sum(holdem_hand_player_statistics.cnt_r_raise)), (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(holdem_hand_player_statistics.cnt_r_call)), (sum((case when(holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))), (sum(holdem_hand_player_statistics.amt_won)), (sum( (case when(holdem_hand_player_statistics.flg_won_hand) then holdem_hand_summary.amt_rake else 0 end) )), (sum(holdem_hand_summary.amt_mgr)), (sum(holdem_hand_player_detail.amt_blind)), (sum((case when(holdem_hand_player_statistics.flg_p_3bet) 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_3bet_def_opp) 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='C') 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_f_3bet) 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_3bet_def_opp) 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='C') 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.flg_t_3bet_opp) 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.enum_t_3bet_action='F') 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='R') 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_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_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(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_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_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(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(holdem_hand_player_statistics.flg_f_cbet_def_opp) 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_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_opp) 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_opp) 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_detail.amt_f_bet_facing > 0 AND holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))), (sum((case when(holdem_hand_player_detail.amt_f_bet_facing > 0 AND holdem_hand_player_statistics.cnt_f_call > 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_detail.amt_f_bet_facing > 0 AND holdem_hand_player_statistics.cnt_f_raise > 0) 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_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 AND holdem_hand_player_statistics.cnt_f_call > 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_detail.amt_t_bet_facing > 0 AND holdem_hand_player_statistics.cnt_t_call > 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_detail.amt_t_bet_facing > 0 AND holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))), (sum((case when(holdem_hand_player_detail.amt_t_bet_facing > 0 AND holdem_hand_player_statistics.cnt_t_raise > 0) 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_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_detail.amt_r_bet_facing > 0 AND holdem_hand_player_statistics.cnt_r_call > 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_detail.amt_r_bet_facing > 0 AND holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))), (sum((case when(holdem_hand_player_detail.amt_r_bet_facing > 0 AND holdem_hand_player_statistics.cnt_r_raise > 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_detail.amt_r_bet_facing > 0) then 1 else 0 end))), (sum(holdem_hand_player_statistics.amt_won * 1.0 / (holdem_limit.amt_bb *holdem_limit.val_nlpl_mult))), (sum( (case when(holdem_hand_player_statistics.flg_p_first_raise) then 1 else 0 end))), (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.enum_f_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_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_def_opp AND holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.cnt_p_raise > 0) 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_r_float) 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.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_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_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(holdem_hand_player_statistics.flg_r_donk_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_t_float_opp) 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_won_hand) 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_p_face_raise) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.flg_p_limp = false) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 0 AND 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.position = 0 AND 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='R' ) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 0 AND holdem_hand_player_statistics.cnt_p_raise > 0 ) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 1 AND holdem_hand_player_statistics.cnt_p_raise > 0 ) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 2 AND holdem_hand_player_statistics.cnt_p_raise > 0 ) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.id_hand > 0 AND holdem_hand_player_statistics.position = 0 ) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.id_hand > 0 AND holdem_hand_player_statistics.position = 1 ) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.id_hand > 0 AND holdem_hand_player_statistics.position = 2 ) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.id_hand > 0 AND holdem_hand_player_statistics.position = 3 ) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 3 AND 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_3bet_def_opp ) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_squeeze_opp ) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_squeeze ) then 1 else 0 end))),

by **monarco** » Fri Aug 29, 2008 3:06 pm

Again in 2 posts:

Code: Select all: (sum((case when( holdem_hand_player_statistics.position = 1 AND holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.flg_f_cbet_def_opp) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 0 AND holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.flg_f_cbet_def_opp) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.flg_f_cbet_def_opp) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.enum_f_cbet_action='F') then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 1 AND holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.enum_f_cbet_action='F') then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 0 AND holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.enum_f_cbet_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.enum_f_cbet_action='F' ) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.flg_f_cbet_def_opp ) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.cnt_f_raise > 0 AND holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.cnt_f_raise > 0 AND holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))), (sqrt(sum( (holdem_hand_player_statistics.amt_won * 1.0 / (holdem_limit.amt_bb *holdem_limit.val_nlpl_mult))^2 ))), (sqrt(count(holdem_hand_player_statistics.id_hand))), (sum((case when(holdem_hand_player_statistics.flg_vpip AND holdem_hand_player_statistics.position = 0) then 1 else 0 end))), (SUM((case when(holdem_hand_player_statistics.position = 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_vpip AND holdem_hand_player_statistics.position = 1) then 1 else 0 end))), (SUM((case when(holdem_hand_player_statistics.position = 1) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_vpip AND holdem_hand_player_statistics.position = 2) then 1 else 0 end))), (SUM((case when(holdem_hand_player_statistics.position = 2) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_vpip AND holdem_hand_player_statistics.position = 6) then 1 else 0 end))), (SUM((case when(holdem_hand_player_statistics.position = 6) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_vpip AND holdem_hand_player_statistics.position = 5) then 1 else 0 end))), (SUM((case when(holdem_hand_player_statistics.position = 5) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_vpip AND holdem_hand_player_statistics.position = 4) then 1 else 0 end))), (SUM((case when(holdem_hand_player_statistics.position = 4) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 0 AND holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 1 AND holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 2 AND holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 3 AND holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.position = 3 AND holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))), (holdem_hand_player_detail.amt_before), (sum((case when(holdem_hand_player_statistics.position = 0 AND holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 1 AND holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 2 AND holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 3 AND holdem_hand_player_statistics.flg_p_3bet) 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_p_3bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_blind_b and holdem_hand_player_statistics.flg_blind_s = false AND holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 0 AND holdem_hand_player_statistics.flg_p_3bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 1 AND holdem_hand_player_statistics.flg_p_3bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 2 AND holdem_hand_player_statistics.flg_p_3bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 3 AND holdem_hand_player_statistics.flg_p_3bet_opp) 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_p_3bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_blind_s = false AND holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_p_3bet_opp) then 1 else 0 end))), (sum( (case when(holdem_hand_player_statistics.flg_blind_s = false AND holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_vpip) then 1 else 0 end) )), (sum( (case when(holdem_hand_player_statistics.flg_blind_s = false AND holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.cnt_p_raise > 0) 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.cnt_p_raise > 0) then 1 else 0 end) )), (sum((case when( holdem_hand_player_statistics.position = 3 AND holdem_hand_player_statistics.cnt_p_raise > 0 ) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.id_hand > 0 AND holdem_hand_player_statistics.position = 3 ) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 0 AND holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.flg_p_limp = false) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 1 AND holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.flg_p_limp = false) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 2 AND holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.flg_p_limp = false) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 3 AND holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.flg_p_limp = false) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 0 AND holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 1 AND holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 2 AND holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 3 AND holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 0 AND 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.position = 1 AND 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.position = 2 AND 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.position = 3 AND 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_blind_s AND holdem_hand_player_statistics.flg_blind_b = false AND 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_blind_b AND holdem_hand_player_statistics.flg_blind_s = false AND 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.position = 0 AND holdem_hand_player_statistics.flg_p_face_raise) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 1 AND holdem_hand_player_statistics.flg_p_face_raise) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 2 AND holdem_hand_player_statistics.flg_p_face_raise) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.position = 3 AND holdem_hand_player_statistics.flg_p_face_raise) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.flg_blind_b = false AND holdem_hand_player_statistics.flg_p_face_raise) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_blind_s = false AND 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.position = 9) 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_opp AND holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.flg_blind_b = false) then 1 else 0 end))), (SUM((case when(holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.flg_blind_b = false) 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_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_p_3bet AND holdem_hand_player_statistics.enum_f_cbet_action='C') then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_3bet 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_t_cbet_action='C') then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_t_cbet_def_opp) then 1 else 0 end))), (sum((case when( holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_detail.flg_f_open_opp AND NOT holdem_hand_player_statistics.flg_f_cbet_opp AND (holdem_hand_player_detail.val_p_raise_aggressor_pos (sum((case when( holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_detail.flg_f_open AND NOT holdem_hand_player_statistics.flg_f_cbet_opp AND (holdem_hand_player_detail.val_p_raise_aggressor_pos (sum((case when( holdem_hand_player_statistics.flg_p_3bet 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 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 AND holdem_hand_player_statistics.enum_t_cbet_action='R') then 1 else 0 end))), (sum( (case when(holdem_hand_summary.amt_rake>0.4) then (case when(holdem_hand_summary.amt_rake=3) then 2 else 1 end) 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 AND holdem_hand_player_statistics.flg_t_cbet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.enum_t_cbet_action='F' ) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.flg_t_cbet_def_opp ) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.flg_t_cbet_def_opp ) then 1 else 0 end))), ((case when( (sum((case when(holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))) > 0 ) then sum(holdem_hand_player_detail.val_f_bet_made_pct) * 1.0 / (sum((case when(holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))) else 0 end)), ((case when( (sum((case when(holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))) > 0 ) then sum(holdem_hand_player_detail.val_r_bet_made_pct) * 1.0 / (sum((case when(holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))) else 0 end)), ((case when( (sum((case when(holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))) > 0 ) then sum(holdem_hand_player_detail.val_t_bet_made_pct) * 1.0 / (sum((case when(holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))) else 0 end)) FROM holdem_hand_player_statistics, holdem_hand_summary, holdem_hand_player_detail, holdem_limit WHERE (holdem_hand_summary.id_hand = holdem_hand_player_statistics.id_hand) AND (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_limit.id_limit = holdem_hand_player_statistics.id_limit) AND (holdem_hand_summary.id_hand = holdem_hand_player_detail.id_hand) AND (holdem_limit.id_limit = holdem_hand_summary.id_limit) AND (holdem_hand_player_statistics.id_player = $1) GROUP BY holdem_hand_player_statistics.id_player, holdem_hand_player_statistics.id_limit, holdem_hand_summary.cnt_players; Reason: Fatal Error (ERROR: column "holdem_hand_player_detail.amt_before" must appear in the GROUP BY clause or be used in an aggregate function )

by **monarco** » Fri Aug 29, 2008 5:11 pm

I already figured it out myself, ty guys.

by **Sattva** » Fri Aug 29, 2008 5:42 pm

could you help me? what should I delete or change?

Code: Select all: There were errors during the housekeeping process: Unable to execute query: CREATE TABLE holdem_cache (id_player integer NOT NULL, id_limit integer NOT NULL, cnt_players integer NOT NULL, cnt_hands integer, cnt_vpip integer, cnt_blind integer, cnt_bb integer, cnt_sb integer, cnt_vpip_sb integer, cnt_sb_steal_fold integer, cnt_bb_steal_fold integer, cnt_steal_def_opp_sb integer, cnt_steal_def_opp_bb integer, cnt_steal_att integer, cnt_steal_opp integer, cnt_won_hand integer, cnt_won_showdown integer, cnt_first_limp integer, cnt_prev_callers_limp integer, cnt_prev_callers_raise integer, cnt_f_saw_won integer, cnt_wtsd integer, cnt_wtsd_won integer, cnt_f_saw integer, cnt_t_saw integer, cnt_r_saw integer, cnt_p_raise integer, cnt_pfr integer, cnt_p_call integer, cnt_p_ccall integer, cnt_p_fold integer, cnt_p_pfr_call integer, cnt_p_pfr_call_opp integer, cnt_f_check integer, cnt_f_check_raise integer, cnt_f_check_raise_opp integer, cnt_f_bet

by **js2002** » Fri Aug 29, 2008 5:55 pm

post all text plz

by **Sattva** » Sat Aug 30, 2008 3:16 am

Code: Select all: There were errors during the housekeeping process: Unable to execute query: CREATE TABLE holdem_cache (id_player integer NOT NULL, id_limit integer NOT NULL, cnt_players integer NOT NULL, cnt_hands integer, cnt_vpip integer, cnt_blind integer, cnt_bb integer, cnt_sb integer, cnt_vpip_sb integer, cnt_sb_steal_fold integer, cnt_bb_steal_fold integer, cnt_steal_def_opp_sb integer, cnt_steal_def_opp_bb integer, cnt_steal_att integer, cnt_steal_opp integer, cnt_won_hand integer, cnt_won_showdown integer, cnt_first_limp integer, cnt_prev_callers_limp integer, cnt_prev_callers_raise integer, cnt_f_saw_won integer, cnt_wtsd integer, cnt_wtsd_won integer, cnt_f_saw integer, cnt_t_saw integer, cnt_r_saw integer, cnt_p_raise integer, cnt_pfr integer, cnt_p_call integer, cnt_p_ccall integer, cnt_p_fold integer, cnt_p_pfr_call integer, cnt_p_pfr_call_opp integer, cnt_f_check integer, cnt_f_check_raise integer, cnt_f_check_raise_opp integer, cnt_f_bet integer, cnt_f_raise integer, cnt_f_call integer, cnt_f_fold integer, cnt_t_check integer, cnt_t_check_raise integer, cnt_t_check_raise_opp integer, cnt_t_bet integer, cnt_t_raise integer, cnt_t_raise_wtsd integer, cnt_t_raise_wtsd_won integer, cnt_t_call integer, cnt_t_fold integer, cnt_r_check integer, cnt_r_check_raise integer, cnt_r_check_raise_opp integer, cnt_r_bet integer, cnt_r_raise integer, cnt_r_raise_wtsd integer, cnt_r_raise_wtsd_won integer, cnt_r_call integer, cnt_r_fold integer, amt_won numeric(9,2), amt_rake numeric(9,2), amt_mgr numeric(9,2), amt_blind numeric(9,2), cnt_p_3bet integer, cnt_p_3bet_opp integer, cnt_p_3bet_def_opp integer, cnt_p_3bet_def_action_fold integer, cnt_p_3bet_def_action_call integer, cnt_p_3bet_def_action_raise integer, cnt_f_3bet integer, cnt_f_3bet_opp integer, cnt_f_3bet_def_opp integer, cnt_f_3bet_def_action_fold integer, cnt_f_3bet_def_action_call integer, cnt_t_3bet integer, cnt_t_3bet_opp integer, cnt_t_3bet_def_opp integer, cnt_t_3bet_def_action_fold integer, cnt_t_3bet_def_action_call integer, cnt_t_3bet_def_action_raise integer, cnt_r_3bet integer, cnt_r_3bet_def_action_call integer, cnt_r_3bet_def_action_fold integer, cnt_r_3bet_def_action_raise integer, cnt_r_3bet_opp integer, cnt_f_4bet integer, cnt_f_4bet_def_action_call integer, cnt_f_4bet_def_action_fold integer, cnt_f_4bet_def_action_raise integer, cnt_f_4bet_def_opp integer, cnt_f_4bet_opp integer, cnt_p_4bet integer, cnt_p_4bet_def_action_call integer, cnt_p_4bet_def_action_fold integer, cnt_p_4bet_def_action_raise integer, cnt_p_4bet_def_opp integer, cnt_p_4bet_opp integer, cnt_r_4bet integer, cnt_r_4bet_def_action_call integer, cnt_r_4bet_def_action_fold integer, cnt_r_4bet_def_action_raise integer, cnt_r_4bet_def_opp integer, cnt_r_4bet_opp integer, cnt_t_4bet integer, cnt_t_4bet_def_action_call integer, cnt_t_4bet_def_action_fold integer, cnt_t_4bet_def_action_raise integer, cnt_t_4bet_def_opp integer, cnt_t_4bet_opp integer, cnt_f_cbet integer, cnt_f_cbet_def_action_call integer, cnt_f_cbet_def_action_fold integer, cnt_f_cbet_def_action_raise integer, cnt_f_cbet_def_opp integer, cnt_f_cbet_opp integer, cnt_t_cbet integer, cnt_t_cbet_def_action_call integer, cnt_t_cbet_def_action_fold integer, cnt_t_cbet_def_action_raise integer, cnt_t_cbet_def_opp integer, cnt_t_cbet_opp integer, cnt_r_cbet integer, cnt_r_cbet_def_action_call integer, cnt_r_cbet_def_action_fold integer, cnt_r_cbet_def_action_raise integer, cnt_r_cbet_def_opp integer, cnt_r_cbet_opp integer, cnt_f_bet_def_opp integer, cnt_f_bet_def_action_fold integer, cnt_f_bet_def_action_call integer, cnt_f_bet_def_action_raise integer, cnt_f_raise_def_opp integer, cnt_f_raise_def_action_fold integer, cnt_f_raise_def_action_call integer, cnt_t_bet_def_action_call integer, cnt_t_bet_def_action_fold integer, cnt_t_bet_def_action_raise integer, cnt_t_bet_def_opp integer, cnt_t_raise_def_action_call integer, cnt_t_raise_def_action_fold integer, cnt_t_raise_def_opp integer, cnt_r_bet_def_action_call integer, cnt_r_bet_def_action_fold integer, cnt_r_bet_def_action_raise integer, cnt_r_bet_def_opp integer, amt_bb_won numeric(9,2), cnt_p_first_raise integer, cnt_r_raise_def_action_call integer, cnt_r_raise_def_action_fold integer, cnt_r_raise_def_opp integer, cnt_f_3bet_def_action_raise integer, cnt_r_3bet_def_opp integer, cnt_bb_steal_raise integer, cnt_sb_steal_raise integer, cnt_steal_reraise_def_action_fold integer, cnt_steal_reraise_def_opp integer, cnt_r_float integer, cnt_t_float integer, cnt_t_float_def_action_call integer, cnt_t_float_def_action_fold integer, cnt_t_float_def_action_raise integer, cnt_t_float_def_opp integer, cnt_r_float_def_action_call integer, cnt_r_float_def_action_fold integer, cnt_r_float_def_action_raise integer, cnt_r_float_def_opp integer, cnt_r_donk integer, cnt_r_donk_def_action_call integer, cnt_r_donk_def_action_fold integer, cnt_r_donk_def_action_raise integer, cnt_r_donk_def_opp integer, cnt_t_donk integer, cnt_t_donk_def_action_call integer, cnt_t_donk_def_action_fold integer, cnt_t_donk_def_action_raise integer, cnt_t_donk_def_opp integer, cnt_t_donk_opp integer, cnt_r_donk_opp integer, cnt_r_float_opp integer, cnt_t_float_opp integer, cnt_sessions integer, cnt_sessions_won integer, cnt_hands_won integer, cnt_hands_raked integer, cnt_hands_with_flop integer, cnt_p_face_raise integer, cnt_p_ccall_opp integer);; Reason: Fatal Error (ERROR: relation "holdem_cache" already exists )

by **maasterflash** » Sat Aug 30, 2008 4:09 am

I have this problem too... Thanks for help.

Code: Select all: There were errors during the housekeeping process: Unable to execute query: CREATE TABLE holdem_cache (id_player integer NOT NULL, id_limit integer NOT NULL, cnt_players integer NOT NULL, cnt_hands integer, cnt_vpip integer, cnt_blind integer, cnt_bb integer, cnt_sb integer, cnt_vpip_sb integer, cnt_sb_steal_fold integer, cnt_bb_steal_fold integer, cnt_steal_def_opp_sb integer, cnt_steal_def_opp_bb integer, cnt_steal_att integer, cnt_steal_opp integer, cnt_won_hand integer, cnt_won_showdown integer, cnt_first_limp integer, cnt_prev_callers_limp integer, cnt_prev_callers_raise integer, cnt_f_saw_won integer, cnt_wtsd integer, cnt_wtsd_won integer, cnt_f_saw integer, cnt_t_saw integer, cnt_r_saw integer, cnt_p_raise integer, cnt_pfr integer, cnt_p_call integer, cnt_p_ccall integer, cnt_p_fold integer, cnt_p_pfr_call integer, cnt_p_pfr_call_opp integer, cnt_f_check integer, cnt_f_check_raise integer, cnt_f_check_raise_opp integer, cnt_f_bet integer, cnt_f_raise integer, cnt_f_call integer, cnt_f_fold integer, cnt_t_check integer, cnt_t_check_raise integer, cnt_t_check_raise_opp integer, cnt_t_bet integer, cnt_t_raise integer, cnt_t_raise_wtsd integer, cnt_t_raise_wtsd_won integer, cnt_t_call integer, cnt_t_fold integer, cnt_r_check integer, cnt_r_check_raise integer, cnt_r_check_raise_opp integer, cnt_r_bet integer, cnt_r_raise integer, cnt_r_raise_wtsd integer, cnt_r_raise_wtsd_won integer, cnt_r_call integer, cnt_r_fold integer, amt_won numeric(9,2), amt_rake numeric(9,2), amt_mgr numeric(9,2), amt_blind numeric(9,2), cnt_p_3bet integer, cnt_p_3bet_opp integer, cnt_p_3bet_def_opp integer, cnt_p_3bet_def_action_fold integer, cnt_p_3bet_def_action_call integer, cnt_p_3bet_def_action_raise integer, cnt_f_3bet integer, cnt_f_3bet_opp integer, cnt_f_3bet_def_opp integer, cnt_f_3bet_def_action_fold integer, cnt_f_3bet_def_action_call integer, cnt_t_3bet integer, cnt_t_3bet_opp integer, cnt_t_3bet_def_opp integer, cnt_t_3bet_def_action_fold integer, cnt_t_3bet_def_action_call integer, cnt_t_3bet_def_action_raise integer, cnt_r_3bet integer, cnt_r_3bet_def_action_call integer, cnt_r_3bet_def_action_fold integer, cnt_r_3bet_def_action_raise integer, cnt_r_3bet_opp integer, cnt_f_4bet integer, cnt_f_4bet_def_action_call integer, cnt_f_4bet_def_action_fold integer, cnt_f_4bet_def_action_raise integer, cnt_f_4bet_def_opp integer, cnt_f_4bet_opp integer, cnt_p_4bet integer, cnt_p_4bet_def_action_call integer, cnt_p_4bet_def_action_fold integer, cnt_p_4bet_def_action_raise integer, cnt_p_4bet_def_opp integer, cnt_p_4bet_opp integer, cnt_r_4bet integer, cnt_r_4bet_def_action_call integer, cnt_r_4bet_def_action_fold integer, cnt_r_4bet_def_action_raise integer, cnt_r_4bet_def_opp integer, cnt_r_4bet_opp integer, cnt_t_4bet integer, cnt_t_4bet_def_action_call integer, cnt_t_4bet_def_action_fold integer, cnt_t_4bet_def_action_raise integer, cnt_t_4bet_def_opp integer, cnt_t_4bet_opp integer, cnt_f_cbet integer, cnt_f_cbet_def_action_call integer, cnt_f_cbet_def_action_fold integer, cnt_f_cbet_def_action_raise integer, cnt_f_cbet_def_opp integer, cnt_f_cbet_opp integer, cnt_t_cbet integer, cnt_t_cbet_def_action_call integer, cnt_t_cbet_def_action_fold integer, cnt_t_cbet_def_action_raise integer, cnt_t_cbet_def_opp integer, cnt_t_cbet_opp integer, cnt_r_cbet integer, cnt_r_cbet_def_action_call integer, cnt_r_cbet_def_action_fold integer, cnt_r_cbet_def_action_raise integer, cnt_r_cbet_def_opp integer, cnt_r_cbet_opp integer, cnt_f_bet_def_opp integer, cnt_f_bet_def_action_fold integer, cnt_f_bet_def_action_call integer, cnt_f_bet_def_action_raise integer, cnt_f_raise_def_opp integer, cnt_f_raise_def_action_fold integer, cnt_f_raise_def_action_call integer, cnt_t_bet_def_action_call integer, cnt_t_bet_def_action_fold integer, cnt_t_bet_def_action_raise integer, cnt_t_bet_def_opp integer, cnt_t_raise_def_action_call integer, cnt_t_raise_def_action_fold integer, cnt_t_raise_def_opp integer, cnt_r_bet_def_action_call integer, cnt_r_bet_def_action_fold integer, cnt_r_bet_def_action_raise integer, cnt_r_bet_def_opp integer, amt_bb_won numeric(9,2), cnt_p_first_raise integer, cnt_r_raise_def_action_call integer, cnt_r_raise_def_action_fold integer, cnt_r_raise_def_opp integer, cnt_f_3bet_def_action_raise integer, cnt_r_3bet_def_opp integer, cnt_bb_steal_raise integer, cnt_sb_steal_raise integer, cnt_steal_reraise_def_action_fold integer, cnt_steal_reraise_def_opp integer, cnt_r_float integer, cnt_t_float integer, cnt_t_float_def_action_call integer, cnt_t_float_def_action_fold integer, cnt_t_float_def_action_raise integer, cnt_t_float_def_opp integer, cnt_r_float_def_action_call integer, cnt_r_float_def_action_fold integer, cnt_r_float_def_action_raise integer, cnt_r_float_def_opp integer, cnt_r_donk integer, cnt_r_donk_def_action_call integer, cnt_r_donk_def_action_fold integer, cnt_r_donk_def_action_raise integer, cnt_r_donk_def_opp integer, cnt_t_donk integer, cnt_t_donk_def_action_call integer, cnt_t_donk_def_action_fold integer, cnt_t_donk_def_action_raise integer, cnt_t_donk_def_opp integer, cnt_t_donk_opp integer, cnt_r_donk_opp integer, cnt_r_float_opp integer, cnt_t_float_opp integer, cnt_sessions integer, cnt_sessions_won integer, cnt_hands_won integer, cnt_hands_raked integer, cnt_hands_with_flop integer, cnt_p_face_raise integer, cnt_p_ccall_opp integer);; Reason: Fatal Error (ERROR: relation "holdem_cache" already exists )

by **WhiteRider** » Sat Aug 30, 2008 5:27 am

viewtopic.php?f=16&t=11031&start=30#p51970

by **WhiteRider** » Sat Aug 30, 2008 6:55 am

Another possible 'fix' from another thread - Those having problems, do you have just one type of game in your DB, cash OR tournaments but not both? Someone who was having problems got their DB to cache by importing some tournament hands where there weren't any before.

by **fyl2u** » Sat Aug 30, 2008 12:29 pm

I've got a similar thing...

My database is on a Debian Linux server. I connect with PT3 over my LAN.

I just tried the housekeeping process for the first time, as PT3 B16 told me I should when it booted up for the first time.

It thought about it for ages, stuck on 25%, saying it was vaccuuming the database or something.

It then finished suddenly and gave me the following text:

There were errors during the housekeeping process:

Unable to execute query: BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE;; Reason: Fatal Error (ERROR: syntax error at or near "ISOLATION" LINE 1: BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE; ^ )
Unable to execute query: CREATE TABLE holdem_cache (id_player integer NOT NULL, id_limit integer NOT NULL, cnt_players integer NOT NULL, cnt_hands integer, cnt_vpip integer, cnt_blind integer, cnt_bb integer, cnt_sb integer, cnt_vpip_sb integer, cnt_sb_steal_fold integer, cnt_bb_steal_fold integer, cnt_steal_def_opp_sb integer, cnt_steal_def_opp_bb integer, cnt_steal_att integer, cnt_steal_opp integer, cnt_won_hand integer, cnt_won_showdown integer, cnt_first_limp integer, cnt_prev_callers_limp integer, cnt_prev_callers_raise integer, cnt_f_saw_won integer, cnt_wtsd integer, cnt_wtsd_won integer, cnt_f_saw integer, cnt_t_saw integer, cnt_r_saw integer, cnt_p_raise integer, cnt_pfr integer, cnt_p_call integer, cnt_p_ccall integer, cnt_p_fold integer, cnt_p_pfr_call integer, cnt_p_pfr_call_opp integer, cnt_f_check integer, cnt_f_check_raise integer, cnt_f_check_raise_opp integer, cnt_f_bet integer, cnt_f_raise integer, cnt_f_call integer, cnt_f_fold integer, cnt_t_check integer, cnt_t_check_raise integer, cnt_t_check_raise_opp integer, cnt_t_bet integer, cnt_t_raise integer, cnt_t_raise_wtsd integer, cnt_t_raise_wtsd_won integer, cnt_t_call integer, cnt_t_fold integer, cnt_r_check integer, cnt_r_check_raise integer, cnt_r_check_raise_opp integer, cnt_r_bet integer, cnt_r_raise integer, cnt_r_raise_wtsd integer, cnt_r_raise_wtsd_won integer, cnt_r_call integer, cnt_r_fold integer, amt_won numeric(9,2), amt_rake numeric(9,2), amt_mgr numeric(9,2), amt_blind numeric(9,2), cnt_p_3bet integer, cnt_p_3bet_opp integer, cnt_p_3bet_def_opp integer, cnt_p_3bet_def_action_fold integer, cnt_p_3bet_def_action_call integer, cnt_p_3bet_def_action_raise integer, cnt_f_3bet integer, cnt_f_3bet_opp integer, cnt_f_3bet_def_opp integer, cnt_f_3bet_def_action_fold integer, cnt_f_3bet_def_action_call integer, cnt_t_3bet integer, cnt_t_3bet_opp integer, cnt_t_3bet_def_opp integer, cnt_t_3bet_def_action_fold integer, cnt_t_3bet_def_action_call integer, cnt_t_3bet_def_action_raise integer, cnt_r_3bet integer, cnt_r_3bet_def_action_call integer, cnt_r_3bet_def_action_fold integer, cnt_r_3bet_def_action_raise integer, cnt_r_3bet_opp integer, cnt_f_4bet integer, cnt_f_4bet_def_action_call integer, cnt_f_4bet_def_action_fold integer, cnt_f_4bet_def_action_raise integer, cnt_f_4bet_def_opp integer, cnt_f_4bet_opp integer, cnt_p_4bet integer, cnt_p_4bet_def_action_call integer, cnt_p_4bet_def_action_fold integer, cnt_p_4bet_def_action_raise integer, cnt_p_4bet_def_opp integer, cnt_p_4bet_opp integer, cnt_r_4bet integer, cnt_r_4bet_def_action_call integer, cnt_r_4bet_def_action_fold integer, cnt_r_4bet_def_action_raise integer, cnt_r_4bet_def_opp integer, cnt_r_4bet_opp integer, cnt_t_4bet integer, cnt_t_4bet_def_action_call integer, cnt_t_4bet_def_action_fold integer, cnt_t_4bet_def_action_raise integer, cnt_t_4bet_def_opp integer, cnt_t_4bet_opp integer, cnt_f_cbet integer, cnt_f_cbet_def_action_call integer, cnt_f_cbet_def_action_fold integer, cnt_f_cbet_def_action_raise integer, cnt_f_cbet_def_opp integer, cnt_f_cbet_opp integer, cnt_t_cbet integer, cnt_t_cbet_def_action_call integer, cnt_t_cbet_def_action_fold integer, cnt_t_cbet_def_action_raise integer, cnt_t_cbet_def_opp integer, cnt_t_cbet_opp integer, cnt_r_cbet integer, cnt_r_cbet_def_action_call integer, cnt_r_cbet_def_action_fold integer, cnt_r_cbet_def_action_raise integer, cnt_r_cbet_def_opp integer, cnt_r_cbet_opp integer, cnt_f_bet_def_opp integer, cnt_f_bet_def_action_fold integer, cnt_f_bet_def_action_call integer, cnt_f_bet_def_action_raise integer, cnt_f_raise_def_opp integer, cnt_f_raise_def_action_fold integer, cnt_f_raise_def_action_call integer, cnt_t_bet_def_action_call integer, cnt_t_bet_def_action_fold integer, cnt_t_bet_def_action_raise integer, cnt_t_bet_def_opp integer, cnt_t_raise_def_action_call integer, cnt_t_raise_def_action_fold integer, cnt_t_raise_def_opp integer, cnt_r_bet_def_action_call integer, cnt_r_bet_def_action_fold integer, cnt_r_bet_def_action_raise integer, cnt_r_bet_def_opp integer, amt_bb_won numeric(9,2), cnt_p_first_raise integer, cnt_r_raise_def_action_call integer, cnt_r_raise_def_action_fold integer, cnt_r_raise_def_opp integer, cnt_f_3bet_def_action_raise integer, cnt_r_3bet_def_opp integer, cnt_bb_steal_raise integer, cnt_sb_steal_raise integer, cnt_steal_reraise_def_action_fold integer, cnt_steal_reraise_def_opp integer, cnt_r_float integer, cnt_t_float integer, cnt_t_float_def_action_call integer, cnt_t_float_def_action_fold integer, cnt_t_float_def_action_raise integer, cnt_t_float_def_opp integer, cnt_r_float_def_action_call integer, cnt_r_float_def_action_fold integer, cnt_r_float_def_action_raise integer, cnt_r_float_def_opp integer, cnt_r_donk integer, cnt_r_donk_def_action_call integer, cnt_r_donk_def_action_fold integer, cnt_r_donk_def_action_raise integer, cnt_r_donk_def_opp integer, cnt_t_donk integer, cnt_t_donk_def_action_call integer, cnt_t_donk_def_action_fold integer, cnt_t_donk_def_action_raise integer, cnt_t_donk_def_opp integer, cnt_t_donk_opp integer, cnt_r_donk_opp integer, cnt_r_float_opp integer, cnt_t_float_opp integer, cnt_sessions integer, cnt_sessions_won integer, cnt_hands_won integer, cnt_hands_raked integer, cnt_hands_with_flop integer, cnt_p_face_raise integer, cnt_p_ccall_opp integer);; Reason: Fatal Error (ERROR: relation "holdem_cache" already exists )

Housekeeping problem

Re: Housekeeping problem

Re: Housekeeping problem

Re: Housekeeping problem

Re: Housekeeping problem

Re: Housekeeping problem

Re: Housekeeping problem

Re: Housekeeping problem

Re: Housekeeping problem

Re: Housekeeping problem

Re: Housekeeping problem

Who is online

14 day free trial
download now

PT4 Supported Sites

PT4 Videos

Press Center

follow us on