Poker-AI.org

SELECT   
   DISTINCT(cash_hand_summary.id_hand) as handId
FROM    cash_hand_player_statistics
JOIN    cash_hand_summary ON cash_hand_summary.id_hand = cash_hand_player_statistics.id_hand
JOIN    player ON cash_hand_player_statistics.id_player = player.id_player
JOIN    lookup_positions ON cash_hand_player_statistics.position = lookup_positions.position AND cash_hand_player_statistics.cnt_players = lookup_positions.cnt_players
JOIN    cash_limit ON cash_hand_summary.id_limit = cash_limit.id_limit
JOIN   lookup_actions as actions_p ON actions_p.id_action = cash_hand_player_statistics.id_action_p
JOIN   lookup_actions as actions_f ON actions_f.id_action = cash_hand_player_statistics.id_action_f
JOIN   lookup_actions as actions_t ON actions_t.id_action = cash_hand_player_statistics.id_action_t
JOIN   lookup_actions as actions_r ON actions_r.id_action = cash_hand_player_statistics.id_action_r
WHERE   
   TRUE
 %FILTER%

SELECT count(*)::float /
   ((SELECT count(*)
    FROM cash_hand_player_statistics denominator
    WHERE denominator.id_player = 49)::float - (SELECT SUM(cc.cnt_walks)
    FROM cash_cache cc WHERE cc.id_player = 49)::float)
   as vpip
FROM cash_hand_player_statistics numerator
WHERE numerator.id_player = 49
and flg_vpip is true


PFR
SELECT count(*)::float /
((SELECT count(*)
    FROM cash_hand_player_statistics denominator
    WHERE denominator.id_player = 49)::float - (SELECT SUM(cc.cnt_walks)
    FROM cash_cache cc WHERE cc.id_player = 49)::float)
   as pfr
FROM cash_hand_player_statistics numerator
WHERE numerator.id_player = 49
and cnt_p_raise =1