PokerTracker

tourney_hand_player_combinations.flg_f_1pair
and tourney_hand_player_combinations.id_f_hand_strength = 1

hola necesito ayuda,hay alguna manera de separar los pockets menores al board con los boards doblados? ya que la opcion "0" incluye ambos

Sorry that doesn't translate very well. Can you please explain in some more detail and give a specific example. Thank you.

La expresión que subí contempla tanto pocketpar inferiores al board ej (33 en 47K)como también boards doblados ej (34 en 88Q)..
La pregunta es si hay alguna manera de separar escribir un expresión para usar en un expresión filter y poder filtrar por separado los pocket pars mencionados de los boards doblados

tourney_hand_player_combinations.flg_f_1pair
y tourney_hand_player_combinations.id_f_hand_strength = 0

Perdon cometí un error en la expresión, la correcta sería esta. Gracias

0 - Board Paired or low pocket pair (under the 3rd board card)
Necesito una expresión para board paired y otra para pocket pair (under the 3rd board card)
Es posible separarlas?

You can add a test for whether the player is actually holding a pocket pair or not:

Code: Select all

tourney_hand_player_statistics.id_holecard in (1,26,49,70,89,106,121,134,145,154,161,166,169)

Code: Select all

NOT tourney_hand_player_statistics.id_holecard in (1,26,49,70,89,106,121,134,145,154,161,166,169)

or you can test the flop so it is paired or not:

Code: Select all

((tourney_hand_summary.card_1  % 13 = tourney_hand_summary.card_2 % 13) OR (tourney_hand_summary.card_1  % 13 = tourney_hand_summary.card_3 % 13) OR (tourney_hand_summary.card_2  % 13 = tourney_hand_summary.card_3 % 13))

Code: Select all

NOT ((tourney_hand_summary.card_1  % 13 = tourney_hand_summary.card_2 % 13) OR (tourney_hand_summary.card_1  % 13 = tourney_hand_summary.card_3 % 13) OR (tourney_hand_summary.card_2  % 13 = tourney_hand_summary.card_3 % 13))