PokerTracker

How can a player with unknown holecards have a flush on the flop?

This query gives me several hits..,

Code: Select all

SELECT
COUNT(*)
FROM holdem_hand_player_statistics hhps, holdem_hand_player_combinations hhpc
WHERE hhps.id_hand = hhpc.id_hand AND flg_f_flush AND id_holecard = 0


Edit: It didn't take me too long to find out that I needed to add WHERE hhps.id_player = hhpc.id_player...