Originally Posted by
Cygnus
I'm having trouble determining the difference between the columns
preflopplayeractiontype_id
firstpreflopactiontype_id
preflopplayeractiontype_id seems to be the direct sequence of what a player did preflop, similar to flopplayeractiontype_id.
But I can't figure out the second one. Help?
My task is to identify hands where there was 1 preflop raiser (doesn't have to be hero), and exactly 1 caller, and the preflop raiser bet on the flop. Here's my query so far.
select f.*
from playerhandsflop f join playerhandscashkeycolumns k on f.playerhand_id = k.playerhand_id
join pokerhands h on h.pokerhand_id = k.pokerhand_id where
flopcbetmade = 1 and
numberofplayerssawflop = 2 and
numberofplayerssawturn = 0 and
flopplayeractiontype_id = 44
(actiontype_id of 44 = B)
My problem is flopcbetmade. It's including hands where there was a raising war preflop and the player_id in question was the last to put in a raise.
So now I'm trying to see if I can incorporate preflopplayeractiontype_id and/or firstpreflopactiontype_id to narrow my hands down to just 1 raiser and 1 caller preflop.
Cygnus