Stats vs sizes

[majonyjony]

Hi, I want to create statistics for 3-handed.
BTN OR NAI
SB 3b NAI
BB CALL

I need to be able to define the BTN and SB bet sizes. How can I do this?
I'm trying something like this, but the BT size doesn't seem to work.

Code: Select all

tourney_hand_player_statistics.position=8 AND tourney_hand_summary.str_aggressors_p LIKE '809%' AND tourney_hand_player_statistics.flg_p_4bet_opp AND  (tourney_hand_player_statistics.amt_p_3bet_facing >= tourney_blinds.amt_bb * (MINsize-1) ) AND (tourney_hand_player_statistics.amt_p_3bet_facing <= tourney_blinds.amt_bb * (MAXsize-1)) AND lookup_actions_p.action LIKE 'C%' AND  tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps where thps.position = 9 AND thps.amt_p_2bet_facing>= thps.amt_blind * MINsizebtn AND thps.amt_p_2bet_facing<= thps.amt_blind * MAXsizebtn )


I've also tried this part at the end, for the BTN size, but it still doesn't work.

Code: Select all


TY in advance
 AND  tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps where thps.position = 0 AND thps.amt_p_raise_made >= MINsizebtn * thps.amt_blind AND thps.amt_p_raise_made <= MAXsizebtn * thps.amt_blind)

[Flag_Hippo]

tourney_hand_player_statistics.amt_blind is specific to each player and it's the amount the player posted so you can't reference that if you want to use the size of the big blind in a query for a player who is not the big blind. The size of the big blind in a hand is:

Code: Select all

tourney_blinds.amt_bb

so you would need to reference that in your subquery.