Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
rubencash wrote:I think that LIKE 'C%' can be any other action as 'CF' or 'CR' not simply 'CC'. If I am wrong then not understand LIKE
if( (cnt_p_3bet / cnt_p_3bet_opp) * 100 <=8.35 AND (cnt_p_ccall / cnt_p_ccall_opp) * 100 <=6.60 AND (cnt_f_cbet_def_action_fold / cnt_f_cbet_def_opp) * 100 >=46.42, 1, if( (cnt_p_3bet / cnt_p_3bet_opp) * 100 <=8.35 AND (cnt_p_ccall / cnt_p_ccall_opp) * 100 <=6.60, 2, if( (cnt_p_ccall / cnt_p_ccall_opp) * 100 <=6.00 AND (cnt_f_cbet_def_action_fold / cnt_f_cbet_def_opp) * 100 >=46.42, 3, if( (cnt_p_3bet / cnt_p_3bet_opp) * 100 <=8.35 AND (cnt_f_cbet_def_action_fold / cnt_f_cbet_def_opp) * 100 >=46.42, 4, if( (cnt_f_cbet_def_action_fold / cnt_f_cbet_def_opp) * 100 >=46.42, 5, if( (cnt_p_ccall / cnt_p_ccall_opp) * 100 <=6.60, 6, if( (cnt_p_3bet / cnt_p_3bet_opp) * 100 <=8.35, 7, 0 )))))))
if( (cnt_p_3bet / cnt_p_3bet_opp) * 100 <=8.35 AND (cnt_p_ccall / cnt_p_ccall_opp) * 100 <=6.60 AND (cnt_f_cbet_def_action_fold / cnt_f_cbet_def_opp) * 100 >=46.42, 1,
if( (cnt_p_3bet / cnt_p_3bet_opp) * 100 <=8.35 AND (cnt_p_ccall / cnt_p_ccall_opp) * 100 <=6.60, 2,
if( (cnt_p_ccall / cnt_p_ccall_opp) * 100 <=6.00 AND (cnt_f_cbet_def_action_fold / cnt_f_cbet_def_opp) * 100 >=46.42, 3,
if( (cnt_p_3bet / cnt_p_3bet_opp) * 100 <=8.35 AND (cnt_f_cbet_def_action_fold / cnt_f_cbet_def_opp) * 100 >=46.42, 4,
if( (cnt_f_cbet_def_action_fold / cnt_f_cbet_def_opp) * 100 >=46.42, 5,
if( (cnt_p_ccall / cnt_p_ccall_opp) * 100 <=6.60, 6,
if( (cnt_p_3bet / cnt_p_3bet_opp) * 100 <=8.35, 7, 0 )))))))
lookup_actions_p.action = 'CC'
or
lookup_actions_p.action SIMILAR TO 'CC'
or
SUBSTRING (lookup_actions_p.action from 1 for 2) = 'CC'
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: Google [Bot] and 38 guests