Hey Chuck,
I need to do the same thing except I want the hold cards from when a player faced with a raise of more than 75% of his stack either called or went all in.
I dont know squadoosh about SQL but this is what I came up with:
##if facing a pre-flop raise
if
tourny_holdem_hand_player_statistics.flg_p_face_raise=true
and
##raise facing is >75*stack at start of hand
tourny_holdem_hand_player_detail.amt_p_raise_faicing >= (75/100)*tourny_holdem_hand_player_detail.amtbefore
and if
##did he:
## call
tourny_holdem_hand_player_statistics.flg_p_ccall = true
or
##reraise
tourny_holdem_hand_player_statistics. Flg_p_3bet=true
or
tourny_holdem_hand_player_statistics. Flg_p_4bet=true
then
output
##player hole cards
tourny_holdem_hand_player_statistics.id_holecards
##player stack
tourny_holdem_hand_player_detail.amt_before
##size of bet
tourny_holdem_hand_player_detail.amt_p_raise_faicing
##player position
tourny_holdem_hand_player_statistics.position
##number of active players behind him
lookup_positions.cnt_players (number of players delt into the hand) - tourny_holdem_hand_player_statistics.position
Can you please help me make this work