Consolidating multiple cache-liner per player

[skyd1v3r]

Hello,

currently I try to use my PT-database to do some behavior-research.
To get valuable data I only consider players with a minimum of 1000 hands.
Getting this value out of the cache (which is updated before I start) is a bit hard due to the multiple lines per user:

Code: Select all

Realmoney=# select cnt_hands from holdem_cache WHERE id_player='2';
 cnt_hands
-----------
        160
        340
        202
        800
        400
        450
       1210
        520
       1080
        560
        245
        290
        630
(13 rows)

As you see there are ~6800 hands of that player, yet only ~2200 find their way into my data, since the code will only consider data with 1000 hands in a single cache line:

Code: Select all

Realmoney=# select cnt_hands from holdem_cache WHERE id_player='2' and cnt_hands>1000;
 cnt_hands
-----------
       1210
       1080
(2 rows)

I need a way to cinsider every player with a minimum of 1000 hands in cache all together.
But while I can get this value with

Code: Select all

Realmoney=# select sum(cnt_hands) from holdem_cache WHERE id_player='2';
 sum
-----
 6880
(1 row)

I don´t know how to proceed.

my idea is to create or join a table with the total numbers, or at least the total handcount...
Yet I have no clue how to continue, as I hardly know about table manupulation.

If I could save that result to a table, it would be incredible help:

Code: Select all

Realmoney=# select id_player,sum(cnt_hands) from holdem_cache GROUP BY id_player ORDER BY id_player;
 id_player | sum
-----------+------
         1 |   94
         2 |  6880
         3 |    6
         4 |  397
         5 |   12
         6 |   13
         7 |   33

Hope someone can point me to the right direction.

THANKS a lot.

[kraada]

Well, if you just want that query saved as a table, you can run this query instead:

CREATE TABLE handcount AS select cnt_hands from holdem_cache WHERE id_player='2' and cnt_hands>1000;

You can of course change the table name, or the select query as you'd like.

Good luck

[skyd1v3r]

Thanks a lot!

With a slight modification it worked out:

Code: Select all

 CREATE TABLE thc AS select id_player,sum(cnt_hands) as thc FROM holdem_cache GROUP BY id_player ORDER BY id_player;

Note: thc (in this case) stands for total_hands_count

to get the whole thing you can use this:

Code: Select all

CREATE TABLE holdem_cache_totals AS SELECT
 id_player                         ,
sum( amt_bb_won                          ) AS total_amt_bb_won                          ,
sum( amt_blind                         ) AS total_amt_blind                         ,
sum( amt_mgr                           ) AS total_amt_mgr                           ,
sum( amt_rake                          ) AS total_amt_rake                          ,
sum( amt_won                           ) AS total_amt_won                           ,
sum( cnt_bb                             ) AS total_cnt_bb                             ,
sum( cnt_bb_steal_fold                  ) AS total_cnt_bb_steal_fold                  ,
sum( cnt_bb_steal_raise                 ) AS total_cnt_bb_steal_raise                 ,
sum( cnt_blind                          ) AS total_cnt_blind                          ,
sum( cnt_f_3bet                         ) AS total_cnt_f_3bet                         ,
sum( cnt_f_3bet_def_action_call         ) AS total_cnt_f_3bet_def_action_call         ,
sum( cnt_f_3bet_def_action_fold         ) AS total_cnt_f_3bet_def_action_fold         ,
sum( cnt_f_3bet_def_action_raise        ) AS total_cnt_f_3bet_def_action_raise        ,
sum( cnt_f_3bet_def_opp                 ) AS total_cnt_f_3bet_def_opp                 ,
sum( cnt_f_3bet_opp                     ) AS total_cnt_f_3bet_opp                     ,
sum( cnt_f_4bet                         ) AS total_cnt_f_4bet                         ,
sum( cnt_f_4bet_def_action_call         ) AS total_cnt_f_4bet_def_action_call         ,
sum( cnt_f_4bet_def_action_fold         ) AS total_cnt_f_4bet_def_action_fold         ,
sum( cnt_f_4bet_def_action_raise        ) AS total_cnt_f_4bet_def_action_raise        ,
sum( cnt_f_4bet_def_opp                 ) AS total_cnt_f_4bet_def_opp                 ,
sum( cnt_f_4bet_opp                     ) AS total_cnt_f_4bet_opp                     ,
sum( cnt_f_bet                          ) AS total_cnt_f_bet                          ,
sum( cnt_f_bet_def_action_call          ) AS total_cnt_f_bet_def_action_call          ,
sum( cnt_f_bet_def_action_fold          ) AS total_cnt_f_bet_def_action_fold          ,
sum( cnt_f_bet_def_action_raise         ) AS total_cnt_f_bet_def_action_raise         ,
sum( cnt_f_bet_def_opp                  ) AS total_cnt_f_bet_def_opp                  ,
sum( cnt_f_bet_raise_hands              ) AS total_cnt_f_bet_raise_hands              ,
sum( cnt_f_call                         ) AS total_cnt_f_call                         ,
sum( cnt_f_call_hands                   ) AS total_cnt_f_call_hands                   ,
sum( cnt_f_cbet                         ) AS total_cnt_f_cbet                         ,
sum( cnt_f_cbet_def_action_call         ) AS total_cnt_f_cbet_def_action_call         ,
sum( cnt_f_cbet_def_action_fold         ) AS total_cnt_f_cbet_def_action_fold         ,
sum( cnt_f_cbet_def_action_raise        ) AS total_cnt_f_cbet_def_action_raise        ,
sum( cnt_f_cbet_def_opp                 ) AS total_cnt_f_cbet_def_opp                 ,
sum( cnt_f_cbet_opp                     ) AS total_cnt_f_cbet_opp                     ,
sum( cnt_f_check                        ) AS total_cnt_f_check                        ,
sum( cnt_f_check_raise                  ) AS total_cnt_f_check_raise                  ,
sum( cnt_f_check_raise_opp              ) AS total_cnt_f_check_raise_opp              ,
sum( cnt_f_fold                         ) AS total_cnt_f_fold                         ,
sum( cnt_f_raise                        ) AS total_cnt_f_raise                        ,
sum( cnt_f_raise_def_action_call        ) AS total_cnt_f_raise_def_action_call        ,
sum( cnt_f_raise_def_action_fold        ) AS total_cnt_f_raise_def_action_fold        ,
sum( cnt_f_raise_def_opp                ) AS total_cnt_f_raise_def_opp                ,
sum( cnt_f_saw                          ) AS total_cnt_f_saw                          ,
sum( cnt_f_saw_won                      ) AS total_cnt_f_saw_won                      ,
sum( cnt_f_total_actions                ) AS total_cnt_f_total_actions                ,
sum( cnt_first_limp                     ) AS total_cnt_first_limp                     ,
sum( cnt_fold_when_f_bet_raise          ) AS total_cnt_fold_when_f_bet_raise          ,
sum( cnt_fold_when_f_call               ) AS total_cnt_fold_when_f_call               ,
sum( cnt_fold_when_p_bet_raise          ) AS total_cnt_fold_when_p_bet_raise          ,
sum( cnt_fold_when_p_call               ) AS total_cnt_fold_when_p_call               ,
sum( cnt_fold_when_r_bet_raise          ) AS total_cnt_fold_when_r_bet_raise          ,
sum( cnt_fold_when_r_call               ) AS total_cnt_fold_when_r_call               ,
sum( cnt_fold_when_t_bet_raise          ) AS total_cnt_fold_when_t_bet_raise          ,
sum( cnt_fold_when_t_call               ) AS total_cnt_fold_when_t_call               ,
sum( cnt_hands                          ) AS total_cnt_hands                          ,
sum( cnt_hands_raked                    ) AS total_cnt_hands_raked                    ,
sum( cnt_hands_with_flop                ) AS total_cnt_hands_with_flop                ,
sum( cnt_hands_won                      ) AS total_cnt_hands_won                      ,
sum( cnt_p_3bet                         ) AS total_cnt_p_3bet                         ,
sum( cnt_p_3bet_def_action_call         ) AS total_cnt_p_3bet_def_action_call         ,
sum( cnt_p_3bet_def_action_fold         ) AS total_cnt_p_3bet_def_action_fold         ,
sum( cnt_p_3bet_def_action_raise        ) AS total_cnt_p_3bet_def_action_raise        ,
sum( cnt_p_3bet_def_opp                 ) AS total_cnt_p_3bet_def_opp                 ,
sum( cnt_p_3bet_opp                     ) AS total_cnt_p_3bet_opp                     ,
sum( cnt_p_4bet                         ) AS total_cnt_p_4bet                         ,
sum( cnt_p_4bet_def_action_call         ) AS total_cnt_p_4bet_def_action_call         ,
sum( cnt_p_4bet_def_action_fold         ) AS total_cnt_p_4bet_def_action_fold         ,
sum( cnt_p_4bet_def_action_raise        ) AS total_cnt_p_4bet_def_action_raise        ,
sum( cnt_p_4bet_def_opp                 ) AS total_cnt_p_4bet_def_opp                 ,
sum( cnt_p_4bet_opp                     ) AS total_cnt_p_4bet_opp                     ,
sum( cnt_p_bb_fold_to_sb                ) AS total_cnt_p_bb_fold_to_sb                ,
sum( cnt_p_bb_fold_to_sb_opp            ) AS total_cnt_p_bb_fold_to_sb_opp            ,
sum( cnt_p_bet_raise_hands              ) AS total_cnt_p_bet_raise_hands              ,
sum( cnt_p_call                         ) AS total_cnt_p_call                         ,
sum( cnt_p_call_hands                   ) AS total_cnt_p_call_hands                   ,
sum( cnt_p_ccall                        ) AS total_cnt_p_ccall                        ,
sum( cnt_p_ccall_opp                    ) AS total_cnt_p_ccall_opp                    ,
sum( cnt_p_check                        ) AS total_cnt_p_check                        ,
sum( cnt_p_face_raise                   ) AS total_cnt_p_face_raise                   ,
sum( cnt_p_facing_limpers               ) AS total_cnt_p_facing_limpers               ,
sum( cnt_p_first_raise                  ) AS total_cnt_p_first_raise                  ,
sum( cnt_p_fold                         ) AS total_cnt_p_fold                         ,
sum( cnt_p_limp_after_limpers_opp       ) AS total_cnt_p_limp_after_limpers_opp       ,
sum( cnt_p_open_opp                     ) AS total_cnt_p_open_opp                     ,
sum( cnt_p_pfr_call                     ) AS total_cnt_p_pfr_call                     ,
sum( cnt_p_pfr_call_opp                 ) AS total_cnt_p_pfr_call_opp                 ,
sum( cnt_p_raise                        ) AS total_cnt_p_raise                        ,
sum( cnt_p_raise_first_in               ) AS total_cnt_p_raise_first_in               ,
sum( cnt_p_raise_limpers                ) AS total_cnt_p_raise_limpers                ,
sum( cnt_p_total_actions                ) AS total_cnt_p_total_actions                ,
sum( cnt_pfr                            ) AS total_cnt_pfr                            ,
sum( cnt_pfr_f_bet                      ) AS total_cnt_pfr_f_bet                      ,
sum( cnt_pfr_f_call                     ) AS total_cnt_pfr_f_call                     ,
sum( cnt_pfr_f_check                    ) AS total_cnt_pfr_f_check                    ,
sum( cnt_pfr_f_checkraise               ) AS total_cnt_pfr_f_checkraise               ,
sum( cnt_pfr_f_fold                     ) AS total_cnt_pfr_f_fold                     ,
sum( cnt_pfr_f_none                     ) AS total_cnt_pfr_f_none                     ,
sum( cnt_pfr_f_raise                    ) AS total_cnt_pfr_f_raise                    ,
sum( cnt_prev_callers_limp              ) AS total_cnt_prev_callers_limp              ,
sum( cnt_prev_callers_raise             ) AS total_cnt_prev_callers_raise             ,
sum( cnt_r_3bet                         ) AS total_cnt_r_3bet                         ,
sum( cnt_r_3bet_def_action_call         ) AS total_cnt_r_3bet_def_action_call         ,
sum( cnt_r_3bet_def_action_fold         ) AS total_cnt_r_3bet_def_action_fold         ,
sum( cnt_r_3bet_def_action_raise        ) AS total_cnt_r_3bet_def_action_raise        ,
sum( cnt_r_3bet_def_opp                 ) AS total_cnt_r_3bet_def_opp                 ,
sum( cnt_r_3bet_opp                     ) AS total_cnt_r_3bet_opp                     ,
sum( cnt_r_4bet                         ) AS total_cnt_r_4bet                         ,
sum( cnt_r_4bet_def_action_call         ) AS total_cnt_r_4bet_def_action_call         ,
sum( cnt_r_4bet_def_action_fold         ) AS total_cnt_r_4bet_def_action_fold         ,
sum( cnt_r_4bet_def_action_raise        ) AS total_cnt_r_4bet_def_action_raise        ,
sum( cnt_r_4bet_def_opp                 ) AS total_cnt_r_4bet_def_opp                 ,
sum( cnt_r_4bet_opp                     ) AS total_cnt_r_4bet_opp                     ,
sum( cnt_r_bet                          ) AS total_cnt_r_bet                          ,
sum( cnt_r_bet_def_action_call          ) AS total_cnt_r_bet_def_action_call          ,
sum( cnt_r_bet_def_action_fold          ) AS total_cnt_r_bet_def_action_fold          ,
sum( cnt_r_bet_def_action_raise         ) AS total_cnt_r_bet_def_action_raise         ,
sum( cnt_r_bet_def_opp                  ) AS total_cnt_r_bet_def_opp                  ,
sum( cnt_r_bet_raise_hands              ) AS total_cnt_r_bet_raise_hands              ,
sum( cnt_r_call                         ) AS total_cnt_r_call                         ,
sum( cnt_r_call_hands                   ) AS total_cnt_r_call_hands                   ,
sum( cnt_r_cbet                         ) AS total_cnt_r_cbet                         ,
sum( cnt_r_cbet_def_action_call         ) AS total_cnt_r_cbet_def_action_call         ,
sum( cnt_r_cbet_def_action_fold         ) AS total_cnt_r_cbet_def_action_fold         ,
sum( cnt_r_cbet_def_action_raise        ) AS total_cnt_r_cbet_def_action_raise        ,
sum( cnt_r_cbet_def_opp                 ) AS total_cnt_r_cbet_def_opp                 ,
sum( cnt_r_cbet_opp                     ) AS total_cnt_r_cbet_opp                     ,
sum( cnt_r_check                        ) AS total_cnt_r_check                        ,
sum( cnt_r_check_raise                  ) AS total_cnt_r_check_raise                  ,
sum( cnt_r_check_raise_opp              ) AS total_cnt_r_check_raise_opp              ,
sum( cnt_r_donk                         ) AS total_cnt_r_donk                         ,
sum( cnt_r_donk_def_action_call         ) AS total_cnt_r_donk_def_action_call         ,
sum( cnt_r_donk_def_action_fold         ) AS total_cnt_r_donk_def_action_fold         ,
sum( cnt_r_donk_def_action_raise        ) AS total_cnt_r_donk_def_action_raise        ,
sum( cnt_r_donk_def_opp                 ) AS total_cnt_r_donk_def_opp                 ,
sum( cnt_r_donk_opp                     ) AS total_cnt_r_donk_opp                     ,
sum( cnt_r_float                        ) AS total_cnt_r_float                        ,
sum( cnt_r_float_def_action_call        ) AS total_cnt_r_float_def_action_call        ,
sum( cnt_r_float_def_action_fold        ) AS total_cnt_r_float_def_action_fold        ,
sum( cnt_r_float_def_action_raise       ) AS total_cnt_r_float_def_action_raise       ,
sum( cnt_r_float_def_opp                ) AS total_cnt_r_float_def_opp                ,
sum( cnt_r_float_opp                    ) AS total_cnt_r_float_opp                    ,
sum( cnt_r_fold                         ) AS total_cnt_r_fold                         ,
sum( cnt_r_raise                        ) AS total_cnt_r_raise                        ,
sum( cnt_r_raise_def_action_call        ) AS total_cnt_r_raise_def_action_call        ,
sum( cnt_r_raise_def_action_fold        ) AS total_cnt_r_raise_def_action_fold        ,
sum( cnt_r_raise_def_opp                ) AS total_cnt_r_raise_def_opp                ,
sum( cnt_r_raise_wtsd                   ) AS total_cnt_r_raise_wtsd                   ,
sum( cnt_r_raise_wtsd_won               ) AS total_cnt_r_raise_wtsd_won               ,
sum( cnt_r_saw                          ) AS total_cnt_r_saw                          ,
sum( cnt_r_total_actions                ) AS total_cnt_r_total_actions                ,
sum( cnt_sb                             ) AS total_cnt_sb                             ,
sum( cnt_sb_steal_fold                  ) AS total_cnt_sb_steal_fold                  ,
sum( cnt_sb_steal_raise                 ) AS total_cnt_sb_steal_raise                 ,
sum( cnt_sessions                       ) AS total_cnt_sessions                       ,
sum( cnt_sessions_won                   ) AS total_cnt_sessions_won                   ,
sum( cnt_steal_att                      ) AS total_cnt_steal_att                      ,
sum( cnt_steal_att_fold                 ) AS total_cnt_steal_att_fold                 ,
sum( cnt_steal_att_no_sd                ) AS total_cnt_steal_att_no_sd                ,
sum( cnt_steal_att_wtsd                 ) AS total_cnt_steal_att_wtsd                 ,
sum( cnt_steal_def_opp_bb               ) AS total_cnt_steal_def_opp_bb               ,
sum( cnt_steal_def_opp_bb_nosd          ) AS total_cnt_steal_def_opp_bb_nosd          ,
sum( cnt_steal_def_opp_bb_win_sd        ) AS total_cnt_steal_def_opp_bb_win_sd        ,
sum( cnt_steal_def_opp_bb_win_wo_sd     ) AS total_cnt_steal_def_opp_bb_win_wo_sd     ,
sum( cnt_steal_def_opp_bb_wtsd          ) AS total_cnt_steal_def_opp_bb_wtsd          ,
sum( cnt_steal_def_opp_sb               ) AS total_cnt_steal_def_opp_sb               ,
sum( cnt_steal_def_opp_sb_nosd          ) AS total_cnt_steal_def_opp_sb_nosd          ,
sum( cnt_steal_def_opp_sb_win_sd        ) AS total_cnt_steal_def_opp_sb_win_sd        ,
sum( cnt_steal_def_opp_sb_win_wo_sd     ) AS total_cnt_steal_def_opp_sb_win_wo_sd     ,
sum( cnt_steal_def_opp_sb_wtsd          ) AS total_cnt_steal_def_opp_sb_wtsd          ,
sum( cnt_steal_opp                      ) AS total_cnt_steal_opp                      ,
sum( cnt_steal_reraise_def_action_fold  ) AS total_cnt_steal_reraise_def_action_fold  ,
sum( cnt_steal_reraise_def_opp          ) AS total_cnt_steal_reraise_def_opp          ,
sum( cnt_steal_success                  ) AS total_cnt_steal_success                  ,
sum( cnt_steal_win_sd                   ) AS total_cnt_steal_win_sd                   ,
sum( cnt_steal_win_wo_sd                ) AS total_cnt_steal_win_wo_sd                ,
sum( cnt_t_3bet                         ) AS total_cnt_t_3bet                         ,
sum( cnt_t_3bet_def_action_call         ) AS total_cnt_t_3bet_def_action_call         ,
sum( cnt_t_3bet_def_action_fold         ) AS total_cnt_t_3bet_def_action_fold         ,
sum( cnt_t_3bet_def_action_raise        ) AS total_cnt_t_3bet_def_action_raise        ,
sum( cnt_t_3bet_def_opp                 ) AS total_cnt_t_3bet_def_opp                 ,
sum( cnt_t_3bet_opp                     ) AS total_cnt_t_3bet_opp                     ,
sum( cnt_t_4bet                         ) AS total_cnt_t_4bet                         ,
sum( cnt_t_4bet_def_action_call         ) AS total_cnt_t_4bet_def_action_call         ,
sum( cnt_t_4bet_def_action_fold         ) AS total_cnt_t_4bet_def_action_fold         ,
sum( cnt_t_4bet_def_action_raise        ) AS total_cnt_t_4bet_def_action_raise        ,
sum( cnt_t_4bet_def_opp                 ) AS total_cnt_t_4bet_def_opp                 ,
sum( cnt_t_4bet_opp                     ) AS total_cnt_t_4bet_opp                     ,
sum( cnt_t_bet                          ) AS total_cnt_t_bet                          ,
sum( cnt_t_bet_def_action_call          ) AS total_cnt_t_bet_def_action_call          ,
sum( cnt_t_bet_def_action_fold          ) AS total_cnt_t_bet_def_action_fold          ,
sum( cnt_t_bet_def_action_raise         ) AS total_cnt_t_bet_def_action_raise         ,
sum( cnt_t_bet_def_opp                  ) AS total_cnt_t_bet_def_opp                  ,
sum( cnt_t_bet_raise_hands              ) AS total_cnt_t_bet_raise_hands              ,
sum( cnt_t_call                         ) AS total_cnt_t_call                         ,
sum( cnt_t_call_hands                   ) AS total_cnt_t_call_hands                   ,
sum( cnt_t_cbet                         ) AS total_cnt_t_cbet                         ,
sum( cnt_t_cbet_def_action_call         ) AS total_cnt_t_cbet_def_action_call         ,
sum( cnt_t_cbet_def_action_fold         ) AS total_cnt_t_cbet_def_action_fold         ,
sum( cnt_t_cbet_def_action_raise        ) AS total_cnt_t_cbet_def_action_raise        ,
sum( cnt_t_cbet_def_opp                 ) AS total_cnt_t_cbet_def_opp                 ,
sum( cnt_t_cbet_opp                     ) AS total_cnt_t_cbet_opp                     ,
sum( cnt_t_check                        ) AS total_cnt_t_check                        ,
sum( cnt_t_check_raise                  ) AS total_cnt_t_check_raise                  ,
sum( cnt_t_check_raise_opp              ) AS total_cnt_t_check_raise_opp              ,
sum( cnt_t_donk                         ) AS total_cnt_t_donk                         ,
sum( cnt_t_donk_def_action_call         ) AS total_cnt_t_donk_def_action_call         ,
sum( cnt_t_donk_def_action_fold         ) AS total_cnt_t_donk_def_action_fold         ,
sum( cnt_t_donk_def_action_raise        ) AS total_cnt_t_donk_def_action_raise        ,
sum( cnt_t_donk_def_opp                 ) AS total_cnt_t_donk_def_opp                 ,
sum( cnt_t_donk_opp                     ) AS total_cnt_t_donk_opp                     ,
sum( cnt_t_float                        ) AS total_cnt_t_float                        ,
sum( cnt_t_float_def_action_call        ) AS total_cnt_t_float_def_action_call        ,
sum( cnt_t_float_def_action_fold        ) AS total_cnt_t_float_def_action_fold        ,
sum( cnt_t_float_def_action_raise       ) AS total_cnt_t_float_def_action_raise       ,
sum( cnt_t_float_def_opp                ) AS total_cnt_t_float_def_opp                ,
sum( cnt_t_float_opp                    ) AS total_cnt_t_float_opp                    ,
sum( cnt_t_fold                         ) AS total_cnt_t_fold                         ,
sum( cnt_t_raise                        ) AS total_cnt_t_raise                        ,
sum( cnt_t_raise_def_action_call        ) AS total_cnt_t_raise_def_action_call        ,
sum( cnt_t_raise_def_action_fold        ) AS total_cnt_t_raise_def_action_fold        ,
sum( cnt_t_raise_def_opp                ) AS total_cnt_t_raise_def_opp                ,
sum( cnt_t_raise_wtsd                   ) AS total_cnt_t_raise_wtsd                   ,
sum( cnt_t_raise_wtsd_won               ) AS total_cnt_t_raise_wtsd_won               ,
sum( cnt_t_saw                          ) AS total_cnt_t_saw                          ,
sum( cnt_t_total_actions                ) AS total_cnt_t_total_actions                ,
sum( cnt_total_actions                  ) AS total_cnt_total_actions                  ,
sum( cnt_vpip                           ) AS total_cnt_vpip                           ,
sum( cnt_vpip_sb                        ) AS total_cnt_vpip_sb                        ,
sum( cnt_won_hand                       ) AS total_cnt_won_hand                       ,
sum( cnt_won_showdown                   ) AS total_cnt_won_showdown                   ,
sum( cnt_wtsd                           ) AS total_cnt_wtsd                           ,
sum( cnt_wtsd_when_f_bet_raise          ) AS total_cnt_wtsd_when_f_bet_raise          ,
sum( cnt_wtsd_when_f_call               ) AS total_cnt_wtsd_when_f_call               ,
sum( cnt_wtsd_when_p_bet_raise          ) AS total_cnt_wtsd_when_p_bet_raise          ,
sum( cnt_wtsd_when_p_call               ) AS total_cnt_wtsd_when_p_call               ,
sum( cnt_wtsd_when_r_bet_raise          ) AS total_cnt_wtsd_when_r_bet_raise          ,
sum( cnt_wtsd_when_r_call               ) AS total_cnt_wtsd_when_r_call               ,
sum( cnt_wtsd_when_t_bet_raise          ) AS total_cnt_wtsd_when_t_bet_raise          ,
sum( cnt_wtsd_when_t_call               ) AS total_cnt_wtsd_when_t_call               ,
sum( cnt_wtsd_won                       ) AS total_cnt_wtsd_won                       ,
sum( cnt_wtsd_won_when_f_bet_raise      ) AS total_cnt_wtsd_won_when_f_bet_raise      ,
sum( cnt_wtsd_won_when_f_call           ) AS total_cnt_wtsd_won_when_f_call           ,
sum( cnt_wtsd_won_when_p_bet_raise      ) AS total_cnt_wtsd_won_when_p_bet_raise      ,
sum( cnt_wtsd_won_when_p_call           ) AS total_cnt_wtsd_won_when_p_call           ,
sum( cnt_wtsd_won_when_r_bet_raise      ) AS total_cnt_wtsd_won_when_r_bet_raise      ,
sum( cnt_wtsd_won_when_r_call           ) AS total_cnt_wtsd_won_when_r_call           ,
sum( cnt_wtsd_won_when_t_bet_raise      ) AS total_cnt_wtsd_won_when_t_bet_raise      ,
sum( cnt_wtsd_won_when_t_call           ) AS total_cnt_wtsd_won_when_t_call           ,
sum( cnt_wwosd_f_bet_raise              ) AS total_cnt_wwosd_f_bet_raise              ,
sum( cnt_wwosd_f_call                   ) AS total_cnt_wwosd_f_call                   ,
sum( cnt_wwosd_p_bet_raise              ) AS total_cnt_wwosd_p_bet_raise              ,
sum( cnt_wwosd_p_call                   ) AS total_cnt_wwosd_p_call                   ,
sum( cnt_wwosd_r_bet_raise              ) AS total_cnt_wwosd_r_bet_raise              ,
sum( cnt_wwosd_r_call                   ) AS total_cnt_wwosd_r_call                   ,
sum( cnt_wwosd_t_bet_raise              ) AS total_cnt_wwosd_t_bet_raise              ,
sum( cnt_wwosd_t_call                   ) AS total_cnt_wwosd_t_call                   ,
sum( amt_sd_bb                        ) AS total_amt_sd_bb                       
FROM holdem_cache
GROUP BY id_player
ORDER BY id_player;


[kraada]

You're quite welcome. We of course are splitting things up in this fashion to speed up query results for ourselves, but I can understand why for statistical analysis purposes you want to have them combined.

Good luck with your study

[skyd1v3r]

Added the line

Code: Select all

    sum( cnt_vpip_noblind                   ) AS total_cnt_vpip_noblind                   ,

as this stat prooves to be usefull in several situations.

Well, here is the way to go:
*config stats -> holdem_hand_player_statistics -> duplicate cnt_vpip
*call it cnt_vpip_noblind

Code: Select all

    sum(CASE WHEN holdem_hand_player_statistics.flg_blind_b = false AND holdem_hand_player_statistics.flg_blind_s = false AND holdem_hand_player_statistics.flg_vpip THEN 1 ELSE 0 END)


*update cache
*recreate holdem_cache_totals table

Code: Select all

    CREATE TABLE holdem_cache_totals AS SELECT
    id_player                         ,
    sum( amt_bb_won                          ) AS total_amt_bb_won                          ,
    sum( amt_blind                         ) AS total_amt_blind                         ,
    sum( amt_mgr                           ) AS total_amt_mgr                           ,
    sum( amt_rake                          ) AS total_amt_rake                          ,
    sum( amt_won                           ) AS total_amt_won                           ,
    sum( cnt_bb                             ) AS total_cnt_bb                             ,
    sum( cnt_bb_steal_fold                  ) AS total_cnt_bb_steal_fold                  ,
    sum( cnt_bb_steal_raise                 ) AS total_cnt_bb_steal_raise                 ,
    sum( cnt_blind                          ) AS total_cnt_blind                          ,
    sum( cnt_f_3bet                         ) AS total_cnt_f_3bet                         ,
    sum( cnt_f_3bet_def_action_call         ) AS total_cnt_f_3bet_def_action_call         ,
    sum( cnt_f_3bet_def_action_fold         ) AS total_cnt_f_3bet_def_action_fold         ,
    sum( cnt_f_3bet_def_action_raise        ) AS total_cnt_f_3bet_def_action_raise        ,
    sum( cnt_f_3bet_def_opp                 ) AS total_cnt_f_3bet_def_opp                 ,
    sum( cnt_f_3bet_opp                     ) AS total_cnt_f_3bet_opp                     ,
    sum( cnt_f_4bet                         ) AS total_cnt_f_4bet                         ,
    sum( cnt_f_4bet_def_action_call         ) AS total_cnt_f_4bet_def_action_call         ,
    sum( cnt_f_4bet_def_action_fold         ) AS total_cnt_f_4bet_def_action_fold         ,
    sum( cnt_f_4bet_def_action_raise        ) AS total_cnt_f_4bet_def_action_raise        ,
    sum( cnt_f_4bet_def_opp                 ) AS total_cnt_f_4bet_def_opp                 ,
    sum( cnt_f_4bet_opp                     ) AS total_cnt_f_4bet_opp                     ,
    sum( cnt_f_bet                          ) AS total_cnt_f_bet                          ,
    sum( cnt_f_bet_def_action_call          ) AS total_cnt_f_bet_def_action_call          ,
    sum( cnt_f_bet_def_action_fold          ) AS total_cnt_f_bet_def_action_fold          ,
    sum( cnt_f_bet_def_action_raise         ) AS total_cnt_f_bet_def_action_raise         ,
    sum( cnt_f_bet_def_opp                  ) AS total_cnt_f_bet_def_opp                  ,
    sum( cnt_f_bet_raise_hands              ) AS total_cnt_f_bet_raise_hands              ,
    sum( cnt_f_call                         ) AS total_cnt_f_call                         ,
    sum( cnt_f_call_hands                   ) AS total_cnt_f_call_hands                   ,
    sum( cnt_f_cbet                         ) AS total_cnt_f_cbet                         ,
    sum( cnt_f_cbet_def_action_call         ) AS total_cnt_f_cbet_def_action_call         ,
    sum( cnt_f_cbet_def_action_fold         ) AS total_cnt_f_cbet_def_action_fold         ,
    sum( cnt_f_cbet_def_action_raise        ) AS total_cnt_f_cbet_def_action_raise        ,
    sum( cnt_f_cbet_def_opp                 ) AS total_cnt_f_cbet_def_opp                 ,
    sum( cnt_f_cbet_opp                     ) AS total_cnt_f_cbet_opp                     ,
    sum( cnt_f_check                        ) AS total_cnt_f_check                        ,
    sum( cnt_f_check_raise                  ) AS total_cnt_f_check_raise                  ,
    sum( cnt_f_check_raise_opp              ) AS total_cnt_f_check_raise_opp              ,
    sum( cnt_f_fold                         ) AS total_cnt_f_fold                         ,
    sum( cnt_f_raise                        ) AS total_cnt_f_raise                        ,
    sum( cnt_f_raise_def_action_call        ) AS total_cnt_f_raise_def_action_call        ,
    sum( cnt_f_raise_def_action_fold        ) AS total_cnt_f_raise_def_action_fold        ,
    sum( cnt_f_raise_def_opp                ) AS total_cnt_f_raise_def_opp                ,
    sum( cnt_f_saw                          ) AS total_cnt_f_saw                          ,
    sum( cnt_f_saw_won                      ) AS total_cnt_f_saw_won                      ,
    sum( cnt_f_total_actions                ) AS total_cnt_f_total_actions                ,
    sum( cnt_first_limp                     ) AS total_cnt_first_limp                     ,
    sum( cnt_fold_when_f_bet_raise          ) AS total_cnt_fold_when_f_bet_raise          ,
    sum( cnt_fold_when_f_call               ) AS total_cnt_fold_when_f_call               ,
    sum( cnt_fold_when_p_bet_raise          ) AS total_cnt_fold_when_p_bet_raise          ,
    sum( cnt_fold_when_p_call               ) AS total_cnt_fold_when_p_call               ,
    sum( cnt_fold_when_r_bet_raise          ) AS total_cnt_fold_when_r_bet_raise          ,
    sum( cnt_fold_when_r_call               ) AS total_cnt_fold_when_r_call               ,
    sum( cnt_fold_when_t_bet_raise          ) AS total_cnt_fold_when_t_bet_raise          ,
    sum( cnt_fold_when_t_call               ) AS total_cnt_fold_when_t_call               ,
    sum( cnt_hands                          ) AS total_cnt_hands                          ,
    sum( cnt_hands_raked                    ) AS total_cnt_hands_raked                    ,
    sum( cnt_hands_with_flop                ) AS total_cnt_hands_with_flop                ,
    sum( cnt_hands_won                      ) AS total_cnt_hands_won                      ,
    sum( cnt_p_3bet                         ) AS total_cnt_p_3bet                         ,
    sum( cnt_p_3bet_def_action_call         ) AS total_cnt_p_3bet_def_action_call         ,
    sum( cnt_p_3bet_def_action_fold         ) AS total_cnt_p_3bet_def_action_fold         ,
    sum( cnt_p_3bet_def_action_raise        ) AS total_cnt_p_3bet_def_action_raise        ,
    sum( cnt_p_3bet_def_opp                 ) AS total_cnt_p_3bet_def_opp                 ,
    sum( cnt_p_3bet_opp                     ) AS total_cnt_p_3bet_opp                     ,
    sum( cnt_p_4bet                         ) AS total_cnt_p_4bet                         ,
    sum( cnt_p_4bet_def_action_call         ) AS total_cnt_p_4bet_def_action_call         ,
    sum( cnt_p_4bet_def_action_fold         ) AS total_cnt_p_4bet_def_action_fold         ,
    sum( cnt_p_4bet_def_action_raise        ) AS total_cnt_p_4bet_def_action_raise        ,
    sum( cnt_p_4bet_def_opp                 ) AS total_cnt_p_4bet_def_opp                 ,
    sum( cnt_p_4bet_opp                     ) AS total_cnt_p_4bet_opp                     ,
    sum( cnt_p_bb_fold_to_sb                ) AS total_cnt_p_bb_fold_to_sb                ,
    sum( cnt_p_bb_fold_to_sb_opp            ) AS total_cnt_p_bb_fold_to_sb_opp            ,
    sum( cnt_p_bet_raise_hands              ) AS total_cnt_p_bet_raise_hands              ,
    sum( cnt_p_call                         ) AS total_cnt_p_call                         ,
    sum( cnt_p_call_hands                   ) AS total_cnt_p_call_hands                   ,
    sum( cnt_p_ccall                        ) AS total_cnt_p_ccall                        ,
    sum( cnt_p_ccall_opp                    ) AS total_cnt_p_ccall_opp                    ,
    sum( cnt_p_check                        ) AS total_cnt_p_check                        ,
    sum( cnt_p_face_raise                   ) AS total_cnt_p_face_raise                   ,
    sum( cnt_p_facing_limpers               ) AS total_cnt_p_facing_limpers               ,
    sum( cnt_p_first_raise                  ) AS total_cnt_p_first_raise                  ,
    sum( cnt_p_fold                         ) AS total_cnt_p_fold                         ,
    sum( cnt_p_limp_after_limpers_opp       ) AS total_cnt_p_limp_after_limpers_opp       ,
    sum( cnt_p_open_opp                     ) AS total_cnt_p_open_opp                     ,
    sum( cnt_p_pfr_call                     ) AS total_cnt_p_pfr_call                     ,
    sum( cnt_p_pfr_call_opp                 ) AS total_cnt_p_pfr_call_opp                 ,
    sum( cnt_p_raise                        ) AS total_cnt_p_raise                        ,
    sum( cnt_p_raise_first_in               ) AS total_cnt_p_raise_first_in               ,
    sum( cnt_p_raise_limpers                ) AS total_cnt_p_raise_limpers                ,
    sum( cnt_p_total_actions                ) AS total_cnt_p_total_actions                ,
    sum( cnt_pfr                            ) AS total_cnt_pfr                            ,
    sum( cnt_pfr_f_bet                      ) AS total_cnt_pfr_f_bet                      ,
    sum( cnt_pfr_f_call                     ) AS total_cnt_pfr_f_call                     ,
    sum( cnt_pfr_f_check                    ) AS total_cnt_pfr_f_check                    ,
    sum( cnt_pfr_f_checkraise               ) AS total_cnt_pfr_f_checkraise               ,
    sum( cnt_pfr_f_fold                     ) AS total_cnt_pfr_f_fold                     ,
    sum( cnt_pfr_f_none                     ) AS total_cnt_pfr_f_none                     ,
    sum( cnt_pfr_f_raise                    ) AS total_cnt_pfr_f_raise                    ,
    sum( cnt_prev_callers_limp              ) AS total_cnt_prev_callers_limp              ,
    sum( cnt_prev_callers_raise             ) AS total_cnt_prev_callers_raise             ,
    sum( cnt_r_3bet                         ) AS total_cnt_r_3bet                         ,
    sum( cnt_r_3bet_def_action_call         ) AS total_cnt_r_3bet_def_action_call         ,
    sum( cnt_r_3bet_def_action_fold         ) AS total_cnt_r_3bet_def_action_fold         ,
    sum( cnt_r_3bet_def_action_raise        ) AS total_cnt_r_3bet_def_action_raise        ,
    sum( cnt_r_3bet_def_opp                 ) AS total_cnt_r_3bet_def_opp                 ,
    sum( cnt_r_3bet_opp                     ) AS total_cnt_r_3bet_opp                     ,
    sum( cnt_r_4bet                         ) AS total_cnt_r_4bet                         ,
    sum( cnt_r_4bet_def_action_call         ) AS total_cnt_r_4bet_def_action_call         ,
    sum( cnt_r_4bet_def_action_fold         ) AS total_cnt_r_4bet_def_action_fold         ,
    sum( cnt_r_4bet_def_action_raise        ) AS total_cnt_r_4bet_def_action_raise        ,
    sum( cnt_r_4bet_def_opp                 ) AS total_cnt_r_4bet_def_opp                 ,
    sum( cnt_r_4bet_opp                     ) AS total_cnt_r_4bet_opp                     ,
    sum( cnt_r_bet                          ) AS total_cnt_r_bet                          ,
    sum( cnt_r_bet_def_action_call          ) AS total_cnt_r_bet_def_action_call          ,
    sum( cnt_r_bet_def_action_fold          ) AS total_cnt_r_bet_def_action_fold          ,
    sum( cnt_r_bet_def_action_raise         ) AS total_cnt_r_bet_def_action_raise         ,
    sum( cnt_r_bet_def_opp                  ) AS total_cnt_r_bet_def_opp                  ,
    sum( cnt_r_bet_raise_hands              ) AS total_cnt_r_bet_raise_hands              ,
    sum( cnt_r_call                         ) AS total_cnt_r_call                         ,
    sum( cnt_r_call_hands                   ) AS total_cnt_r_call_hands                   ,
    sum( cnt_r_cbet                         ) AS total_cnt_r_cbet                         ,
    sum( cnt_r_cbet_def_action_call         ) AS total_cnt_r_cbet_def_action_call         ,
    sum( cnt_r_cbet_def_action_fold         ) AS total_cnt_r_cbet_def_action_fold         ,
    sum( cnt_r_cbet_def_action_raise        ) AS total_cnt_r_cbet_def_action_raise        ,
    sum( cnt_r_cbet_def_opp                 ) AS total_cnt_r_cbet_def_opp                 ,
    sum( cnt_r_cbet_opp                     ) AS total_cnt_r_cbet_opp                     ,
    sum( cnt_r_check                        ) AS total_cnt_r_check                        ,
    sum( cnt_r_check_raise                  ) AS total_cnt_r_check_raise                  ,
    sum( cnt_r_check_raise_opp              ) AS total_cnt_r_check_raise_opp              ,
    sum( cnt_r_donk                         ) AS total_cnt_r_donk                         ,
    sum( cnt_r_donk_def_action_call         ) AS total_cnt_r_donk_def_action_call         ,
    sum( cnt_r_donk_def_action_fold         ) AS total_cnt_r_donk_def_action_fold         ,
    sum( cnt_r_donk_def_action_raise        ) AS total_cnt_r_donk_def_action_raise        ,
    sum( cnt_r_donk_def_opp                 ) AS total_cnt_r_donk_def_opp                 ,
    sum( cnt_r_donk_opp                     ) AS total_cnt_r_donk_opp                     ,
    sum( cnt_r_float                        ) AS total_cnt_r_float                        ,
    sum( cnt_r_float_def_action_call        ) AS total_cnt_r_float_def_action_call        ,
    sum( cnt_r_float_def_action_fold        ) AS total_cnt_r_float_def_action_fold        ,
    sum( cnt_r_float_def_action_raise       ) AS total_cnt_r_float_def_action_raise       ,
    sum( cnt_r_float_def_opp                ) AS total_cnt_r_float_def_opp                ,
    sum( cnt_r_float_opp                    ) AS total_cnt_r_float_opp                    ,
    sum( cnt_r_fold                         ) AS total_cnt_r_fold                         ,
    sum( cnt_r_raise                        ) AS total_cnt_r_raise                        ,
    sum( cnt_r_raise_def_action_call        ) AS total_cnt_r_raise_def_action_call        ,
    sum( cnt_r_raise_def_action_fold        ) AS total_cnt_r_raise_def_action_fold        ,
    sum( cnt_r_raise_def_opp                ) AS total_cnt_r_raise_def_opp                ,
    sum( cnt_r_raise_wtsd                   ) AS total_cnt_r_raise_wtsd                   ,
    sum( cnt_r_raise_wtsd_won               ) AS total_cnt_r_raise_wtsd_won               ,
    sum( cnt_r_saw                          ) AS total_cnt_r_saw                          ,
    sum( cnt_r_total_actions                ) AS total_cnt_r_total_actions                ,
    sum( cnt_sb                             ) AS total_cnt_sb                             ,
    sum( cnt_sb_steal_fold                  ) AS total_cnt_sb_steal_fold                  ,
    sum( cnt_sb_steal_raise                 ) AS total_cnt_sb_steal_raise                 ,
    sum( cnt_sessions                       ) AS total_cnt_sessions                       ,
    sum( cnt_sessions_won                   ) AS total_cnt_sessions_won                   ,
    sum( cnt_steal_att                      ) AS total_cnt_steal_att                      ,
    sum( cnt_steal_att_fold                 ) AS total_cnt_steal_att_fold                 ,
    sum( cnt_steal_att_no_sd                ) AS total_cnt_steal_att_no_sd                ,
    sum( cnt_steal_att_wtsd                 ) AS total_cnt_steal_att_wtsd                 ,
    sum( cnt_steal_def_opp_bb               ) AS total_cnt_steal_def_opp_bb               ,
    sum( cnt_steal_def_opp_bb_nosd          ) AS total_cnt_steal_def_opp_bb_nosd          ,
    sum( cnt_steal_def_opp_bb_win_sd        ) AS total_cnt_steal_def_opp_bb_win_sd        ,
    sum( cnt_steal_def_opp_bb_win_wo_sd     ) AS total_cnt_steal_def_opp_bb_win_wo_sd     ,
    sum( cnt_steal_def_opp_bb_wtsd          ) AS total_cnt_steal_def_opp_bb_wtsd          ,
    sum( cnt_steal_def_opp_sb               ) AS total_cnt_steal_def_opp_sb               ,
    sum( cnt_steal_def_opp_sb_nosd          ) AS total_cnt_steal_def_opp_sb_nosd          ,
    sum( cnt_steal_def_opp_sb_win_sd        ) AS total_cnt_steal_def_opp_sb_win_sd        ,
    sum( cnt_steal_def_opp_sb_win_wo_sd     ) AS total_cnt_steal_def_opp_sb_win_wo_sd     ,
    sum( cnt_steal_def_opp_sb_wtsd          ) AS total_cnt_steal_def_opp_sb_wtsd          ,
    sum( cnt_steal_opp                      ) AS total_cnt_steal_opp                      ,
    sum( cnt_steal_reraise_def_action_fold  ) AS total_cnt_steal_reraise_def_action_fold  ,
    sum( cnt_steal_reraise_def_opp          ) AS total_cnt_steal_reraise_def_opp          ,
    sum( cnt_steal_success                  ) AS total_cnt_steal_success                  ,
    sum( cnt_steal_win_sd                   ) AS total_cnt_steal_win_sd                   ,
    sum( cnt_steal_win_wo_sd                ) AS total_cnt_steal_win_wo_sd                ,
    sum( cnt_t_3bet                         ) AS total_cnt_t_3bet                         ,
    sum( cnt_t_3bet_def_action_call         ) AS total_cnt_t_3bet_def_action_call         ,
    sum( cnt_t_3bet_def_action_fold         ) AS total_cnt_t_3bet_def_action_fold         ,
    sum( cnt_t_3bet_def_action_raise        ) AS total_cnt_t_3bet_def_action_raise        ,
    sum( cnt_t_3bet_def_opp                 ) AS total_cnt_t_3bet_def_opp                 ,
    sum( cnt_t_3bet_opp                     ) AS total_cnt_t_3bet_opp                     ,
    sum( cnt_t_4bet                         ) AS total_cnt_t_4bet                         ,
    sum( cnt_t_4bet_def_action_call         ) AS total_cnt_t_4bet_def_action_call         ,
    sum( cnt_t_4bet_def_action_fold         ) AS total_cnt_t_4bet_def_action_fold         ,
    sum( cnt_t_4bet_def_action_raise        ) AS total_cnt_t_4bet_def_action_raise        ,
    sum( cnt_t_4bet_def_opp                 ) AS total_cnt_t_4bet_def_opp                 ,
    sum( cnt_t_4bet_opp                     ) AS total_cnt_t_4bet_opp                     ,
    sum( cnt_t_bet                          ) AS total_cnt_t_bet                          ,
    sum( cnt_t_bet_def_action_call          ) AS total_cnt_t_bet_def_action_call          ,
    sum( cnt_t_bet_def_action_fold          ) AS total_cnt_t_bet_def_action_fold          ,
    sum( cnt_t_bet_def_action_raise         ) AS total_cnt_t_bet_def_action_raise         ,
    sum( cnt_t_bet_def_opp                  ) AS total_cnt_t_bet_def_opp                  ,
    sum( cnt_t_bet_raise_hands              ) AS total_cnt_t_bet_raise_hands              ,
    sum( cnt_t_call                         ) AS total_cnt_t_call                         ,
    sum( cnt_t_call_hands                   ) AS total_cnt_t_call_hands                   ,
    sum( cnt_t_cbet                         ) AS total_cnt_t_cbet                         ,
    sum( cnt_t_cbet_def_action_call         ) AS total_cnt_t_cbet_def_action_call         ,
    sum( cnt_t_cbet_def_action_fold         ) AS total_cnt_t_cbet_def_action_fold         ,
    sum( cnt_t_cbet_def_action_raise        ) AS total_cnt_t_cbet_def_action_raise        ,
    sum( cnt_t_cbet_def_opp                 ) AS total_cnt_t_cbet_def_opp                 ,
    sum( cnt_t_cbet_opp                     ) AS total_cnt_t_cbet_opp                     ,
    sum( cnt_t_check                        ) AS total_cnt_t_check                        ,
    sum( cnt_t_check_raise                  ) AS total_cnt_t_check_raise                  ,
    sum( cnt_t_check_raise_opp              ) AS total_cnt_t_check_raise_opp              ,
    sum( cnt_t_donk                         ) AS total_cnt_t_donk                         ,
    sum( cnt_t_donk_def_action_call         ) AS total_cnt_t_donk_def_action_call         ,
    sum( cnt_t_donk_def_action_fold         ) AS total_cnt_t_donk_def_action_fold         ,
    sum( cnt_t_donk_def_action_raise        ) AS total_cnt_t_donk_def_action_raise        ,
    sum( cnt_t_donk_def_opp                 ) AS total_cnt_t_donk_def_opp                 ,
    sum( cnt_t_donk_opp                     ) AS total_cnt_t_donk_opp                     ,
    sum( cnt_t_float                        ) AS total_cnt_t_float                        ,
    sum( cnt_t_float_def_action_call        ) AS total_cnt_t_float_def_action_call        ,
    sum( cnt_t_float_def_action_fold        ) AS total_cnt_t_float_def_action_fold        ,
    sum( cnt_t_float_def_action_raise       ) AS total_cnt_t_float_def_action_raise       ,
    sum( cnt_t_float_def_opp                ) AS total_cnt_t_float_def_opp                ,
    sum( cnt_t_float_opp                    ) AS total_cnt_t_float_opp                    ,
    sum( cnt_t_fold                         ) AS total_cnt_t_fold                         ,
    sum( cnt_t_raise                        ) AS total_cnt_t_raise                        ,
    sum( cnt_t_raise_def_action_call        ) AS total_cnt_t_raise_def_action_call        ,
    sum( cnt_t_raise_def_action_fold        ) AS total_cnt_t_raise_def_action_fold        ,
    sum( cnt_t_raise_def_opp                ) AS total_cnt_t_raise_def_opp                ,
    sum( cnt_t_raise_wtsd                   ) AS total_cnt_t_raise_wtsd                   ,
    sum( cnt_t_raise_wtsd_won               ) AS total_cnt_t_raise_wtsd_won               ,
    sum( cnt_t_saw                          ) AS total_cnt_t_saw                          ,
    sum( cnt_t_total_actions                ) AS total_cnt_t_total_actions                ,
    sum( cnt_total_actions                  ) AS total_cnt_total_actions                  ,
    sum( cnt_vpip                           ) AS total_cnt_vpip                           ,
    sum( cnt_vpip_noblind                   ) AS total_cnt_vpip_noblind                   ,
    sum( cnt_vpip_sb                        ) AS total_cnt_vpip_sb                        ,
    sum( cnt_won_hand                       ) AS total_cnt_won_hand                       ,
    sum( cnt_won_showdown                   ) AS total_cnt_won_showdown                   ,
    sum( cnt_wtsd                           ) AS total_cnt_wtsd                           ,
    sum( cnt_wtsd_when_f_bet_raise          ) AS total_cnt_wtsd_when_f_bet_raise          ,
    sum( cnt_wtsd_when_f_call               ) AS total_cnt_wtsd_when_f_call               ,
    sum( cnt_wtsd_when_p_bet_raise          ) AS total_cnt_wtsd_when_p_bet_raise          ,
    sum( cnt_wtsd_when_p_call               ) AS total_cnt_wtsd_when_p_call               ,
    sum( cnt_wtsd_when_r_bet_raise          ) AS total_cnt_wtsd_when_r_bet_raise          ,
    sum( cnt_wtsd_when_r_call               ) AS total_cnt_wtsd_when_r_call               ,
    sum( cnt_wtsd_when_t_bet_raise          ) AS total_cnt_wtsd_when_t_bet_raise          ,
    sum( cnt_wtsd_when_t_call               ) AS total_cnt_wtsd_when_t_call               ,
    sum( cnt_wtsd_won                       ) AS total_cnt_wtsd_won                       ,
    sum( cnt_wtsd_won_when_f_bet_raise      ) AS total_cnt_wtsd_won_when_f_bet_raise      ,
    sum( cnt_wtsd_won_when_f_call           ) AS total_cnt_wtsd_won_when_f_call           ,
    sum( cnt_wtsd_won_when_p_bet_raise      ) AS total_cnt_wtsd_won_when_p_bet_raise      ,
    sum( cnt_wtsd_won_when_p_call           ) AS total_cnt_wtsd_won_when_p_call           ,
    sum( cnt_wtsd_won_when_r_bet_raise      ) AS total_cnt_wtsd_won_when_r_bet_raise      ,
    sum( cnt_wtsd_won_when_r_call           ) AS total_cnt_wtsd_won_when_r_call           ,
    sum( cnt_wtsd_won_when_t_bet_raise      ) AS total_cnt_wtsd_won_when_t_bet_raise      ,
    sum( cnt_wtsd_won_when_t_call           ) AS total_cnt_wtsd_won_when_t_call           ,
    sum( cnt_wwosd_f_bet_raise              ) AS total_cnt_wwosd_f_bet_raise              ,
    sum( cnt_wwosd_f_call                   ) AS total_cnt_wwosd_f_call                   ,
    sum( cnt_wwosd_p_bet_raise              ) AS total_cnt_wwosd_p_bet_raise              ,
    sum( cnt_wwosd_p_call                   ) AS total_cnt_wwosd_p_call                   ,
    sum( cnt_wwosd_r_bet_raise              ) AS total_cnt_wwosd_r_bet_raise              ,
    sum( cnt_wwosd_r_call                   ) AS total_cnt_wwosd_r_call                   ,
    sum( cnt_wwosd_t_bet_raise              ) AS total_cnt_wwosd_t_bet_raise              ,
    sum( cnt_wwosd_t_call                   ) AS total_cnt_wwosd_t_call                   ,
    sum( amt_sd_bb                        ) AS total_amt_sd_bb   
                   
    FROM holdem_cache
    GROUP BY id_player
    ORDER BY id_player;