c/r Flop and c/<sth> Turn

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

c/r Flop and c/<sth> Turn

Postby js2002 » Tue Feb 01, 2011 8:22 am

1. c/r Flop and c/f Turn

sum(if[lookup_actions_f.action LIKE 'XR' AND
lookup_actions_t.action LIKE 'XF',1,0])
_______________________________________
sum(if[lookup_actions_f.action LIKE 'XR' AND
lookup_actions_t.action LIKE 'X_%',1,0])

This is it.
Now I wanna add

2. c/r Flop and c/c Turn

sum(if[lookup_actions_f.action LIKE 'XR' AND
lookup_actions_t.action LIKE 'XC',1,0]) <---------------------- XC or XC%, what do u think 4 consistence and advice?
_______________________________________
sum(if[lookup_actions_f.action LIKE 'XR' AND
lookup_actions_t.action LIKE 'X_%',1,0])


3. c/r Flop and c/r Turn


sum(if[lookup_actions_f.action LIKE 'XR' AND
lookup_actions_t.action LIKE 'XR',1,0]) <---------------------- XR or XR%, what do u think 4 consistence and advice?
_______________________________________
sum(if[lookup_actions_f.action LIKE 'XR' AND
lookup_actions_t.action LIKE 'X_%',1,0])


My opinion: everything without % will do well! U think the same?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: c/r Flop and c/<sth> Turn

Postby js2002 » Tue Feb 01, 2011 8:44 am

Im not really sure if I want to have c/r / c/rr or c/r / c/rc in these stats! hmmmmm fuck!

EDIT: I need c/r c/rc ! So I need c/r c/r% with %age sign !
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: c/r Flop and c/<sth> Turn

Postby kraada » Tue Feb 01, 2011 9:54 am

I like using the %s in spots like that just because you probably don't want to lose an opportunity or two because they check/raised the turn and got 3-bet - opportunities for something like this are already going to be rare enough!
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 2 guests