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
by 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
by 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
by EinSIM » Mon Jan 31, 2011 3:03 pm
merci
-
EinSIM
-
- Posts: 74
- Joined: Tue May 06, 2008 6:16 pm
by 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
by 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
by 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
by 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
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 20 guests