Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.
Moderator: Moderators
by funct0r » Tue Jul 01, 2008 10:00 pm
Here is what I have so far:
SELECT (SUM(CASE flg_p_limp WHEN TRUE THEN 1 ELSE 0 END)/CAST(COUNT(id_hand) AS float8)) AS limp
FROM tourney_holdem_hand_player_statistics
LEFT JOIN tourney_holdem_hand_summary summary USING (id_hand)
WHERE summary.cnt_players=2 AND flg_blind_b=FALSE;
Notice any problems?
-
funct0r
-
- Posts: 4
- Joined: Tue Jul 01, 2008 9:57 pm
by funct0r » Wed Jul 02, 2008 1:42 am
Based on the results I'm getting, Im guessing that flg_blind_p is never true for heads up play (or for the small blind rather) and instead, cnt_p_call is set? Can anyone verify this?
Thanks
-
funct0r
-
- Posts: 4
- Joined: Tue Jul 01, 2008 9:57 pm
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 3 guests