MLB - Situation Plays - SDQL

**emceeaye** · 08-11-14, 12:10 PM

Bases query pointing to Rays/Rangers under today

Nice WP on Mondays and in August:

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

**Alex Vaile** · 08-11-14, 12:56 PM

3 and 3 yesterday on posted plays for -.15 units.
71 and 62 overall
+ 4.26 units

Seattle easy winner from amazing stat info and I should have played that Nats under but didnt. Best of luck today everyone!

**Alex Vaile** · 08-11-14, 01:06 PM

First play for Monday:
My own creation

Orioles -133
team=Orioles and HF and p:L and pp:W and ppp:W

Orioles 14 and 4 in last 18 in this situation and I like them to crush Capuano today. Yanks solid in this spot as well but Ill take the better lineup at home.

**emceeaye** · 08-11-14, 02:54 PM

Originally posted by Alex Vaile

First play for Monday:
My own creation

Orioles -133
team=Orioles and HF and p:L and pp:W and ppp:W

Orioles 14 and 4 in last 18 in this situation and I like them to crush Capuano today. Yanks solid in this spot as well but Ill take the better lineup at home.

Nice rationale! Here is another query from I think Jmon supporting it: I added Monday.

site = home and p:line < -105 and line < -105 and p:runs+2 <=po:runs and p:SG=3 and SG=1 and 2013 <=season and day=Monday

**JMon** · 08-11-14, 03:19 PM

Play LAD

Here we want to fade a fav of <=-150; a team averaging .9 HRs or less off b2b team left on base of 10 or more. Better in non divisional games! Let's root this nice doggies in boys!

SDQL is

line<=-150 and tA(HR)<=.9 and p:TLOB>=10 and pp:TLOB>=10 and total<9

**JMon** · 08-11-14, 03:41 PM

Originally posted by Alex Vaile

First play for Monday:
My own creation

Orioles -133
team=Orioles and HF and p:L and pp:W and ppp:W

Orioles 14 and 4 in last 18 in this situation and I like them to crush Capuano today. Yanks solid in this spot as well but Ill take the better lineup at home.

BOL on your 'own creation' ....like to see this hit buddy

**emceeaye** · 08-11-14, 04:20 PM

Originally posted by JMon

Play LAD

Here we want to fade a fav of <=-150; a team averaging .9 HRs or less off b2b team left on base of 10 or more. Better in non divisional games! Let's root this nice doggies in boys!

SDQL is

line<=-150 and tA(HR)<=.9 and p:TLOB>=10 and pp:TLOB>=10 and total<9

Really nice Jmon!

I wanted to see how runs scored relative to TLOB affected the results kind of as a Litmus test for what seems like a very straightforward and effective query; I added a term to the end of it, and see what it does to RL.

line<=-150 and tA(HR)<=.9 and p:TLOB>=10 and pp:TLOB>=10 and total<9 and .61>tA(runs, N=15)/tA(TLOB, N=15)

**JMon** · 08-11-14, 04:28 PM

Originally posted by emceeaye

Really nice Jmon!

I wanted to see how runs scored relative to TLOB affected the results kind of as a Litmus test for what seems like a very straightforward and effective query; I added a term to the end of it, and see what it does to RL.

line<=-150 and tA(HR)<=.9 and p:TLOB>=10 and pp:TLOB>=10 and total<9 and .61>tA(runs, N=15)/tA(TLOB, N=15)

**JMon** · 08-11-14, 05:05 PM

Originally posted by tarosill

Here is another one similar to the previous query. These two, combined together make a nice set of complementary queries.

HF and line < -130 and tS(hits) / tS(at bats) < 0.25 and p:RMAX < 6 and o:STDSERA >= 4.8 and 1 < os:SIP < 9 and o:starter rest < 8 and 0.21 < tS(o:hits, N=18) / tS(o:at bats, N=18) < 0.26 and conference = AL

nice one...noticed if you omit sundays and series game above 3, improves this doggie nicely. (10-3 this season).

**Alex Vaile** · 08-11-14, 06:04 PM

Originally posted by JMon

BOL on your 'own creation' ....like to see this hit buddy

Thanks. Hope so too!

**Alex Vaile** · 08-11-14, 06:50 PM

Unbelievable play in Oriole game hope it doesnt end up the difference.

**Alex Vaile** · 08-12-14, 12:27 AM

Originally posted by Alex Vaile

First play for Monday:
My own creation

Orioles -133
team=Orioles and HF and p:L and pp:W and ppp:W

Orioles 14 and 4 in last 18 in this situation and I like them to crush Capuano today. Yanks solid in this spot as well but Ill take the better lineup at home.

Well it took a little longer than I thought but turned out how I envisioned it. Winner!

**Alex Vaile** · 08-12-14, 12:43 AM

Originally posted by JMon

Play LAD

Here we want to fade a fav of <=-150; a team averaging .9 HRs or less off b2b team left on base of 10 or more. Better in non divisional games! Let's root this nice doggies in boys!

SDQL is

line<=-150 and tA(HR)<=.9 and p:TLOB>=10 and pp:TLOB>=10 and total<9

I played it with you. Nice win! Thanks for the info

**JMon** · 08-12-14, 07:26 AM

Originally posted by Alex Vaile

Well it took a little longer than I thought but turned out how I envisioned it. Winner!

**BeanTownClown88** · 08-12-14, 07:38 AM

Sweet game to win!

**emceeaye** · 08-12-14, 08:43 AM

good pics all the way around guys

good job with Dodgers and Orioles guys!! I went with those plus the Rays/ Rangers under in seattle straight up, and overall everything turned out well! however I did get burned on the Mariners under and the Rangers straight up.

**Alex Vaile** · 08-12-14, 09:00 AM

First posted play for Tuesday:
(Bases or JMon)
HF and 13 >= p:margin >= 6 and s:margin > 0 and SG > 1 and os:margin < 0 and tS(runs, N=9) > oS(runs, N=9) and tA(BPRA, N=10) < oA(BPRA,N=10)

Play the Mariners -120

**Alex Vaile** · 08-12-14, 09:02 AM

1 and 0 yesterday for 1 unit
72 and 62 overall
+ 5.26 units

**Alex Vaile** · 08-12-14, 09:02 AM

Originally posted by emceeaye

good job with Dodgers and Orioles guys!! I went with those plus the Rays/ Rangers under in seattle straight up, and overall everything turned out well! however I did get burned on the Mariners under and the Rangers straight up.

4 and 2 still a great day!

**tarosill** · 08-12-14, 10:01 AM

Originally posted by JMon

nice one...noticed if you omit sundays and series game above 3, improves this doggie nicely. (10-3 this season).

Yes I agree, Sundays should be omitted.

**tarosill** · 08-12-14, 10:11 AM

Originally posted by Alex Vaile

First posted play for Tuesday:
(Bases or JMon)
HF and 13 >= p:margin >= 6 and s:margin > 0 and SG > 1 and os:margin < 0 and tS(runs, N=9) > oS(runs, N=9) and tA(BPRA, N=10) < oA(BPRA,N=10)

Play the Mariners -120

I like this one. It's straightforward and easy to understand. I tweaked a bit so here is the final result.

HF and p:margin > 6 and s:W and 1 < SG < 5 and os:L and tS(runs, N=9) >= oS(runs, N=9) and p:BPRA < 3

**Alex Vaile** · 08-12-14, 02:43 PM

Originally posted by tarosill

I like this one. It's straightforward and easy to understand. I tweaked a bit so here is the final result.

HF and p:margin > 6 and s:W and 1 < SG < 5 and os:L and tS(runs, N=9) >= oS(runs, N=9) and p:BPRA < 3

Nice adjustments!

**Alex Vaile** · 08-12-14, 02:47 PM

Second play:

Under 7 + 105 Brewers vs Cubs (Bases)

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** · 08-12-14, 02:56 PM

Third pick: (Dr.M)

Houston - 144

team=Twins and season=2014 and oS:W and oS:season=season

Twins 0 and 12 this season in this spot.

**JMon** · 08-12-14, 03:46 PM

Play Cubs

SDQL is

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

**JMon** · 08-12-14, 03:48 PM

Originally posted by Alex Vaile

Third pick: (Dr.M)

Houston - 144

team=Twins and season=2014 and oS:W and oS:season=season

Twins 0 and 12 this season in this spot.

Supports Astros play

streak = -2 and o:streak = 2 and 4 > SG > 1 and (H or day != Sunday) and (H or conference = NL) and SGS > 2 and 1 < p:hits < 13 and 2 < pp:hits < 13 and ppp:hits > 7 and p:margin > -9 and pp:margin > -11 and opp:margin < 11 and op:hits > 7 and opp:hits < 16 and op:HR + opp:HR != 0 and op:TLOB + opp:TLOB < 22 and 0 < s:SSO < 10 and os:SHRA < 4 and os:SHF < 33 and 4 < o:starter rest < 7 and line < 150 and season = 2014

**JMon** · 08-12-14, 04:12 PM

Play; Mariners, Orioles, and Rays

SDQL

p:margin<-6 and conference=AL and 11>=total>=7 and SG<4 and line>=-200 and rest=0

**JMon** · 08-12-14, 04:16 PM

Play Oak

SDQL

H and line >100 and tA(HR) <= .9 and 1.4 >= STDSWHIP >= 1.3 and A(o:SHRA@o:starter and o:season) <= .5 and conference = AL and rest = 0 and SG<4

A and line<=-125 and Sum(hits@team and season)/Sum(at bats@team and season)<=.265 and t:conference=AL and 9 * oS(o:earned runs - starter earned runs) / oS(9 - starter innings pitched)<=3.75 and sA(SHRA)<=.5 and 2009<=season

**JMon** · 08-12-14, 04:19 PM

Tuesday NL Home dog normally a good spot...play Cubs, Marlins, Mets, Giants

Simple SDQL

site==home and -105< line and day=Tuesday and conference=NL

**JMon** · 08-12-14, 04:37 PM

Play Reds over

SDQL by bases

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

**emceeaye** · 08-12-14, 05:02 PM

Query on Indians and Angels

Here's an interleague game query favoring Indians and Angels. Despite WP, I'm skeptical of Angels due to CJ Wilson's horrible recent performances...

playoffs==0 and conference==NL and o:conference==AL and (site=='away' and -105 < line) and line > 154 and SG = 1

**JMon** · 08-12-14, 05:06 PM

Originally posted by emceeaye

Here's an interleague game query favoring Indians and Angels. Despite WP, I'm skeptical of Angels due to CJ Wilson's horrible recent performances...

playoffs==0 and conference==NL and o:conference==AL and (site=='away' and -105<line) and line>154 and SG=1

your sdql is jumbled, but oddly enough when I reply to your post, I can see it correctly.

**emceeaye** · 08-12-14, 05:15 PM

Originally posted by JMon

your sdql is jumbled, but oddly enough when I reply to your post, I can see it correctly.

Yes, it keeps doing that when I post unfortunately...I added some spaces and it is visible now in original post...what do you think?

**inZane** · 08-12-14, 05:17 PM

Hey JMon, thanks for posting your picks. So on tonight's card you like the Mariners, O's, Rays, Cubs, Marlins, Mets, Giants, and the Red's over. Are these all for the same amount, or do you like some more than others? Btw, go Broncos!!!

**JMon** · 08-12-14, 06:22 PM

Originally posted by inZane

Hey JMon, thanks for posting your picks. So on tonight's card you like the Mariners, O's, Rays, Cubs, Marlins, Mets, Giants, and the Red's over. Are these all for the same amount, or do you like some more than others? Btw, go Broncos!!!

ya and the A's. Not sure about SF. I flat bet everything