a couple of seconds after the Update Cache process had begun, this appeared to me:



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_fo ld) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_bb_steal_fo ld) then 1 else 0 end))),
(sum( (case when(holdem_hand_player_statistics.flg_blind_def_o pp AND holdem_hand_player_statistics.flg_blind_s) then 1 else 0 end))),
(sum( (case when(holdem_hand_player_statistics.flg_blind_def_o pp 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_rais e 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_rais e) 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_rai se) 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_rai se) 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_rai se) 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_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_p_3bet_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_p_3bet_act ion='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_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_f_3bet_act ion='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_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_3bet_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_3bet_act ion='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_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_3bet_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_3bet_act ion='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_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_f_4bet_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_f_4bet_act ion='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_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_p_4bet_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_p_4bet_act ion='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_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_4bet_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_4bet_act ion='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_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_4bet_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_4bet_act ion='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_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_f_cbet_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_f_cbet_act ion='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_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_cbet_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_cbet_act ion='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_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_cbet_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_cbet_act ion='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_rais e) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_face_rais e AND holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_face_rais e 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_rais e AND holdem_hand_player_statistics.cnt_t_call > 0) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_face_rais e AND holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_face_rais e) 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( (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( (case when(holdem_hand_player_statistics.flg_p_first_rai se) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_face_rais e AND holdem_hand_player_statistics.cnt_r_call > 0) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_face_rais e AND holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_face_rais e) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_f_3bet_act ion='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_ac tion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_float_ac tion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_float_ac tion='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_ac tion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_float_ac tion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_float_ac tion='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_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_donk_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_donk_act ion='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_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_donk_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_donk_act ion='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_rais e) then 1 else 0 end))),
(sum( (case when( NOT(NOT(holdem_hand_player_statistics.flg_p_face_r aise) 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(holdem_hand_player_statistics.flg_p_first_rai se AND holdem_hand_player_statistics.flg_p_open_opp) 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_fold AND
holdem_hand_player_statistics.position = 8 AND (holdem_hand_summary.cnt_players - holdem_hand_player_detail.val_p_raise_aggressor_po s) = 1 AND holdem_hand_player_statistics.flg_blind_def_opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.position = 8 AND (holdem_hand_summary.cnt_players - holdem_hand_player_detail.val_p_raise_aggressor_po s) = 1 AND holdem_hand_player_statistics.flg_blind_def_opp) 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.flg_showdown) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_blind_def_o pp 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_o pp 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_o pp 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_o pp 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_o pp 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_o pp 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_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_p_3bet and (holdem_hand_player_statistics.flg_blind_b OR holdem_hand_player_statistics.flg_blind_s)) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_3bet_opp and (holdem_hand_player_statistics.flg_blind_b OR holdem_hand_player_statistics.flg_blind_s)) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_3bet and ((holdem_hand_summary.cnt_players = 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players = 5 and holdem_hand_player_statistics.position = 2) or
(holdem_hand_summary.cnt_players = 6 and holdem_hand_player_statistics.position = 3) or
(holdem_hand_summary.cnt_players = 7 and holdem_hand_player_statistics.position = 4) or
(holdem_hand_summary.cnt_players = 8 and (holdem_hand_player_statistics.position = 4 or holdem_hand_player_statistics.position = 5)) or
(holdem_hand_summary.cnt_players = 9 and (holdem_hand_player_statistics.position = 5 or holdem_hand_player_statistics.position = 6)) or
(holdem_hand_summary.cnt_players = 10 and (holdem_hand_player_statistics.position = 6 or holdem_hand_player_statistics.position = 7)))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_3bet_opp and ((holdem_hand_summary.cnt_players = 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players = 5 and holdem_hand_player_statistics.position = 2) or
(holdem_hand_summary.cnt_players = 6 and holdem_hand_player_statistics.position = 3) or
(holdem_hand_summary.cnt_players = 7 and holdem_hand_player_statistics.position = 4) or
(holdem_hand_summary.cnt_players = 8 and (holdem_hand_player_statistics.position = 4 or holdem_hand_player_statistics.position = 5)) or
(holdem_hand_summary.cnt_players = 9 and (holdem_hand_player_statistics.position = 5 or holdem_hand_player_statistics.position = 6)) or
(holdem_hand_summary.cnt_players = 10 and (holdem_hand_player_statistics.position = 6 or holdem_hand_player_statistics.position = 7)))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_3bet and ((holdem_hand_summary.cnt_players > 2 and holdem_hand_player_statistics.position = 0) or
(holdem_hand_summary.cnt_players > 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players > 8 and holdem_hand_player_statistics.position = 2))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_3bet_opp and ((holdem_hand_summary.cnt_players > 2 and holdem_hand_player_statistics.position = 0) or
(holdem_hand_summary.cnt_players > 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players > 8 and holdem_hand_player_statistics.position = 2))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_3bet and
((holdem_hand_player_statistics.position = 2 and holdem_hand_summary.cnt_players > 5 and holdem_hand_summary.cnt_players (holdem_hand_player_statistics.position = 3 and holdem_hand_summary.cnt_players > 6) or
(holdem_hand_player_statistics.position = 4 and holdem_hand_summary.cnt_players > 8))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_3bet_opp and
((holdem_hand_player_statistics.position = 2 and holdem_hand_summary.cnt_players > 5 and holdem_hand_summary.cnt_players (holdem_hand_player_statistics.position = 3 and holdem_hand_summary.cnt_players > 6) or
(holdem_hand_player_statistics.position = 4 and holdem_hand_summary.cnt_players > 8))) then 1 else 0 end))),
(sum((case when(not(holdem_hand_player_statistics.flg_blind_d ef_opp) and holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))),
(sum((case when(not(holdem_hand_player_statistics.flg_blind_d ef_opp) and holdem_hand_player_statistics.flg_p_3bet_opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_4bet and (holdem_hand_player_statistics.flg_blind_b OR holdem_hand_player_statistics.flg_blind_s)) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_4bet_opp and (holdem_hand_player_statistics.flg_blind_b OR holdem_hand_player_statistics.flg_blind_s)) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_4bet and ((holdem_hand_summary.cnt_players = 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players = 5 and holdem_hand_player_statistics.position = 2) or
(holdem_hand_summary.cnt_players = 6 and holdem_hand_player_statistics.position = 3) or
(holdem_hand_summary.cnt_players = 7 and holdem_hand_player_statistics.position = 4) or
(holdem_hand_summary.cnt_players = 8 and (holdem_hand_player_statistics.position = 4 or holdem_hand_player_statistics.position = 5)) or
(holdem_hand_summary.cnt_players = 9 and (holdem_hand_player_statistics.position = 5 or holdem_hand_player_statistics.position = 6)) or
(holdem_hand_summary.cnt_players = 10 and (holdem_hand_player_statistics.position = 6 or holdem_hand_player_statistics.position = 7)))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_4bet_opp and ((holdem_hand_summary.cnt_players = 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players = 5 and holdem_hand_player_statistics.position = 2) or
(holdem_hand_summary.cnt_players = 6 and holdem_hand_player_statistics.position = 3) or
(holdem_hand_summary.cnt_players = 7 and holdem_hand_player_statistics.position = 4) or
(holdem_hand_summary.cnt_players = 8 and (holdem_hand_player_statistics.position = 4 or holdem_hand_player_statistics.position = 5)) or
(holdem_hand_summary.cnt_players = 9 and (holdem_hand_player_statistics.position = 5 or holdem_hand_player_statistics.position = 6)) or
(holdem_hand_summary.cnt_players = 10 and (holdem_hand_player_statistics.position = 6 or holdem_hand_player_statistics.position = 7)))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_4bet and ((holdem_hand_summary.cnt_players > 2 and holdem_hand_player_statistics.position = 0) or
(holdem_hand_summary.cnt_players > 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players > 8 and holdem_hand_player_statistics.position = 2))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_4bet_opp and ((holdem_hand_summary.cnt_players > 2 and holdem_hand_player_statistics.position = 0) or
(holdem_hand_summary.cnt_players > 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players > 8 and holdem_hand_player_statistics.position = 2))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_4bet and
((holdem_hand_player_statistics.position = 2 and holdem_hand_summary.cnt_players > 5 and holdem_hand_summary.cnt_players (holdem_hand_player_statistics.position = 3 and holdem_hand_summary.cnt_players > 6) or
(holdem_hand_player_statistics.position = 4 and holdem_hand_summary.cnt_players > 8))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_4bet_opp and
((holdem_hand_player_statistics.position = 2 and holdem_hand_summary.cnt_players > 5 and holdem_hand_summary.cnt_players (holdem_hand_player_statistics.position = 3 and holdem_hand_summary.cnt_players > 6) or
(holdem_hand_player_statistics.position = 4 and holdem_hand_summary.cnt_players > 8))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_face_rais e AND holdem_hand_player_statistics.flg_p_fold = false AND holdem_hand_player_statistics.cnt_p_raise=0 and (holdem_hand_player_statistics.flg_blind_b OR holdem_hand_player_statistics.flg_blind_s)) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_face_rais e and (holdem_hand_player_statistics.flg_blind_b OR holdem_hand_player_statistics.flg_blind_s)) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_face_rais e 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 (holdem_hand_player_detail.val_p_raise_aggressor_p os (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 (holdem_hand_player_detail.val_p_raise_aggressor_p os (sum((case when(holdem_hand_player_statistics.flg_showdown and
((holdem_hand_player_statistics.position = 2 and holdem_hand_summary.cnt_players > 5 and holdem_hand_summary.cnt_players (holdem_hand_player_statistics.position = 3 and holdem_hand_summary.cnt_players > 6) or
(holdem_hand_player_statistics.position = 4 and holdem_hand_summary.cnt_players > 8))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_saw and
((holdem_hand_player_statistics.position = 2 and holdem_hand_summary.cnt_players > 5 and holdem_hand_summary.cnt_players (holdem_hand_player_statistics.position = 3 and holdem_hand_summary.cnt_players > 6) or
(holdem_hand_player_statistics.position = 4 and holdem_hand_summary.cnt_players > 8))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_showdown and ((holdem_hand_summary.cnt_players > 2 and holdem_hand_player_statistics.position = 0) or
(holdem_hand_summary.cnt_players > 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players > 8 and holdem_hand_player_statistics.position = 2))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_saw and ((holdem_hand_summary.cnt_players > 2 and holdem_hand_player_statistics.position = 0) or
(holdem_hand_summary.cnt_players > 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players > 8 and holdem_hand_player_statistics.position = 2))) then 1 else 0 end))),
(sum((case when( holdem_hand_player_statistics.flg_p_face_raise and holdem_hand_player_statistics.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_po s > holdem_hand_player_statistics.position) 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_po s > holdem_hand_player_statistics.position) then 1 else 0 end))),
(sum((case when(holdem_hand_player_detail.val_p_raise_aggress or_pos = -1 and holdem_hand_player_detail.amt_f_bet_facing > 0 and substring(lookup_actions_f.action from 1 for 1) = 'F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_detail.val_p_raise_aggress or_pos = -1 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 holdem_hand_player_statistics.cnt_p_raise > 0 and holdem_hand_player_detail.val_p_raise_aggressor_po s = -1 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 holdem_hand_player_statistics.cnt_p_raise > 0 and holdem_hand_player_detail.val_p_raise_aggressor_po s = -1 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(holdem_hand_player_statistics.enum_p_3bet_act ion='F' and holdem_hand_player_statistics.flg_p_first_raise and (holdem_hand_player_statistics.flg_blind_b OR holdem_hand_player_statistics.flg_blind_s)) 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 (holdem_hand_player_statistics.flg_blind_b OR holdem_hand_player_statistics.flg_blind_s)) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_p_3bet_act ion='F' and holdem_hand_player_statistics.flg_p_first_raise and ((holdem_hand_summary.cnt_players = 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players = 5 and holdem_hand_player_statistics.position = 2) or
(holdem_hand_summary.cnt_players = 6 and holdem_hand_player_statistics.position = 3) or
(holdem_hand_summary.cnt_players = 7 and holdem_hand_player_statistics.position = 4) or
(holdem_hand_summary.cnt_players = 8 and (holdem_hand_player_statistics.position = 4 or holdem_hand_player_statistics.position = 5)) or
(holdem_hand_summary.cnt_players = 9 and (holdem_hand_player_statistics.position = 5 or holdem_hand_player_statistics.position = 6)) or
(holdem_hand_summary.cnt_players = 10 and (holdem_hand_player_statistics.position = 6 or holdem_hand_player_statistics.position = 7)))) 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 ((holdem_hand_summary.cnt_players = 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players = 5 and holdem_hand_player_statistics.position = 2) or
(holdem_hand_summary.cnt_players = 6 and holdem_hand_player_statistics.position = 3) or
(holdem_hand_summary.cnt_players = 7 and holdem_hand_player_statistics.position = 4) or
(holdem_hand_summary.cnt_players = 8 and (holdem_hand_player_statistics.position = 4 or holdem_hand_player_statistics.position = 5)) or
(holdem_hand_summary.cnt_players = 9 and (holdem_hand_player_statistics.position = 5 or holdem_hand_player_statistics.position = 6)) or
(holdem_hand_summary.cnt_players = 10 and (holdem_hand_player_statistics.position = 6 or holdem_hand_player_statistics.position = 7)))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_p_3bet_act ion='F' and holdem_hand_player_statistics.flg_p_first_raise and ((holdem_hand_summary.cnt_players > 2 and holdem_hand_player_statistics.position = 0) or
(holdem_hand_summary.cnt_players > 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players > 8 and holdem_hand_player_statistics.position = 2))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_3bet_def_ opp and holdem_hand_player_statistics.flg_p_first_raise and ((holdem_hand_summary.cnt_players > 2 and holdem_hand_player_statistics.position = 0) or
(holdem_hand_summary.cnt_players > 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players > 8 and holdem_hand_player_statistics.position = 2))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_p_3bet_act ion='F' and holdem_hand_player_statistics.flg_p_first_raise and
((holdem_hand_player_statistics.position = 2 and holdem_hand_summary.cnt_players > 5 and holdem_hand_summary.cnt_players (holdem_hand_player_statistics.position = 3 and holdem_hand_summary.cnt_players > 6) or
(holdem_hand_player_statistics.position = 4 and holdem_hand_summary.cnt_players > 8))) 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
((holdem_hand_player_statistics.position = 2 and holdem_hand_summary.cnt_players > 5 and holdem_hand_summary.cnt_players (holdem_hand_player_statistics.position = 3 and holdem_hand_summary.cnt_players > 6) or
(holdem_hand_player_statistics.position = 4 and holdem_hand_summary.cnt_players > 8))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0 and (holdem_hand_player_statistics.flg_blind_b OR holdem_hand_player_statistics.flg_blind_s)) then 1 else 0 end))),
(sum( (case when(holdem_hand_player_statistics.flg_blind_b OR holdem_hand_player_statistics.flg_blind_s) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0 and ((holdem_hand_summary.cnt_players = 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players = 5 and holdem_hand_player_statistics.position = 2) or
(holdem_hand_summary.cnt_players = 6 and holdem_hand_player_statistics.position = 3) or
(holdem_hand_summary.cnt_players = 7 and holdem_hand_player_statistics.position = 4) or
(holdem_hand_summary.cnt_players = 8 and (holdem_hand_player_statistics.position = 4 or holdem_hand_player_statistics.position = 5)) or
(holdem_hand_summary.cnt_players = 9 and (holdem_hand_player_statistics.position = 5 or holdem_hand_player_statistics.position = 6)) or
(holdem_hand_summary.cnt_players = 10 and (holdem_hand_player_statistics.position = 6 or holdem_hand_player_statistics.position = 7)))) then 1 else 0 end))),
(sum((case when(((holdem_hand_summary.cnt_players = 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players = 5 and holdem_hand_player_statistics.position = 2) or
(holdem_hand_summary.cnt_players = 6 and holdem_hand_player_statistics.position = 3) or
(holdem_hand_summary.cnt_players = 7 and holdem_hand_player_statistics.position = 4) or
(holdem_hand_summary.cnt_players = 8 and (holdem_hand_player_statistics.position = 4 or holdem_hand_player_statistics.position = 5)) or
(holdem_hand_summary.cnt_players = 9 and (holdem_hand_player_statistics.position = 5 or holdem_hand_player_statistics.position = 6)) or
(holdem_hand_summary.cnt_players = 10 and (holdem_hand_player_statistics.position = 6 or holdem_hand_player_statistics.position = 7)))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0 and ((holdem_hand_summary.cnt_players > 2 and holdem_hand_player_statistics.position = 0) or
(holdem_hand_summary.cnt_players > 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players > 8 and holdem_hand_player_statistics.position = 2))) then 1 else 0 end))),
(sum((case when(((holdem_hand_summary.cnt_players > 2 and holdem_hand_player_statistics.position = 0) or
(holdem_hand_summary.cnt_players > 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players > 8 and holdem_hand_player_statistics.position = 2))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0 and
((holdem_hand_player_statistics.position = 2 and holdem_hand_summary.cnt_players > 5 and holdem_hand_summary.cnt_players (holdem_hand_player_statistics.position = 3 and holdem_hand_summary.cnt_players > 6) or
(holdem_hand_player_statistics.position = 4 and holdem_hand_summary.cnt_players > 8))) then 1 else 0 end))),
(sum((case when(
((holdem_hand_player_statistics.position = 2 and holdem_hand_summary.cnt_players > 5 and holdem_hand_summary.cnt_players (holdem_hand_player_statistics.position = 3 and holdem_hand_summary.cnt_players > 6) or
(holdem_hand_player_statistics.position = 4 and holdem_hand_summary.cnt_players > 8))) then 1 else 0 end))),
(sum( (case when(holdem_hand_player_statistics.flg_p_limp AND substring(lookup_actions_p.action from 2 for 1)='R' and (holdem_hand_player_statistics.flg_blind_b OR holdem_hand_player_statistics.flg_blind_s)) then 1 else 0 end) )),
(sum( (case when(holdem_hand_player_statistics.flg_p_limp AND holdem_hand_player_statistics.flg_p_face_raise and (holdem_hand_player_statistics.flg_blind_b OR holdem_hand_player_statistics.flg_blind_s)) then 1 else 0 end) )),
(sum( (case when(holdem_hand_player_statistics.flg_p_limp AND substring(lookup_actions_p.action from 2 for 1)='R' and ((holdem_hand_summary.cnt_players = 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players = 5 and holdem_hand_player_statistics.position = 2) or
(holdem_hand_summary.cnt_players = 6 and holdem_hand_player_statistics.position = 3) or
(holdem_hand_summary.cnt_players = 7 and holdem_hand_player_statistics.position = 4) or
(holdem_hand_summary.cnt_players = 8 and (holdem_hand_player_statistics.position = 4 or holdem_hand_player_statistics.position = 5)) or
(holdem_hand_summary.cnt_players = 9 and (holdem_hand_player_statistics.position = 5 or holdem_hand_player_statistics.position = 6)) or
(holdem_hand_summary.cnt_players = 10 and (holdem_hand_player_statistics.position = 6 or holdem_hand_player_statistics.position = 7)))) then 1 else 0 end) )),
(sum( (case when(holdem_hand_player_statistics.flg_p_limp AND holdem_hand_player_statistics.flg_p_face_raise and ((holdem_hand_summary.cnt_players = 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players = 5 and holdem_hand_player_statistics.position = 2) or
(holdem_hand_summary.cnt_players = 6 and holdem_hand_player_statistics.position = 3) or
(holdem_hand_summary.cnt_players = 7 and holdem_hand_player_statistics.position = 4) or
(holdem_hand_summary.cnt_players = 8 and (holdem_hand_player_statistics.position = 4 or holdem_hand_player_statistics.position = 5)) or
(holdem_hand_summary.cnt_players = 9 and (holdem_hand_player_statistics.position = 5 or holdem_hand_player_statistics.position = 6)) or
(holdem_hand_summary.cnt_players = 10 and (holdem_hand_player_statistics.position = 6 or holdem_hand_player_statistics.position = 7)))) then 1 else 0 end) )),
(sum( (case when(holdem_hand_player_statistics.flg_p_limp AND substring(lookup_actions_p.action from 2 for 1)='R' and ((holdem_hand_summary.cnt_players > 2 and holdem_hand_player_statistics.position = 0) or
(holdem_hand_summary.cnt_players > 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players > 8 and holdem_hand_player_statistics.position = 2))) then 1 else 0 end) )),
(sum( (case when(holdem_hand_player_statistics.flg_p_limp AND holdem_hand_player_statistics.flg_p_face_raise and ((holdem_hand_summary.cnt_players > 2 and holdem_hand_player_statistics.position = 0) or
(holdem_hand_summary.cnt_players > 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players > 8 and holdem_hand_player_statistics.position = 2))) then 1 else 0 end) )),
(sum( (case when(holdem_hand_player_statistics.flg_p_limp AND substring(lookup_actions_p.action from 2 for 1)='R' and
((holdem_hand_player_statistics.position = 2 and holdem_hand_summary.cnt_players > 5 and holdem_hand_summary.cnt_players (holdem_hand_player_statistics.position = 3 and holdem_hand_summary.cnt_players > 6) or
(holdem_hand_player_statistics.position = 4 and holdem_hand_summary.cnt_players > 8))) then 1 else 0 end) )),
(sum( (case when(holdem_hand_player_statistics.flg_p_limp AND holdem_hand_player_statistics.flg_p_face_raise and
((holdem_hand_player_statistics.position = 2 and holdem_hand_summary.cnt_players > 5 and holdem_hand_summary.cnt_players (holdem_hand_player_statistics.position = 3 and holdem_hand_summary.cnt_players > 6) or
(holdem_hand_player_statistics.position = 4 and holdem_hand_summary.cnt_players > 8))) then 1 else 0 end) )),
(sum((case when(holdem_hand_player_statistics.flg_f_saw and (holdem_hand_player_statistics.flg_blind_b OR holdem_hand_player_statistics.flg_blind_s)) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_saw and ((holdem_hand_summary.cnt_players = 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players = 5 and holdem_hand_player_statistics.position = 2) or
(holdem_hand_summary.cnt_players = 6 and holdem_hand_player_statistics.position = 3) or
(holdem_hand_summary.cnt_players = 7 and holdem_hand_player_statistics.position = 4) or
(holdem_hand_summary.cnt_players = 8 and (holdem_hand_player_statistics.position = 4 or holdem_hand_player_statistics.position = 5)) or
(holdem_hand_summary.cnt_players = 9 and (holdem_hand_player_statistics.position = 5 or holdem_hand_player_statistics.position = 6)) or
(holdem_hand_summary.cnt_players = 10 and (holdem_hand_player_statistics.position = 6 or holdem_hand_player_statistics.position = 7)))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_vpip and (holdem_hand_player_statistics.flg_blind_b OR holdem_hand_player_statistics.flg_blind_s)) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_vpip and
((holdem_hand_summary.cnt_players = 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players = 5 and holdem_hand_player_statistics.position = 2) or
(holdem_hand_summary.cnt_players = 6 and holdem_hand_player_statistics.position = 3) or
(holdem_hand_summary.cnt_players = 7 and holdem_hand_player_statistics.position = 4) or
(holdem_hand_summary.cnt_players = 8 and (holdem_hand_player_statistics.position = 4 or holdem_hand_player_statistics.position = 5)) or
(holdem_hand_summary.cnt_players = 9 and (holdem_hand_player_statistics.position = 5 or holdem_hand_player_statistics.position = 6)) or
(holdem_hand_summary.cnt_players = 10 and (holdem_hand_player_statistics.position = 6 or holdem_hand_player_statistics.position = 7)))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_vpip and ((holdem_hand_summary.cnt_players > 2 and holdem_hand_player_statistics.position = 0) or
(holdem_hand_summary.cnt_players > 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players > 8 and 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 = 2 and holdem_hand_summary.cnt_players > 5 and holdem_hand_summary.cnt_players (holdem_hand_player_statistics.position = 3 and holdem_hand_summary.cnt_players > 6) or
(holdem_hand_player_statistics.position = 4 and holdem_hand_summary.cnt_players > 8))) then 1 else 0 end))),
(sum( (case when(holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand and (holdem_hand_player_statistics.flg_blind_b OR holdem_hand_player_statistics.flg_blind_s)) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_showdown and (holdem_hand_player_statistics.flg_blind_b OR holdem_hand_player_statistics.flg_blind_s)) then 1 else 0 end))),
(sum( (case when(holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand and ((holdem_hand_summary.cnt_players = 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players = 5 and holdem_hand_player_statistics.position = 2) or
(holdem_hand_summary.cnt_players = 6 and holdem_hand_player_statistics.position = 3) or
(holdem_hand_summary.cnt_players = 7 and holdem_hand_player_statistics.position = 4) or
(holdem_hand_summary.cnt_players = 8 and (holdem_hand_player_statistics.position = 4 or holdem_hand_player_statistics.position = 5)) or
(holdem_hand_summary.cnt_players = 9 and (holdem_hand_player_statistics.position = 5 or holdem_hand_player_statistics.position = 6)) or
(holdem_hand_summary.cnt_players = 10 and (holdem_hand_player_statistics.position = 6 or holdem_hand_player_statistics.position = 7)))) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_showdown and ((holdem_hand_summary.cnt_players = 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players = 5 and holdem_hand_player_statistics.position = 2) or
(holdem_hand_summary.cnt_players = 6 and holdem_hand_player_statistics.position = 3) or
(holdem_hand_summary.cnt_players = 7 and holdem_hand_player_statistics.position = 4) or
(holdem_hand_summary.cnt_players = 8 and (holdem_hand_player_statistics.position = 4 or holdem_hand_player_statistics.position = 5)) or
(holdem_hand_summary.cnt_players = 9 and (holdem_hand_player_statistics.position = 5 or holdem_hand_player_statistics.position = 6)) or
(holdem_hand_summary.cnt_players = 10 and (holdem_hand_player_statistics.position = 6 or holdem_hand_player_statistics.position = 7)))) then 1 else 0 end))),
(sum( (case when(holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand and ((holdem_hand_summary.cnt_players > 2 and holdem_hand_player_statistics.position = 0) or
(holdem_hand_summary.cnt_players > 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players > 8 and holdem_hand_player_statistics.position = 2))) then 1 else 0 end))),
(sum( (case when(holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand and
((holdem_hand_player_statistics.position = 2 and holdem_hand_summary.cnt_players > 5 and holdem_hand_summary.cnt_players (holdem_hand_player_statistics.position = 3 and holdem_hand_summary.cnt_players > 6) or
(holdem_hand_player_statistics.position = 4 and holdem_hand_summary.cnt_players > 8))) then 1 else 0 end))),
(sum( (case when( holdem_hand_player_statistics.flg_blind_db and
(((holdem_hand_player_statistics.position = 2 and holdem_hand_summary.cnt_players > 5 and holdem_hand_summary.cnt_players (holdem_hand_player_statistics.position = 3 and holdem_hand_summary.cnt_players > 6) or
(holdem_hand_player_statistics.position = 4 and holdem_hand_summary.cnt_players > 8)) or
((holdem_hand_summary.cnt_players = 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players = 5 and holdem_hand_player_statistics.position = 2) or
(holdem_hand_summary.cnt_players = 6 and holdem_hand_player_statistics.position = 3) or
(holdem_hand_summary.cnt_players = 7 and holdem_hand_player_statistics.position = 4) or
(holdem_hand_summary.cnt_players = 8 and (holdem_hand_player_statistics.position = 4 or holdem_hand_player_statistics.position = 5)) or
(holdem_hand_summary.cnt_players = 9 and (holdem_hand_player_statistics.position = 5 or holdem_hand_player_statistics.position = 6)) or
(holdem_hand_summary.cnt_players = 10 and (holdem_hand_player_statistics.position = 6 or holdem_hand_player_statistics.position = 7)))) ) 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=' F') 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.enum_p_3bet_act ion='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.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_limp and not(holdem_hand_player_statistics.flg_f_saw)) then 1 else 0 end))),
(sum( (case when(holdem_hand_player_statistics.flg_p_limp and holdem_hand_player_statistics.flg_p_face_raise) then 1 else 0 end))),
(sum(holdem_hand_player_detail.val_f_bet_made_pct) ),
(sum(holdem_hand_player_detail.val_r_bet_made_pct) ),
(sum(holdem_hand_player_detail.val_t_bet_made_pct) )
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: missing FROM-clause entry in subquery for table "lookup_actions_f" LINE 283: ..._player_detail.amt_f_bet_facing > 0 and substring(lookup_act... ^ )




what's wrong?

You're still using Build 3 and you have a stat that requires use of the more recent Beta versions. Upgrade to Beta 23 and housekeeping should complete as normal.

There is a stat you have that contains the column holdem_hand_player_statistics.lookup_actions_f, replace that with
holdem_hand_player_statistics.enum_f_cbet_action, and I think it should work, enum_f_cbet_action contains the actions on the flop with a continuation bet, and what the player did, but what I am not sure about is if LIKE 'BF' will work, since its an enum ... I think these can contain only 1 character, but I am unsure.

enum_f_cbet_action is just the action a player made in response to a cbet. The issue the OP was discussing was resolved with a software update quite a while ago.