Preflop Hand Ranges Stats - Doublecheck

[bloodndef]

I've completed these hand range stats so far. I am almost halfway done and will upload the complete package to the repository all at once. This should be very soon. The purpose of these stats is to form a HUD popup that will show the actual hand ranges that are known after a player performs a certain action. (Also, the exported stats will have the textual hand range displays color-coded according to sample size.) For example: If a player once limped with previous callers with AA and this hand was shown or shown down, after the text "LWPC:" in the HUD popup, a red "AA-KK" would appear, telling the hero that this player has the capability of deep-limping AA-KK.

A quick rundown on positional abbreviations:

4EP = the 4 earliest positions, 4-7
HJPL = hijack and plank, 2-3
BUCO = button and cutoff, 0-1

A quick rundown on hand range abbreviations:

PremiPr = Premium Pairs = AA-KK
SolidPr = Solid Pairs = QQ-88
SmallPr = Small Pairs = 77-22
PremiUn = Premium Unpaired hands = AK-ATs, KQ
SolidUn = Solid Unpaired hands = ATo-A2, KJ-K8s, QJ-Q8s, JT-J9
SuitCon = Suited Connectors = T9s-43s, T8s-53s, J8s-63s, J7s
Light = All other hands

42 of 105 Hand Range Stats

LFI-4EP:PremiPr
LFI-4EP:SolidPr
LFI-4EP:SmallPr
LFI-4EP:PremiUn
LFI-4EP:SolidUn
LFI-4EP:SuitCon
LFI-4EP:Light

Example Stat:

LFI-4EP:PremiPr

if (cnt_p_lfi_4ep_premipr > 0, 'AA-KK','')

cnt_p_lfi_4ep_premipr

sum(if[(holdem_hand_player_statistics.position = 4 OR holdem_hand_player_statistics.position = 5 OR holdem_hand_player_statistics.position = 6 OR holdem_hand_player_statistics.position = 7) AND holdem_hand_player_statistics.flg_p_limp AND holdem_hand_player_statistics.flg_p_open_opp AND (holdem_hand_player_statistics.id_holecard=1 OR holdem_hand_player_statistics.id_holecard=26), 1, 0])

LFI-HJPL:PremiPr
LFI-HJPL:SolidPr
LFI-HJPL:SmallPr
LFI-HJPL:PremiUn
LFI-HJPL:SolidUn
LFI-HJPL:SuitCon
LFI-HJPL:Light

LFI-BUCO:PremiPr
LFI-BUCO:SolidPr
LFI-BUCO:SmallPr
LFI-BUCO:PremiUn
LFI-BUCO:SolidUn
LFI-BUCO:SuitCon
LFI-BUCO:Light

LFI-SB:PremiPr
LFI-SB:SolidPr
LFI-SB:SmallPr
LFI-SB:PremiUn
LFI-SB:SolidUn
LFI-SB:SuitCon
LFI-SB:Light

Example Stat:

LFI-SB:PremiUn

if (cnt_p_lfi_sb_premiun > 0, 'AK-ATs, KQ','')

cnt_p_lfi_sb_premiun

sum(if[holdem_hand_player_statistics.position = 9 AND holdem_hand_player_statistics.flg_p_limp AND holdem_hand_player_statistics.flg_p_open_opp AND (holdem_hand_player_statistics.id_holecard=2 OR holdem_hand_player_statistics.id_holecard=3 OR holdem_hand_player_statistics.id_holecard=4 OR holdem_hand_player_statistics.id_holecard=5 OR holdem_hand_player_statistics.id_holecard=6 OR holdem_hand_player_statistics.id_holecard=7 OR holdem_hand_player_statistics.id_holecard=8 OR holdem_hand_player_statistics.id_holecard=27 OR holdem_hand_player_statistics.id_holecard=28), 1, 0])

LWPC:PremiPr
LWPC:SolidPr
LWPC:SmallPr
LWPC:PremiUn
LWPC:SolidUn
LWPC:SuitCon
LWPC:Light

Example Stat:

LWPC:SolidUn

if (cnt_p_lwpc_solidun > 0, 'ATo-A2, KJ-K8s, QJ-Q8s, JT-J9','')

cnt_p_lwpc_solidun

sum(if[holdem_hand_player_statistics.flg_p_open = false AND holdem_hand_player_statistics.flg_p_limp AND (holdem_hand_player_statistics.id_holecard=9 OR holdem_hand_player_statistics.id_holecard=10 OR holdem_hand_player_statistics.id_holecard=11 OR holdem_hand_player_statistics.id_holecard=12 OR holdem_hand_player_statistics.id_holecard=13 OR holdem_hand_player_statistics.id_holecard=14 OR holdem_hand_player_statistics.id_holecard=15 OR holdem_hand_player_statistics.id_holecard=16 OR holdem_hand_player_statistics.id_holecard=17 OR holdem_hand_player_statistics.id_holecard=18 OR holdem_hand_player_statistics.id_holecard=19 OR holdem_hand_player_statistics.id_holecard=20 OR holdem_hand_player_statistics.id_holecard=21 OR holdem_hand_player_statistics.id_holecard=22 OR holdem_hand_player_statistics.id_holecard=23 OR holdem_hand_player_statistics.id_holecard=24 OR holdem_hand_player_statistics.id_holecard=25 OR holdem_hand_player_statistics.id_holecard=29 OR holdem_hand_player_statistics.id_holecard=30 OR holdem_hand_player_statistics.id_holecard=31 OR holdem_hand_player_statistics.id_holecard=32 OR holdem_hand_player_statistics.id_holecard=33 OR holdem_hand_player_statistics.id_holecard=34 OR holdem_hand_player_statistics.id_holecard=35 OR holdem_hand_player_statistics.id_holecard=50 OR holdem_hand_player_statistics.id_holecard=51 OR holdem_hand_player_statistics.id_holecard=52 OR holdem_hand_player_statistics.id_holecard=53 OR holdem_hand_player_statistics.id_holecard=54 OR holdem_hand_player_statistics.id_holecard=55 OR holdem_hand_player_statistics.id_holecard=56 OR holdem_hand_player_statistics.id_holecard=71 OR holdem_hand_player_statistics.id_holecard=72 OR holdem_hand_player_statistics.id_holecard=73 OR holdem_hand_player_statistics.id_holecard=74), 1, 0])

CCPF:PremiPr
CCPF:SolidPr
CCPF:SmallPr
CCPF:PremiUn
CCPF:SolidUn
CCPF:SuitCon
CCPF:Light

Example Stat:

CCPF:Light

if (cnt_p_ccpf_light > 0, 'Light','')

cnt_p_ccpf_light

sum(if[holdem_hand_player_statistics.flg_p_ccall AND holdem_hand_player_statistics.id_holecard>0 AND NOT (holdem_hand_player_statistics.id_holecard=1 OR holdem_hand_player_statistics.id_holecard=26 OR holdem_hand_player_statistics.id_holecard=2 OR holdem_hand_player_statistics.id_holecard=3 OR holdem_hand_player_statistics.id_holecard=4 OR holdem_hand_player_statistics.id_holecard=5 OR holdem_hand_player_statistics.id_holecard=6 OR holdem_hand_player_statistics.id_holecard=7 OR holdem_hand_player_statistics.id_holecard=8 OR holdem_hand_player_statistics.id_holecard=27 OR holdem_hand_player_statistics.id_holecard=28 OR holdem_hand_player_statistics.id_holecard=49 OR holdem_hand_player_statistics.id_holecard=70 OR holdem_hand_player_statistics.id_holecard=89 OR holdem_hand_player_statistics.id_holecard=9 OR holdem_hand_player_statistics.id_holecard=10 OR holdem_hand_player_statistics.id_holecard=11 OR holdem_hand_player_statistics.id_holecard=12 OR holdem_hand_player_statistics.id_holecard=13 OR holdem_hand_player_statistics.id_holecard=14 OR holdem_hand_player_statistics.id_holecard=15 OR holdem_hand_player_statistics.id_holecard=16 OR holdem_hand_player_statistics.id_holecard=17 OR holdem_hand_player_statistics.id_holecard=18 OR holdem_hand_player_statistics.id_holecard=19 OR holdem_hand_player_statistics.id_holecard=20 OR holdem_hand_player_statistics.id_holecard=21 OR holdem_hand_player_statistics.id_holecard=22 OR holdem_hand_player_statistics.id_holecard=23 OR holdem_hand_player_statistics.id_holecard=24 OR holdem_hand_player_statistics.id_holecard=25 OR holdem_hand_player_statistics.id_holecard=29 OR holdem_hand_player_statistics.id_holecard=30 OR holdem_hand_player_statistics.id_holecard=31 OR holdem_hand_player_statistics.id_holecard=32 OR holdem_hand_player_statistics.id_holecard=33 OR holdem_hand_player_statistics.id_holecard=34 OR holdem_hand_player_statistics.id_holecard=35 OR holdem_hand_player_statistics.id_holecard=50 OR holdem_hand_player_statistics.id_holecard=51 OR holdem_hand_player_statistics.id_holecard=52 OR holdem_hand_player_statistics.id_holecard=53 OR holdem_hand_player_statistics.id_holecard=54 OR holdem_hand_player_statistics.id_holecard=55 OR holdem_hand_player_statistics.id_holecard=56 OR holdem_hand_player_statistics.id_holecard=71 OR holdem_hand_player_statistics.id_holecard=72 OR holdem_hand_player_statistics.id_holecard=73 OR holdem_hand_player_statistics.id_holecard=74 OR holdem_hand_player_statistics.id_holecard=106 OR holdem_hand_player_statistics.id_holecard=121 OR holdem_hand_player_statistics.id_holecard=134 OR holdem_hand_player_statistics.id_holecard=145 OR holdem_hand_player_statistics.id_holecard=154 OR holdem_hand_player_statistics.id_holecard=161 OR holdem_hand_player_statistics.id_holecard=166 OR holdem_hand_player_statistics.id_holecard=169 OR holdem_hand_player_statistics.id_holecard=75 OR holdem_hand_player_statistics.id_holecard=77 OR holdem_hand_player_statistics.id_holecard=90 OR holdem_hand_player_statistics.id_holecard=92 OR holdem_hand_player_statistics.id_holecard=94 OR holdem_hand_player_statistics.id_holecard=107 OR holdem_hand_player_statistics.id_holecard=109 OR holdem_hand_player_statistics.id_holecard=111 OR holdem_hand_player_statistics.id_holecard=122 OR holdem_hand_player_statistics.id_holecard=124 OR holdem_hand_player_statistics.id_holecard=126 OR holdem_hand_player_statistics.id_holecard=135 OR holdem_hand_player_statistics.id_holecard=137 OR holdem_hand_player_statistics.id_holecard=139 OR holdem_hand_player_statistics.id_holecard=146 OR holdem_hand_player_statistics.id_holecard=148 OR holdem_hand_player_statistics.id_holecard=150 OR holdem_hand_player_statistics.id_holecard=155 OR holdem_hand_player_statistics.id_holecard=157 OR holdem_hand_player_statistics.id_holecard=162), 1, 0])


THANKS FOR ANY INPUT!

[kraada]

I'm very much looking forward to seeing how this looks on an actual table once the stats are finished.

Also, check your PMs.

[WhiteRider]

Since you have some ranges of holecards in your big if statements:

holdem_hand_player_statistics.id_holecard=1 OR holdem_hand_player_statistics.id_holecard=26 OR holdem_hand_player_statistics.id_holecard=2 OR holdem_hand_player_statistics.id_holecard=3 OR holdem_hand_player_statistics.id_holecard=4 OR holdem_hand_player_statistics.id_holecard=5

..you could use:
(holdem_hand_player_statistics.id_holecard>=1 AND holdem_hand_player_statistics.id_holecard<=25) OR (...)
..rather than typing all values explicitly.

[bloodndef]

I'd like users to be able to define different hand ranges if they'd like. That's why I've left all the hands explicitly stated. That being said, would it be possible to define a hand grouping and have a column reference that?

E.g.

cnt_p_lfi_4ep_premipr

sum(if[(holdem_hand_player_statistics.position = 4 OR holdem_hand_player_statistics.position = 5 OR holdem_hand_player_statistics.position = 6 OR holdem_hand_player_statistics.position = 7) AND holdem_hand_player_statistics.flg_p_limp AND holdem_hand_player_statistics.flg_p_open_opp AND cnt_premium_pair, 1, 0])

where

cnt_premium_pair

sum(if[(holdem_hand_player_statistics.id_holecard=1 OR holdem_hand_player_statistics.id_holecard=26), 1, 0])

Can columns reference other columns? If not, is there another way to do this?

Thanks!

[kraada]

No, unfortunately that sort of recursion won't work. (I've asked to get that sort of thing built in eventually but I don't know if/when it will happen.)

[bloodndef]

Added:

Put in the First Raise Preflop from the 4 Earliest Positions with X hand range (7 stats)
Put in the First Raise Preflop from the HiJack or PLank with X hand range (7 stats)
Raised First In from the BUtton or CutOff with X hand range (7 stats)
Raised With Previous Callers from the BUtton or CutOff with X hand range (7 stats)
Raised First In from the Small Blind with X hand range (7 stats)
3Bet Preflop with X hand range (7 stats)
4Bet Preflop with X hand range (7 stats)

Total: 91 out of 105 preflop hand range stats.

Example:

Put in the First Raise Preflop from the HiJack or PLank with Suited Connectors

R-HJPL:SuitCon

if (cnt_p_firstraise_hjpl_suitcon > 0, 'T9s-43s, T8s-53s, J8s-63s, J7s','')

cnt_p_firstraise_hjpl_suitcon

sum(if[(holdem_hand_player_statistics.position = 2 OR holdem_hand_player_statistics.position = 3) AND holdem_hand_player_statistics.flg_p_first_raise AND (holdem_hand_player_statistics.id_holecard=75 OR holdem_hand_player_statistics.id_holecard=77 OR holdem_hand_player_statistics.id_holecard=90 OR holdem_hand_player_statistics.id_holecard=92 OR holdem_hand_player_statistics.id_holecard=94 OR holdem_hand_player_statistics.id_holecard=107 OR holdem_hand_player_statistics.id_holecard=109 OR holdem_hand_player_statistics.id_holecard=111 OR holdem_hand_player_statistics.id_holecard=122 OR holdem_hand_player_statistics.id_holecard=124 OR holdem_hand_player_statistics.id_holecard=126 OR holdem_hand_player_statistics.id_holecard=135 OR holdem_hand_player_statistics.id_holecard=137 OR holdem_hand_player_statistics.id_holecard=139 OR holdem_hand_player_statistics.id_holecard=146 OR holdem_hand_player_statistics.id_holecard=148 OR holdem_hand_player_statistics.id_holecard=150 OR holdem_hand_player_statistics.id_holecard=155 OR holdem_hand_player_statistics.id_holecard=157 OR holdem_hand_player_statistics.id_holecard=162), 1, 0])

Example:

Raised with Previous Callers from the BUtton or CutOff with Small Pairs

RWPC-BUCO:SmallPr

if (cnt_p_rwpc_buco_smallpr > 0, '77-22','')

cnt_p_rwpc_buco_smallpr

sum(if[(holdem_hand_player_statistics.position = 0 OR holdem_hand_player_statistics.position = 1) AND holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open = false AND (holdem_hand_player_statistics.id_holecard=134 OR holdem_hand_player_statistics.id_holecard=145 OR holdem_hand_player_statistics.id_holecard=154 OR holdem_hand_player_statistics.id_holecard=161 OR holdem_hand_player_statistics.id_holecard=166 OR holdem_hand_player_statistics.id_holecard=169), 1, 0])

Example:

Raised First In from the Small Blind Light

RFI-SB:Light

if (cnt_p_rfi_sb_light > 0, 'Light','')

cnt_p_rfi_sb_light

sum(if[holdem_hand_player_statistics.position = 9 AND holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open_opp AND holdem_hand_player_statistics.id_holecard>0 AND NOT (holdem_hand_player_statistics.id_holecard=1 OR holdem_hand_player_statistics.id_holecard=26 OR holdem_hand_player_statistics.id_holecard=2 OR holdem_hand_player_statistics.id_holecard=3 OR holdem_hand_player_statistics.id_holecard=4 OR holdem_hand_player_statistics.id_holecard=5 OR holdem_hand_player_statistics.id_holecard=6 OR holdem_hand_player_statistics.id_holecard=7 OR holdem_hand_player_statistics.id_holecard=8 OR holdem_hand_player_statistics.id_holecard=27 OR holdem_hand_player_statistics.id_holecard=28 OR holdem_hand_player_statistics.id_holecard=49 OR holdem_hand_player_statistics.id_holecard=70 OR holdem_hand_player_statistics.id_holecard=89 OR holdem_hand_player_statistics.id_holecard=9 OR holdem_hand_player_statistics.id_holecard=10 OR holdem_hand_player_statistics.id_holecard=11 OR holdem_hand_player_statistics.id_holecard=12 OR holdem_hand_player_statistics.id_holecard=13 OR holdem_hand_player_statistics.id_holecard=14 OR holdem_hand_player_statistics.id_holecard=15 OR holdem_hand_player_statistics.id_holecard=16 OR holdem_hand_player_statistics.id_holecard=17 OR holdem_hand_player_statistics.id_holecard=18 OR holdem_hand_player_statistics.id_holecard=19 OR holdem_hand_player_statistics.id_holecard=20 OR holdem_hand_player_statistics.id_holecard=21 OR holdem_hand_player_statistics.id_holecard=22 OR holdem_hand_player_statistics.id_holecard=23 OR holdem_hand_player_statistics.id_holecard=24 OR holdem_hand_player_statistics.id_holecard=25 OR holdem_hand_player_statistics.id_holecard=29 OR holdem_hand_player_statistics.id_holecard=30 OR holdem_hand_player_statistics.id_holecard=31 OR holdem_hand_player_statistics.id_holecard=32 OR holdem_hand_player_statistics.id_holecard=33 OR holdem_hand_player_statistics.id_holecard=34 OR holdem_hand_player_statistics.id_holecard=35 OR holdem_hand_player_statistics.id_holecard=50 OR holdem_hand_player_statistics.id_holecard=51 OR holdem_hand_player_statistics.id_holecard=52 OR holdem_hand_player_statistics.id_holecard=53 OR holdem_hand_player_statistics.id_holecard=54 OR holdem_hand_player_statistics.id_holecard=55 OR holdem_hand_player_statistics.id_holecard=56 OR holdem_hand_player_statistics.id_holecard=71 OR holdem_hand_player_statistics.id_holecard=72 OR holdem_hand_player_statistics.id_holecard=73 OR holdem_hand_player_statistics.id_holecard=74 OR holdem_hand_player_statistics.id_holecard=106 OR holdem_hand_player_statistics.id_holecard=121 OR holdem_hand_player_statistics.id_holecard=134 OR holdem_hand_player_statistics.id_holecard=145 OR holdem_hand_player_statistics.id_holecard=154 OR holdem_hand_player_statistics.id_holecard=161 OR holdem_hand_player_statistics.id_holecard=166 OR holdem_hand_player_statistics.id_holecard=169 OR holdem_hand_player_statistics.id_holecard=75 OR holdem_hand_player_statistics.id_holecard=77 OR holdem_hand_player_statistics.id_holecard=90 OR holdem_hand_player_statistics.id_holecard=92 OR holdem_hand_player_statistics.id_holecard=94 OR holdem_hand_player_statistics.id_holecard=107 OR holdem_hand_player_statistics.id_holecard=109 OR holdem_hand_player_statistics.id_holecard=111 OR holdem_hand_player_statistics.id_holecard=122 OR holdem_hand_player_statistics.id_holecard=124 OR holdem_hand_player_statistics.id_holecard=126 OR holdem_hand_player_statistics.id_holecard=135 OR holdem_hand_player_statistics.id_holecard=137 OR holdem_hand_player_statistics.id_holecard=139 OR holdem_hand_player_statistics.id_holecard=146 OR holdem_hand_player_statistics.id_holecard=148 OR holdem_hand_player_statistics.id_holecard=150 OR holdem_hand_player_statistics.id_holecard=155 OR holdem_hand_player_statistics.id_holecard=157 OR holdem_hand_player_statistics.id_holecard=162), 1, 0])

Example:

4Bet Preflop with Solid Pairs

4Bet:SolidPr

if (cnt_p_4bet_solidpr > 0, 'QQ-88','')

cnt_p_4bet_solidpr

sum(if[holdem_hand_player_statistics.flg_p_4bet AND (holdem_hand_player_statistics.id_holecard=49 OR holdem_hand_player_statistics.id_holecard=70 OR holdem_hand_player_statistics.id_holecard=89 OR holdem_hand_player_statistics.id_holecard=106 OR holdem_hand_player_statistics.id_holecard=121), 1, 0])

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Tested out a working version of the HUD. So far so good.



And a close-up.



The last 2 sets of stats that I am working on are the most difficult.

I'd like to make a Raise from the BB with X Hand Range When Only the SB Limps stat. And I'd also like to make a Raise With Previous Callers from the Small Blind or Big Blind with X Hand Range (Not Including Raising from the BB When Only the SB Limps) stat. Any help on where to begin? I appreciate it!

[WhiteRider]

The last 2 sets of stats that I am working on are the most difficult.

I'd like to make a Raise from the BB with X Hand Range When Only the SB Limps stat. And I'd also like to make a Raise With Previous Callers from the Small Blind or Big Blind with X Hand Range (Not Including Raising from the BB When Only the SB Limps) stat. Any help on where to begin? I appreciate it!

Yes, these are awkward.
It's difficult to tell what position the other limpers are in, especially when there are no raises. You can tell when the only limper was the SB if the BB raises by comparing the size of the raise as an absolute value and a percentage of the pot.
Have a look at this thread.

[bloodndef]

Thank you, I'll attempt something later tonight.

I wanted to repost this image from the other thread, a small screenshot of the stat LFI-HJPL (limped first in, from the Hijack or Plank, positions 2 or 3) across 7 different hand ranges:

[bloodndef]

You can tell when the only limper was the SB if the BB raises by comparing the size of the raise as an absolute value and a percentage of the pot... Have a look at this thread.

This is great! Thanks again.

Here's what I've made:

Raised a single small blind limper from the big blind with a small pair:

RSBL-BB:SmallPr

if (cnt_p_rsbl_smallpr > 0, '77-22','')

cnt_p_rsbl_smallpr

sum(if[holdem_hand_player_statistics.position = 8 AND holdem_hand_player_statistics.flg_p_first_raise AND (holdem_hand_player_detail.amt_p_raise_made / (2 * holdem_limit.amt_bb) = holdem_hand_player_detail.val_p_raise_made_pct) AND (holdem_hand_player_statistics.id_holecard=134 OR holdem_hand_player_statistics.id_holecard=145 OR holdem_hand_player_statistics.id_holecard=154 OR holdem_hand_player_statistics.id_holecard=161 OR holdem_hand_player_statistics.id_holecard=166 OR holdem_hand_player_statistics.id_holecard=169), 1, 0])


Raised with previous callers from the small blind or big blind (but not a big blind raise of a single small blind limper) with a small pair:

Edit/Kraada: Removed since it was incorrect and fixed in the next post.



If these all look ok, I'll submit the package to the repository. 105 stats total. Haven't looked into it yet, but can I upload the whole package as one link? Can PT3 import the whole thing all at once?

Thanks for all the help!

[bloodndef]

Whoops, second one was wrong. This should be it:

Raised with previous callers from the small blind or big blind (but not a big blind raise of a single small blind limper) with a small pair:

RWPC-SB/BB:SmallPr

if (cnt_p_rwpc_sbbb_smallpr > 0, '77-22','')

cnt_p_rwpc_sbbb_smallpr

sum(if[(holdem_hand_player_statistics.position = 8 OR holdem_hand_player_statistics.position = 9) AND holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open = false AND NOT (holdem_hand_player_statistics.position = 8 AND holdem_hand_player_statistics.flg_p_first_raise AND (holdem_hand_player_detail.amt_p_raise_made / (2 * holdem_limit.amt_bb) = holdem_hand_player_detail.val_p_raise_made_pct) ) AND (holdem_hand_player_statistics.id_holecard=134 OR holdem_hand_player_statistics.id_holecard=145 OR holdem_hand_player_statistics.id_holecard=154 OR holdem_hand_player_statistics.id_holecard=161 OR holdem_hand_player_statistics.id_holecard=166 OR holdem_hand_player_statistics.id_holecard=169), 1, 0])

And how about:


Raised with previous callers from the small blind or big blind (but not a big blind raise of a single small blind limper) light:

RWPC-SB/BB:Light

if (cnt_p_rwpc_sbbb_light > 0, 'Light','')

cnt_p_rwpc_sbbb_light

sum(if[(holdem_hand_player_statistics.position = 8 OR holdem_hand_player_statistics.position = 9) AND holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open = false AND NOT (holdem_hand_player_statistics.position = 8 AND holdem_hand_player_statistics.flg_p_first_raise AND (holdem_hand_player_detail.amt_p_raise_made / (2 * holdem_limit.amt_bb) = holdem_hand_player_detail.val_p_raise_made_pct) ) AND holdem_hand_player_statistics.id_holecard>0 AND NOT (holdem_hand_player_statistics.id_holecard=1 OR holdem_hand_player_statistics.id_holecard=26 OR holdem_hand_player_statistics.id_holecard=2 OR holdem_hand_player_statistics.id_holecard=3 OR holdem_hand_player_statistics.id_holecard=4 OR holdem_hand_player_statistics.id_holecard=5 OR holdem_hand_player_statistics.id_holecard=6 OR holdem_hand_player_statistics.id_holecard=7 OR holdem_hand_player_statistics.id_holecard=8 OR holdem_hand_player_statistics.id_holecard=27 OR holdem_hand_player_statistics.id_holecard=28 OR holdem_hand_player_statistics.id_holecard=49 OR holdem_hand_player_statistics.id_holecard=70 OR holdem_hand_player_statistics.id_holecard=89 OR holdem_hand_player_statistics.id_holecard=9 OR holdem_hand_player_statistics.id_holecard=10 OR holdem_hand_player_statistics.id_holecard=11 OR holdem_hand_player_statistics.id_holecard=12 OR holdem_hand_player_statistics.id_holecard=13 OR holdem_hand_player_statistics.id_holecard=14 OR holdem_hand_player_statistics.id_holecard=15 OR holdem_hand_player_statistics.id_holecard=16 OR holdem_hand_player_statistics.id_holecard=17 OR holdem_hand_player_statistics.id_holecard=18 OR holdem_hand_player_statistics.id_holecard=19 OR holdem_hand_player_statistics.id_holecard=20 OR holdem_hand_player_statistics.id_holecard=21 OR holdem_hand_player_statistics.id_holecard=22 OR holdem_hand_player_statistics.id_holecard=23 OR holdem_hand_player_statistics.id_holecard=24 OR holdem_hand_player_statistics.id_holecard=25 OR holdem_hand_player_statistics.id_holecard=29 OR holdem_hand_player_statistics.id_holecard=30 OR holdem_hand_player_statistics.id_holecard=31 OR holdem_hand_player_statistics.id_holecard=32 OR holdem_hand_player_statistics.id_holecard=33 OR holdem_hand_player_statistics.id_holecard=34 OR holdem_hand_player_statistics.id_holecard=35 OR holdem_hand_player_statistics.id_holecard=50 OR holdem_hand_player_statistics.id_holecard=51 OR holdem_hand_player_statistics.id_holecard=52 OR holdem_hand_player_statistics.id_holecard=53 OR holdem_hand_player_statistics.id_holecard=54 OR holdem_hand_player_statistics.id_holecard=55 OR holdem_hand_player_statistics.id_holecard=56 OR holdem_hand_player_statistics.id_holecard=71 OR holdem_hand_player_statistics.id_holecard=72 OR holdem_hand_player_statistics.id_holecard=73 OR holdem_hand_player_statistics.id_holecard=74 OR holdem_hand_player_statistics.id_holecard=106 OR holdem_hand_player_statistics.id_holecard=121 OR holdem_hand_player_statistics.id_holecard=134 OR holdem_hand_player_statistics.id_holecard=145 OR holdem_hand_player_statistics.id_holecard=154 OR holdem_hand_player_statistics.id_holecard=161 OR holdem_hand_player_statistics.id_holecard=166 OR holdem_hand_player_statistics.id_holecard=169 OR holdem_hand_player_statistics.id_holecard=75 OR holdem_hand_player_statistics.id_holecard=77 OR holdem_hand_player_statistics.id_holecard=90 OR holdem_hand_player_statistics.id_holecard=92 OR holdem_hand_player_statistics.id_holecard=94 OR holdem_hand_player_statistics.id_holecard=107 OR holdem_hand_player_statistics.id_holecard=109 OR holdem_hand_player_statistics.id_holecard=111 OR holdem_hand_player_statistics.id_holecard=122 OR holdem_hand_player_statistics.id_holecard=124 OR holdem_hand_player_statistics.id_holecard=126 OR holdem_hand_player_statistics.id_holecard=135 OR holdem_hand_player_statistics.id_holecard=137 OR holdem_hand_player_statistics.id_holecard=139 OR holdem_hand_player_statistics.id_holecard=146 OR holdem_hand_player_statistics.id_holecard=148 OR holdem_hand_player_statistics.id_holecard=150 OR holdem_hand_player_statistics.id_holecard=155 OR holdem_hand_player_statistics.id_holecard=157 OR holdem_hand_player_statistics.id_holecard=162), 1, 0])