MLB - Situation Plays - SDQL

**emceeaye** · 09-24-14, 07:37 AM

brewers/reds under

can't remember whose query this is, but it's pointing to brewers/reds under today:

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

**emceeaye** · 09-24-14, 07:40 AM

d-backs/twins under

Here is a query by Jmon I believe favoring d-backs/twins under:

7.5>=total>=7.0 and 4.2>=STDSERA>=3.7 and conference=NL and o:STDSWHIP<=1.3 and o:conference=AL and rest=0

**Alex Vaile** · 09-24-14, 11:15 AM

2 and 3 yesterday for - 1.85 units
137 and 111 overall
+ 16.05 units

**Alex Vaile** · 09-24-14, 05:19 PM

First play : ( Bases )

Under 7.5 - 110 Red Sox vs Rays

season > 2008 and H and 10 > month > 5 and SG < 4 and 5 > streak > -5 and 1 > tA(HR) > .7 and s:SRA < 6 and p:hits < 11 and 16 > op:hits > 4 and sss:SRA < 4 and rest = 0 and p:home runs < 2 and os:SSO < 11 and oss:SSO < 10 and os:SHA < 11 and 2 < oss:SHA < 11 and p:IT < 6 and p:LOB < 21 and s:SPT < 122 and ss:SPT < 119 and team != Rockies and team != Athletics and o:team != Blue Jays and (p:errors + pp:errors + ppp:errors + pppp:errors + ppppp:errors + pppppp:errors) < 10 and (op:errors + opp:errors + oppp:errors + opppp:errors + oppppp:errors + opppppp:errors) < 8 and (p:temperature < 91 or p:temperature = Indoors)

**emceeaye** · 09-24-14, 05:23 PM

Nats su

series of same tweaked query with data customized to today's game points to Nats su:

A and line>150 and tA(W)<.50 and p:runs<=2 and p:L and season>=2008 and SG=2 and day=Wednesday and os:SRA<=2 and oss:SRA<=3 and os:SRA + oss:SRA<=5 and (oS:SRA + oSS:SRA + oSSS:SRA + oSSSS:SRA)>=5

A and line>150 and tA(W)<.50 and p:runs<=2 and p:L and season>=2008 and SG=2 and day=Wednesday

A and line>150 and tA(W)<.50 and p:runs<=2 and p:L and season>=2008

**emceeaye** · 09-25-14, 12:26 PM

Yankees/Orioles under

starter = Hiroki Kuroda and s:SIP > 6 and team = Yankees and LGS

Add "and LGS" and see record improve but decrease in already small sample size

**emceeaye** · 09-25-14, 12:50 PM

Tigers su

Here's one (by Jmon I think) pointing to Tigers SU:

(team=Twins or team=Rangers) and D and oS:W and oS:season=season and season>=2012

Get rid of team =Rangers and add SG=1...and day=Thursday just to make sure...

Looks solid...plus, intuitively it looks right, because May sucks and Scherzer good in last start, and solid over last 3 starts and at home in general.

Since juice is ridiculously high, what about at least a little bit on parlaying this with Yankees/Orioles under, Padres/Giants under, and Giants (NFL) ATS (courtesy of Dr. M)? I may just do this by round robin by 2s.

**Alex Vaile** · 09-26-14, 10:34 AM

0 and 1 on Wednesday for -1.1 units
137 and 112 overall
+14.95 units

**Alex Vaile** · 09-26-14, 11:39 AM

First 2 plays: ( Bases )

Under 7.5 - 125 Astros vs Mets
Under 8 - 105 Royals vs White Sox

season > 2008 and H and 10 > month > 5 and SG < 4 and 5 > streak > -5 and 1 > tA(HR) > .7 and s:SRA < 6 and p:hits < 11 and 16 > op:hits > 4 and sss:SRA < 4 and rest = 0 and p:home runs < 2 and os:SSO < 11 and oss:SSO < 10 and os:SHA < 11 and 2 < oss:SHA < 11 and p:IT < 6 and p:LOB < 21 and s:SPT < 122 and ss:SPT < 119 and team != Rockies and team != Athletics and o:team != Blue Jays and (p:errors + pp:errors + ppp:errors + pppp:errors + ppppp:errors + pppppp:errors) < 10 and (op:errors + opp:errors + oppp:errors + opppp:errors + oppppp:errors + opppppp:errors) < 8 and (p:temperature < 91 or p:temperature = Indoors)

**emceeaye** · 09-26-14, 11:58 AM

Dodgers/Rockies over

Bases query pointing to Doyers/Rockies over:

SG = 1 and day = Friday and H and 10.5 > total > 7 and 12.6 > oA(hits, N=10) > 9.1 and 9.2 < tA(hits, N=10) < 12.6 and 12 > s:SHA > 4 and s:SRA != 0 and s:SPT > 83 and 119 > os:SPT > 69 and o:starter rest < 10 and 19 > p:hits > 4 and op:hits > 4 and oA(walks, N=10) < 4.7 and ss:SPT < 116 and oA(HR, N=10) < 1.8 and tA(HR, N=10) < 2 and p:HR < 4 and oA(errors, N=10) < 1.1 and tA(errors, N=10) > .1

**emceeaye** · 09-26-14, 12:15 PM

tigers/twins over

Bases query pointing to tigers/twins over:

p:HR = 2 and SG = 2 and day = Friday and op:HR < 3 and SG < 5 and SG != 3 and 1 < SGS < 5 and pp:HR < 2 and opp:HR < 3 and p:hits < 18 and pp:hits < 15 and ppp:hits < 14 and pppp:hits < 10 and op:hits < 18 and 3 < opp:hits < 17 and oppp:hits < 13 and 4 < opppp:hits < 18 and p:walks < 7 and op:walks < 6 and p:doubles != 0 and pp:doubles < 4 and ppp:doubles < 3 and pppp:doubles < 3 and op:doubles < 5 and opp:doubles < 5 and oppp:HR < 3 and conference = o:conference and o:division != AL West and s:SHRA < 3

**JMon** · 09-26-14, 01:58 PM

PLay NYM ML and UNDER

SDQL: space after o:

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) and team=Mets and 2014=season

**b1slickguy** · 09-26-14, 04:47 PM

Anyone else having issues accessing query links at KS? SDB is working fine here.
Sent an email to KS support.
Good luck.

**Alex Vaile** · 09-27-14, 02:14 AM

2 and 0 today for + 2 units
139 and 112 overall
+ 16.95 units

**Alex Vaile** · 09-27-14, 02:15 AM

Originally posted by emceeaye

Bases query pointing to Doyers/Rockies over:

SG = 1 and day = Friday and H and 10.5 > total > 7 and 12.6 > oA(hits, N=10) > 9.1 and 9.2 < tA(hits, N=10) < 12.6 and 12 > s:SHA > 4 and s:SRA != 0 and s:SPT > 83 and 119 > os:SPT > 69 and o:starter rest < 10 and 19 > p:hits > 4 and op:hits > 4 and oA(walks, N=10) < 4.7 and ss:SPT < 116 and oA(HR, N=10) < 1.8 and tA(HR, N=10) < 2 and p:HR < 4 and oA(errors, N=10) < 1.1 and tA(errors, N=10) > .1

Thanks for posting! Rode on this one for the win with you.

**emceeaye** · 09-27-14, 09:59 AM

Originally posted by Alex Vaile

Thanks for posting! Rode on this one for the win with you.

**Alex Vaile** · 09-27-14, 12:59 PM

First 3 plays : ( Bases )

Under 7 - 115 Padres vs Giants
Under 7.5 - 125 Braves vs Phillies
Under 8.5 - 115 Twins vs Tigers

season > 2008 and H and 10 > month > 5 and SG < 4 and 5 > streak > -5 and 1 > tA(HR) > .7 and s:SRA < 6 and p:hits < 11 and 16 > op:hits > 4 and sss:SRA < 4 and rest = 0 and p:home runs < 2 and os:SSO < 11 and oss:SSO < 10 and os:SHA < 11 and 2 < oss:SHA < 11 and p:IT < 6 and p:LOB < 21 and s:SPT < 122 and ss:SPT < 119 and team != Rockies and team != Athletics and o:team != Blue Jays and (p:errors + pp:errors + ppp:errors + pppp:errors + ppppp:errors + pppppp:errors) < 10 and (op:errors + opp:errors + oppp:errors + opppp:errors + oppppp:errors + opppppp:errors) < 8 and (p:temperature < 91 or p:temperature = Indoors)

**Alex Vaile** · 09-28-14, 12:59 AM

2 and 1 today for + .85 units
141 and 113
+ 17.8 units

**FlyinAir** · 09-28-14, 01:49 AM

Originally posted by FlyinAir

Before MLB season even started, I wanted to keep track (write down, put on Word sheet, whatever) Every single SQDL.

Anybody have the time to do so?
Anybody want to split it up (pg 1 thru 20 type thing)
Make a beautiful SDQL packet

Same goes for last years SDQL NBA - for this years season.

Just an idea.

Most of you said you HAVE SAVED your situations (and previous years) MLB SDQL's...Jmon, I was mostly around during the NBA thread and didn't bet ass on mlb sdql's this year but we all know how these are gold. -- Thinking though that we have 74 pages of it, why not list it? (Wanting too cause I don't have all these gold mine sqdl's in my back pocket, let alone a save sheet.
Anyone willing to start it up, I'm in for it... Thanks guys

**JMon** · 09-28-14, 04:46 AM

Flyinair, they have already been given to you once in this thread. Do a little work and go through it and copy them down.

**JMon** · 09-28-14, 10:31 AM

ref post #750

Situation A: Fade a Sunday NL Getaway team

2014 tracking results on the fade: 28-53 (34.6%) (+1910)

Last week (+90)

Fading (play against)

Cubs
Braves
Rockies

**JMon** · 09-28-14, 10:34 AM

ref post #750

Situation B: Sunday Under Getaway

2014 tracking results over-under-push: 44-49-3 (+0)

Last week: (-160)

Play under

CHC
STL
COL
HOU

**emceeaye** · 09-28-14, 11:35 AM

orioles/blue jays under and mariners/angels under

Bases query pointing to Balt/Tor under and Sea/LAA under:

p:RMAX = 1 and SG=3 and day=Sunday and month=9 and p:runs = 2 and SG < 4 and SGS = 3 and op:runs < 5 and 0 < po:runs < 5 and op:HR < 2 and op:hits > 2 and 3 < p:hits < 13 and tS(HR, N=4) < 7 and 3 < oS(HR, N=10) < 14 and tS(hits, N=10) < 103 and oS(hits, N=10) < 104 and -23 < oS(ou margin, N=10) < 16 and os:SHRA < 3 and day != Wednesday and 0 > ou streak > -6 and p:doubles < 4 and s:SHF < 33 and os:SHF < 33 and s:SPT < 115 and o:starter rest < 16

**emceeaye** · 09-28-14, 11:38 AM

orioles/blue jays under, brewers/cubs under, mets/astros under

Bases query:

day = Sunday and SG = 3 and month = 9 and 0 < s:SRA < 8 and 0 < os:SRA < 6 and (163 > game number > 126 or 103 > game number > 77) and starter rest < 11 and 113 > s:SPT > 58 and 118 > os:SPT > 52 and (H or F) and (s:SWA + ss:SWA + sss:SWA) > 1 and 3.9 > (tA(BPRA) + oA(BPRA)) > 2.1 and (s:SHRA + ss:SHRA + sss:SHRA + ssss:SHRA) < 6 and os:SHRA < 3 and (p:HR + pp:HR + ppp:HR + pppp:HR) < 9 and streak > -5 and o:streak > -7 and ou streak < 3 and (p:fly balls + pp:fly balls + ppp:fly balls) > 9 and (op:fly balls + opp:fly balls + oppp:fly balls + opppp:fly balls) > 14 and 3 < (s:SSO + ss:SSO) < 17 and os:SSO < 9

**nash13** · 09-29-14, 08:03 AM

hi guys, in my research on the web i read something about the effect of umpires on totals. is there a query to work on this on sdql?

**JMon** · 09-29-14, 10:15 AM

Originally posted by nash13

hi guys, in my research on the web i read something about the effect of umpires on totals. is there a query to work on this on sdql?

don't know what you are looking for, but there is a parameter for umpires or the shortcut is HPU

**nash13** · 09-29-14, 11:12 AM

thx a lot, i will post some insight later.

**emceeaye** · 09-29-14, 03:16 PM

Well, it has certainly been lucrative this baseball season with the help of everyone posting so many different SDQL queries. Its just too bad the season's almost over with only a handful of games left (and no more regular season games left). I feel like it was hard work, but definitely worth it, especially having a good number of queries that will come in handy for next season. Now I can only sigh at the thought of doing all that hard work again, that is to generate/acquire enough queries to sample enough key variables that influence outcomes in NFL in order to make enough correct picks to make a profit.

**nash13** · 09-29-14, 03:41 PM

Originally posted by emceeaye

Well, it has certainly been lucrative this baseball season with the help of everyone posting so many different SDQL queries. Its just too bad the season's almost over with only a handful of games left (and no more regular season games left). I feel like it was hard work, but definitely worth it, especially having a good number of queries that will come in handy for next season. Now I can only sigh at the thought of doing all that hard work again, that is to generate/acquire enough queries to sample enough key variables that influence outcomes in NFL in order to make enough correct picks to make a profit.

i am working on a rating system for those queries. based on number of games, roi, profit and recent success. it will not be perfect, but may help to select the real good ones. i did this for the NBA and based on the sportsdatabase google group.

**nash13** · 09-29-14, 04:45 PM

My best performing queries this year for MLB were:
tp:runs <= 2 and op:runs <= 2 and conference = AL
HD and tA(W) < .42 and month < 7 and division = o:division
AD and division=o:division and p:W and playoffs=0 and day!=Saturday and day!=Sunday and temperature<85

+37.40 Units

**JMon** · 09-29-14, 04:48 PM

Originally posted by nash13

i am working on a rating system for those queries. based on number of games, roi, profit and recent success. it will not be perfect, but may help to select the real good ones. i did this for the NBA and based on the sportsdatabase google group.

thanks nash...please don't post all queries here, but I am sure the few who worked hard on this thread during the MLB grind would appreciate a PM if you are willing.

**JMon** · 09-29-14, 04:52 PM

Originally posted by emceeaye

Well, it has certainly been lucrative this baseball season with the help of everyone posting so many different SDQL queries. Its just too bad the season's almost over with only a handful of games left (and no more regular season games left). I feel like it was hard work, but definitely worth it, especially having a good number of queries that will come in handy for next season. Now I can only sigh at the thought of doing all that hard work again, that is to generate/acquire enough queries to sample enough key variables that influence outcomes in NFL in order to make enough correct picks to make a profit.

It's been fun comrade

. I appreciate your hard work and diligence in this thread. Many don't believe the power of SDQL, but proof is right in this 74 page thread with 70+K views. I will look forward to next season where I will start the thread with new and different conditions in regards to posting- more organized and tracking to say the least.

Now would be the time to concentrate on NFL!

**emceeaye** · 09-29-14, 05:38 PM

Originally posted by nash13

i am working on a rating system for those queries. based on number of games, roi, profit and recent success. it will not be perfect, but may help to select the real good ones. i did this for the NBA and based on the sportsdatabase google group.

really good idea! That would be useful

**JMon** · 09-29-14, 05:46 PM

A person almost feels lost not having to cap MLB

. I miss it already

**mdunlap3** · 09-29-14, 06:00 PM

Really gonna miss this thread here also..I learned so much from guys like vaile,nash,bases,jmon,etc...all the information you guys have provided me really is invaluable to me. Thank you. Really hope you all are down for some hoops this year tho eh?