Face open min raise

[Guest666]

I apologize, if was similar a topic, I haven't found.
Whether there is a possibility to make such stat? (I want to make stats of type "Fold bb to steal", only that was considered button and against open mp min raises)
I know there is such field: "holdem_hand_player_statistics.flg_p_face_raise", but what fields to use to define that this open raise and size 2 bb ?
In advance thanks for the answer :)

[kraada]

Yes, you can make this statistic.

You'll want to use:
holdem_hand_player_detail.amt_p_raise_facing = 2 * holdem_limit.amt_bb

to pick the situation out.

[WhiteRider]

You mean multiplied by 2..?

holdem_hand_player_detail.amt_p_raise_facing = 2 * holdem_limit.amt_bb

[kraada]

Yes, I do - edited it now. :oops:

[Guest666]

Thanks.
Has made stat (cnt_face_mr_fold_3lv / cnt_face_mr_3lv) * 100

cnt_face_mr_3lv
sum( if[(tourney_holdem_blinds.amt_bb = 50) and
(tourney_holdem_hand_player_statistics.flg_p_face_raise) and
(not (tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp)) and
(tourney_holdem_hand_player_detail.amt_p_raise_facing >= 2 * tourney_holdem_blinds.amt_bb) and
(tourney_holdem_hand_player_detail.amt_p_raise_facing < 3 * tourney_holdem_blinds.amt_bb) and
(
(tourney_holdem_hand_player_detail.val_p_raise_facing_pct>44) OR
((tourney_holdem_hand_player_detail.val_p_raise_facing_pct>33) and
(tourney_holdem_hand_player_statistics.position=9))
), 1, 0])

cnt_face_mr_fold_3lv:
sum( if[(tourney_holdem_blinds.amt_bb = 50) and
(tourney_holdem_hand_player_statistics.flg_p_face_raise) and
(not (tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp)) and
(tourney_holdem_hand_player_detail.amt_p_raise_facing >= 2 * tourney_holdem_blinds.amt_bb) and
(tourney_holdem_hand_player_detail.amt_p_raise_facing < 3 * tourney_holdem_blinds.amt_bb) and
(
(tourney_holdem_hand_player_detail.val_p_raise_facing_pct>44) OR
((tourney_holdem_hand_player_detail.val_p_raise_facing_pct>33) and
(tourney_holdem_hand_player_statistics.position=9))
)and
(tourney_omaha_hand_player_statistics.flg_p_fold)
, 1, 0])



But when I do full housekeeping - shows a error

Spoiler: show

There were errors during the housekeeping process:
Unable to prepare query: INSERT INTO tourney_holdem_cache SELECT tourney_holdem_hand_player_statistics.id_player, tourney_holdem_hand_player_statistics.id_blinds, tourney_holdem_hand_summary.cnt_players, ((case when( lookup_positions.flg_blinds) then 0 else (case when( lookup_positions.flg_ep) then 1 else (case when( lookup_positions.flg_mp) then 2 else 3 end) end) end)),
(sum( (CASE WHEN ( (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) )),
(sum(tourney_holdem_hand_player_detail.amt_blind)),
(sum(tourney_holdem_hand_player_statistics.amt_won)),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_b and tourney_holdem_hand_player_statistics.flg_blind_s = false) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_blind_b AND tourney_holdem_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action LIKE 'C') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_bb_steal_fold) then 1 else 0 end))),
(sum((case when( tourney_holdem_hand_player_statistics.flg_blind_b AND tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_b OR tourney_holdem_hand_player_statistics.flg_blind_s) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_f_3bet) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_f_3bet_action='C') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_f_3bet_action='F') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_f_3bet_action='R') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_f_3bet_def_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_f_3bet_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_f_4bet) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_f_4bet_action='C') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_f_4bet_action='F') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_f_4bet_action='R') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_f_4bet_def_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_f_4bet_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(C|XC)%')) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(F|XF)%')) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(R|XR)%')) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_detail.amt_f_bet_facing > 0) then 1 else 0 end))),
(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))),
(sum(tourney_holdem_hand_player_statistics.cnt_f_call)),
(sum((case when(tourney_holdem_hand_player_statistics.cnt_f_call > 0) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_f_cbet) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_f_cbet_action='C') then 1 else 0 end))),
(sum((case when(substring(lookup_actions_f.action from 1 for 1)'X' AND tourney_holdem_hand_player_statistics.enum_f_cbet_action='C') then 1 else 0 end))),
(sum((case when(substring(lookup_actions_f.action from 1 for 1)='X' AND tourney_holdem_hand_player_statistics.enum_f_cbet_action='C') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_f_cbet_action='F') then 1 else 0 end))),
(sum((case when(substring(lookup_actions_f.action from 1 for 1)'X' AND tourney_holdem_hand_player_statistics.enum_f_cbet_action='F') then 1 else 0 end))),
(sum((case when(substring(lookup_actions_f.action from 1 for 1)='X' AND tourney_holdem_hand_player_statistics.enum_f_cbet_action='F') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_f_cbet_action='R') then 1 else 0 end))),
(sum((case when(substring(lookup_actions_f.action from 1 for 1)'X' AND tourney_holdem_hand_player_statistics.enum_f_cbet_action='R') then 1 else 0 end))),
(sum((case when(substring(lookup_actions_f.action from 1 for 1)='X' AND tourney_holdem_hand_player_statistics.enum_f_cbet_action='R') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_f_cbet_def_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_f_cbet and tourney_holdem_hand_player_statistics.flg_f_face_raise) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_f_cbet and lookup_actions_f.action LIKE 'BF') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_f_cbet_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_f_cbet AND NOT(tourney_holdem_hand_player_statistics.flg_t_saw) AND NOT(tourney_holdem_hand_player_statistics.flg_f_face_raise)) then 1 else 0 end))
),
(sum((case when(tourney_holdem_hand_player_statistics.flg_f_check) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_f_check_raise) then 1 else 0 end))),
(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))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_p_face_raise AND NOT(tourney_holdem_hand_player_statistics.flg_p_3bet OR tourney_holdem_hand_player_statistics.flg_p_4bet) AND tourney_holdem_hand_player_statistics.flg_f_bet AND NOT(tourney_holdem_hand_player_statistics.flg_f_cbet_opp) AND
((tourney_holdem_hand_summary.cnt_players > 2 and tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos (sum((case when(lookup_actions_p.action LIKE '%R' and tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 AND NOT(tourney_holdem_hand_player_detail.flg_f_open_opp)) then 1 else 0 end))),
(sum((case when(lookup_actions_p.action LIKE '%R' and tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 and NOT(tourney_holdem_hand_player_detail.flg_f_open_opp) AND substring(lookup_actions_f.action from 1 for 1) = 'C') then 1 else 0 end))),
(sum((case when(lookup_actions_p.action LIKE '%R' and tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 and NOT(tourney_holdem_hand_player_detail.flg_f_open_opp) AND substring(lookup_actions_f.action from 1 for 1) = 'F') then 1 else 0 end))),
(sum((case when(lookup_actions_p.action LIKE '%R' and tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 and NOT(tourney_holdem_hand_player_detail.flg_f_open_opp) AND substring(lookup_actions_f.action from 1 for 1) = 'R') then 1 else 0 end))),
(sum((case when( tourney_holdem_hand_player_statistics.flg_p_face_raise AND NOT(tourney_holdem_hand_player_statistics.flg_p_3bet OR tourney_holdem_hand_player_statistics.flg_p_4bet) AND (tourney_holdem_hand_player_detail.flg_f_open_opp) AND NOT(tourney_holdem_hand_player_statistics.flg_f_cbet_opp) AND ((tourney_holdem_hand_summary.cnt_players > 2 and tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos (sum ( (case when( flg_f_bet AND tourney_holdem_hand_player_statistics.flg_f_face_raise AND (tourney_holdem_hand_player_detail.val_f_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then 1 else 0 end) )
),
(sum ( (case when( lookup_actions_f.action LIKE 'BC' and tourney_holdem_hand_player_statistics.flg_f_face_raise AND (tourney_holdem_hand_player_detail.val_f_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then 1 else 0 end) )
),
(sum ( (case when( lookup_actions_f.action LIKE 'BF' and tourney_holdem_hand_player_statistics.flg_f_face_raise AND (tourney_holdem_hand_player_detail.val_f_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then 1 else 0 end) )
),
(sum ( (case when( lookup_actions_f.action LIKE 'BR' and tourney_holdem_hand_player_statistics.flg_f_face_raise AND (tourney_holdem_hand_player_detail.val_f_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then 1 else 0 end) )
),
(sum((case when( tourney_holdem_hand_player_statistics.flg_p_face_raise and tourney_holdem_hand_player_statistics.cnt_p_raise = 0 and tourney_holdem_hand_player_statistics.cnt_p_call = 1 and tourney_holdem_hand_player_detail.flg_f_open_opp and tourney_holdem_hand_player_statistics.flg_f_bet and tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position) then 1 else 0 end))),
(sum((case when( not(tourney_holdem_hand_player_statistics.flg_p_face_raise) and lookup_actions_p.action LIKE '%R' and tourney_holdem_hand_player_detail.flg_f_open_opp and tourney_holdem_hand_player_statistics.flg_f_check and tourney_holdem_hand_player_detail.amt_f_bet_facing > 0) then 1 else 0 end))),
(sum((case when( not(tourney_holdem_hand_player_statistics.flg_p_face_raise) and lookup_actions_p.action LIKE '%R' and tourney_holdem_hand_player_detail.flg_f_open_opp and tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 and substring(lookup_actions_f.action from 1 for 2) = 'XC') then 1 else 0 end))),
(sum((case when( not(tourney_holdem_hand_player_statistics.flg_p_face_raise) and lookup_actions_p.action LIKE '%R' and tourney_holdem_hand_player_detail.flg_f_open_opp and tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 and substring(lookup_actions_f.action from 1 for 2) = 'XF') then 1 else 0 end))),
(sum((case when( not(tourney_holdem_hand_player_statistics.flg_p_face_raise) and lookup_actions_p.action LIKE '%R' and tourney_holdem_hand_player_detail.flg_f_open_opp and tourney_holdem_hand_player_detail.amt_f_bet_facing > 0 and substring(lookup_actions_f.action from 1 for 2) = 'XR') then 1 else 0 end))),
(sum((case when( tourney_holdem_hand_player_statistics.flg_p_face_raise and tourney_holdem_hand_player_statistics.cnt_p_raise = 0 and tourney_holdem_hand_player_statistics.cnt_p_call = 1 and tourney_holdem_hand_player_detail.flg_f_open_opp and tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))),
(sum(tourney_holdem_hand_player_statistics.cnt_f_raise)),
(sum((case when(tourney_holdem_hand_player_statistics.flg_f_face_raise AND tourney_holdem_hand_player_statistics.cnt_f_call > 0) then 1 else 0 end))),
(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))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_f_face_raise) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))),
(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))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_f_call)) + (sum((case when(tourney_holdem_hand_player_statistics.flg_f_check) then 1 else 0 end))) + (sum((case when(tourney_holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_f_raise)),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_p_open AND tourney_holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))),
(sum( (case when( (tourney_holdem_hand_player_statistics.flg_f_bet OR tourney_holdem_hand_player_statistics.cnt_f_raise > 0) and NOT(tourney_holdem_hand_player_statistics.flg_won_hand) and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( tourney_holdem_hand_player_statistics.cnt_f_call > 0 and NOT(tourney_holdem_hand_player_statistics.flg_won_hand) and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( (tourney_holdem_hand_player_statistics.cnt_p_raise > 0) and NOT(tourney_holdem_hand_player_statistics.flg_won_hand) and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( tourney_holdem_hand_player_statistics.cnt_p_call > 0 and NOT(tourney_holdem_hand_player_statistics.flg_won_hand) and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( (tourney_holdem_hand_player_statistics.flg_r_bet OR tourney_holdem_hand_player_statistics.cnt_r_raise > 0) and NOT(tourney_holdem_hand_player_statistics.flg_won_hand) and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( tourney_holdem_hand_player_statistics.cnt_r_call > 0 and NOT(tourney_holdem_hand_player_statistics.flg_won_hand) and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( (tourney_holdem_hand_player_statistics.flg_t_bet OR tourney_holdem_hand_player_statistics.cnt_t_raise > 0) and NOT(tourney_holdem_hand_player_statistics.flg_won_hand) and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( tourney_holdem_hand_player_statistics.cnt_t_call > 0 and NOT(tourney_holdem_hand_player_statistics.flg_won_hand) and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_summary.cnt_players_f > 0) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_p_3bet AND tourney_holdem_hand_player_statistics.flg_p_4bet_def_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_p_3bet_action='C') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_p_3bet_action='F') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_p_3bet_action='F' and tourney_holdem_hand_player_statistics.flg_p_first_raise and not(tourney_holdem_hand_player_statistics.flg_steal_att)) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_p_3bet_action='R') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp and tourney_holdem_hand_player_statistics.flg_p_first_raise and not(tourney_holdem_hand_player_statistics.flg_steal_att)) then 1 else 0 end))),
(sum((case when( (tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp OR tourney_holdem_hand_player_statistics.flg_p_4bet_def_opp) AND tourney_holdem_hand_player_statistics.enum_f_cbet_action='C') then 1 else 0 end))),
(sum((case when( tourney_holdem_hand_player_statistics.cnt_p_raise > 0 AND tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp AND tourney_holdem_hand_player_statistics.enum_f_cbet_action='F') then 1 else 0 end))),
(sum((case when( (tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp OR tourney_holdem_hand_player_statistics.flg_p_4bet_def_opp) AND tourney_holdem_hand_player_statistics.enum_f_cbet_action='R') then 1 else 0 end))),
(sum((case when( (tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp OR tourney_holdem_hand_player_statistics.flg_p_4bet_def_opp) AND tourney_holdem_hand_player_statistics.flg_f_cbet_def_opp) then 1 else 0 end))),
(sum((case when( tourney_holdem_hand_player_statistics.flg_p_3bet and tourney_holdem_hand_player_statistics.enum_p_4bet_action = 'F') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_p_3bet_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_p_4bet) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_p_4bet_action='C') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_p_4bet_action='F') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_p_4bet_action='R') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_p_4bet_def_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_p_4bet_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_p_fold AND
tourney_holdem_hand_player_statistics.position = 8 AND (tourney_holdem_hand_summary.cnt_players - tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos) = 1 AND tourney_holdem_hand_player_statistics.flg_blind_def_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.position = 8 AND (tourney_holdem_hand_summary.cnt_players - tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos) = 1 AND tourney_holdem_hand_player_statistics.flg_blind_def_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.position = 8 AND tourney_holdem_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action='C' AND tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 9) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.position = 8 AND tourney_holdem_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action='F' AND tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 9) then 1 else 0 end))),
(sum((case when(lookup_actions_p.action LIKE 'R%' AND
tourney_holdem_hand_player_statistics.position = 8 AND tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 9 AND tourney_holdem_hand_player_statistics.flg_blind_def_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))),
(sum(tourney_holdem_hand_player_statistics.cnt_p_call)),
(sum((case when(tourney_holdem_hand_player_statistics.cnt_p_call > 0) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))),
(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) )),
(sum((case when(substring(lookup_actions_p.action from 1 for 1)='X') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_p_face_raise) then 1 else 0 end))),
(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) )),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_p_first_raise) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end) )),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'CC%') then 1 else 0 end) )),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_p_limp AND tourney_holdem_hand_player_statistics.flg_p_face_raise = true) then 1 else 0 end) )),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_p_limp AND lookup_actions_p.action = 'CF') then 1 else 0 end) )),
(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_blind_b)) then 1 else 0 end) )),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'CR%') then 1 else 0 end) )),
(sum((case when(tourney_holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_p_face_raise AND tourney_holdem_hand_player_statistics.flg_p_fold = false AND tourney_holdem_hand_player_statistics.cnt_p_raise=0) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_p_face_raise) then 1 else 0 end))),
(sum(tourney_holdem_hand_player_statistics.cnt_p_raise)),
(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)) ),
(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) )),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_p_squeeze) then 1 else 0 end) )),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_p_squeeze_def_opp AND tourney_holdem_hand_player_statistics.enum_p_squeeze_action = 'C') then 1 else 0 end) )),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_p_squeeze_def_opp AND tourney_holdem_hand_player_statistics.enum_p_squeeze_action = 'F') then 1 else 0 end) )),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_p_squeeze_def_opp) then 1 else 0 end) )),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_p_squeeze_def_opp AND tourney_holdem_hand_player_statistics.enum_p_squeeze_action = 'R') then 1 else 0 end) )),
(sum( (case when( tourney_holdem_hand_player_statistics.flg_p_squeeze_opp) then 1 else 0 end) )),
(sum(tourney_holdem_hand_player_statistics.cnt_p_call)) + (sum((case when(tourney_holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_p_raise)) + (sum((case when(substring(lookup_actions_p.action from 1 for 1)='X') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0 AND tourney_holdem_hand_player_statistics.flg_f_saw AND substring(lookup_actions_f.action from 1 for 1)='B') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0 AND tourney_holdem_hand_player_statistics.flg_f_saw AND substring(lookup_actions_f.action from 1 for 1)='C') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0 AND tourney_holdem_hand_player_statistics.flg_f_saw AND substring(lookup_actions_f.action from 1 for 1)='X') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0 AND tourney_holdem_hand_player_statistics.flg_f_saw AND substring(lookup_actions_f.action from 1 for 2)='XR') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0 AND tourney_holdem_hand_player_statistics.flg_f_saw AND substring(lookup_actions_f.action from 1 for 1)='F') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0 AND (NOT tourney_holdem_hand_player_statistics.flg_f_saw OR substring(lookup_actions_f.action from 1 for 1)='')) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0 AND tourney_holdem_hand_player_statistics.flg_f_saw AND substring(lookup_actions_f.action from 1 for 1)='R') then 1 else 0 end))),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_p_open = false AND tourney_holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_p_open = false AND tourney_holdem_hand_player_statistics.cnt_p_raise > 0 AND tourney_holdem_hand_player_statistics.flg_p_limp = false AND tourney_holdem_hand_player_statistics.flg_p_ccall = false) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_3bet) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_r_3bet_action='C') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_r_3bet_action='F') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_r_3bet_action='R') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_3bet_def_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_3bet_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_4bet) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_r_4bet_action='C') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_r_4bet_action='F') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_r_4bet_action='R') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_4bet_def_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_4bet_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_detail.amt_r_bet_facing > 0 AND (lookup_actions_r.action SIMILAR TO '(C|XC)%')) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_detail.amt_r_bet_facing > 0 AND (lookup_actions_r.action SIMILAR TO '(F|XF)%')) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_detail.amt_r_bet_facing > 0 AND (lookup_actions_r.action SIMILAR TO '(R|XR)%')) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_detail.amt_r_bet_facing > 0) then 1 else 0 end))),
(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))),
(sum(tourney_holdem_hand_player_statistics.cnt_r_call)),
(sum((case when(tourney_holdem_hand_player_statistics.cnt_r_call > 0) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_cbet) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_r_cbet_action='C') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_r_cbet_action='F') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_r_cbet_action='R') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_cbet_def_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_cbet and tourney_holdem_hand_player_statistics.flg_r_face_raise) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_cbet and lookup_actions_r.action LIKE 'BF') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_cbet_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_check) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_check_raise) then 1 else 0 end))),
(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))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_donk) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_r_donk_action='C') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_r_donk_action='F') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_r_donk_action='R') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_donk_def_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_donk_opp) then 1 else 0 end))),
(sum ( (case when( flg_r_bet AND tourney_holdem_hand_player_statistics.flg_r_face_raise AND (tourney_holdem_hand_player_detail.val_r_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then 1 else 0 end) )
),
(sum ( (case when( lookup_actions_r.action LIKE 'BC' and tourney_holdem_hand_player_statistics.flg_r_face_raise AND (tourney_holdem_hand_player_detail.val_r_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then 1 else 0 end) )
),
(sum ( (case when( lookup_actions_r.action LIKE 'BF' and tourney_holdem_hand_player_statistics.flg_r_face_raise AND (tourney_holdem_hand_player_detail.val_r_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then 1 else 0 end) )
),
(sum ( (case when( lookup_actions_r.action LIKE 'BR' and tourney_holdem_hand_player_statistics.flg_r_face_raise AND (tourney_holdem_hand_player_detail.val_r_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then 1 else 0 end) )
),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_float) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_r_float_action='C') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_r_float_action='F') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_r_float_action='R') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_float_def_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_float_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_bet and lookup_actions_t.action LIKE 'X' and tourney_holdem_hand_player_statistics.enum_f_cbet_action = 'C' and NOT(lookup_actions_f.action LIKE '%R')) then 1 else 0 end))
),
(sum((case when(tourney_holdem_hand_player_detail.flg_r_open_opp and lookup_actions_t.action LIKE 'X' and tourney_holdem_hand_player_statistics.enum_f_cbet_action = 'C' and NOT(lookup_actions_f.action LIKE '%R')) then 1 else 0 end))
),
(sum(tourney_holdem_hand_player_statistics.cnt_r_raise)),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_face_raise AND tourney_holdem_hand_player_statistics.cnt_r_call > 0) then 1 else 0 end))),
(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))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_face_raise) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.cnt_r_raise > 0 AND tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.cnt_r_raise > 0 AND tourney_holdem_hand_player_statistics.flg_showdown AND tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_saw) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_r_call)) + (sum((case when(tourney_holdem_hand_player_statistics.flg_r_check) then 1 else 0 end))) + (sum((case when(tourney_holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_r_raise)),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_b = false AND tourney_holdem_hand_player_statistics.flg_blind_s) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_s AND lookup_actions_p.action LIKE 'C') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_sb_steal_fold) then 1 else 0 end))),
(sum( (case when( tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_s AND tourney_holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.position=0) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.position=1) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.enum_folded'N') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att AND NOT tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.position=9) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_b) then 1 else 0 end))),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_b) then 1 else 0 end))) - (sum((case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_b AND tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_b AND tourney_holdem_hand_player_statistics.flg_won_hand AND tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_b AND tourney_holdem_hand_player_statistics.flg_won_hand AND NOT tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_b AND tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_s) then 1 else 0 end))),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_s) then 1 else 0 end))) - (sum((case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_s AND tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_s AND tourney_holdem_hand_player_statistics.flg_won_hand AND tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_s AND tourney_holdem_hand_player_statistics.flg_won_hand AND NOT tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_s AND tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_steal_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_steal_opp AND tourney_holdem_hand_player_statistics.position=0) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_steal_opp AND tourney_holdem_hand_player_statistics.position=1) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_steal_opp AND tourney_holdem_hand_player_statistics.position=9) then 1 else 0 end))),
(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))),
(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))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att AND NOT(tourney_holdem_hand_player_statistics.flg_f_saw) AND NOT(tourney_holdem_hand_player_statistics.flg_p_face_raise)) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.flg_won_hand AND tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.flg_won_hand AND NOT tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_3bet) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_t_3bet_action='C') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_t_3bet_action='F') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_t_3bet_action='R') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_3bet_def_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_3bet_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_4bet) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_t_4bet_action='C') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_t_4bet_action='F') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_t_4bet_action='R') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_4bet_def_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_4bet_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_detail.amt_t_bet_facing > 0 AND (lookup_actions_t.action SIMILAR TO '(C|XC)%')) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_detail.amt_t_bet_facing > 0 AND (lookup_actions_t.action SIMILAR TO '(F|XF)%')) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_detail.amt_t_bet_facing > 0 AND (lookup_actions_t.action SIMILAR TO '(R|XR)%')) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_detail.amt_t_bet_facing > 0) then 1 else 0 end))),
(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))),
(sum(tourney_holdem_hand_player_statistics.cnt_t_call)),
(sum((case when(tourney_holdem_hand_player_statistics.cnt_t_call > 0) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_cbet) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_t_cbet_action='C') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_t_cbet_action='F') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_t_cbet_action='R') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_cbet_def_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_cbet and tourney_holdem_hand_player_statistics.flg_t_face_raise) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_cbet and lookup_actions_t.action LIKE 'BF') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_cbet_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_check) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_check_raise) then 1 else 0 end))),
(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))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_donk) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_t_donk_action='C') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_t_donk_action='F') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_t_donk_action='R') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_donk_def_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_donk_opp) then 1 else 0 end))),
(sum ( (case when( flg_t_bet AND tourney_holdem_hand_player_statistics.flg_t_face_raise AND (tourney_holdem_hand_player_detail.val_t_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then 1 else 0 end) )
),
(sum ( (case when( lookup_actions_t.action LIKE 'BC' and tourney_holdem_hand_player_statistics.flg_t_face_raise AND (tourney_holdem_hand_player_detail.val_t_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then 1 else 0 end) )
),
(sum ( (case when( lookup_actions_t.action LIKE 'BF' and tourney_holdem_hand_player_statistics.flg_t_face_raise AND (tourney_holdem_hand_player_detail.val_t_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then 1 else 0 end) )
),
(sum ( (case when( lookup_actions_t.action LIKE 'BR' and tourney_holdem_hand_player_statistics.flg_t_face_raise AND (tourney_holdem_hand_player_detail.val_t_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then 1 else 0 end) )
),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_float) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_t_float_action='C') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_t_float_action='F') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.enum_t_float_action='R') then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_float_def_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_float_opp) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_bet and lookup_actions_f.action LIKE 'X' and lookup_actions_p.action NOT LIKE '%R' and tourney_holdem_hand_player_statistics.flg_p_face_raise and not(tourney_holdem_hand_player_detail.flg_t_has_position)) then 1 else 0 end))
),
(sum((case when(tourney_holdem_hand_player_detail.flg_t_open_opp and lookup_actions_f.action LIKE 'X' and lookup_actions_p.action NOT LIKE '%R' and tourney_holdem_hand_player_statistics.flg_p_face_raise and not(tourney_holdem_hand_player_detail.flg_t_has_position)) then 1 else 0 end))
),
(sum(tourney_holdem_hand_player_statistics.cnt_t_raise)),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_face_raise AND tourney_holdem_hand_player_statistics.cnt_t_call > 0) then 1 else 0 end))),
(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))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_face_raise) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.cnt_t_raise > 0 AND tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.cnt_t_raise > 0 AND tourney_holdem_hand_player_statistics.flg_showdown AND tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_saw) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_t_call)) + (sum((case when(tourney_holdem_hand_player_statistics.flg_t_check) then 1 else 0 end))) + (sum((case when(tourney_holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_t_raise)),
(sum(tourney_holdem_hand_player_statistics.cnt_p_call)) + (sum((case when(tourney_holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_p_raise)) + (sum((case when(substring(lookup_actions_p.action from 1 for 1)='X') then 1 else 0 end))) + (sum((case when(tourney_holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_f_call)) + (sum((case when(tourney_holdem_hand_player_statistics.flg_f_check) then 1 else 0 end))) + (sum((case when(tourney_holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_f_raise)) + (sum((case when(tourney_holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_t_call)) + (sum((case when(tourney_holdem_hand_player_statistics.flg_t_check) then 1 else 0 end))) + (sum((case when(tourney_holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_t_raise)) + (sum((case when(tourney_holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_r_call)) + (sum((case when(tourney_holdem_hand_player_statistics.flg_r_check) then 1 else 0 end))) + (sum((case when(tourney_holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))) + (sum(tourney_holdem_hand_player_statistics.cnt_r_raise)),
(sum((case when(tourney_holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_b = false AND tourney_holdem_hand_player_statistics.flg_blind_s AND tourney_holdem_hand_player_statistics.flg_vpip) then 1 else 0 end) )),
(sum((case when(tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_showdown AND tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(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))),
(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))),
(sum( (case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0 and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when( tourney_holdem_hand_player_statistics.cnt_p_call > 0 and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(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))),
(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))),
(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))),
(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))),
(sum( (case when(tourney_holdem_hand_player_statistics.flg_showdown AND tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))),
(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))),
(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))),
(sum( (case when( tourney_holdem_hand_player_statistics.cnt_p_raise > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when( tourney_holdem_hand_player_statistics.cnt_p_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(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))),
(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))),
(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))),
(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))),
(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 NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( tourney_holdem_hand_player_statistics.cnt_f_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( tourney_holdem_hand_player_statistics.cnt_p_raise > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( tourney_holdem_hand_player_statistics.cnt_p_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(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 NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( tourney_holdem_hand_player_statistics.cnt_r_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(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 NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( tourney_holdem_hand_player_statistics.cnt_t_call > 0 and tourney_holdem_hand_player_statistics.flg_won_hand and NOT(tourney_holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when((tourney_holdem_blinds.amt_bb = 50) and
(tourney_holdem_hand_player_statistics.flg_p_face_raise) and
(not (tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp)) and
(tourney_holdem_hand_player_detail.amt_p_raise_facing >= 2 * tourney_holdem_blinds.amt_bb) and
(tourney_holdem_hand_player_detail.amt_p_raise_facing
) then 1 else 0 end))),
(sum( (case when((tourney_holdem_blinds.amt_bb = 50) and
(tourney_holdem_hand_player_statistics.flg_p_face_raise) and
(not (tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp)) and
(tourney_holdem_hand_player_detail.amt_p_raise_facing >= 2 * tourney_holdem_blinds.amt_bb) and
(tourney_holdem_hand_player_detail.amt_p_raise_facing
(tourney_omaha_hand_player_statistics.flg_p_fold)
) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_steal_opp AND
(tourney_holdem_blinds.amt_bb > 99) and
(tourney_holdem_blinds.amt_bb (tourney_holdem_hand_player_statistics.flg_p_fold) and
tourney_holdem_hand_player_statistics.position=9) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_steal_opp AND
(tourney_holdem_blinds.amt_bb > 99) and
(tourney_holdem_blinds.amt_bb (tourney_holdem_hand_player_statistics.flg_p_limp) and
(tourney_holdem_hand_player_statistics.enum_face_allin = 'P') and
(tourney_holdem_hand_player_statistics.flg_f_saw)and
tourney_holdem_hand_player_statistics.position=9) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_steal_opp AND
(tourney_holdem_blinds.amt_bb > 99) and
(tourney_holdem_blinds.amt_bb (tourney_holdem_hand_player_statistics.flg_p_limp) and
(tourney_holdem_hand_player_statistics.enum_face_allin = 'P') and
tourney_holdem_hand_player_statistics.position=9) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_steal_opp AND
(tourney_holdem_blinds.amt_bb > 99) and
(tourney_holdem_blinds.amt_bb (tourney_holdem_hand_player_statistics.flg_p_limp) and
tourney_holdem_hand_player_statistics.position=9) then 1 else 0 end))),
(sum((case when(tourney_holdem_hand_player_statistics.flg_steal_opp AND
(tourney_holdem_blinds.amt_bb > 99) and
(tourney_holdem_blinds.amt_bb tourney_holdem_hand_player_statistics.position=9) then 1 else 0 end)))
FROM
tourney_holdem_hand_player_statistics ,
tourney_omaha_hand_player_statistics,
tourney_holdem_hand_player_detail,
tourney_holdem_hand_summary,
lookup_actions lookup_actions_f,
lookup_actions lookup_actions_p,
tourney_holdem_blinds,
lookup_actions lookup_actions_r,
lookup_actions lookup_actions_t,
lookup_positions
WHERE (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 (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_statistics.id_hand)
AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds)
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_hand_summary.id_hand = tourney_holdem_hand_player_detail.id_hand)
AND (lookup_actions_f.id_action=tourney_holdem_hand_player_detail.id_action_f)
AND (lookup_actions_p.id_action=tourney_holdem_hand_player_detail.id_action_p)
AND (lookup_actions_r.id_action=tourney_holdem_hand_player_detail.id_action_r)
AND (lookup_actions_t.id_action=tourney_holdem_hand_player_detail.id_action_t)
AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_summary.id_blinds)
AND (tourney_holdem_hand_player_statistics.id_player = $1)
GROUP BY tourney_holdem_hand_player_statistics.id_player, tourney_holdem_hand_player_statistics.id_blinds, tourney_holdem_hand_summary.cnt_players, ((case when( lookup_positions.flg_blinds) then 0 else (case when( lookup_positions.flg_ep) then 1 else (case when( lookup_positions.flg_mp) then 2 else 3 end) end) end)) ; Reason: Fatal Error (ERROR: column reference "flg_f_bet" is ambiguous LINE 57: (sum ( (case when( flg_f_bet AND tourney_holdem_hand_player_... ^ )

Where an error, specify please.

[kraada]

That error doesn't seem to be related to your stats you built here - have you imported other stats recently?

The one that builds this expression:

(sum((case when( tourney_holdem_hand_player_statistics.flg_p_face_raise AND NOT(tourney_holdem_hand_player_statistics.flg_p_3bet OR tourney_holdem_hand_player_statistics.flg_p_4bet) AND (tourney_holdem_hand_player_detail.flg_f_open_opp) AND NOT(tourney_holdem_hand_player_statistics.flg_f_cbet_opp) AND ((tourney_holdem_hand_summary.cnt_players > 2 and tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos (sum ( (case when( flg_f_bet AND tourney_holdem_hand_player_statistics.flg_f_face_raise AND (tourney_holdem_hand_player_detail.val_f_raise_aggressor_pos > tourney_holdem_hand_player_statistics.position)) then 1 else 0 end) )

Is the problem - it needs to be tourney_holdem_hand_player_statistics.flg_f_bet not just flg_f_bet.

[Guest666]

No. It also seemed to me strange. I delete stat - the error disappears, I add - and the error appears again.

[kraada]

Why did you add the val_p_raise_facing_pct? You already know the size of the open raise in terms of big blinds from the amt_p_raise_facing. It just seems a little redundant - you could try removing that bit and see what happens.

[Guest666]

I tried already :) The error remains.
This bit to exclude cold call and limpers.

[kraada]

This is very strange. Please backup just your custom stats and attach them to a support ticket so that we can investigate further for you. The broken column looks very similar to a default column (cnt_f_donk_opp) but I have no idea why it's breaking as it is.