MLB - Situation Plays - SDQL

[emceeaye]

Bases query supporting Orioles/Indians over

(SG = 1 or SG = 4) and 1 < SGS < 5 and p:HR = 2 and op:HR < 3 and s:SHRA = 1 and os:SHRA < 2 and ss:SHRA = 0 and sss:SHRA < 3 and s:SRA < 7 and s:SSO > 1 and p:hits < 16 and tA(hits, N=10) < 10.5 and oA(hits,N=10) > 7.3 and tA(HR, N=10) > .6 and oA(fly balls, N=10) < 10.5 and tA(SO, N=10) < 8.6

Take a look at SG=1 only and month=8...nice record.

[hyahya]

FYI, bases' ultra long query showing ROI of 50% over nearly 500 samples is pointing to the A's today.

[posey]

Not getting the logic of this query. Why would the home team win more often when there has been a higher number and average of recent league dog away wins (over 50%).

I don't get it either. As I said it wasn't my intention to set up the query like I posted it. Don't know...maybe someone can help? I have really no clue what's going on with this query.

[emceeaye]

FYI, bases' ultra long query showing ROI of 50% over nearly 500 samples is pointing to the A's today.

Can you please post the query?

[JMon]

3rd and 4th play: ( Dr.M )(Daily Report)

Play Dodgers - 171
Dodgers RL +125
Greinke 19 and 0 this spot. 4 and 0 this season.

More support:
starter=’Zack Greinke’ and season>=2011 and H and line<-140 and 12>=s:runs+so:runs>=2
33 and 1 with this query. 7 and 1 this season

xtra support for LAD

p:errors = 0 and op:errors = 1 and (H or SG > 1) and SG < 5 and SGS > 2 and SGS - SG < 3 and (H or day != Saturday) and ((H and -215 < line < 142) or (A and -200 < line < 175)) and (conference = AL or o:conference = NL) and op:HR < 3 and p:runs > 2 and p:margin > -2 and 12 > pp:margin > -9 and streak < 5 and -7 < o:streak < 3 and p:SO < 14 and game number > 13 and -21 < tS(margin, N=10) < 29 and -30 < oS(margin, N=10) < 26 and s:SHA > 1 and s:SWA < 6 and s:SSO < 11 and s:SIP > 1.9 and s:SHF > 21 and s:SPT < 121 and 4 < starter rest < 17 and os:SRA < 7 and os:SWA < 6 and 20 < os:SHF < 33 and os:SIP < 8.1 and o:starter rest < 10 and op:runs < 9 and opp:runs < 13 and oppp:runs < 11 and oS(runs, N=10) > 21 and tS(HR, N=10) < 19 and tS(walks, N=10) > 16 and 42 < tS(SO, N=10) < 86 and site streak > -10 and o:site streak > -8 and op:SII < 5 and p:RMAX > 1 and oss:SHF > 13 and oss:SPT > 73 and -5 < tS(W, N=10) - oS(W, N=10) < 6 and -8 < tS(errors, N=10) - oS(errors, N=10) < 6 and opp:RMAX < 5

[hyahya]

Can you please post the query?

Will do when I get back home.

[JMon]

FYI, bases' ultra long query showing ROI of 50% over nearly 500 samples is pointing to the A's today.

ya just seen that, but they did lose in that situation already this year.

[JMon]

Can you please post the query?

AD and (SG = 1 or SG = 3) and playoffs = 0 and streak > -4 and -8 < o:streak < 6 and -7 < p:margin < 10 and -10 < op:margin < 9 and p:runs < 13 and op:runs != 0 and p:hits > 1 and 3 < op:hits < 15 and op:doubles < 6 and p:triples < 3 and op:triples < 2 and p:SO > 3 and 2 < op:SO < 17 and 3 < p:ground balls < 21 and 2 < op:ground balls < 24 and p:fly balls < 16 and 2 < op:fly balls < 16 and op:BPRA < 9 and 1.5 < p:SIP < 8.1 and 1.9 < op:SIP < 8.5 and 33 < p:SPT < 116 and 48 < op:SPT < 111 and op:SHF < 34 and 27 < p:batters faced < 46 and 28 < op:batters faced < 57 and p:at bats + p:walks < 48 and op:at bats + op:walks < 46 and 0 < p:TLOB < 12 and 0 < op:TLOB < 13 and (14 > site streak > 5 or -1 > site streak > -12) and (1 < o:site streak < 10 or -11 < o:site streak < -5) and (conference = AL or o:conference = NL) and op:RMAX < 8 and op:R1 < 5 and op:R2 < 4 and op:R3 < 3 and p:errors < 3 and op:errors < 4 and os:SHA < 12 and os:SRA < 7 and 0 < os:SWA < 5 and s:SPT > 83 and starter rest < 12 and s:SIP > 4.9 and s:SHF > 21 and s:SSO < 10 and op:BL < 8 and 2 < p:PU < 7 and -39 < tS(margin, N=10) - oS(margin, N=10) < 32 and oS(HR, N=10) > 4 and 3 < tS(HR, N=10) < 19 and oS(doubles, N=10) < 29 and tS(hits, N=10) > 63 and 65 < oS(hits, N=10) < 105 and line < 225 and day != Sunday and oss:SHA < 11 and oss:SHRA < 3 and game number > 24 and tS(margin, N=20) - oS(margin, N=20) < 43 and tS(hits, N=20) - oS(hits, N=20) < 27

[JMon]

(SG = 1 or SG = 4) and 1 < SGS < 5 and p:HR = 2 and op:HR < 3 and s:SHRA = 1 and os:SHRA < 2 and ss:SHRA = 0 and sss:SHRA < 3 and s:SRA < 7 and s:SSO > 1 and p:hits < 16 and tA(hits, N=10) < 10.5 and oA(hits,N=10) > 7.3 and tA(HR, N=10) > .6 and oA(fly balls, N=10) < 10.5 and tA(SO, N=10) < 8.6

Take a look at SG=1 only and month=8...nice record.

xtra support

p:HR = 2 and op:HR < 3 and SG < 5 and SG != 3 and 1 < SGS < 5 and s:SRA < 6 and os:SRA < 6 and (s:SHA + ss:SHA) < 17 and (os:SHA + oss:SHA) < 17 and 2.6 < tA(runs, N=10) < 6.8 and oA(runs, N=10) < 6.6 and total < 10.5 and 84 < os:SPT < 119 and starter rest < 20 and o:starter rest < 25 and (rest = 1 or rest = 0) and p:hits < 17 and 3 < op:hits < 18 and .8 < tA(doubles, N=10) < 2.5 and .8 < oA(doubles, N=10) < 3.1 and day != Wednesday and -2 < ou streak < 5 and -2 < ou streak < 3 and month < 10 and (game number < 107 or game number > 116) and tA(walks, N=10) > 1.9 and 1.9 < oA(walks, N=10) < 4.7 and tA(BPRA, N=10) > .4 and p:hits > 5 and (start time - p:start time < -306 or start time - p:start time > -102) and (p:SO + op:SO) > 7

[JMon]

Play Tor under

Supporting SDQL by bases..on a heater

starter rest = 6 and s:starter rest = 6 and ss:starter rest < 9 and o:starter rest > 5 and os:starter rest = 5 and total > 7 and s:SRA < 7 and s:SHA < 8 and 0 < s:SWA < 6 and 1 < s:SSO < 9 and os:SRA != 0 and os:SHA < 11 and os:SSO < 10 and os:SHRA < 3 and SGS > 2 and ss:SRA < 6 and 3 < ss:SHA < 10 and 71 < s:SPT < 117 and 59 < os:SPT < 110 and month != 7

[JMon]

Play NYM un

(the query is suggesting other teams as well, including Balt un!!!,)

SDQL, by bases

H and -7 < ou streak < 2 and -6 < o: ou streak < 2 and SG < 4 and 5 > SGS > 2 and 11.5 > total > 6 and p:hits < 18 and op:hits < 17 and pp:hits < 18 and 3 < ppp:hits < 17 and pppp:hits < 16 and ppppp:hits < 15 and pppppp:hits > 2 and opp:hits < 15 and s:SRA < 5 and 0 < os:SRA < 10 and 2 < s:SHA < 10 and s:SHRA < 2 and os:SHRA < 3 and os:SWA < 7 and s:SSO > 3 and s:SHF < 33 and 16 < os:SHF < 34 and 73 < os:SPT < 110 and 76 < s:SPT < 117 and starter rest < 13 and o:starter rest < 11 and day != Monday and -22.5 < tS(ou margin, N=6) < 10.5 and -15 < oS(ou margin, N=6) < 18.5 and ss:SRA < 6 and ss:SHA > 2 and ss:SSO > 1 and ss:SHF > 19 and oss:SHF < 32 and 4 < s:starter rest < 9 and os:starter rest < 22 and game number < 154 and tS(O, N=10) < 7 and 23 < tS(runs, N=10) < 63 and 36 < tS(hits, N=6) < 65 and 1 < oS(errors, N=10) < 10

[emceeaye]

xtra support

p:HR = 2 and op:HR < 3 and SG < 5 and SG != 3 and 1 < SGS < 5 and s:SRA < 6 and os:SRA < 6 and (s:SHA + ss:SHA) < 17 and (os:SHA + oss:SHA) < 17 and 2.6 < tA(runs, N=10) < 6.8 and oA(runs, N=10) < 6.6 and total < 10.5 and 84 < os:SPT < 119 and starter rest < 20 and o:starter rest < 25 and (rest = 1 or rest = 0) and p:hits < 17 and 3 < op:hits < 18 and .8 < tA(doubles, N=10) < 2.5 and .8 < oA(doubles, N=10) < 3.1 and day != Wednesday and -2 < ou streak < 5 and -2 < ou streak < 3 and month < 10 and (game number < 107 or game number > 116) and tA(walks, N=10) > 1.9 and 1.9 < oA(walks, N=10) < 4.7 and tA(BPRA, N=10) > .4 and p:hits > 5 and (start time - p:start time < -306 or start time - p:start time > -102) and (p:SO + op:SO) > 7

Here's one that contradicts it but when you filter w/ SG=1 and month=8, its not that great of a record although w/ small sample size.

[emceeaye]

xtra support

p:HR = 2 and op:HR < 3 and SG < 5 and SG != 3 and 1 < SGS < 5 and s:SRA < 6 and os:SRA < 6 and (s:SHA + ss:SHA) < 17 and (os:SHA + oss:SHA) < 17 and 2.6 < tA(runs, N=10) < 6.8 and oA(runs, N=10) < 6.6 and total < 10.5 and 84 < os:SPT < 119 and starter rest < 20 and o:starter rest < 25 and (rest = 1 or rest = 0) and p:hits < 17 and 3 < op:hits < 18 and .8 < tA(doubles, N=10) < 2.5 and .8 < oA(doubles, N=10) < 3.1 and day != Wednesday and -2 < ou streak < 5 and -2 < ou streak < 3 and month < 10 and (game number < 107 or game number > 116) and tA(walks, N=10) > 1.9 and 1.9 < oA(walks, N=10) < 4.7 and tA(BPRA, N=10) > .4 and p:hits > 5 and (start time - p:start time < -306 or start time - p:start time > -102) and (p:SO + op:SO) > 7

Here's one that contradicts it but when you filter with SG=1 and month=8, its not that dramatic although now widdled down to small sample size.

H and -7 < ou streak < 2 and -6 < ou streak < 2 and SG < 4 and 5 > SGS > 2 and 11.5 > total > 6 and p:hits < 18 and op:hits < 17 and pp:hits < 18 and 3 < ppp:hits < 17 and pppp:hits < 16 and ppppp:hits < 15 and pppppp:hits > 2 and opp:hits < 15 and s:SRA < 5 and 0 < os:SRA < 10 and 2 < s:SHA < 10 and s:SHRA < 2 and os:SHRA < 3 and os:SWA < 7 and s:SSO > 3 and s:SHF < 33 and 16 < os:SHF < 34 and 73 < os:SPT < 110 and 76 < s:SPT < 117 and starter rest < 13 and o:starter rest < 11 and day != Monday and -22.5 < tS(ou margin, N=6) < 10.5 and -15 < oS(ou margin, N=6) < 18.5 and ss:SRA < 6 and ss:SHA > 2 and ss:SSO > 1 and ss:SHF > 19 and oss:SHF < 32 and 4 < s:starter rest < 9 and os:starter rest < 22 and game number < 154 and tS(O, N=10) < 7 and 23 < tS(runs, N=10) < 63 and 36 < tS(hits, N=6) < 65 and 1 < oS(errors, N=10) < 10

[JMon]

We road the Cubs in this dog spot in the Brewers series; Cubs are active again vs Mets.

Play Cubs

SDQL

Average(runs@team and season)<=4.3 and p:runs<5 and pp:runs<5 and ppp:runs<5 and pppp:runs<5 and line>=-105 and conference=o:conference and month!=7 and SG<4 and team=Cubs and 2014=season

[JMon]

This dog spot is under preforming this year, but still showing a profit and Southsiders have went 4-0 in this spot this year.

Play CWS

SDQL

H and -105 < line< 200 and p:L and op:A and (SG=1 or SG=3) and line<200 and total>7 and division!=o:division and season=2014 and team=White Sox

[BeanTownClown88]

Nice looking for reason to take cubs!

[JMon]

Play SF

SDQL:

WP < 53 and A(SWHIP@starter and season) < 1.2 and A(SOPW@starter and season) >= .333 and A(SSPB@starter and season) >= .50 and D and conference = NL and SG < 4 and line > 100 and month!= 9 and team=Phillies

[JMon]

Good spot to fade the Diamondbacks, in games series 2 or 3 we want to fade a road dog that went into extra innings their last two games.

Play Mia

SDQL

AD and p:X and pp:X and line <= 190 and (SG = 2 or SG=3) and total>6.5

[JMon]

Play Det

Here we want to fade a road dog of >=115, starting a pitcher with a win % of >=70; play against a AL starter with a whip of <=1.30 (not in May) 18-4 this season.

Supporting SDQL


line >= 115 and 100.0 * starter wins / (starter losses + starter wins) >= 70 and o:STDSWHIP <= 1.30 and o:conference = AL and A and month != 5

[JMon]

Gotta chime in I love this thread...follow y'all daily. Very much appreciate all of your hard work gentlemen, keep it up!

glad you like it

[emceeaye]

Play SF

SDQL:

WP < 53 and A(SWHIP@starter and season) < 1.2 and A(SOPW@starter and season) >= .333 and A(SSPB@starter and season) >= .50 and D and conference = NL and SG < 4 and line > 100 and month!= 9 and team=Phillies

Nice, I'm on it

[emceeaye]

query by I think by Bases on Reds/Rockies under

Here it is and see SG=2 and month=8 in recent years:

tA(doubles, N=10) < 1.9 and 8.9 < tA(hits, N=10) < 10.4 and .5 < tA(HR, N=10) < 1.3 and 1 < oA(doubles, N=10) < 1.7 and oA(hits, N=10) < 9.9 and oA(HR, N=10) < 1.1 and SG < 4 and 5 > SGS > 2 and p:HR < 3 and p:hits < 15 and 18 > pp:hits > 4 and 3 < ppp:hits < 16 and 3 < pppp:hits < 13 and ppppp:hits < 15 and pppppp:hits < 15 and ppppppp:hits > 6 and op:hits < 13 and s:SRA < 7 and s:SHRA < 2 and os:SRA < 8 and os:SPT < 122

[emceeaye]

Play Det

Here we want to fade a road dog of >=115, starting a pitcher with a win % of >=70; play against a AL starter with a whip of <=1.30 (not in May) 18-4 this season.

Supporting SDQL


line >= 115 and 100.0 * starter wins / (starter losses + starter wins) >= 70 and o:STDSWHIP <= 1.30 and o:conference = AL and A and month != 5

More support for Detroit:

s:SRA = 1 and s:SIP < 7 and s:SHA < 7 and s:SWA < 6 and 0 < s:SSO < 8 and 74 < s:SPT < 109 and starter rest < 10 and day != Wednesday and day != Thursday and 6 < p:hits < 18 and 3 < pp:hits < 14 and game number < 165 and (game number < 79 or game number > 89) and (game number > 28 or game number < 20) and line > -220 and -5 < streak < 5 and o:streak < 4 and op:hits < 15

[JMon]

Here it is and see SG=2 and month=8 in recent years:

tA(doubles, N=10) < 1.9 and 8.9 < tA(hits, N=10) < 10.4 and .5 < tA(HR, N=10) < 1.3 and 1 < oA(doubles, N=10) < 1.7 and oA(hits, N=10) < 9.9 and oA(HR, N=10) < 1.1 and SG < 4 and 5 > SGS > 2 and p:HR < 3 and p:hits < 15 and 18 > pp:hits > 4 and 3 < ppp:hits < 16 and 3 < pppp:hits < 13 and ppppp:hits < 15 and pppppp:hits < 15 and ppppppp:hits > 6 and op:hits < 13 and s:SRA < 7 and s:SHRA < 2 and os:SRA < 8 and os:SPT < 122

This is a good one; I can't believe I didn't have this one saved, but will now Thanks emc

[JMon]

More support for Detroit:

s:SRA = 1 and s:SIP < 7 and s:SHA < 7 and s:SWA < 6 and 0 < s:SSO < 8 and 74 < s:SPT < 109 and starter rest < 10 and day != Wednesday and day != Thursday and 6 < p:hits < 18 and 3 < pp:hits < 14 and game number < 165 and (game number < 79 or game number > 89) and (game number > 28 or game number < 20) and line > -220 and -5 < streak < 5 and o:streak < 4 and op:hits < 15

another Damn thinking about a parlay tonight. Hardly play them but......

[JMon]

Here it is and see SG=2 and month=8 in recent years:

tA(doubles, N=10) < 1.9 and 8.9 < tA(hits, N=10) < 10.4 and .5 < tA(HR, N=10) < 1.3 and 1 < oA(doubles, N=10) < 1.7 and oA(hits, N=10) < 9.9 and oA(HR, N=10) < 1.1 and SG < 4 and 5 > SGS > 2 and p:HR < 3 and p:hits < 15 and 18 > pp:hits > 4 and 3 < ppp:hits < 16 and 3 < pppp:hits < 13 and ppppp:hits < 15 and pppppp:hits < 15 and ppppppp:hits > 6 and op:hits < 13 and s:SRA < 7 and s:SHRA < 2 and os:SRA < 8 and os:SPT < 122

Morales was scratched...noticed some pitcher parameters within the queries...emc is this going to affect it?

[Alex Vaile]

I found this one from Bases.

It points to Oakland Colorado and Texas and unders in all as well.
(s:SPT + ss:SPT) > 222 and s:SPT > 96 and ss:SPT < 132 and 58 < sss:SPT < 123 and s:SHA < 8 and s:SRA < 6 and ss:SRA < 7 and sss:SRA < 6 and ss:SHA > 3 and 7 > s:SWA > 0 and ss:SWA < 6 and sss:SWA < 4 and starter rest < 9 and s:starter rest < 8 and s:SSO > 3 and 12 > ss:SSO > 2 and total < 11 and p:hits < 16 and 19 > pp:hits > 3 and 1 < ppp:hits < 22 and streak < 6 and ou streak > -5 and game number > 30 and 8 > os:SRA > 0 and 14 > o:starter rest > 4 and 23 > os:starter rest > 3 and 24.5 > (s:SIP + ss:SIP + sss:SIP) > 16 and (os:SIP + oss:SIP + osss:SIP) > 11.35 and o:streak < 5 and oA(hits, N=10) < 11 and tA(doubles, N=10) < 2.9 and tA(BPRA, N=10) < 2.5 and oA(BPRA, N=10) > .4


Im already playing Atlanta but so I wont play Oakland but ill take a stab with Rangers.
5th play:

Rangers + 189

Pitching change so ill take rockies off because I can't find a line at my book.

[emceeaye]

Morales was scratched...noticed some pitcher parameters within the queries...emc is this going to affect it?

Didn't know that...I think It'll affect the outcome. Thanks for the update. Its a no go now for me.

[hyahya]

Here's one pointing to the dbacks:

AD and season > 2010 and month != 7 and p:hits < 8 and pp:hits > 6 and 18 > ppp:hits > 2 and pppp:hits > 5 and 17 > ppppp:hits > 4 and 16 > op:hits > 6 and s:SRA < 6 and streak > -5 and SG < 4 and line < 190 and total < 10.01 and 1.9 > STDSWHIP > 1.2

[emceeaye]

another Damn thinking about a parlay tonight. Hardly play them but......

Me either but it might help to narrow down the best picks, right? How bout small amount on a parlay of 3-5?
Who would you go with?

Mets under, dodgers su, Detroit su,white Sox SU?

Or

Toronto under, mets under, Dodgers SU, tigers SU, tigers under....

[hyahya]

mariners:

180 >= line >= 100 and tA(runs) <= 4.2 and o:STDSERA <= 3.5 and o:conference = AL and (p:runs + po:runs) <= 3 and 2009 <= season and o:rest = 0 and total > 6.5

[Alex Vaile]

Lots of info again today. Good work everyone!
Just checked the Az query. It's 8 and 14 last 22.

[JMon]

Here's one pointing to the dbacks:

AD and season > 2010 and month != 7 and p:hits < 8 and pp:hits > 6 and 18 > ppp:hits > 2 and pppp:hits > 5 and 17 > ppppp:hits > 4 and 16 > op:hits > 6 and s:SRA < 6 and streak > -5 and SG < 4 and line < 190 and total < 10.01 and 1.9 > STDSWHIP > 1.2

nice hyahya...eliminates Mia

[JMon]

Damn information overload today guys.. LOL

[hyahya]

This one is not going to get me off the dodgers but fyi:



s:SHRA = 0 and ss:SHRA = 1 and sss:SHRA = 1 and SG < 4 and starter rest < 10 and s:SIP < 7.5 and s:SRA < 4 and ss:SRA < 9 and op:HR < 2 and p:HR < 3 and pp:HR < 3 and 3 < p:hits < 18 and 2 < pp:hits < 16 and ppp:hits > 2 and op:hits < 18 and opp:hits < 17 and oppp:hits < 18 and 1 < os:SHA < 9 and 1 < oss:SHA < 8 and os:SWA < 5 and os:SPT < 119 and day != Thursday and line < 200