PostgreSQL on Mac unable to login to database

[benegizer]

2013-10-18 22:14:16 JST ERROR: canceling statement due to user request
2013-10-18 22:14:16 JST STATEMENT: SELECT (player_real.player_name_search) as "str_player_name_search_real", (sum((case when(tourney_holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))) as "cnt_hands", (session.str_player_name) as "str_player_name", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))) as "_pos_cnt_hands_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))) as "_pos_cnt_hands_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))) as "_pos_cnt_hands_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))) as "_pos_cnt_hands_lp", (sum(tourney_holdem_hand_player_statistics.amt_won)) as "amt_won", (sum((case when((lookup_positions.flg_blinds=true)) then (tourney_holdem_hand_player_statistics.amt_won) else 0 end))) as "_pos_amt_won_blind", (sum((case when((lookup_positions.flg_ep=true)) then (tourney_holdem_hand_player_statistics.amt_won) else 0 end))) as "_pos_amt_won_ep", (sum((case when((lookup_positions.flg_mp=true)) then (tourney_holdem_hand_player_statistics.amt_won) else 0 end))) as "_pos_amt_won_mp", (sum((case when((lookup_positions.flg_lp=true)) then (tourney_holdem_hand_player_statistics.amt_won) else 0 end))) as "_pos_amt_won_lp", (sum( (CASE WHEN ( (tourney_holdem_blinds.amt_bb *tourney_holdem_blinds.val_nlpl_mult)) <> 0 THEN ( (CASE WHEN (( (tourney_holdem_blinds.amt_bb *tourney_holdem_blinds.val_nlpl_mult))) <> 0 THEN (((tourney_holdem_hand_player_statistics.amt_won * 1.0 ))/(( (tourney_holdem_blinds.amt_bb *tourney_holdem_blinds.val_nlpl_mult)))) ELSE 0 END) ) ELSE 0 END) )) as "amt_bb_won", (sum((case when((lookup_positions.flg_blinds=true)) then ( (CASE WHEN ( (tourney_holdem_blinds.amt_bb *tourney_holdem_blinds.val_nlpl_mult)) <> 0 THEN ((tourney_holdem_hand_player_statistics.amt_won * 1.0 * 1.0 )/( (tourney_holdem_blinds.amt_bb *tourney_holdem_blinds.val_nlpl_mult))) ELSE 0 END) ) else 0 end))) as "_pos_amt_bb_won_blind", (sum((case when((lookup_positions.flg_ep=true)) then ( (CASE WHEN ( (tourney_holdem_blinds.amt_bb *tourney_holdem_blinds.val_nlpl_mult)) <> 0 THEN ((tourney_holdem_hand_player_statistics.amt_won * 1.0 * 1.0 )/( (tourney_holdem_blinds.amt_bb *tourney_holdem_blinds.val_nlpl_mult))) ELSE 0 END) ) else 0 end))) as "_pos_amt_bb_won_ep", (sum((case when((lookup_positions.flg_mp=true)) then ( (CASE WHEN ( (tourney_holdem_blinds.amt_bb *tourney_holdem_blinds.val_nlpl_mult)) <> 0 THEN ((tourney_holdem_hand_player_statistics.amt_won * 1.0 * 1.0 )/( (tourney_holdem_blinds.amt_bb *tourney_holdem_blinds.val_nlpl_mult))) ELSE 0 END) ) else 0 end))) as "_pos_amt_bb_won_mp", (sum((case when((lookup_positions.flg_lp=true)) then ( (CASE WHEN ( (tourney_holdem_blinds.amt_bb *tourney_holdem_blinds.val_nlpl_mult)) <> 0 THEN ((tourney_holdem_hand_player_statistics.amt_won * 1.0 * 1.0 )/( (tourney_holdem_blinds.amt_bb *tourney_holdem_blinds.val_nlpl_mult))) ELSE 0 END) ) else 0 end))) as "_pos_amt_bb_won_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))) as "cnt_won_hand", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))) as "_pos_cnt_won_hand_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))) as "_pos_cnt_won_hand_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))) as "_pos_cnt_won_hand_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))) as "_pos_cnt_won_hand_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))) as "cnt_vpip", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))) as "_pos_cnt_vpip_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))) as "_pos_cnt_vpip_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))) as "_pos_cnt_vpip_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))) as "_pos_cnt_vpip_lp", (sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))) as "cnt_pfr", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))) as "_pos_cnt_pfr_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))) as "_pos_cnt_pfr_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))) as "_pos_cnt_pfr_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))) as "_pos_cnt_pfr_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "cnt_wtsd", (sum((case when(tourney_holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))) as "cnt_f_saw", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))) as "_pos_cnt_f_saw_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))) as "_pos_cnt_f_saw_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))) as "_pos_cnt_f_saw_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))) as "_pos_cnt_f_saw_lp", (sum( (case when(tourney_holdem_hand_player_statistics.flg_showdown AND tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))) as "cnt_wtsd_won", (sum( (case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_showdown AND tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))) as "_pos_cnt_wtsd_won_blind", (sum( (case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_showdown AND tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))) as "_pos_cnt_wtsd_won_ep", (sum( (case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_showdown AND tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))) as "_pos_cnt_wtsd_won_mp", (sum( (case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_showdown AND tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))) as "_pos_cnt_wtsd_won_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))) as "cnt_f_bet", (sum(tourney_holdem_hand_player_statistics.cnt_f_raise)) as "cnt_f_raise", (sum((case when(tourney_holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))) as "cnt_t_bet", (sum(tourney_holdem_hand_player_statistics.cnt_t_raise)) as "cnt_t_raise", (sum((case when(tourney_holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))) as "cnt_r_bet", (sum(tourney_holdem_hand_player_statistics.cnt_r_raise)) as "cnt_r_raise", (sum(tourney_holdem_hand_player_statistics.cnt_f_call)) as "cnt_f_call", (sum((case when(tourney_holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))) as "cnt_f_fold", (sum(tourney_holdem_hand_player_statistics.cnt_t_call)) as "cnt_t_call", (sum((case when(tourney_holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))) as "cnt_t_fold", (sum(tourney_holdem_hand_player_statistics.cnt_r_call)) as "cnt_r_call", (sum((case when(tourney_holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))) as "cnt_r_fold", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))) as "_pos_cnt_f_bet_blind", (sum((case when((lookup_positions.flg_blinds=true)) then (tourney_holdem_hand_player_statistics.cnt_f_raise) else 0 end))) as "_pos_cnt_f_raise_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))) as "_pos_cnt_t_bet_blind", (sum((case when((lookup_positions.flg_blinds=true)) then (tourney_holdem_hand_player_statistics.cnt_t_raise) else 0 end))) as "_pos_cnt_t_raise_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))) as "_pos_cnt_r_bet_blind", (sum((case when((lookup_positions.flg_blinds=true)) then (tourney_holdem_hand_player_statistics.cnt_r_raise) else 0 end))) as "_pos_cnt_r_raise_blind", (sum((case when((lookup_positions.flg_blinds=true)) then (tourney_holdem_hand_player_statistics.cnt_f_call) else 0 end))) as "_pos_cnt_f_call_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))) as "_pos_cnt_f_fold_blind", (sum((case when((lookup_positions.flg_blinds=true)) then (tourney_holdem_hand_player_statistics.cnt_t_call) else 0 end))) as "_pos_cnt_t_call_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))) as "_pos_cnt_t_fold_blind", (sum((case when((lookup_positions.flg_blinds=true)) then (tourney_holdem_hand_player_statistics.cnt_r_call) else 0 end))) as "_pos_cnt_r_call_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))) as "_pos_cnt_r_fold_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))) as "_pos_cnt_f_bet_ep", (sum((case when((lookup_positions.flg_ep=true)) then (tourney_holdem_hand_player_statistics.cnt_f_raise) else 0 end))) as "_pos_cnt_f_raise_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))) as "_pos_cnt_t_bet_ep", (sum((case when((lookup_positions.flg_ep=true)) then (tourney_holdem_hand_player_statistics.cnt_t_raise) else 0 end))) as "_pos_cnt_t_raise_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))) as "_pos_cnt_r_bet_ep", (sum((case when((lookup_positions.flg_ep=true)) then (tourney_holdem_hand_player_statistics.cnt_r_raise) else 0 end))) as "_pos_cnt_r_raise_ep", (sum((case when((lookup_positions.flg_ep=true)) then (tourney_holdem_hand_player_statistics.cnt_f_call) else 0 end))) as "_pos_cnt_f_call_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))) as "_pos_cnt_f_fold_ep", (sum((case when((lookup_positions.flg_ep=true)) then (tourney_holdem_hand_player_statistics.cnt_t_call) else 0 end))) as "_pos_cnt_t_call_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))) as "_pos_cnt_t_fold_ep", (sum((case when((lookup_positions.flg_ep=true)) then (tourney_holdem_hand_player_statistics.cnt_r_call) else 0 end))) as "_pos_cnt_r_call_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))) as "_pos_cnt_r_fold_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))) as "_pos_cnt_f_bet_mp", (sum((case when((lookup_positions.flg_mp=true)) then (tourney_holdem_hand_player_statistics.cnt_f_raise) else 0 end))) as "_pos_cnt_f_raise_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))) as "_pos_cnt_t_bet_mp", (sum((case when((lookup_positions.flg_mp=true)) then (tourney_holdem_hand_player_statistics.cnt_t_raise) else 0 end))) as "_pos_cnt_t_raise_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))) as "_pos_cnt_r_bet_mp", (sum((case when((lookup_positions.flg_mp=true)) then (tourney_holdem_hand_player_statistics.cnt_r_raise) else 0 end))) as "_pos_cnt_r_raise_mp", (sum((case when((lookup_positions.flg_mp=true)) then (tourney_holdem_hand_player_statistics.cnt_f_call) else 0 end))) as "_pos_cnt_f_call_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))) as "_pos_cnt_f_fold_mp", (sum((case when((lookup_positions.flg_mp=true)) then (tourney_holdem_hand_player_statistics.cnt_t_call) else 0 end))) as "_pos_cnt_t_call_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))) as "_pos_cnt_t_fold_mp", (sum((case when((lookup_positions.flg_mp=true)) then (tourney_holdem_hand_player_statistics.cnt_r_call) else 0 end))) as "_pos_cnt_r_call_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))) as "_pos_cnt_r_fold_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))) as "_pos_cnt_f_bet_lp", (sum((case when((lookup_positions.flg_lp=true)) then (tourney_holdem_hand_player_statistics.cnt_f_raise) else 0 end))) as "_pos_cnt_f_raise_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))) as "_pos_cnt_t_bet_lp", (sum((case when((lookup_positions.flg_lp=true)) then (tourney_holdem_hand_player_statistics.cnt_t_raise) else 0 end))) as "_pos_cnt_t_raise_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))) as "_pos_cnt_r_bet_lp", (sum((case when((lookup_positions.flg_lp=true)) then (tourney_holdem_hand_player_statistics.cnt_r_raise) else 0 end))) as "_pos_cnt_r_raise_lp", (sum((case when((lookup_positions.flg_lp=true)) then (tourney_holdem_hand_player_statistics.cnt_f_call) else 0 end))) as "_pos_cnt_f_call_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))) as "_pos_cnt_f_fold_lp", (sum((case when((lookup_positions.flg_lp=true)) then (tourney_holdem_hand_player_statistics.cnt_t_call) else 0 end))) as "_pos_cnt_t_call_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))) as "_pos_cnt_t_fold_lp", (sum((case when((lookup_positions.flg_lp=true)) then (tourney_holdem_hand_player_statistics.cnt_r_call) else 0 end))) as "_pos_cnt_r_call_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))) as "_pos_cnt_r_fold_lp", (sum((case when( (tourney_holdem_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'C%C%') OR ((NOT tourney_holdem_hand_player_statistics.flg_p_limp) AND lookup_actions_p.action LIKE '%C%') ) then 1 else 0 end))) as "cnt_p_pfr_call", (sum((case when(tourney_holdem_hand_player_statistics.flg_p_face_raise) then 1 else 0 end))) as "cnt_p_pfr_call_opp", (sum((case when((lookup_positions.flg_blinds=true) AND (tourney_holdem_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'C%C%') OR ((NOT tourney_holdem_hand_player_statistics.flg_p_limp) AND lookup_actions_p.action LIKE '%C%') ) then 1 else 0 end))) as "_pos_cnt_p_pfr_call_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_p_face_raise) then 1 else 0 end))) as "_pos_cnt_p_pfr_call_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND (tourney_holdem_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'C%C%') OR ((NOT tourney_holdem_hand_player_statistics.flg_p_limp) AND lookup_actions_p.action LIKE '%C%') ) then 1 else 0 end))) as "_pos_cnt_p_pfr_call_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_p_face_raise) then 1 else 0 end))) as "_pos_cnt_p_pfr_call_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND (tourney_holdem_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'C%C%') OR ((NOT tourney_holdem_hand_player_statistics.flg_p_limp) AND lookup_actions_p.action LIKE '%C%') ) then 1 else 0 end))) as "_pos_cnt_p_pfr_call_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_p_face_raise) then 1 else 0 end))) as "_pos_cnt_p_pfr_call_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND (tourney_holdem_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'C%C%') OR ((NOT tourney_holdem_hand_player_statistics.flg_p_limp) AND lookup_actions_p.action LIKE '%C%') ) then 1 else 0 end))) as "_pos_cnt_p_pfr_call_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_p_face_raise) then 1 else 0 end))) as "_pos_cnt_p_pfr_call_opp_lp", (sum((case when(tourney_holdem_hand_player_statistics.enum_p_3bet_action='C') then 1 else 0 end))) as "cnt_p_3bet_def_action_call", (sum((case when(tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp) then 1 else 0 end))) as "cnt_p_3bet_def_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.enum_p_3bet_action='C') then 1 else 0 end))) as "_pos_cnt_p_3bet_def_action_call_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp) then 1 else 0 end))) as "_pos_cnt_p_3bet_def_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.enum_p_3bet_action='C') then 1 else 0 end))) as "_pos_cnt_p_3bet_def_action_call_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp) then 1 else 0 end))) as "_pos_cnt_p_3bet_def_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.enum_p_3bet_action='C') then 1 else 0 end))) as "_pos_cnt_p_3bet_def_action_call_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp) then 1 else 0 end))) as "_pos_cnt_p_3bet_def_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.enum_p_3bet_action='C') then 1 else 0 end))) as "_pos_cnt_p_3bet_def_action_call_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp) then 1 else 0 end))) as "_pos_cnt_p_3bet_def_opp_lp", (sum((case when(tourney_holdem_hand_player_statistics.enum_p_3bet_action='F') then 1 else 0 end))) as "cnt_p_3bet_def_action_fold", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.enum_p_3bet_action='F') then 1 else 0 end))) as "_pos_cnt_p_3bet_def_action_fold_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.enum_p_3bet_action='F') then 1 else 0 end))) as "_pos_cnt_p_3bet_def_action_fold_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.enum_p_3bet_action='F') then 1 else 0 end))) as "_pos_cnt_p_3bet_def_action_fold_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.enum_p_3bet_action='F') then 1 else 0 end))) as "_pos_cnt_p_3bet_def_action_fold_lp", (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_open = false AND tourney_holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))) as "cnt_prev_callers_limp", (sum( (case when( ((NOT tourney_holdem_hand_player_statistics.flg_p_face_raise) OR tourney_holdem_hand_player_statistics.flg_p_limp OR tourney_holdem_hand_player_statistics.flg_p_first_raise) AND NOT tourney_holdem_hand_player_statistics.flg_p_open_opp AND lookup_actions_p.action <> '') then 1 else 0 end) )) as "cnt_p_facing_limpers", (sum( (case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_p_open = false AND tourney_holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))) as "_pos_cnt_prev_callers_limp_blind", (sum( (case when((lookup_positions.flg_blinds=true) AND ((NOT tourney_holdem_hand_player_statistics.flg_p_face_raise) OR tourney_holdem_hand_player_statistics.flg_p_limp OR tourney_holdem_hand_player_statistics.flg_p_first_raise) AND NOT tourney_holdem_hand_player_statistics.flg_p_open_opp AND lookup_actions_p.action <> '') then 1 else 0 end) )) as "_pos_cnt_p_facing_limpers_blind", (sum( (case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_p_open = false AND tourney_holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))) as "_pos_cnt_prev_callers_limp_ep", (sum( (case when((lookup_positions.flg_ep=true) AND ((NOT tourney_holdem_hand_player_statistics.flg_p_face_raise) OR tourney_holdem_hand_player_statistics.flg_p_limp OR tourney_holdem_hand_player_statistics.flg_p_first_raise) AND NOT tourney_holdem_hand_player_statistics.flg_p_open_opp AND lookup_actions_p.action <> '') then 1 else 0 end) )) as "_pos_cnt_p_facing_limpers_ep", (sum( (case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_p_open = false AND tourney_holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))) as "_pos_cnt_prev_callers_limp_mp", (sum( (case when((lookup_positions.flg_mp=true) AND ((NOT tourney_holdem_hand_player_statistics.flg_p_face_raise) OR tourney_holdem_hand_player_statistics.flg_p_limp OR tourney_holdem_hand_player_statistics.flg_p_first_raise) AND NOT tourney_holdem_hand_player_statistics.flg_p_open_opp AND lookup_actions_p.action <> '') then 1 else 0 end) )) as "_pos_cnt_p_facing_limpers_mp", (sum( (case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_p_open = false AND tourney_holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))) as "_pos_cnt_prev_callers_limp_lp", (sum( (case when((lookup_positions.flg_lp=true) AND ((NOT tourney_holdem_hand_player_statistics.flg_p_face_raise) OR tourney_holdem_hand_player_statistics.flg_p_limp OR tourney_holdem_hand_player_statistics.flg_p_first_raise) AND NOT tourney_holdem_hand_player_statistics.flg_p_open_opp AND lookup_actions_p.action <> '') then 1 else 0 end) )) as "_pos_cnt_p_facing_limpers_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))) as "cnt_p_ccall", (sum( (case when( NOT(NOT(tourney_holdem_hand_player_statistics.flg_p_face_raise) OR (tourney_holdem_hand_player_statistics.flg_p_limp) OR (tourney_holdem_hand_player_statistics.flg_p_first_raise)) AND (tourney_holdem_hand_player_detail.amt_blind=0)) then 1 else 0 end) )) as "cnt_p_ccall_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))) as "_pos_cnt_p_ccall_blind", (sum( (case when((lookup_positions.flg_blinds=true) AND NOT(NOT(tourney_holdem_hand_player_statistics.flg_p_face_raise) OR (tourney_holdem_hand_player_statistics.flg_p_limp) OR (tourney_holdem_hand_player_statistics.flg_p_first_raise)) AND (tourney_holdem_hand_player_detail.amt_blind=0)) then 1 else 0 end) )) as "_pos_cnt_p_ccall_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))) as "_pos_cnt_p_ccall_ep", (sum( (case when((lookup_positions.flg_ep=true) AND NOT(NOT(tourney_holdem_hand_player_statistics.flg_p_face_raise) OR (tourney_holdem_hand_player_statistics.flg_p_limp) OR (tourney_holdem_hand_player_statistics.flg_p_first_raise)) AND (tourney_holdem_hand_player_detail.amt_blind=0)) then 1 else 0 end) )) as "_pos_cnt_p_ccall_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))) as "_pos_cnt_p_ccall_mp", (sum( (case when((lookup_positions.flg_mp=true) AND NOT(NOT(tourney_holdem_hand_player_statistics.flg_p_face_raise) OR (tourney_holdem_hand_player_statistics.flg_p_limp) OR (tourney_holdem_hand_player_statistics.flg_p_first_raise)) AND (tourney_holdem_hand_player_detail.amt_blind=0)) then 1 else 0 end) )) as "_pos_cnt_p_ccall_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))) as "_pos_cnt_p_ccall_lp", (sum( (case when((lookup_positions.flg_lp=true) AND NOT(NOT(tourney_holdem_hand_player_statistics.flg_p_face_raise) OR (tourney_holdem_hand_player_statistics.flg_p_limp) OR (tourney_holdem_hand_player_statistics.flg_p_first_raise)) AND (tourney_holdem_hand_player_detail.amt_blind=0)) then 1 else 0 end) )) as "_pos_cnt_p_ccall_opp_lp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_bb_steal_fold) then 1 else 0 end))) as "_pos_cnt_bb_steal_fold_blind", (sum( (case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_b) then 1 else 0 end))) as "_pos_cnt_steal_def_opp_bb_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_sb_steal_fold) then 1 else 0 end))) as "_pos_cnt_sb_steal_fold_blind", (sum( (case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_s) then 1 else 0 end))) as "_pos_cnt_steal_def_opp_sb_blind", (sum((case when( tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp AND tourney_holdem_hand_player_statistics.enum_p_3bet_action='F') then 1 else 0 end))) as "cnt_steal_reraise_def_action_fold", (sum((case when( tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp) then 1 else 0 end))) as "cnt_steal_reraise_def_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp AND tourney_holdem_hand_player_statistics.enum_p_3bet_action='F') then 1 else 0 end))) as "_pos_cnt_steal_reraise_def_action_fold_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp) then 1 else 0 end))) as "_pos_cnt_steal_reraise_def_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp AND tourney_holdem_hand_player_statistics.enum_p_3bet_action='F') then 1 else 0 end))) as "_pos_cnt_steal_reraise_def_action_fold_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp) then 1 else 0 end))) as "_pos_cnt_steal_reraise_def_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp AND tourney_holdem_hand_player_statistics.enum_p_3bet_action='F') then 1 else 0 end))) as "_pos_cnt_steal_reraise_def_action_fold_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp) then 1 else 0 end))) as "_pos_cnt_steal_reraise_def_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp AND tourney_holdem_hand_player_statistics.enum_p_3bet_action='F') then 1 else 0 end))) as "_pos_cnt_steal_reraise_def_action_fold_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp) then 1 else 0 end))) as "_pos_cnt_steal_reraise_def_opp_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))) as "cnt_p_3bet", (sum((case when(tourney_holdem_hand_player_statistics.flg_p_3bet_opp) then 1 else 0 end))) as "cnt_p_3bet_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))) as "_pos_cnt_p_3bet_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_p_3bet_opp) then 1 else 0 end))) as "_pos_cnt_p_3bet_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))) as "_pos_cnt_p_3bet_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_p_3bet_opp) then 1 else 0 end))) as "_pos_cnt_p_3bet_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))) as "_pos_cnt_p_3bet_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_p_3bet_opp) then 1 else 0 end))) as "_pos_cnt_p_3bet_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))) as "_pos_cnt_p_3bet_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_p_3bet_opp) then 1 else 0 end))) as "_pos_cnt_p_3bet_opp_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_p_4bet) then 1 else 0 end))) as "cnt_p_4bet", (sum((case when(tourney_holdem_hand_player_statistics.flg_p_4bet_opp) then 1 else 0 end))) as "cnt_p_4bet_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_p_4bet) then 1 else 0 end))) as "_pos_cnt_p_4bet_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_p_4bet_opp) then 1 else 0 end))) as "_pos_cnt_p_4bet_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_p_4bet) then 1 else 0 end))) as "_pos_cnt_p_4bet_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_p_4bet_opp) then 1 else 0 end))) as "_pos_cnt_p_4bet_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_p_4bet) then 1 else 0 end))) as "_pos_cnt_p_4bet_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_p_4bet_opp) then 1 else 0 end))) as "_pos_cnt_p_4bet_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_p_4bet) then 1 else 0 end))) as "_pos_cnt_p_4bet_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_p_4bet_opp) then 1 else 0 end))) as "_pos_cnt_p_4bet_opp_lp", (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_first_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end)) ) as "cnt_p_raise_first_in", (sum((case when(tourney_holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end))) as "cnt_p_open_opp", (sum( (case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_p_first_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end)) ) as "_pos_cnt_p_raise_first_in_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end))) as "_pos_cnt_p_open_opp_blind", (sum( (case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_p_first_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end)) ) as "_pos_cnt_p_raise_first_in_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end))) as "_pos_cnt_p_open_opp_ep", (sum( (case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_p_first_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end)) ) as "_pos_cnt_p_raise_first_in_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end))) as "_pos_cnt_p_open_opp_mp", (sum( (case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_p_first_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end)) ) as "_pos_cnt_p_raise_first_in_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end))) as "_pos_cnt_p_open_opp_lp", (sum( (case when( tourney_holdem_hand_player_statistics.flg_p_first_raise AND NOT tourney_holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end) )) as "cnt_p_raise_limpers", (sum( (case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_p_first_raise AND NOT tourney_holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end) )) as "_pos_cnt_p_raise_limpers_blind", (sum( (case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_p_first_raise AND NOT tourney_holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end) )) as "_pos_cnt_p_raise_limpers_ep", (sum( (case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_p_first_raise AND NOT tourney_holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end) )) as "_pos_cnt_p_raise_limpers_mp", (sum( (case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_p_first_raise AND NOT tourney_holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end) )) as "_pos_cnt_p_raise_limpers_lp", (sum(tourney_holdem_hand_player_statistics.cnt_p_raise)) as "cnt_p_raise", (sum(tourney_holdem_hand_player_statistics.cnt_p_call)) as "cnt_p_call", (sum((case when(tourney_holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))) as "cnt_p_fold", (sum((case when((lookup_positions.flg_blinds=true)) then (tourney_holdem_hand_player_statistics.cnt_p_raise) else 0 end))) as "_pos_cnt_p_raise_blind", (sum((case when((lookup_positions.flg_blinds=true)) then (tourney_holdem_hand_player_statistics.cnt_p_call) else 0 end))) as "_pos_cnt_p_call_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))) as "_pos_cnt_p_fold_blind", (sum((case when((lookup_positions.flg_ep=true)) then (tourney_holdem_hand_player_statistics.cnt_p_raise) else 0 end))) as "_pos_cnt_p_raise_ep", (sum((case when((lookup_positions.flg_ep=true)) then (tourney_holdem_hand_player_statistics.cnt_p_call) else 0 end))) as "_pos_cnt_p_call_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))) as "_pos_cnt_p_fold_ep", (sum((case when((lookup_positions.flg_mp=true)) then (tourney_holdem_hand_player_statistics.cnt_p_raise) else 0 end))) as "_pos_cnt_p_raise_mp", (sum((case when((lookup_positions.flg_mp=true)) then (tourney_holdem_hand_player_statistics.cnt_p_call) else 0 end))) as "_pos_cnt_p_call_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))) as "_pos_cnt_p_fold_mp", (sum((case when((lookup_positions.flg_lp=true)) then (tourney_holdem_hand_player_statistics.cnt_p_raise) else 0 end))) as "_pos_cnt_p_raise_lp", (sum((case when((lookup_positions.flg_lp=true)) then (tourney_holdem_hand_player_statistics.cnt_p_call) else 0 end))) as "_pos_cnt_p_call_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))) as "_pos_cnt_p_fold_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att) then 1 else 0 end))) as "cnt_steal_att", (sum((case when(tourney_holdem_hand_player_statistics.flg_steal_opp) then 1 else 0 end))) as "cnt_steal_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_steal_att) then 1 else 0 end))) as "_pos_cnt_steal_att_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_steal_opp) then 1 else 0 end))) as "_pos_cnt_steal_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_steal_att) then 1 else 0 end))) as "_pos_cnt_steal_att_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_steal_opp) then 1 else 0 end))) as "_pos_cnt_steal_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_steal_att) then 1 else 0 end))) as "_pos_cnt_steal_att_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_steal_opp) then 1 else 0 end))) as "_pos_cnt_steal_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_steal_att) then 1 else 0 end))) as "_pos_cnt_steal_att_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_steal_opp) then 1 else 0 end))) as "_pos_cnt_steal_opp_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_won_hand AND tourney_holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))) as "cnt_f_saw_won", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_won_hand AND tourney_holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))) as "_pos_cnt_f_saw_won_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_won_hand AND tourney_holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))) as "_pos_cnt_f_saw_won_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_won_hand AND tourney_holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))) as "_pos_cnt_f_saw_won_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_won_hand AND tourney_holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))) as "_pos_cnt_f_saw_won_lp", (sum((case when(tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(F|XF)%')) then 1 else 0 end))) as "cnt_f_bet_def_action_fold", (sum((case when(tourney_holdem_hand_player_detail.amt_f_bet_facing > 0) then 1 else 0 end))) as "cnt_f_bet_def_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(F|XF)%')) then 1 else 0 end))) as "_pos_cnt_f_bet_def_action_fold_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_detail.amt_f_bet_facing > 0) then 1 else 0 end))) as "_pos_cnt_f_bet_def_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(F|XF)%')) then 1 else 0 end))) as "_pos_cnt_f_bet_def_action_fold_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_detail.amt_f_bet_facing > 0) then 1 else 0 end))) as "_pos_cnt_f_bet_def_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(F|XF)%')) then 1 else 0 end))) as "_pos_cnt_f_bet_def_action_fold_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_detail.amt_f_bet_facing > 0) then 1 else 0 end))) as "_pos_cnt_f_bet_def_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(F|XF)%')) then 1 else 0 end))) as "_pos_cnt_f_bet_def_action_fold_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_detail.amt_f_bet_facing > 0) then 1 else 0 end))) as "_pos_cnt_f_bet_def_opp_lp", (sum((case when(tourney_holdem_hand_player_statistics.enum_f_cbet_action='F') then 1 else 0 end))) as "cnt_f_cbet_def_action_fold", (sum((case when(tourney_holdem_hand_player_statistics.flg_f_cbet_def_opp) then 1 else 0 end))) as "cnt_f_cbet_def_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.enum_f_cbet_action='F') then 1 else 0 end))) as "_pos_cnt_f_cbet_def_action_fold_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_f_cbet_def_opp) then 1 else 0 end))) as "_pos_cnt_f_cbet_def_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.enum_f_cbet_action='F') then 1 else 0 end))) as "_pos_cnt_f_cbet_def_action_fold_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_f_cbet_def_opp) then 1 else 0 end))) as "_pos_cnt_f_cbet_def_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.enum_f_cbet_action='F') then 1 else 0 end))) as "_pos_cnt_f_cbet_def_action_fold_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_f_cbet_def_opp) then 1 else 0 end))) as "_pos_cnt_f_cbet_def_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.enum_f_cbet_action='F') then 1 else 0 end))) as "_pos_cnt_f_cbet_def_action_fold_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_f_cbet_def_opp) then 1 else 0 end))) as "_pos_cnt_f_cbet_def_opp_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_f_face_raise AND tourney_holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))) as "cnt_f_raise_def_action_fold", (sum((case when(tourney_holdem_hand_player_statistics.flg_f_face_raise) then 1 else 0 end))) as "cnt_f_raise_def_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_f_face_raise AND tourney_holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))) as "_pos_cnt_f_raise_def_action_fold_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_f_face_raise) then 1 else 0 end))) as "_pos_cnt_f_raise_def_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_f_face_raise AND tourney_holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))) as "_pos_cnt_f_raise_def_action_fold_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_f_face_raise) then 1 else 0 end))) as "_pos_cnt_f_raise_def_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_f_face_raise AND tourney_holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))) as "_pos_cnt_f_raise_def_action_fold_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_f_face_raise) then 1 else 0 end))) as "_pos_cnt_f_raise_def_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_f_face_raise AND tourney_holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))) as "_pos_cnt_f_raise_def_action_fold_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_f_face_raise) then 1 else 0 end))) as "_pos_cnt_f_raise_def_opp_lp", (sum((case when(tourney_holdem_hand_player_statistics.enum_f_3bet_action='F') then 1 else 0 end))) as "cnt_f_3bet_def_action_fold", (sum((case when(tourney_holdem_hand_player_statistics.flg_f_3bet_def_opp) then 1 else 0 end))) as "cnt_f_3bet_def_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.enum_f_3bet_action='F') then 1 else 0 end))) as "_pos_cnt_f_3bet_def_action_fold_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_f_3bet_def_opp) then 1 else 0 end))) as "_pos_cnt_f_3bet_def_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.enum_f_3bet_action='F') then 1 else 0 end))) as "_pos_cnt_f_3bet_def_action_fold_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_f_3bet_def_opp) then 1 else 0 end))) as "_pos_cnt_f_3bet_def_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.enum_f_3bet_action='F') then 1 else 0 end))) as "_pos_cnt_f_3bet_def_action_fold_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_f_3bet_def_opp) then 1 else 0 end))) as "_pos_cnt_f_3bet_def_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.enum_f_3bet_action='F') then 1 else 0 end))) as "_pos_cnt_f_3bet_def_action_fold_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_f_3bet_def_opp) then 1 else 0 end))) as "_pos_cnt_f_3bet_def_opp_lp", (sum( (case when( tourney_holdem_hand_player_statistics.cnt_f_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "cnt_wtsd_won_when_f_call", (sum((case when(tourney_holdem_hand_player_statistics.cnt_f_call > 0) then 1 else 0 end))) as "cnt_f_call_hands", (sum( (case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.cnt_f_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_f_call_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.cnt_f_call > 0) then 1 else 0 end))) as "_pos_cnt_f_call_hands_blind", (sum( (case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.cnt_f_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_f_call_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.cnt_f_call > 0) then 1 else 0 end))) as "_pos_cnt_f_call_hands_ep", (sum( (case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.cnt_f_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_f_call_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.cnt_f_call > 0) then 1 else 0 end))) as "_pos_cnt_f_call_hands_mp", (sum( (case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.cnt_f_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_f_call_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.cnt_f_call > 0) then 1 else 0 end))) as "_pos_cnt_f_call_hands_lp", (sum( (case when( tourney_holdem_hand_player_statistics.cnt_f_call > 0 and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "cnt_wtsd_when_f_call", (sum( (case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.cnt_f_call > 0 and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_f_call_blind", (sum( (case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.cnt_f_call > 0 and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_f_call_ep", (sum( (case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.cnt_f_call > 0 and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_f_call_mp", (sum( (case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.cnt_f_call > 0 and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_f_call_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_f_check) then 1 else 0 end))) as "cnt_f_check", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_f_check) then 1 else 0 end))) as "_pos_cnt_f_check_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_f_check) then 1 else 0 end))) as "_pos_cnt_f_check_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_f_check) then 1 else 0 end))) as "_pos_cnt_f_check_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_f_check) then 1 else 0 end))) as "_pos_cnt_f_check_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_f_3bet) then 1 else 0 end))) as "cnt_f_3bet", (sum((case

[benegizer]

when(tourney_holdem_hand_player_statistics.flg_f_3bet_opp) then 1 else 0 end))) as "cnt_f_3bet_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_f_3bet) then 1 else 0 end))) as "_pos_cnt_f_3bet_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_f_3bet_opp) then 1 else 0 end))) as "_pos_cnt_f_3bet_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_f_3bet) then 1 else 0 end))) as "_pos_cnt_f_3bet_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_f_3bet_opp) then 1 else 0 end))) as "_pos_cnt_f_3bet_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_f_3bet) then 1 else 0 end))) as "_pos_cnt_f_3bet_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_f_3bet_opp) then 1 else 0 end))) as "_pos_cnt_f_3bet_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_f_3bet) then 1 else 0 end))) as "_pos_cnt_f_3bet_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_f_3bet_opp) then 1 else 0 end))) as "_pos_cnt_f_3bet_opp_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_f_check_raise) then 1 else 0 end))) as "cnt_f_check_raise", (sum((case when(tourney_holdem_hand_player_statistics.flg_f_check AND (tourney_holdem_hand_player_statistics.cnt_f_raise > 0 OR tourney_holdem_hand_player_statistics.cnt_f_call > 0 OR tourney_holdem_hand_player_statistics.flg_f_fold)) then 1 else 0 end))) as "cnt_f_check_raise_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_f_check_raise) then 1 else 0 end))) as "_pos_cnt_f_check_raise_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_f_check AND (tourney_holdem_hand_player_statistics.cnt_f_raise > 0 OR tourney_holdem_hand_player_statistics.cnt_f_call > 0 OR tourney_holdem_hand_player_statistics.flg_f_fold)) then 1 else 0 end))) as "_pos_cnt_f_check_raise_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_f_check_raise) then 1 else 0 end))) as "_pos_cnt_f_check_raise_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_f_check AND (tourney_holdem_hand_player_statistics.cnt_f_raise > 0 OR tourney_holdem_hand_player_statistics.cnt_f_call > 0 OR tourney_holdem_hand_player_statistics.flg_f_fold)) then 1 else 0 end))) as "_pos_cnt_f_check_raise_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_f_check_raise) then 1 else 0 end))) as "_pos_cnt_f_check_raise_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_f_check AND (tourney_holdem_hand_player_statistics.cnt_f_raise > 0 OR tourney_holdem_hand_player_statistics.cnt_f_call > 0 OR tourney_holdem_hand_player_statistics.flg_f_fold)) then 1 else 0 end))) as "_pos_cnt_f_check_raise_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_f_check_raise) then 1 else 0 end))) as "_pos_cnt_f_check_raise_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_f_check AND (tourney_holdem_hand_player_statistics.cnt_f_raise > 0 OR tourney_holdem_hand_player_statistics.cnt_f_call > 0 OR tourney_holdem_hand_player_statistics.flg_f_fold)) then 1 else 0 end))) as "_pos_cnt_f_check_raise_opp_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_f_cbet) then 1 else 0 end))) as "cnt_f_cbet", (sum((case when(tourney_holdem_hand_player_statistics.flg_f_cbet_opp) then 1 else 0 end))) as "cnt_f_cbet_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_f_cbet) then 1 else 0 end))) as "_pos_cnt_f_cbet_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_f_cbet_opp) then 1 else 0 end))) as "_pos_cnt_f_cbet_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_f_cbet) then 1 else 0 end))) as "_pos_cnt_f_cbet_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_f_cbet_opp) then 1 else 0 end))) as "_pos_cnt_f_cbet_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_f_cbet) then 1 else 0 end))) as "_pos_cnt_f_cbet_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_f_cbet_opp) then 1 else 0 end))) as "_pos_cnt_f_cbet_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_f_cbet) then 1 else 0 end))) as "_pos_cnt_f_cbet_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_f_cbet_opp) then 1 else 0 end))) as "_pos_cnt_f_cbet_opp_lp", (sum( (case when( (tourney_holdem_hand_player_statistics.flg_f_bet OR tourney_holdem_hand_player_statistics.cnt_f_raise > 0) and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "cnt_wtsd_won_when_f_bet_raise", (sum( (case when((tourney_holdem_hand_player_statistics.flg_f_bet OR tourney_holdem_hand_player_statistics.cnt_f_raise > 0) and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "cnt_wtsd_when_f_bet_raise", (sum( (case when((lookup_positions.flg_blinds=true) AND (tourney_holdem_hand_player_statistics.flg_f_bet OR tourney_holdem_hand_player_statistics.cnt_f_raise > 0) and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_f_bet_raise_blind", (sum( (case when((lookup_positions.flg_blinds=true) AND (tourney_holdem_hand_player_statistics.flg_f_bet OR tourney_holdem_hand_player_statistics.cnt_f_raise > 0) and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_f_bet_raise_blind", (sum( (case when((lookup_positions.flg_ep=true) AND (tourney_holdem_hand_player_statistics.flg_f_bet OR tourney_holdem_hand_player_statistics.cnt_f_raise > 0) and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_f_bet_raise_ep", (sum( (case when((lookup_positions.flg_ep=true) AND (tourney_holdem_hand_player_statistics.flg_f_bet OR tourney_holdem_hand_player_statistics.cnt_f_raise > 0) and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_f_bet_raise_ep", (sum( (case when((lookup_positions.flg_mp=true) AND (tourney_holdem_hand_player_statistics.flg_f_bet OR tourney_holdem_hand_player_statistics.cnt_f_raise > 0) and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_f_bet_raise_mp", (sum( (case when((lookup_positions.flg_mp=true) AND (tourney_holdem_hand_player_statistics.flg_f_bet OR tourney_holdem_hand_player_statistics.cnt_f_raise > 0) and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_f_bet_raise_mp", (sum( (case when((lookup_positions.flg_lp=true) AND (tourney_holdem_hand_player_statistics.flg_f_bet OR tourney_holdem_hand_player_statistics.cnt_f_raise > 0) and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_f_bet_raise_lp", (sum( (case when((lookup_positions.flg_lp=true) AND (tourney_holdem_hand_player_statistics.flg_f_bet OR tourney_holdem_hand_player_statistics.cnt_f_raise > 0) and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_f_bet_raise_lp", (sum((case when( (tourney_holdem_hand_player_statistics.flg_f_bet OR tourney_holdem_hand_player_statistics.cnt_f_raise > 0)) then 1 else 0 end))) as "cnt_f_bet_raise_hands", (sum((case when((lookup_positions.flg_blinds=true) AND (tourney_holdem_hand_player_statistics.flg_f_bet OR tourney_holdem_hand_player_statistics.cnt_f_raise > 0)) then 1 else 0 end))) as "_pos_cnt_f_bet_raise_hands_blind", (sum((case when((lookup_positions.flg_ep=true) AND (tourney_holdem_hand_player_statistics.flg_f_bet OR tourney_holdem_hand_player_statistics.cnt_f_raise > 0)) then 1 else 0 end))) as "_pos_cnt_f_bet_raise_hands_ep", (sum((case when((lookup_positions.flg_mp=true) AND (tourney_holdem_hand_player_statistics.flg_f_bet OR tourney_holdem_hand_player_statistics.cnt_f_raise > 0)) then 1 else 0 end))) as "_pos_cnt_f_bet_raise_hands_mp", (sum((case when((lookup_positions.flg_lp=true) AND (tourney_holdem_hand_player_statistics.flg_f_bet OR tourney_holdem_hand_player_statistics.cnt_f_raise > 0)) then 1 else 0 end))) as "_pos_cnt_f_bet_raise_hands_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_t_saw) then 1 else 0 end))) as "cnt_t_saw", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_t_saw) then 1 else 0 end))) as "_pos_cnt_t_saw_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_t_saw) then 1 else 0 end))) as "_pos_cnt_t_saw_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_t_saw) then 1 else 0 end))) as "_pos_cnt_t_saw_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_t_saw) then 1 else 0 end))) as "_pos_cnt_t_saw_lp", (sum((case when(tourney_holdem_hand_player_detail.amt_t_bet_facing > 0 AND (lookup_actions_t.action SIMILAR TO '(F|XF)%')) then 1 else 0 end))) as "cnt_t_bet_def_action_fold", (sum((case when(tourney_holdem_hand_player_detail.amt_t_bet_facing > 0) then 1 else 0 end))) as "cnt_t_bet_def_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_detail.amt_t_bet_facing > 0 AND (lookup_actions_t.action SIMILAR TO '(F|XF)%')) then 1 else 0 end))) as "_pos_cnt_t_bet_def_action_fold_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_detail.amt_t_bet_facing > 0) then 1 else 0 end))) as "_pos_cnt_t_bet_def_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_detail.amt_t_bet_facing > 0 AND (lookup_actions_t.action SIMILAR TO '(F|XF)%')) then 1 else 0 end))) as "_pos_cnt_t_bet_def_action_fold_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_detail.amt_t_bet_facing > 0) then 1 else 0 end))) as "_pos_cnt_t_bet_def_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_detail.amt_t_bet_facing > 0 AND (lookup_actions_t.action SIMILAR TO '(F|XF)%')) then 1 else 0 end))) as "_pos_cnt_t_bet_def_action_fold_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_detail.amt_t_bet_facing > 0) then 1 else 0 end))) as "_pos_cnt_t_bet_def_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_detail.amt_t_bet_facing > 0 AND (lookup_actions_t.action SIMILAR TO '(F|XF)%')) then 1 else 0 end))) as "_pos_cnt_t_bet_def_action_fold_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_detail.amt_t_bet_facing > 0) then 1 else 0 end))) as "_pos_cnt_t_bet_def_opp_lp", (sum((case when(tourney_holdem_hand_player_statistics.enum_t_cbet_action='F') then 1 else 0 end))) as "cnt_t_cbet_def_action_fold", (sum((case when(tourney_holdem_hand_player_statistics.flg_t_cbet_def_opp) then 1 else 0 end))) as "cnt_t_cbet_def_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.enum_t_cbet_action='F') then 1 else 0 end))) as "_pos_cnt_t_cbet_def_action_fold_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_t_cbet_def_opp) then 1 else 0 end))) as "_pos_cnt_t_cbet_def_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.enum_t_cbet_action='F') then 1 else 0 end))) as "_pos_cnt_t_cbet_def_action_fold_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_t_cbet_def_opp) then 1 else 0 end))) as "_pos_cnt_t_cbet_def_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.enum_t_cbet_action='F') then 1 else 0 end))) as "_pos_cnt_t_cbet_def_action_fold_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_t_cbet_def_opp) then 1 else 0 end))) as "_pos_cnt_t_cbet_def_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.enum_t_cbet_action='F') then 1 else 0 end))) as "_pos_cnt_t_cbet_def_action_fold_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_t_cbet_def_opp) then 1 else 0 end))) as "_pos_cnt_t_cbet_def_opp_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_t_face_raise AND tourney_holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))) as "cnt_t_raise_def_action_fold", (sum((case when(tourney_holdem_hand_player_statistics.flg_t_face_raise) then 1 else 0 end))) as "cnt_t_raise_def_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_t_face_raise AND tourney_holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))) as "_pos_cnt_t_raise_def_action_fold_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_t_face_raise) then 1 else 0 end))) as "_pos_cnt_t_raise_def_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_t_face_raise AND tourney_holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))) as "_pos_cnt_t_raise_def_action_fold_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_t_face_raise) then 1 else 0 end))) as "_pos_cnt_t_raise_def_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_t_face_raise AND tourney_holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))) as "_pos_cnt_t_raise_def_action_fold_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_t_face_raise) then 1 else 0 end))) as "_pos_cnt_t_raise_def_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_t_face_raise AND tourney_holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))) as "_pos_cnt_t_raise_def_action_fold_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_t_face_raise) then 1 else 0 end))) as "_pos_cnt_t_raise_def_opp_lp", (sum((case when(tourney_holdem_hand_player_statistics.enum_t_3bet_action='F') then 1 else 0 end))) as "cnt_t_3bet_def_action_fold", (sum((case when(tourney_holdem_hand_player_statistics.flg_t_3bet_def_opp) then 1 else 0 end))) as "cnt_t_3bet_def_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.enum_t_3bet_action='F') then 1 else 0 end))) as "_pos_cnt_t_3bet_def_action_fold_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_t_3bet_def_opp) then 1 else 0 end))) as "_pos_cnt_t_3bet_def_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.enum_t_3bet_action='F') then 1 else 0 end))) as "_pos_cnt_t_3bet_def_action_fold_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_t_3bet_def_opp) then 1 else 0 end))) as "_pos_cnt_t_3bet_def_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.enum_t_3bet_action='F') then 1 else 0 end))) as "_pos_cnt_t_3bet_def_action_fold_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_t_3bet_def_opp) then 1 else 0 end))) as "_pos_cnt_t_3bet_def_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.enum_t_3bet_action='F') then 1 else 0 end))) as "_pos_cnt_t_3bet_def_action_fold_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_t_3bet_def_opp) then 1 else 0 end))) as "_pos_cnt_t_3bet_def_opp_lp", (sum( (case when( tourney_holdem_hand_player_statistics.cnt_t_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "cnt_wtsd_won_when_t_call", (sum((case when(tourney_holdem_hand_player_statistics.cnt_t_call > 0) then 1 else 0 end))) as "cnt_t_call_hands", (sum( (case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.cnt_t_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_t_call_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.cnt_t_call > 0) then 1 else 0 end))) as "_pos_cnt_t_call_hands_blind", (sum( (case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.cnt_t_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_t_call_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.cnt_t_call > 0) then 1 else 0 end))) as "_pos_cnt_t_call_hands_ep", (sum( (case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.cnt_t_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_t_call_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.cnt_t_call > 0) then 1 else 0 end))) as "_pos_cnt_t_call_hands_mp", (sum( (case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.cnt_t_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_t_call_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.cnt_t_call > 0) then 1 else 0 end))) as "_pos_cnt_t_call_hands_lp", (sum( (case when( tourney_holdem_hand_player_statistics.cnt_t_call > 0 and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "cnt_wtsd_when_t_call", (sum( (case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.cnt_t_call > 0 and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_t_call_blind", (sum( (case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.cnt_t_call > 0 and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_t_call_ep", (sum( (case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.cnt_t_call > 0 and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_t_call_mp", (sum( (case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.cnt_t_call > 0 and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_t_call_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_t_check) then 1 else 0 end))) as "cnt_t_check", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_t_check) then 1 else 0 end))) as "_pos_cnt_t_check_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_t_check) then 1 else 0 end))) as "_pos_cnt_t_check_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_t_check) then 1 else 0 end))) as "_pos_cnt_t_check_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_t_check) then 1 else 0 end))) as "_pos_cnt_t_check_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_t_3bet) then 1 else 0 end))) as "cnt_t_3bet", (sum((case when(tourney_holdem_hand_player_statistics.flg_t_3bet_opp) then 1 else 0 end))) as "cnt_t_3bet_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_t_3bet) then 1 else 0 end))) as "_pos_cnt_t_3bet_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_t_3bet_opp) then 1 else 0 end))) as "_pos_cnt_t_3bet_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_t_3bet) then 1 else 0 end))) as "_pos_cnt_t_3bet_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_t_3bet_opp) then 1 else 0 end))) as "_pos_cnt_t_3bet_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_t_3bet) then 1 else 0 end))) as "_pos_cnt_t_3bet_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_t_3bet_opp) then 1 else 0 end))) as "_pos_cnt_t_3bet_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_t_3bet) then 1 else 0 end))) as "_pos_cnt_t_3bet_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_t_3bet_opp) then 1 else 0 end))) as "_pos_cnt_t_3bet_opp_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_t_check_raise) then 1 else 0 end))) as "cnt_t_check_raise", (sum((case when(tourney_holdem_hand_player_statistics.flg_t_check AND (tourney_holdem_hand_player_statistics.cnt_t_raise > 0 OR tourney_holdem_hand_player_statistics.cnt_t_call > 0 OR tourney_holdem_hand_player_statistics.flg_t_fold)) then 1 else 0 end))) as "cnt_t_check_raise_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_t_check_raise) then 1 else 0 end))) as "_pos_cnt_t_check_raise_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_t_check AND (tourney_holdem_hand_player_statistics.cnt_t_raise > 0 OR tourney_holdem_hand_player_statistics.cnt_t_call > 0 OR tourney_holdem_hand_player_statistics.flg_t_fold)) then 1 else 0 end))) as "_pos_cnt_t_check_raise_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_t_check_raise) then 1 else 0 end))) as "_pos_cnt_t_check_raise_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_t_check AND (tourney_holdem_hand_player_statistics.cnt_t_raise > 0 OR tourney_holdem_hand_player_statistics.cnt_t_call > 0 OR tourney_holdem_hand_player_statistics.flg_t_fold)) then 1 else 0 end))) as "_pos_cnt_t_check_raise_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_t_check_raise) then 1 else 0 end))) as "_pos_cnt_t_check_raise_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_t_check AND (tourney_holdem_hand_player_statistics.cnt_t_raise > 0 OR tourney_holdem_hand_player_statistics.cnt_t_call > 0 OR tourney_holdem_hand_player_statistics.flg_t_fold)) then 1 else 0 end))) as "_pos_cnt_t_check_raise_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_t_check_raise) then 1 else 0 end))) as "_pos_cnt_t_check_raise_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_t_check AND (tourney_holdem_hand_player_statistics.cnt_t_raise > 0 OR tourney_holdem_hand_player_statistics.cnt_t_call > 0 OR tourney_holdem_hand_player_statistics.flg_t_fold)) then 1 else 0 end))) as "_pos_cnt_t_check_raise_opp_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_t_cbet) then 1 else 0 end))) as "cnt_t_cbet", (sum((case when(tourney_holdem_hand_player_statistics.flg_t_cbet_opp) then 1 else 0 end))) as "cnt_t_cbet_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_t_cbet) then 1 else 0 end))) as "_pos_cnt_t_cbet_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_t_cbet_opp) then 1 else 0 end))) as "_pos_cnt_t_cbet_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_t_cbet) then 1 else 0 end))) as "_pos_cnt_t_cbet_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_t_cbet_opp) then 1 else 0 end))) as "_pos_cnt_t_cbet_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_t_cbet) then 1 else 0 end))) as "_pos_cnt_t_cbet_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_t_cbet_opp) then 1 else 0 end))) as "_pos_cnt_t_cbet_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_t_cbet) then 1 else 0 end))) as "_pos_cnt_t_cbet_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_t_cbet_opp) then 1 else 0 end))) as "_pos_cnt_t_cbet_opp_lp", (sum( (case when( (tourney_holdem_hand_player_statistics.flg_t_bet OR tourney_holdem_hand_player_statistics.cnt_t_raise > 0) and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "cnt_wtsd_won_when_t_bet_raise", (sum( (case when((tourney_holdem_hand_player_statistics.flg_t_bet OR tourney_holdem_hand_player_statistics.cnt_t_raise > 0) and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "cnt_wtsd_when_t_bet_raise", (sum( (case when((lookup_positions.flg_blinds=true) AND (tourney_holdem_hand_player_statistics.flg_t_bet OR tourney_holdem_hand_player_statistics.cnt_t_raise > 0) and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_t_bet_raise_blind", (sum( (case when((lookup_positions.flg_blinds=true) AND (tourney_holdem_hand_player_statistics.flg_t_bet OR tourney_holdem_hand_player_statistics.cnt_t_raise > 0) and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_t_bet_raise_blind", (sum( (case when((lookup_positions.flg_ep=true) AND (tourney_holdem_hand_player_statistics.flg_t_bet OR tourney_holdem_hand_player_statistics.cnt_t_raise > 0) and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_t_bet_raise_ep", (sum( (case when((lookup_positions.flg_ep=true) AND (tourney_holdem_hand_player_statistics.flg_t_bet OR tourney_holdem_hand_player_statistics.cnt_t_raise > 0) and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_t_bet_raise_ep", (sum( (case when((lookup_positions.flg_mp=true) AND (tourney_holdem_hand_player_statistics.flg_t_bet OR tourney_holdem_hand_player_statistics.cnt_t_raise > 0) and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_t_bet_raise_mp", (sum( (case when((lookup_positions.flg_mp=true) AND (tourney_holdem_hand_player_statistics.flg_t_bet OR tourney_holdem_hand_player_statistics.cnt_t_raise > 0) and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_t_bet_raise_mp", (sum( (case when((lookup_positions.flg_lp=true) AND (tourney_holdem_hand_player_statistics.flg_t_bet OR tourney_holdem_hand_player_statistics.cnt_t_raise > 0) and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_t_bet_raise_lp", (sum( (case when((lookup_positions.flg_lp=true) AND (tourney_holdem_hand_player_statistics.flg_t_bet OR tourney_holdem_hand_player_statistics.cnt_t_raise > 0) and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_t_bet_raise_lp", (sum((case when( (tourney_holdem_hand_player_statistics.flg_t_bet OR tourney_holdem_hand_player_statistics.cnt_t_raise > 0)) then 1 else 0 end))) as "cnt_t_bet_raise_hands", (sum((case when((lookup_positions.flg_blinds=true) AND (tourney_holdem_hand_player_statistics.flg_t_bet OR tourney_holdem_hand_player_statistics.cnt_t_raise > 0)) then 1 else 0 end))) as "_pos_cnt_t_bet_raise_hands_blind", (sum((case when((lookup_positions.flg_ep=true) AND (tourney_holdem_hand_player_statistics.flg_t_bet OR tourney_holdem_hand_player_statistics.cnt_t_raise > 0)) then 1 else 0 end))) as "_pos_cnt_t_bet_raise_hands_ep", (sum((case when((lookup_positions.flg_mp=true) AND (tourney_holdem_hand_player_statistics.flg_t_bet OR tourney_holdem_hand_player_statistics.cnt_t_raise > 0)) then 1 else 0 end))) as "_pos_cnt_t_bet_raise_hands_mp", (sum((case when((lookup_positions.flg_lp=true) AND (tourney_holdem_hand_player_statistics.flg_t_bet OR tourney_holdem_hand_player_statistics.cnt_t_raise > 0)) then 1 else 0 end))) as "_pos_cnt_t_bet_raise_hands_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_r_saw) then 1 else 0 end))) as "cnt_r_saw", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_r_saw) then 1 else 0 end))) as "_pos_cnt_r_saw_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_r_saw) then 1 else 0 end))) as "_pos_cnt_r_saw_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_r_saw) then 1 else 0 end))) as "_pos_cnt_r_saw_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_r_saw) then 1 else 0 end))) as "_pos_cnt_r_saw_lp", (sum((case when(tourney_holdem_hand_player_detail.amt_r_bet_facing > 0 AND (lookup_actions_r.action SIMILAR TO '(F|XF)%')) then 1 else 0 end))) as "cnt_r_bet_def_action_fold", (sum((case when(tourney_holdem_hand_player_detail.amt_r_bet_facing > 0) then 1 else 0 end))) as "cnt_r_bet_def_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_detail.amt_r_bet_facing > 0 AND (lookup_actions_r.action SIMILAR TO '(F|XF)%')) then 1 else 0 end))) as "_pos_cnt_r_bet_def_action_fold_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_detail.amt_r_bet_facing > 0) then 1 else 0 end))) as "_pos_cnt_r_bet_def_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_detail.amt_r_bet_facing > 0 AND (lookup_actions_r.action SIMILAR TO '(F|XF)%')) then 1 else 0 end))) as "_pos_cnt_r_bet_def_action_fold_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_detail.amt_r_bet_facing > 0) then 1 else 0 end))) as "_pos_cnt_r_bet_def_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_detail.amt_r_bet_facing > 0 AND (lookup_actions_r.action SIMILAR TO '(F|XF)%')) then 1 else 0 end))) as "_pos_cnt_r_bet_def_action_fold_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_detail.amt_r_bet_facing > 0) then 1 else 0 end))) as "_pos_cnt_r_bet_def_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_detail.amt_r_bet_facing > 0 AND (lookup_actions_r.action SIMILAR TO '(F|XF)%')) then 1 else 0 end))) as "_pos_cnt_r_bet_def_action_fold_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_detail.amt_r_bet_facing > 0) then 1 else 0 end))) as "_pos_cnt_r_bet_def_opp_lp", (sum((case when(tourney_holdem_hand_player_statistics.enum_r_cbet_action='F') then 1 else 0 end))) as "cnt_r_cbet_def_action_fold", (sum((case when(tourney_holdem_hand_player_statistics.flg_r_cbet_def_opp) then 1 else 0 end))) as "cnt_r_cbet_def_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.enum_r_cbet_action='F') then 1 else 0 end))) as "_pos_cnt_r_cbet_def_action_fold_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_r_cbet_def_opp) then 1 else 0 end))) as "_pos_cnt_r_cbet_def_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.enum_r_cbet_action='F') then 1 else 0 end))) as "_pos_cnt_r_cbet_def_action_fold_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_r_cbet_def_opp) then 1 else 0 end))) as "_pos_cnt_r_cbet_def_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.enum_r_cbet_action='F') then 1 else 0 end))) as "_pos_cnt_r_cbet_def_action_fold_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_r_cbet_def_opp) then 1 else 0 end))) as "_pos_cnt_r_cbet_def_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.enum_r_cbet_action='F') then 1 else 0 end))) as "_pos_cnt_r_cbet_def_action_fold_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_r_cbet_def_opp) then 1 else 0 end))) as "_pos_cnt_r_cbet_def_opp_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_r_face_raise AND tourney_holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))) as "cnt_r_raise_def_action_fold", (sum((case when(tourney_holdem_hand_player_statistics.flg_r_face_raise) then 1 else 0 end))) as "cnt_r_raise_def_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_r_face_raise AND tourney_holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))) as "_pos_cnt_r_raise_def_action_fold_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_r_face_raise) then 1 else 0 end))) as "_pos_cnt_r_raise_def_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_r_face_raise AND tourney_holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))) as "_pos_cnt_r_raise_def_action_fold_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_r_face_raise) then 1 else 0 end))) as "_pos_cnt_r_raise_def_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_r_face_raise AND tourney_holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))) as "_pos_cnt_r_raise_def_action_fold_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_r_face_raise) then 1 else 0 end))) as "_pos_cnt_r_raise_def_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_r_face_raise AND tourney_holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))) as "_pos_cnt_r_raise_def_action_fold_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_r_face_raise) then 1 else 0 end))) as "_pos_cnt_r_raise_def_opp_lp", (sum((case when(tourney_holdem_hand_player_statistics.enum_r_3bet_action='F') then 1 else 0 end))) as "cnt_r_3bet_def_action_fold", (sum((case when(tourney_holdem_hand_player_statistics.flg_r_3bet_def_opp) then 1 else 0 end))) as "cnt_r_3bet_def_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.enum_r_3bet_action='F') then 1 else 0 end))) as "_pos_cnt_r_3bet_def_action_fold_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_r_3bet_def_opp) then 1 else 0 end))) as "_pos_cnt_r_3bet_def_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.enum_r_3bet_action='F') then 1 else 0 end))) as "_pos_cnt_r_3bet_def_action_fold_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_r_3bet_def_opp) then 1 else 0 end))) as "_pos_cnt_r_3bet_def_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.enum_r_3bet_action='F') then 1 else 0 end))) as "_pos_cnt_r_3bet_def_action_fold_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_r_3bet_def_opp) then 1 else 0 end))) as "_pos_cnt_r_3bet_def_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.enum_r_3bet_action='F') then 1 else 0 end))) as "_pos_cnt_r_3bet_def_action_fold_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_r_3bet_def_opp) then 1 else 0 end))) as "_pos_cnt_r_3bet_def_opp_lp", (sum( (case when( tourney_holdem_hand_player_statistics.cnt_r_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "cnt_wtsd_won_when_r_call", (sum((case when(tourney_holdem_hand_player_statistics.cnt_r_call > 0) then 1 else 0 end))) as "cnt_r_call_hands", (sum( (case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.cnt_r_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_r_call_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.cnt_r_call > 0) then 1 else 0 end))) as "_pos_cnt_r_call_hands_blind", (sum( (case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.cnt_r_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_r_call_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.cnt_r_call > 0) then 1 else 0 end))) as "_pos_cnt_r_call_hands_ep", (sum( (case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.cnt_r_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_r_call_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.cnt_r_call > 0) then 1 else 0 end))) as "_pos_cnt_r_call_hands_mp", (sum( (case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.cnt_r_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_r_call_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.cnt_r_call > 0) then 1 else 0 end))) as "_pos_cnt_r_call_hands_lp", (sum( (case when( tourney_holdem_hand_player_statistics.cnt_r_call > 0 and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "cnt_wtsd_when_r_call", (sum( (case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.cnt_r_call > 0 and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_r_call_blind", (sum( (case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.cnt_r_call > 0 and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_r_call_ep", (sum( (case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.cnt_r_call > 0 and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_r_call_mp", (sum( (case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.cnt_r_call > 0 and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_r_call_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_r_check) then 1 else 0 end))) as "cnt_r_check", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_r_check) then 1 else 0 end))) as "_pos_cnt_r_check_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_r_check) then 1 else 0 end))) as "_pos_cnt_r_check_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_r_check) then 1 else 0 end))) as "_pos_cnt_r_check_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_r_check) then 1 else 0 end))) as "_pos_cnt_r_check_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_r_3bet) then 1 else 0 end))) as "cnt_r_3bet", (sum((case when(tourney_holdem_hand_player_statistics.flg_r_3bet_opp) then 1 else 0 end))) as "cnt_r_3bet_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_r_3bet) then 1 else 0 end))) as "_pos_cnt_r_3bet_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_r_3bet_opp) then 1 else 0 end))) as "_pos_cnt_r_3bet_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_r_3bet) then 1 else 0 end))) as "_pos_cnt_r_3bet_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_r_3bet_opp) then 1 else 0 end))) as "_pos_cnt_r_3bet_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_r_3bet) then 1 else 0 end))) as "_pos_cnt_r_3bet_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_r_3bet_opp) then 1 else 0 end))) as "_pos_cnt_r_3bet_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_r_3bet) then 1 else 0 end))) as "_pos_cnt_r_3bet_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_r_3bet_opp) then 1 else 0 end))) as "_pos_cnt_r_3bet_opp_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_r_check_raise) then 1 else 0 end))) as "cnt_r_check_raise", (sum((case when(tourney_holdem_hand_player_statistics.flg_r_check AND (tourney_holdem_hand_player_statistics.cnt_r_raise > 0 OR tourney_holdem_hand_player_statistics.cnt_r_call > 0 OR tourney_holdem_hand_player_statistics.flg_r_fold)) then 1 else 0 end))) as "cnt_r_check_raise_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_r_check_raise) then 1 else 0 end))) as "_pos_cnt_r_check_raise_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_r_check AND (tourney_holdem_hand_player_statistics.cnt_r_raise > 0 OR tourney_holdem_hand_player_statistics.cnt_r_call > 0 OR tourney_holdem_hand_player_statistics.flg_r_fold)) then 1 else 0 end))) as "_pos_cnt_r_check_raise_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_r_check_raise) then 1 else 0 end))) as "_pos_cnt_r_check_raise_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_r_check AND (tourney_holdem_hand_player_statistics.cnt_r_raise > 0 OR tourney_holdem_hand_player_statistics.cnt_r_call > 0 OR tourney_holdem_hand_player_statistics.flg_r_fold)) then 1 else 0 end))) as "_pos_cnt_r_check_raise_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_r_check_raise) then 1 else 0 end))) as "_pos_cnt_r_check_raise_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_r_check AND (tourney_holdem_hand_player_statistics.cnt_r_raise > 0 OR tourney_holdem_hand_player_statistics.cnt_r_call > 0 OR tourney_holdem_hand_player_statistics.flg_r_fold)) then 1 else 0 end))) as "_pos_cnt_r_check_raise_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_r_check_raise) then 1 else 0 end))) as "_pos_cnt_r_check_raise_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_r_check AND (tourney_holdem_hand_player_statistics.cnt_r_raise > 0 OR tourney_holdem_hand_player_statistics.cnt_r_call > 0 OR tourney_holdem_hand_player_statistics.flg_r_fold)) then 1 else 0 end))) as "_pos_cnt_r_check_raise_opp_lp", (sum((case when(tourney_holdem_hand_player_statistics.flg_r_cbet) then 1 else 0 end))) as "cnt_r_cbet", (sum((case when(tourney_holdem_hand_player_statistics.flg_r_cbet_opp) then 1 else 0 end))) as "cnt_r_cbet_opp", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_r_cbet) then 1 else 0 end))) as "_pos_cnt_r_cbet_blind", (sum((case when((lookup_positions.flg_blinds=true) AND tourney_holdem_hand_player_statistics.flg_r_cbet_opp) then 1 else 0 end))) as "_pos_cnt_r_cbet_opp_blind", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_r_cbet) then 1 else 0 end))) as "_pos_cnt_r_cbet_ep", (sum((case when((lookup_positions.flg_ep=true) AND tourney_holdem_hand_player_statistics.flg_r_cbet_opp) then 1 else 0 end))) as "_pos_cnt_r_cbet_opp_ep", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_r_cbet) then 1 else 0 end))) as "_pos_cnt_r_cbet_mp", (sum((case when((lookup_positions.flg_mp=true) AND tourney_holdem_hand_player_statistics.flg_r_cbet_opp) then 1 else 0 end))) as "_pos_cnt_r_cbet_opp_mp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_r_cbet) then 1 else 0 end))) as "_pos_cnt_r_cbet_lp", (sum((case when((lookup_positions.flg_lp=true) AND tourney_holdem_hand_player_statistics.flg_r_cbet_opp) then 1 else 0 end))) as "_pos_cnt_r_cbet_opp_lp", (sum( (case when( (tourney_holdem_hand_player_statistics.flg_r_bet OR tourney_holdem_hand_player_statistics.cnt_r_raise > 0) and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "cnt_wtsd_won_when_r_bet_raise", (sum( (case when((tourney_holdem_hand_player_statistics.flg_r_bet OR tourney_holdem_hand_player_statistics.cnt_r_raise > 0) and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "cnt_wtsd_when_r_bet_raise", (sum( (case when((lookup_positions.flg_blinds=true) AND (tourney_holdem_hand_player_statistics.flg_r_bet OR tourney_holdem_hand_player_statistics.cnt_r_raise > 0) and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_r_bet_raise_blind", (sum( (case when((lookup_positions.flg_blinds=true) AND (tourney_holdem_hand_player_statistics.flg_r_bet OR tourney_holdem_hand_player_statistics.cnt_r_raise > 0) and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_r_bet_raise_blind", (sum( (case when((lookup_positions.flg_ep=true) AND (tourney_holdem_hand_player_statistics.flg_r_bet OR tourney_holdem_hand_player_statistics.cnt_r_raise > 0) and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_r_bet_raise_ep", (sum( (case when((lookup_positions.flg_ep=true) AND (tourney_holdem_hand_player_statistics.flg_r_bet OR tourney_holdem_hand_player_statistics.cnt_r_raise > 0) and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_r_bet_raise_ep", (sum( (case when((lookup_positions.flg_mp=true) AND (tourney_holdem_hand_player_statistics.flg_r_bet OR tourney_holdem_hand_player_statistics.cnt_r_raise > 0) and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_r_bet_raise_mp", (sum( (case when((lookup_positions.flg_mp=true) AND (tourney_holdem_hand_player_statistics.flg_r_bet OR tourney_holdem_hand_player_statistics.cnt_r_raise > 0) and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_r_bet_raise_mp", (sum( (case when((lookup_positions.flg_lp=true) AND (tourney_holdem_hand_player_statistics.flg_r_bet OR tourney_holdem_hand_player_statistics.cnt_r_raise > 0) and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_won_when_r_bet_raise_lp", (sum( (case when((lookup_positions.flg_lp=true) AND (tourney_holdem_hand_player_statistics.flg_r_bet OR tourney_holdem_hand_player_statistics.cnt_r_raise > 0) and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "_pos_cnt_wtsd_when_r_bet_raise_lp", (sum((case when( (tourney_holdem_hand_player_statistics.flg_r_bet OR tourney_holdem_hand_player_statistics.cnt_r_raise > 0)) then 1 else 0 end))) as "cnt_r_bet_raise_hands", (sum((case when((lookup_positions.flg_blinds=true) AND (tourney_holdem_hand_player_statistics.flg_r_bet OR tourney_holdem_hand_player_statistics.cnt_r_raise > 0)) then 1 else 0 end))) as "_pos_cnt_r_bet_raise_hands_blind", (sum((case when((lookup_positions.flg_ep=true) AND (tourney_holdem_hand_player_statistics.flg_r_bet OR tourney_holdem_hand_player_statistics.cnt_r_raise > 0)) then 1 else 0 end))) as "_pos_cnt_r_bet_raise_hands_ep", (sum((case when((lookup_positions.flg_mp=true) AND (tourney_holdem_hand_player_statistics.flg_r_bet OR tourney_holdem_hand_player_statistics.cnt_r_raise > 0)) then 1 else 0 end))) as "_pos_cnt_r_bet_raise_hands_mp", (sum((case when((lookup_positions.flg_lp=true) AND (tourney_holdem_hand_player_statistics.flg_r_bet OR tourney_holdem_hand_player_statistics.cnt_r_raise > 0)) then 1 else 0 end))) as "_pos_cnt_r_bet_raise_hands_lp" FROM tourney_holdem_hand_summary, tourney_holdem_hand_player_statistics, tourney_holdem_hand_player_detail, lookup_positions, tourney_holdem_blinds, lookup_actions lookup_actions_p, lookup_actions lookup_actions_f, lookup_actions lookup_actions_t, player player_real, lookup_actions lookup_actions_r,(SELECT hhps.id_tourney as id_tourney, (case when(p.id_player_alias <> 0) then p.id_player_alias else p.id_player end) as id_player, p.player_name as str_player_name, p.player_name_search as str_player_name_search, p.val_icon as val_icon FROM player as p, tourney_holdem_hand_summary as hhs, tourney_holdem_hand_player_statistics as hhps WHERE ( p.id_site = 300 AND (p.player_name_search='omega operative') ) AND p.id_player = hhps.id_player_real AND hhps.id_hand = hhs.id_hand AND hhs.hand_no = 33390133580) as session WHERE (tourney_holdem_hand_player_statistics.id_tourney = session.id_tourney) AND (tourney_holdem_hand_player_statistics.id_hand = tourney_holdem_hand_player_detail.id_hand AND tourney_holdem_hand_player_statistics.id_player = tourney_holdem_hand_player_detail.id_player) AND (lookup_positions."position"=tourney_holdem_hand_player_statistics."position" AND lookup_positions.cnt_players=tourney_holdem_hand_player_statistics.cnt_players) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds) AND (player_real.id_player = tourney_holdem_hand_player_statistics.id_player_real) AND (session.id_player = tourney_holdem_hand_player_statistics.id_player) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_statistics.id_hand) AND (lookup_actions_p.id_action=tourney_holdem_hand_player_detail.id_action_p) AND (lookup_actions_f.id_action=tourney_holdem_hand_player_detail.id_action_f) AND (lookup_actions_t.id_action=tourney_holdem_hand_player_detail.id_action_t) AND (lookup_actions_r.id_action=tourney_holdem_hand_player_detail.id_action_r) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_detail.id_hand) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_summary.id_blinds) GROUP BY (player_real.player_name_search), (session.str_player_name)
2013-10-18 22:36:20 JST LOG: received smart shutdown request
2013-10-18 22:36:20 JST LOG: autovacuum launcher shutting down
2013-10-18 22:36:20 JST FATAL: terminating autovacuum process due to administrator command
2013-10-18 22:36:20 JST LOG: shutting down
2013-10-18 22:36:21 JST LOG: database system is shut down

[kraada]

Please create a support ticket requesting remote assistance and referencing this thread and we'll get things sorted out for you.

[benegizer]

Thanks Kraara. I created a support ticket. I forgot to reference this thread however.

[kraada]

Don't worry about it, we'll get you all fixed up

[benegizer]

You guys really are amazing. Having to troubleshoot and fix everybody's problems day in and day out, must be exhausting. I commend you guys.

I'm holding off downloading Mavericks until we get this all sorted out. Just in case.

[jamierhind]

hi ive purchased pt4 and having postgres problems too. i downloaded the trial a few months back and postgres added another user to my login screen on my imac, i tried to uninstall all files and now it just wont open at all. I have went thorough the info on this thread to try and fix it but to no avail. please help.

Default Parameters error
Unable to login to database (postgres). Reason:could not connect to server. No such file or directory is the server running locally and accepting connections on Unix domain socket '/tmp/.s.PGSQL.5432'?

then my 2 options are configure details or cancel. when i go to config the banner is Configure PostgresSQL Server. The info is all correct ie DB user Password Server and host. I click connect and it says unable to connect to this database, please check config. I also used the link to downlaod manually Postgres which i got from this thread. Sorry i am completely clueless when it comes to this.

[kraada]

Please re-run the OS X PostgreSQL installer and that should likely fix things. You can find details on how to do that in our uninstall/reinstall guide available here.