Page 1 of 1

Query for preflop limp % for different player counts

PostPosted: Tue Jul 01, 2008 10:00 pm
by funct0r
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?

Re: Query for preflop limp % for different player counts

PostPosted: Wed Jul 02, 2008 1:42 am
by funct0r
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