board-texture in SQL?

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Re: board-texture in SQL?

Postby EinSIM » Wed Jan 26, 2011 4:12 pm

hello, i need some different bd textures :

1. Flop with 2 Cards of one suit
2. Turn is the 3rd Card of a suit
3. River is the 3rd Card of a suit

and 4. Flop Rainbow and (Two Cards are Gapped and the thirsd is not connected)

Thx
EinSIM
 
Posts: 74
Joined: Tue May 06, 2008 6:16 pm

Re: board-texture in SQL?

Postby kraada » Wed Jan 26, 2011 4:50 pm

(1) ((holdem_hand_summary.card_1 <= 13 and holdem_hand_summary.card_2 <= 13 and holdem_hand_summary.card_3 >13) or (holdem_hand_summary.card_1 <= 13 and holdem_hand_summary.card_2 > 13 and holdem_hand_summary.card_3 <= 13) or (holdem_hand_summary.card_1 > 13 and holdem_hand_summary.card_2 <= 13 and holdem_hand_summary.card_3 <= 13) or ((holdem_hand_summary.card_1 <= 26 and holdem_hand_summary.card_1 >= 14) and (holdem_hand_summary.card_2 <= 26 and holdem_hand_summary.card_2 >= 14) and (holdem_hand_summary.card_3 > 26 or holdem_hand_summary.card_3 < 14)) or ((holdem_hand_summary.card_1 <= 26 and holdem_hand_summary.card_1 >= 14) and (holdem_hand_summary.card_2 > 26 or holdem_hand_summary.card_2 < 14) and (holdem_hand_summary.card_3 <= 26 and holdem_hand_summary.card_3 >= 14)) or ((holdem_hand_summary.card_1 > 26 or holdem_hand_summary.card_1 < 14) and (holdem_hand_summary.card_2 <= 26 and holdem_hand_summary.card_2 >= 14) and (holdem_hand_summary.card_3 <= 26 and holdem_hand_summary.card_3 >= 14)) or ((holdem_hand_summary.card_1 <= 39 and holdem_hand_summary.card_1 >= 27) and (holdem_hand_summary.card_2 <= 39 and holdem_hand_summary.card_2 >= 27) and (holdem_hand_summary.card_3 > 39 or holdem_hand_summary.card_3 < 27)) or ((holdem_hand_summary.card_1 <= 39 and holdem_hand_summary.card_1 >= 27) and (holdem_hand_summary.card_2 > 39 or holdem_hand_summary.card_2 < 27) and (holdem_hand_summary.card_3 <= 39 and holdem_hand_summary.card_3 >= 27)) or ((holdem_hand_summary.card_1 > 39 or holdem_hand_summary.card_1 < 27) and (holdem_hand_summary.card_2 <= 39 and holdem_hand_summary.card_2 >= 27) and (holdem_hand_summary.card_3 <= 39 and holdem_hand_summary.card_3 >= 27)) or (holdem_hand_summary.card_1 >= 40 and holdem_hand_summary.card_2 >= 40 and holdem_hand_summary.card_3 < 40) or (holdem_hand_summary.card_1 >= 40 and holdem_hand_summary.card_2 < 40 and holdem_hand_summary.card_3 >= 40) or (holdem_hand_summary.card_1 < 40 and holdem_hand_summary.card_2 >= 40 and holdem_hand_summary.card_3 >= 40)) and holdem_hand_player_statistics.flg_f_saw

(2) ((holdem_hand_summary.card_1 <= 13 and holdem_hand_summary.card_2 <= 13 and holdem_hand_summary.card_3 >13 and holdem_hand_summary.card_4 <= 13) or (holdem_hand_summary.card_1 <= 13 and holdem_hand_summary.card_2 > 13 and holdem_hand_summary.card_3 <= 13 and holdem_hand_summary.card_4 <= 13) or (holdem_hand_summary.card_1 > 13 and holdem_hand_summary.card_2 <= 13 and holdem_hand_summary.card_3 <= 13 and holdem_hand_summary.card_4 <= 13) or ((holdem_hand_summary.card_1 <= 26 and holdem_hand_summary.card_1 >= 14) and (holdem_hand_summary.card_2 <= 26 and holdem_hand_summary.card_2 >= 14) and (holdem_hand_summary.card_3 > 26 or holdem_hand_summary.card_3 < 14) and (holdem_hand_summary.card_4 <= 26 and holdem_hand_summary.card_4 >= 14)) or ((holdem_hand_summary.card_1 <= 26 and holdem_hand_summary.card_1 >= 14) and (holdem_hand_summary.card_2 > 26 or holdem_hand_summary.card_2 < 14) and (holdem_hand_summary.card_3 <= 26 and holdem_hand_summary.card_3 >= 14) and (holdem_hand_summary.card_4 <= 26 and holdem_hand_summary.card_4 >= 14)) or ((holdem_hand_summary.card_1 > 26 or holdem_hand_summary.card_1 < 14) and (holdem_hand_summary.card_2 <= 26 and holdem_hand_summary.card_2 >= 14) and (holdem_hand_summary.card_3 <= 26 and holdem_hand_summary.card_3 >= 14) and (holdem_hand_summary.card_4 <= 26 and holdem_hand_summary.card_4 >= 14)) or ((holdem_hand_summary.card_1 <= 39 and holdem_hand_summary.card_1 >= 27) and (holdem_hand_summary.card_2 <= 39 and holdem_hand_summary.card_2 >= 27) and (holdem_hand_summary.card_3 > 39 or holdem_hand_summary.card_3 < 27) and (holdem_hand_summary.card_4 <= 39 and holdem_hand_summary.card_4 >= 27)) or ((holdem_hand_summary.card_1 <= 39 and holdem_hand_summary.card_1 >= 27) and (holdem_hand_summary.card_2 > 39 or holdem_hand_summary.card_2 < 27) and (holdem_hand_summary.card_3 <= 39 and holdem_hand_summary.card_3 >= 27) and (holdem_hand_summary.card_4 <= 39 and holdem_hand_summary.card_4 >= 27)) or ((holdem_hand_summary.card_1 > 39 or holdem_hand_summary.card_1 < 27) and (holdem_hand_summary.card_2 <= 39 and holdem_hand_summary.card_2 >= 27) and (holdem_hand_summary.card_3 <= 39 and holdem_hand_summary.card_3 >= 27) and (holdem_hand_summary.card_4 <= 39 and holdem_hand_summary.card_4 >= 27)) or (holdem_hand_summary.card_1 >= 40 and holdem_hand_summary.card_2 >= 40 and holdem_hand_summary.card_3 < 40 and holdem_hand_summary.card_4 >= 40) or (holdem_hand_summary.card_1 >= 40 and holdem_hand_summary.card_2 < 40 and holdem_hand_summary.card_3 >= 40 and holdem_hand_summary.card_4 >= 40) or (holdem_hand_summary.card_1 < 40 and holdem_hand_summary.card_2 >= 40 and holdem_hand_summary.card_3 >= 40 and holdem_hand_summary.card_4 >= 40)) and holdem_hand_player_statistics.flg_t_saw

(3) ((holdem_hand_summary.card_1 > 13 and holdem_hand_summary.card_2 > 13 and holdem_hand_summary.card_3 <= 13 and holdem_hand_summary.card_4 <= 13 and holdem_hand_summary.card_5 <= 13) or (holdem_hand_summary.card_1 > 13 and holdem_hand_summary.card_2 <= 13 and holdem_hand_summary.card_3 > 13 and holdem_hand_summary.card_4 <= 13 and holdem_hand_summary.card_5 <= 13) or (holdem_hand_summary.card_1 <= 13 and holdem_hand_summary.card_2 > 13 and holdem_hand_summary.card_3 > 13 and holdem_hand_summary.card_4 <= 13 and holdem_hand_summary.card_5 <= 13) or (holdem_hand_summary.card_1 > 13 and holdem_hand_summary.card_2 <= 13 and holdem_hand_summary.card_3 <= 13 and holdem_hand_summary.card_4 > 13 and holdem_hand_summary.card_5 <= 13) or (holdem_hand_summary.card_1 <= 13 and holdem_hand_summary.card_2 > 13 and holdem_hand_summary.card_3 <= 13 and holdem_hand_summary.card_4 > 13 and holdem_hand_summary.card_5 <= 13) or (holdem_hand_summary.card_1 <= 13 and holdem_hand_summary.card_2 <= 13 and holdem_hand_summary.card_3 > 13 and holdem_hand_summary.card_4 > 13 and holdem_hand_summary.card_5 <= 13) or ((holdem_hand_summary.card_1 <= 26 and holdem_hand_summary.card_1 >= 14) and (holdem_hand_summary.card_2 <= 26 and holdem_hand_summary.card_2 >= 14) and (holdem_hand_summary.card_3 > 26 or holdem_hand_summary.card_3 < 14) and (holdem_hand_summary.card_4 > 26 or holdem_hand_summary.card_4 < 14) and (holdem_hand_summary.card_5 <= 26 and holdem_hand_summary.card_5 >= 14)) or ((holdem_hand_summary.card_1 > 26 or holdem_hand_summary.card_1 < 14) and (holdem_hand_summary.card_2 > 26 or holdem_hand_summary.card_2 < 14) and (holdem_hand_summary.card_3 <= 26 and holdem_hand_summary.card_3 >= 14) and (holdem_hand_summary.card_4 <= 26 and holdem_hand_summary.card_4 >= 14) and
(holdem_hand_summary.card_5 <= 26 and holdem_hand_summary.card_5 >= 14)) or ((holdem_hand_summary.card_1 > 26 or holdem_hand_summary.card_1 < 14) and (holdem_hand_summary.card_2 <= 26 and holdem_hand_summary.card_2 >= 14) and (holdem_hand_summary.card_3 > 26 or holdem_hand_summary.card_3 < 14) and (holdem_hand_summary.card_4 <= 26 and holdem_hand_summary.card_4 >= 14) and (holdem_hand_summary.card_5 <= 26 and holdem_hand_summary.card_5 >= 14)) or ((holdem_hand_summary.card_1 <= 26 and holdem_hand_summary.card_1 >= 14) and (holdem_hand_summary.card_2 > 26 or holdem_hand_summary.card_2 < 14) and (holdem_hand_summary.card_3 > 26 or holdem_hand_summary.card_3 < 14) and (holdem_hand_summary.card_4 <= 26 and holdem_hand_summary.card_4 >= 14) and
(holdem_hand_summary.card_5 <= 26 and holdem_hand_summary.card_5 >= 14)) or ((holdem_hand_summary.card_1 <= 26 and holdem_hand_summary.card_1 >= 14) and (holdem_hand_summary.card_2 > 26 or holdem_hand_summary.card_2 < 14) and (holdem_hand_summary.card_3 <= 26 and holdem_hand_summary.card_3 >= 14) and (holdem_hand_summary.card_4 > 26 or holdem_hand_summary.card_4 < 14) and
(holdem_hand_summary.card_5 <= 26 and holdem_hand_summary.card_5 >= 14)) or ((holdem_hand_summary.card_1 > 26 or holdem_hand_summary.card_1 < 14) and (holdem_hand_summary.card_2 <= 26 and holdem_hand_summary.card_2 >= 14) and (holdem_hand_summary.card_3 <= 26 and holdem_hand_summary.card_3 >= 14) and (holdem_hand_summary.card_4 > 26 or holdem_hand_summary.card_4 < 14) and (holdem_hand_summary.card_5 <= 26 and holdem_hand_summary.card_5 >= 14)) or
((holdem_hand_summary.card_1 <= 39 and holdem_hand_summary.card_1 >= 27) and (holdem_hand_summary.card_2 <= 39 and holdem_hand_summary.card_2 >= 27) and (holdem_hand_summary.card_3 > 39 or holdem_hand_summary.card_3 < 27) and
(holdem_hand_summary.card_4 > 39 or holdem_hand_summary.card_4 < 27) and
(holdem_hand_summary.card_5 <= 39 and holdem_hand_summary.card_5 >= 27)) or ((holdem_hand_summary.card_1 > 39 or holdem_hand_summary.card_1 < 27) and (holdem_hand_summary.card_2 <= 39 and holdem_hand_summary.card_2 >= 27) and (holdem_hand_summary.card_3 > 39 or holdem_hand_summary.card_3 < 27) and
(holdem_hand_summary.card_4 <= 39 and holdem_hand_summary.card_4 >= 27) and
(holdem_hand_summary.card_5 <= 39 and holdem_hand_summary.card_5 >= 27)) or ((holdem_hand_summary.card_1 <= 39 and holdem_hand_summary.card_1 >= 27) and (holdem_hand_summary.card_2 > 39 or holdem_hand_summary.card_2 < 27) and (holdem_hand_summary.card_3 <= 39 and holdem_hand_summary.card_3 >= 27) and
(holdem_hand_summary.card_4 > 39 or holdem_hand_summary.card_4 < 27) and
(holdem_hand_summary.card_5 <= 39 and holdem_hand_summary.card_5 >= 27)) or ((holdem_hand_summary.card_1 > 39 or holdem_hand_summary.card_1 < 27) and (holdem_hand_summary.card_2 <= 39 and holdem_hand_summary.card_2 >= 27) and (holdem_hand_summary.card_3 <= 39 and holdem_hand_summary.card_3 >= 27) and
(holdem_hand_summary.card_4 > 39 or holdem_hand_summary.card_4 < 27) and
(holdem_hand_summary.card_5 <= 39 and holdem_hand_summary.card_5 >= 27)) or ((holdem_hand_summary.card_1 > 39 or holdem_hand_summary.card_1 < 27) and (holdem_hand_summary.card_2 > 39 or holdem_hand_summary.card_2 < 27) and (holdem_hand_summary.card_3 <= 39 and holdem_hand_summary.card_3 >= 27) and
(holdem_hand_summary.card_4 <= 39 and holdem_hand_summary.card_4 >= 27) and
(holdem_hand_summary.card_5 <= 39 and holdem_hand_summary.card_5 >= 27)) or ((holdem_hand_summary.card_1 <= 39 and holdem_hand_summary.card_1 >= 27) and (holdem_hand_summary.card_2 > 39 or holdem_hand_summary.card_2 < 27) and (holdem_hand_summary.card_3 > 39 or holdem_hand_summary.card_3 < 27) and
(holdem_hand_summary.card_4 <= 39 and holdem_hand_summary.card_4 >= 27) and
(holdem_hand_summary.card_5 <= 39 and holdem_hand_summary.card_5 >= 27)) or (holdem_hand_summary.card_1 >= 40 and holdem_hand_summary.card_2 >= 40 and holdem_hand_summary.card_3 < 40 and holdem_hand_summary.card_4 < 40 and holdem_hand_summary.card_5 >= 40) or (holdem_hand_summary.card_1 >= 40 and holdem_hand_summary.card_2 < 40 and holdem_hand_summary.card_3 < 40 and holdem_hand_summary.card_4 >= 40 and holdem_hand_summary.card_5 >= 40) or (holdem_hand_summary.card_1 < 40 and holdem_hand_summary.card_2 < 40 and holdem_hand_summary.card_3 >= 40 and holdem_hand_summary.card_4 >= 40 and holdem_hand_summary.card_5 >= 40) or (holdem_hand_summary.card_1 < 40 and holdem_hand_summary.card_2 >= 40 and holdem_hand_summary.card_3 < 40 and holdem_hand_summary.card_4 >= 40 and holdem_hand_summary.card_5 >= 40) or (holdem_hand_summary.card_1 >= 40 and holdem_hand_summary.card_2 < 40 and holdem_hand_summary.card_3 >= 40 and holdem_hand_summary.card_4 < 40 and holdem_hand_summary.card_5 >= 40) or (holdem_hand_summary.card_1 < 40 and holdem_hand_summary.card_2 >= 40 and holdem_hand_summary.card_3 >= 40 and holdem_hand_summary.card_4 < 40 and holdem_hand_summary.card_5 >= 40)) and holdem_hand_player_statistics.flg_r_saw

(4) ((holdem_hand_summary.card_1 % 13 = 11 and holdem_hand_summary.card_2 % 13 = 0 and holdem_hand_summary.card_3 % 13 < 9 and holdem_hand_summary.card_3 % 13 > 0) or ( holdem_hand_summary.card_2 % 13 = 11 and holdem_hand_summary.card_1 % 13 = 0 and holdem_hand_summary.card_3 % 13 < 9 and holdem_hand_summary.card_3 % 13 > 0)
or ( holdem_hand_summary.card_1 % 13 = 11 and holdem_hand_summary.card_3 % 13 = 0 and holdem_hand_summary.card_2 % 13 < 9 and holdem_hand_summary.card_2 % 13 > 0) or ( holdem_hand_summary.card_3 % 13 = 11 and holdem_hand_summary.card_1 % 13 = 0 and holdem_hand_summary.card_2 % 13 < 9 and
holdem_hand_summary.card_2 % 13 > 0) or ( holdem_hand_summary.card_3 % 13 = 11 and holdem_hand_summary.card_2 % 13 = 0 and holdem_hand_summary.card_1 % 13 < 9 and holdem_hand_summary.card_1 % 13 > 0) or ( holdem_hand_summary.card_2 % 13 = 11 and holdem_hand_summary.card_3 % 13 = 0 and holdem_hand_summary.card_1 % 13 < 9 and holdem_hand_summary.card_1 % 13 > 0) or ( holdem_hand_summary.card_1 % 13 = 12 and holdem_hand_summary.card_2 % 13 = 10 and holdem_hand_summary.card_3 % 13 < 8 and holdem_hand_summary.card_3 % 13 > 0) or ( holdem_hand_summary.card_2 % 13 = 12 and holdem_hand_summary.card_1 % 13 = 10 and holdem_hand_summary.card_3 % 13 < 8 and holdem_hand_summary.card_3 % 13 > 0) or ( holdem_hand_summary.card_1 % 13 = 12 and holdem_hand_summary.card_3 % 13 = 10 and holdem_hand_summary.card_2 % 13 < 8 and holdem_hand_summary.card_2 % 13 > 0) or ( holdem_hand_summary.card_3 % 13 = 12 and holdem_hand_summary.card_1 % 13 = 10 and holdem_hand_summary.card_2 % 13 < 8 and holdem_hand_summary.card_2 % 13 > 0) or ( holdem_hand_summary.card_3 % 13 = 12 and holdem_hand_summary.card_2 % 13 = 10 and holdem_hand_summary.card_1 % 13 < 8 and holdem_hand_summary.card_1 % 13 > 0) or ( holdem_hand_summary.card_2 % 13 = 12 and holdem_hand_summary.card_3 % 13 = 10 and holdem_hand_summary.card_1 % 13 < 8 and holdem_hand_summary.card_1 % 13 > 0) or ( holdem_hand_summary.card_1 % 13 = 9 and holdem_hand_summary.card_2 % 13 = 11 and holdem_hand_summary.card_3 % 13 < 7 and holdem_hand_summary.card_3 % 13 > 0) or ( holdem_hand_summary.card_2 % 13 = 9 and holdem_hand_summary.card_1 % 13 = 11 and holdem_hand_summary.card_3 % 13 < 7 and holdem_hand_summary.card_3 % 13 > 0) or ( holdem_hand_summary.card_1 % 13 = 9 and holdem_hand_summary.card_3 % 13 = 11 and holdem_hand_summary.card_2 % 13 < 7 and
holdem_hand_summary.card_2 % 13 > 0) or ( holdem_hand_summary.card_3 % 13 = 9 and holdem_hand_summary.card_1 % 13 = 11 and holdem_hand_summary.card_2 % 13 < 7 and holdem_hand_summary.card_2 % 13 > 0) or ( holdem_hand_summary.card_3 % 13 = 9 and holdem_hand_summary.card_2 % 13 = 11 and holdem_hand_summary.card_1 % 13 < 7 and
holdem_hand_summary.card_1 % 13 > 0) or ( holdem_hand_summary.card_2 % 13 = 9 and holdem_hand_summary.card_3 % 13 = 11 and holdem_hand_summary.card_1 % 13 < 7 and holdem_hand_summary.card_1 % 13 > 0) or (holdem_hand_summary.card_1 % 13 < 10 and holdem_hand_summary.card_2 % 13 = ((holdem_hand_summary.card_1 % 13) +2) and (holdem_hand_summary.card_3 % 13 > ((holdem_hand_summary.card_1 % 13) + 4) or
holdem_hand_summary.card_3 % 13 < ((holdem_hand_summary.card_1 % 13) - 2))) or
(holdem_hand_summary.card_2 % 13 < 10 and holdem_hand_summary.card_1 % 13 = ((holdem_hand_summary.card_2 % 13) +2) and (holdem_hand_summary.card_3 % 13 > ((holdem_hand_summary.card_2 % 13) + 4) or
holdem_hand_summary.card_3 % 13 < ((holdem_hand_summary.card_2 % 13) - 2))) or (holdem_hand_summary.card_1 % 13 < 10 and holdem_hand_summary.card_3 % 13 = ((holdem_hand_summary.card_1 % 13) +2) and (holdem_hand_summary.card_2 % 13 > ((holdem_hand_summary.card_1 % 13) + 4) or holdem_hand_summary.card_2 % 13 < ((holdem_hand_summary.card_1 % 13) - 2)))
or (holdem_hand_summary.card_3 % 13 < 10 and holdem_hand_summary.card_2 % 13 = ((holdem_hand_summary.card_3 % 13) +2) and (holdem_hand_summary.card_1 % 13 > ((holdem_hand_summary.card_3 % 13) + 4) or holdem_hand_summary.card_1 % 13 < ((holdem_hand_summary.card_3 % 13) - 2)) ) or (holdem_hand_summary.card_2 % 13 < 10 and
holdem_hand_summary.card_3 % 13 = ((holdem_hand_summary.card_2 % 13) +2) and
(holdem_hand_summary.card_1 % 13 > ((holdem_hand_summary.card_2 % 13) + 4) or
holdem_hand_summary.card_1 % 13 < ((holdem_hand_summary.card_2 % 13) - 2)) ) or (holdem_hand_summary.card_3 % 13 < 10 and holdem_hand_summary.card_1 % 13 = ((holdem_hand_summary.card_3 % 13) +2) and
(holdem_hand_summary.card_2 % 13 > ((holdem_hand_summary.card_3 % 13) + 4) or
holdem_hand_summary.card_2 % 13 < ((holdem_hand_summary.card_3 % 13) - 2)) )) and holdem_hand_player_statistics.flg_f_saw
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: board-texture in SQL?

Postby EinSIM » Mon Jan 31, 2011 3:03 pm

merci :-)
EinSIM
 
Posts: 74
Joined: Tue May 06, 2008 6:16 pm

Re: board-texture in SQL?

Postby kraada » Mon Jan 31, 2011 3:20 pm

You're welcome. If you find a simpler way while using these please do let me know. They're more than a bit ugly . . .
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: board-texture in SQL?

Postby EinSIM » Mon Jan 31, 2011 3:24 pm

i need the third stat in another way
1. River is the 3rd Card of a suit and Flop with 2 Cards of one suit (Flush Draw on Flop and Hit on River)

and 2. River is NOT the 3rd Card of a suit and Flop with 2 Cards of one suit (Flush Draw on Flop and NO Hit on River)
EinSIM
 
Posts: 74
Joined: Tue May 06, 2008 6:16 pm

Re: board-texture in SQL?

Postby kraada » Mon Jan 31, 2011 4:07 pm

Then remove the sections where card_5 matches card_4 - card_5 is the river, card_4 is the turn.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: board-texture in SQL?

Postby daniguru » Tue Mar 26, 2013 7:09 pm

hi kraada

could you please show how it exactly would look like cause i dont get it right :?

1. River is the 3rd Card of a suit and Flop with 2 Cards of one suit (Flush Draw on Flop and Hit on River)


2. River is NOT the 3rd Card of a suit and Flop with 2 Cards of one suit (Flush Draw on Flop and NO Hit on River)

many many thanks kraada ;)

daniel
daniguru
 
Posts: 69
Joined: Mon Aug 11, 2008 10:20 am

Previous

Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 8 guests

cron
highfalutin