PokerTracker

tourney_hand_player_combinations.flg_f_2pair
AND tourney_hand_player_combinations.id_f_hand_strength = 3

hola necesito ayuda para separar los doble par en flop formados con una hole card y una carta de la mesa "inferior" a la carta doblada con los
doble par en flop formados con una hole card y una carta de la mesa "superior" a la carta doblada
ej :
necesito separar = A4 en TT4 ,86 en KK8 ,97 en TT7
de =K5 K55 ,84 en 833,93 en 955
Gracias

That would require separate tests for the value of the possible board pairs (1st & 2nd card or 1st & 3rd card or 2nd & 3rd card) to the unpaired card:

Board Pair Higher

Code: Select all

((tourney_hand_player_combinations.flg_f_2pair  AND tourney_hand_player_combinations.id_f_hand_strength = 3)) AND ((((((tourney_hand_summary.card_1 > 0 and ((tourney_hand_summary.card_1  % 13 = tourney_hand_summary.card_2 % 13 AND (tourney_hand_summary.card_1 + 12) % 13 > (tourney_hand_summary.card_3 + 12) % 13) OR  (tourney_hand_summary.card_1  % 13 = tourney_hand_summary.card_3 % 13 AND (tourney_hand_summary.card_1 + 12) % 13 > (tourney_hand_summary.card_2 + 12) % 13) OR (tourney_hand_summary.card_2  % 13 = tourney_hand_summary.card_3 % 13 AND (tourney_hand_summary.card_1 + 12) % 13 < (tourney_hand_summary.card_2 + 12) % 13))))))))

Board Pair Lower

Code: Select all

((tourney_hand_player_combinations.flg_f_2pair  AND tourney_hand_player_combinations.id_f_hand_strength = 3)) AND ((((((tourney_hand_summary.card_1 > 0 and ((tourney_hand_summary.card_1  % 13 = tourney_hand_summary.card_2 % 13 AND (tourney_hand_summary.card_1 + 12) % 13 < (tourney_hand_summary.card_3 + 12) % 13) OR  (tourney_hand_summary.card_1  % 13 = tourney_hand_summary.card_3 % 13 AND (tourney_hand_summary.card_1 + 12) % 13 < (tourney_hand_summary.card_2 + 12) % 13) OR (tourney_hand_summary.card_2  % 13 = tourney_hand_summary.card_3 % 13 AND (tourney_hand_summary.card_1 + 12) % 13 > (tourney_hand_summary.card_2 + 12) % 13))))))))