MLB - Situation Plays - SDQL

**Alex Vaile** · 08-06-14, 12:33 PM

Fourth and fifth play for Weds: Courtesy of Bases

Oakland A's - 1.5 +105
Oakland A's -189

(so:inning runs so:R1 = 3 or so:inning runs so:R1 = 4) and SG != 2 and 5 > SGS > 1 and s:SRA < 10 and 3 < s:SHA < 10 and s:SWA < 5 and 6 > s:SSO > 1 and starter rest < 17 and s:SPT > 56 and os:SRA < 8 and s:SHRA < 4 and os:SHRA < 2 and os:SPT > 69 and o:starter rest < 18 and p:hits < 12 and 0 < ss:SSO < 12 and ss:SPT > 66 and -8 < os:margin < 6 and tA(hits,N=10) > 6.8 and oA(LOB, N=10) < 18.5 and 1.4 < oA(walks, N=10) < 4.8 and tA(walks, N=10) > 1.7

**Alex Vaile** · 08-06-14, 12:41 PM

Sixth play:
Courtesy of Bases:

Mets + 148

p:inning runs p:R8 + p:inning runs p:R9 = 1 and SG < 5 and SG != 3 and SGS < 5 and 0 < streak < 4 and 0 > o:streak > -3 and (site streak > 3 or -10 < site streak < 0) and 5 < p:hits < 14 and 2 < p:TLOB < 10 and p:runs < 9 and s:SRA < 8 and p:HR < 4 and 0 < os:SSO < 8 and 4 < starter rest < 10 and s:SPT > 66 and o:starter rest < 11 and os:SPT < 116 and op:inning runs op:R9 < 2

**emceeaye** · 08-06-14, 01:38 PM

Originally posted by Alex Vaile

Sixth play:
Courtesy of Bases:

Mets + 148

p:inning runs p:R8 + p:inning runs p:R9 = 1 and SG < 5 and SG != 3 and SGS < 5 and 0 < streak < 4 and 0 > o:streak > -3 and (site streak > 3 or -10 < site streak < 0) and 5 < p:hits < 14 and 2 < p:TLOB < 10 and p:runs < 9 and s:SRA < 8 and p:HR < 4 and 0 < os:SSO < 8 and 4 < starter rest < 10 and s:SPT > 66 and o:starter rest < 11 and os:SPT < 116 and op:inning runs op:R9 < 2

Might want to take a look at this one by either Jmon or Bases--may make you think twice at least.

p:runs = 6 and os:SRA = 2 and A and SG = 2 and conference = o:conference and 2 < SGS < 5 and os:SHA < 8 and os:SHRA < 2 and os:SWA < 3 and os:SPT < 116 and line > -155 and op:runs!=0 and op:errors < 3 and division != AL West.

Or

p:runs = 6 and os:SRA = 2 and A and (SG = 2 or SG = 3) and conference = o:conference and 2 < SGS < 5 and os:SHA < 8 and os:SHRA < 2 and os:SWA < 3 and os:SPT < 116 and line > -155 and op:runs != 0 and op:errors < 3 and division != AL West

**JMon** · 08-06-14, 03:21 PM

^ ya emc you beat me too it... that one on the Nats

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

Originally posted by emceeaye

Solid one supporting hot Orioles:

-171 < line < 140 and SG=2 and - 12 < p:margin < -1 and -10 < pp:margin < -2 and op:runs > 7 and H and SGS < 4 and total < 11 and p:HR < 2 and op:HR < 4 and pp:runs < 6 and 2 < opp:runs < 12 and streak > -8 and site streak < 7

additional support

-140<=line<=120 and p:margin<=-4 and pp:margin<=-4 and op:runs>=8 and H and SG<4 and total<11

**JMon** · 08-06-14, 03:27 PM

El Perfecto is active tonight on the Royals, possible RL. This will be slicker happy

. Does El Perfecto say perfect tonight

AF and p:W and SG=2 and p:margin > 9 and WP > 50 and o:WP < 50 and conference=AL

**JMon** · 08-06-14, 03:33 PM

FYI..I will be on the road the next 3 days or so, so I will be very limited on posting here. So bol to those who contribute and to keeping the thread strong.

.

I will also be starting the NFL SDQL thread in the next week or so...hope to see you guys over there. I will provide a link in here when ready

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

Originally posted by emceeaye

Might want to take a look at this one by either Jmon or Bases--may make you think twice at least.

p:runs = 6 and os:SRA = 2 and A and SG = 2 and conference = o:conference and 2 < SGS < 5 and os:SHA < 8 and os:SHRA < 2 and os:SWA < 3 and os:SPT < 116 and line > -155 and op:runs!=0 and op:errors < 3 and division != AL West.

Or

p:runs = 6 and os:SRA = 2 and A and (SG = 2 or SG = 3) and conference = o:conference and 2 < SGS < 5 and os:SHA < 8 and os:SHRA < 2 and os:SWA < 3 and os:SPT < 116 and line > -155 and op:runs != 0 and op:errors < 3 and division != AL West

Ya im back at work now so I have to put em in early. But thanks for the info guys. Hope it works for me.

**JMon** · 08-07-14, 05:59 AM

Originally posted by JMon

El Perfecto is active tonight on the Royals, possible RL. This will be slicker happy

. Does El Perfecto say perfect tonight

AF and p:W and SG=2 and p:margin > 9 and WP > 50 and o:WP < 50 and conference=AL

Still perfect!

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

A couple of bases queries point to Balt/Tor un. On phone, so cant post them now..Alex/EMC can you post them if you find them.

**Alex Vaile** · 08-07-14, 09:50 AM

1 and 5 yesterday for - 5.04 units
63 and 53 overall
+ 3.9 units

**Alex Vaile** · 08-07-14, 10:22 AM

First posted play:

Over 7.5 - 105 Cincinnati vs Cleveland

(ou streak = 4 or ou streak = 5) and s:SRA < 5 and os:SRA < 6 and SGS = 4 and 85 < s:SPT < 112 and starter rest < 8 and op:HR < 4 and ou streak < 7

**Alex Vaile** · 08-07-14, 10:29 AM

Second and third posted plays:
From Dr.M (Been cold lately like me)

Chicago White Sox +160
White Sox RL +1.5 -135

team=Mariners and H and line<=-125 and p:W and p:runs>=6 and p:hits>=8 and p:HR>0 and date>20100624

**Alex Vaile** · 08-07-14, 10:41 AM

Fourth play courtesy of Bases query:

Toronto Blue Jays - 111

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

**Alex Vaile** · 08-07-14, 11:22 AM

Fifth posted play: (Bases)

Under 10.5 -105 Cubs vs Rockies

AF and SGS = 3 and os:SHRA = 0 and s:SHRA + ss:SHRA != 0 and s:SRA < 8 and os:SRA < 7 and s:SHA > 2 and 2 < os:SHA < 10 and s:SWA < 5 and os:SWA != 0 and starter rest < 11 and s:SIP < 8 and o:starter rest < 14 and p:HR < 4 and p:hits < 16 and (p:SIP + pp:SIP + ppp:SIP + pppp:SIP) > 18 and op:hits > 2 and pp:hits < 14 and total > 7.5 and (game number > 153 or game number < 139) and streak < 4 and o:streak > -7 and -5 < ou streak < 5

**BarstoolProphet** · 08-07-14, 12:33 PM

Alex check your mail

**emceeaye** · 08-07-14, 12:37 PM

one of Bases' Orioles/Blue Jays under queries for today

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

**emceeaye** · 08-07-14, 12:57 PM

Bases query supporting Phillies/Astros under

H and .5 < tA(HR, N=10) < 1.1 and p:HR < 2 and 1.6 > oA(HR, N=10) > .8 and op:HR < 2 and s:SHRA < 2 and os:SHRA < 2 and ss:SHRA = 0 and opp:HR < 2 and p:hits < 16 and op:hits > 5 and opp:hits > 4 and oppp:hits > 5 and 2 < opppp:hits < 18 and s:SPT < 111 and 74 < ss:SPT < 115 and starter rest < 8 and o:starter rest < 8 and SGS != 2 and day != Saturday and p:BPRA < 4

**JMon** · 08-07-14, 01:30 PM

Thanks for posting that Tor un query guys. Here I was able dig up . Fading cubs here. I've posted this one several times.

sA(SHRA) <= .5 and p:BPRA >= 4 and line>=-140 and SG>1

**RollinDo** · 08-07-14, 01:38 PM

Toronto Under a go??

**BeanTownClown88** · 08-07-14, 03:47 PM

Need Cubs to get Cargo out here!! If they can, under is pacing decently

Ugh he's throwing fastballs under 90 mph..Scary sht

**JMon** · 08-07-14, 04:47 PM

Originally posted by RollinDo

Toronto Under a go??

I'm on it...bol if u play it bud

**Alex Vaile** · 08-08-14, 10:16 AM

1 and 4 for -3.51 units
64 and 57 overall
+ 1.53 units
What a horrible run its got to turn around.

**b1slickguy** · 08-08-14, 11:01 AM

Originally posted by Alex Vaile

1 and 4 for -3.51 units
64 and 57 overall
+ 1.53 units
What a horrible run its got to turn around.

I hear you, Alex.
I went 9-2 last week, 4-7 so far this week.
Good luck.

**b1slickguy** · 08-08-14, 12:17 PM

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

24-0 on the fade this season.
Good luck.

**emceeaye** · 08-08-14, 01:41 PM

Bases or Jmon query supporting Giants and Cards RL

Giants RL and Cards RL supported:

SG = 1 and site = home and p:HR = 1 and op:hits > 3 and day = Friday and pp:HR != 0 and op:HR < 5 and s:SHRA = 0 and os:SHRA < 2 and line < 120 and oA

Update: contradictory query that fades Giants:

s:SIP = 9.0 and SG=1 and starter rest = 5 and s:SHA < 7 and s:SRA < 3 and s:SSO < 11 and s:SWA < 4 and line > -181 and (SGS = 3 or SGS = 4) and s:SPT < 12

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

First second and third picks:
By Bases:
Under 8 -120 Mets vs Phillies
Under 8.5 - 110 Red Sox vs Angels
Under 8 - 105 Rockies vs Dbacks

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)

**JMon** · 08-08-14, 03:36 PM

Bingo..play Pirates
sdql is
team = Pirates and 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

**Mako-SBR** · 08-08-14, 03:49 PM

How's it going boys, just glanced at the thread and see JMon and the rest of the guys crushing it like always. Good job!

I never got a feel for MLB myself, hovering just below .500 currently and am not into the sport itself much so it became a grind I got bored of.

But...NFL is coming, woohoo, and it's time to open that branch of our SDQL estate on SBR.

Just created the new football thread here hop on over when you get time and we'll get it rolling toward Week 1.

Cheers!

**emceeaye** · 08-08-14, 04:47 PM

Bases query on pirates/padres under

H and SG = 1 and p:margin = 1 and op:hits < 13 and 0 < op:runs < 7 and p:HR - pp:HR > -2 and opp:hits < 11 and (p:A or op:A) and game number < 160 and (game number < 35 or 108 > game number > 53 or game number > 135) and line < 125 and o:starter rest < 9 and os:SPT < 108

Update: sorry about that posted wrong one. Here it is:

H and .5 < tA(HR, N=10) < 1.1 and p:HR < 2 and 1.6 > oA(HR, N=10) > .8 and op:HR < 2 and s:SHRA < 2 and os:SHRA < 2 and ss:SHRA = 0 and opp:HR < 2 and p:hits < 16 and op:hits > 5 and opp:hits > 4 and oppp:hits > 5 and 2 < opppp:hits < 18 and s:SPT < 111 and 74 < ss:SPT < 115 and starter rest < 8 and o:starter rest < 8 and SGS != 2 and day != Saturday and p:BPRA < 4

**Alex Vaile** · 08-08-14, 05:48 PM

Originally posted by emceeaye

H and SG = 1 and p:margin = 1 and op:hits < 13 and 0 < op:runs < 7 and p:HR - pp:HR > -2 and opp:hits < 11 and (p:A or op:A) and game number < 160 and (game number < 35 or 108 > game number > 53 or game number > 135) and line < 125 and o:starter rest < 9 and os:SPT < 108

I think thats for a different one. This one isnt active as far as I see. Last active 731

**Alex Vaile** · 08-08-14, 05:48 PM

Originally posted by b1slickguy

I hear you, Alex.
I went 9-2 last week, 4-7 so far this week.
Good luck.

Thanks slicker. I was rolling along until last 2 weeks. Hope today is better

**emceeaye** · 08-08-14, 06:15 PM

Originally posted by Alex Vaile

I think thats for a different one. This one isnt active as far as I see. Last active 731

Yes, sorry. This is it:

H and .5 < tA(HR, N=10) < 1.1 and p:HR < 2 and 1.6 > oA(HR, N=10) > .8 and op:HR < 2 and s:SHRA < 2 and os:SHRA < 2 and ss:SHRA = 0 and opp:HR < 2 and p:hits < 16 and op:hits > 5 and opp:hits > 4 and oppp:hits > 5 and 2 < opppp:hits < 18 and s:SPT < 111 and 74 < ss:SPT < 115 and starter rest < 8 and o:starter rest < 8 and SGS != 2 and day != Saturday and p:BPRA < 4

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

Originally posted by emceeaye

Yes, sorry. This is it:

H and .5 < tA(HR, N=10) < 1.1 and p:HR < 2 and 1.6 > oA(HR, N=10) > .8 and op:HR < 2 and s:SHRA < 2 and os:SHRA < 2 and ss:SHRA = 0 and opp:HR < 2 and p:hits < 16 and op:hits > 5 and opp:hits > 4 and oppp:hits > 5 and 2 < opppp:hits < 18 and s:SPT < 111 and 74 < ss:SPT < 115 and starter rest < 8 and o:starter rest < 8 and SGS != 2 and day != Saturday and p:BPRA < 4

Thanks for the winner I still went with it

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

1-1-1 today for -.2 units.
65 and 58 overall
+1.33 units
Damn phillies got 3 runs in Bottom 9th to burn the under and still lose. And then the Rockies score 2 Top 9 to force the push in Arizona and they lost. Baseball is a funny game.
Nice calls on Pirates and under and As you guys.