hand strength value

[corvet]

Hi ! Is it correct ?
As i see this info its look like 1 or 2 but not 3, how its work on flop ? And How to filter when pair with my hole card over Board pair ?

Thank you

"Within Two Pair:

1 - Board Paired, low pair (34 on a KK378 board)
2 - Board Paired, middle pair (QJ on a AT8JT board)
3 - Board Paired, top pair (KQ on a JTTQ8 board)"

_260530145645.png

(39.07 KiB) Downloaded 347 times

[Flag_Hippo]

As i see this info its look like 1 or 2 but not 3, how its work on flop ?

If the flop is paired then you can only have the top pair. If the turn is paired you can only have top or bottom. Middle pairs are only possible on the river.

And How to filter when pair with my hole card over Board pair ?

Try this:

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 - 1) % 13 = (tourney_hand_summary.card_2 - 1) % 13) AND (tourney_hand_player_statistics.holecard_1 - 1) % 13 = (tourney_hand_summary.card_3 - 1) % 13 AND (tourney_hand_player_statistics.holecard_1 - 1) % 13 > (tourney_hand_summary.card_1 - 1) % 13) OR
    (((tourney_hand_summary.card_1 - 1) % 13 = (tourney_hand_summary.card_2 - 1) % 13) AND (tourney_hand_player_statistics.holecard_2 - 1) % 13 = (tourney_hand_summary.card_3 - 1) % 13 AND (tourney_hand_player_statistics.holecard_2 - 1) % 13 > (tourney_hand_summary.card_1 - 1) % 13) OR
    (((tourney_hand_summary.card_1 - 1) % 13 = (tourney_hand_summary.card_3 - 1) % 13) AND (tourney_hand_player_statistics.holecard_1 - 1) % 13 = (tourney_hand_summary.card_2 - 1) % 13 AND (tourney_hand_player_statistics.holecard_1 - 1) % 13 > (tourney_hand_summary.card_1 - 1) % 13) OR
    (((tourney_hand_summary.card_1 - 1) % 13 = (tourney_hand_summary.card_3 - 1) % 13) AND (tourney_hand_player_statistics.holecard_2 - 1) % 13 = (tourney_hand_summary.card_2 - 1) % 13 AND (tourney_hand_player_statistics.holecard_2 - 1) % 13 > (tourney_hand_summary.card_1 - 1) % 13) OR
    (((tourney_hand_summary.card_2 - 1) % 13 = (tourney_hand_summary.card_3 - 1) % 13) AND (tourney_hand_player_statistics.holecard_1 - 1) % 13 = (tourney_hand_summary.card_1 - 1) % 13 AND (tourney_hand_player_statistics.holecard_1 - 1) % 13 > (tourney_hand_summary.card_2 - 1) % 13) OR
    (((tourney_hand_summary.card_2 - 1) % 13 = (tourney_hand_summary.card_3 - 1) % 13) AND (tourney_hand_player_statistics.holecard_2 - 1) % 13 = (tourney_hand_summary.card_1 - 1) % 13 AND (tourney_hand_player_statistics.holecard_2 - 1) % 13 > (tourney_hand_summary.card_2 - 1) % 13)
)

[corvet]

Thank you