MLB - Situation Plays - SDQL

emceeaye · 08-15-14, 01:45 PM

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 · 08-15-14, 01:48 PM

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

posey · 08-15-14, 01:48 PM

Originally posted by emceeaye

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 · 08-15-14, 01:52 PM

Originally posted by hyahya

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 · 08-15-14, 01:54 PM

Originally posted by Alex Vaile

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 · 08-15-14, 01:56 PM

Originally posted by emceeaye

Can you please post the query?

Will do when I get back home.

JMon · 08-15-14, 01:58 PM

Originally posted by hyahya

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 · 08-15-14, 02:00 PM

Originally posted by emceeaye

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 · 08-15-14, 02:08 PM

Originally posted by emceeaye

(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 · 08-15-14, 02:14 PM

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 · 08-15-14, 02:18 PM

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 · 08-15-14, 02:20 PM

Originally posted by JMon

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 · 08-15-14, 02:22 PM

Originally posted by JMon

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 < o

u 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 · 08-15-14, 02:27 PM

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 · 08-15-14, 02:32 PM

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 · 08-15-14, 02:57 PM

Nice looking for reason to take cubs!

JMon · 08-15-14, 03:27 PM

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 · 08-15-14, 03:29 PM

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 · 08-15-14, 03:37 PM

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 · 08-15-14, 03:37 PM

Originally posted by mdunlap3

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 · 08-15-14, 03:40 PM

Originally posted by 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

Nice, I'm on it

emceeaye · 08-15-14, 03:58 PM

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 · 08-15-14, 04:11 PM

Originally posted by 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

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 · 08-15-14, 04:16 PM

Originally posted by emceeaye

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 · 08-15-14, 04:21 PM

Originally posted by emceeaye

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 · 08-15-14, 04:28 PM

Originally posted by emceeaye

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 · 08-15-14, 04:33 PM

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 · 08-15-14, 04:55 PM

Originally posted by JMon

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 · 08-15-14, 04:57 PM

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 · 08-15-14, 05:14 PM

Originally posted by JMon

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 · 08-15-14, 05:15 PM

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 · 08-15-14, 05:24 PM

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

JMon · 08-15-14, 05:26 PM

Originally posted by 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

nice hyahya...eliminates Mia

JMon · 08-15-14, 05:27 PM

Damn information overload today guys.. LOL

hyahya · 08-15-14, 05:30 PM

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