Query for preflop limp % for different player counts

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

Query for preflop limp % for different player counts

Postby 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

Re: Query for preflop limp % for different player counts

Postby 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]

Who is online

Users browsing this forum: No registered users and 3 guests