MLB - Situation Plays - SDQL

**mdunlap3** · 07-28-14, 05:16 PM

Jmon OAK TT under?

**emceeaye** · 07-28-14, 05:24 PM

problem getting how many 1st inning runs allowed output for Vance Worley

Is any one able to get correct output of the following query telling us number of runs allowed in first inning by Vance Worley? Not working for me for some reason.

starter=Vance Worley and season=2014 and o:R1

Thanks.

**JMon** · 07-28-14, 05:48 PM

No clue why that won't work. May have email Joe. May be a bug

**JMon** · 07-28-14, 05:50 PM

Originally posted by mdunlap3

Jmon OAK TT under?

don't mess around with TT's, but appears to look good

**mdunlap3** · 07-28-14, 06:05 PM

You said OAK under in one of our aforementioned posts, just wasn't sure if that meant TT under or the total to go under, just wanted to clarify. Thanks man...love this thread though Vaile and Jmon. Finally an empirical approach, rather than most on here just using pure logic and reason.

**JMon** · 07-28-14, 07:13 PM

Originally posted by mdunlap3

You said OAK under in one of our aforementioned posts, just wasn't sure if that meant TT under or the total to go under, just wanted to clarify. Thanks man...love this thread though Vaile and Jmon. Finally an empirical approach, rather than most on here just using pure logic and reason.

oh, yep oak under

**Alex Vaile** · 07-28-14, 10:55 PM

2 and 1 today posted plays for 1 unit. Milwaukee almost got it done for us but couldn't finish.
54 and 37 overall
+13.63 units

**emceeaye** · 07-29-14, 10:44 AM

Bases query supporting RL on Indians/Mariners game

s:SRA = 3 and H and SG = 1 and 2 < SGS < 5 and playoffs = 0 and s:SHRA < 3 and s:SWA < 5 and starter rest > 4 and 57 < s:SPT < 112 and s:SHF > 17 and s:SSO != 0 and s:SHA > 4 and 2 < ss:SHA < 12 and s:SWA + s:SHA < 13 and s:starter rest < 16 and 77 < ss:SPT < 124 and 20 < ss:SHF < 33 and 0 < ss:SSO < 12 and 3 < os:SHA + os:SWA < 14 and os:SRA < 8 and os:SHRA < 3 and os:SHA > 4 and os:SIP > 4 and o:starter rest < 7 and line < 138 and game number > 21

It looks like it has done well in July in recent years.

And here's more support for it from this query (from Jmon I think):

A and Sum(o

oints > points@team and season,N=7) >= 5 and line >= 100 and 54>=WP>=51 and o:WP<50 and 2008<=season

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

First posted play for today:

Pirates vs Giants Under 6.5 Even

H and month > 5 and season > 2009 and 1.2 > tA(BPRA) > .6 and 8 > (s:SRA - os:SRA) > -4 and (p:hits + os:walks) < 15 and month != 8 and s:SRA < 6 and os:SRA < 5 and 30.7 > (p:SIP + pp:SIP + ppp:SIP + pppp:SIP) > 18.7 and (op:SIP + opp:SIP + oppp:SIP + opppp:SIP) > 19.4 and total > 6.4 and p

u margin > -6.6 and streak < 5 and o:streak < 6 and -8 < o

u streak < 4 and os:SPT < 123 and team != Twins and team != Red Sox and o:team != Indians and (s:SSO + ss:SSO + sss:SSO + ssss:SSO) > 9 and (s:SSO + ss:SSO + sss:SSO) < 26 and (os:SSO + oss:SSO + osss:SSO + ossss:SSO + osssss:SSO) > 13 and (os:SSO + oss:SSO + osss:SSO + ossss:SSO) < 31

**sportcap** · 07-29-14, 12:19 PM

Originally posted by emceeaye

s:SRA = 3 and H and SG = 1 and 2 < SGS < 5 and playoffs = 0 and s:SHRA < 3 and s:SWA < 5 and starter rest > 4 and 57 < s:SPT < 112 and s:SHF > 17 and s:SSO != 0 and s:SHA > 4 and 2 < ss:SHA < 12 and s:SWA + s:SHA < 13 and s:starter rest < 16 and 77 < ss:SPT < 124 and 20 < ss:SHF < 33 and 0 < ss:SSO < 12 and 3 < os:SHA + os:SWA < 14 and os:SRA < 8 and os:SHRA < 3 and os:SHA > 4 and os:SIP > 4 and o:starter rest < 7 and line < 138 and game number > 21

It looks like it has done well in July in recent years.

is this supporting Clev or Sea on RL? thanks.

**emceeaye** · 07-29-14, 01:36 PM

Originally posted by sportcap

is this supporting Clev or Sea on RL? thanks.

SEA

**JMon** · 07-29-14, 04:21 PM

One of bases queries a whopping 7-51 on the fade is active fading the Nationals.

p:runs = 6 and os:SRA = 2 and season>2007 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** · 07-29-14, 04:28 PM

SMALL sample, but PERFECTO throughout the database tracking era. Perfect on the RL too since tracking. Play at your own risk due to sample size.

Play Blue Jays

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

**mdunlap3** · 07-29-14, 04:30 PM

Strasburg absolutely horrible on the road also

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

Post this before already...logic play road team starting a pitcher with a whip of <2.50 over his last three; playing against a starter with a whip of >=2.25 over his last three. 12-5 this year. play Yankees

A and A(starter whip@starter and season, N=3)<2.50 and A(o:starter whip@o:starter and o:season, N=3)>=2.25 and 2012<=season and line<=160 and rest=0 and 9.5>=total>=8 and month!=8

**JMon** · 07-29-14, 04:50 PM

Sure I will try the bravos against Beckett

A and 170 >= line >= 110 and po:runs = 0 and p:runs + po:runs <= 3 and rest < 2

**JMon** · 07-29-14, 05:08 PM

Scary riding any Padres over, but this spot is 10-2 this season. contrarian to say the least.

total <= 7 and tA(runs) <= 3.3 and oA(runs) <= 3.8 and conference = NL and o:conference = NL and rest = 0 and 2011 <= season

**JMon** · 07-29-14, 05:18 PM

Solid interleague total that is 7-31 under since '04 Play under Brewers/Rays

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

Play under (7.5>=total>=7) a NL team starting a pitcher with a ERA of 4.2>=STDSERA>=3.7; playing a AL team starting a pitcher with a Whip of <=1.3, on zero rest

**Alex Vaile** · 07-29-14, 06:24 PM

Originally posted by JMon

Scary riding any Padres over, but this spot is 10-2 this season. contrarian to say the least.

total <= 7 and tA(runs) <= 3.3 and oA(runs) <= 3.8 and conference = NL and o:conference = NL and rest = 0 and 2011 <= season

Loving the contrarian. As usual

**Alex Vaile** · 07-29-14, 06:26 PM

Originally posted by JMon

One of bases queries a whopping 7-51 on the fade is active fading the Nationals.

p:runs = 6 and os:SRA = 2 and season>2007 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

Yes indeed fade Strasburg!

**Alex Vaile** · 07-30-14, 01:22 AM

Originally posted by JMon

SMALL sample, but PERFECTO throughout the database tracking era. Perfect on the RL too since tracking. Play at your own risk due to sample size.

Play Blue Jays

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

Still perfect. Good call

**Alex Vaile** · 07-30-14, 01:23 AM

1 and 0 today for 1 unit
55 and 37
+14.63 units

**Alex Vaile** · 07-30-14, 11:09 AM

First posted play of 7/30:

Minnesota Twins + 138

team=Twins and s:L and ss:L and season=2014

17 and 3 this season

**Alex Vaile** · 07-30-14, 11:20 AM

Second play:

Under 7 -115 Twins vs Royals

H and month > 5 and season > 2009 and 1.2 > tA(BPRA) > .6 and 8 > (s:SRA - os:SRA) > -4 and (p:hits + os:walks) < 15 and month != 8 and s:SRA < 6 and os:SRA < 5 and 30.7 > (p:SIP + pp:SIP + ppp:SIP + pppp:SIP) > 18.7 and (op:SIP + opp:SIP + oppp:SIP + opppp:SIP) > 19.4 and total > 6.4 and p

u margin > -6.6 and streak < 5 and o:streak < 6 and -8 < o

u streak < 4 and os:SPT < 123 and team != Twins and team != Red Sox and o:team != Indians and (s:SSO + ss:SSO + sss:SSO + ssss:SSO) > 9 and (s:SSO + ss:SSO + sss:SSO) < 26 and (os:SSO + oss:SSO + osss:SSO + ossss:SSO + osssss:SSO) > 13 and (os:SSO + oss:SSO + osss:SSO + ossss:SSO) < 31

Maybe a small parlay?

**JMon** · 07-30-14, 11:22 AM

A bases query that hit last night on the Marlins under and active again today on the Marlins

p:HR = 0 and 4 > SG > 1 and op:HR = 0 and SGS = 3 and H and s:SRA < 6 and os:SRA != 0 and os:SWA != 0 and s:SPT > 86 and os:SPT < 122 and 163 > game number > 28 and site streak < 9 and o:site streak > -9 and ou streak > -7 and tS(hits, N=5) < 55 and tS(hits, N=20) < 198 and oS(hits, N=2) > 8 and oS(hits, N=5) > 29 and oS(hits, N=20) < 202 and oS(hits, N=10) > 66 and oS(runs, N=10) > 25 and oS(runs, N=2) < 15 and oS(runs, N=5) < 34 and tS(runs, N=2) > 1 and tS(runs, N=10) < 55 and 170 > line > -250 and team=Marlins

**JMon** · 07-30-14, 11:26 AM

Play Under Angels

p:X and SG>1 and division!=o:division and p:PU > 4 and p:PU < po:PU and A and 9>=total>=8 and 8>month>4

**JMon** · 07-30-14, 11:42 AM

Worked on this total last night, never a losing season since db tracking. Play under Oakland

Road fav of <=-115, starting a pitcher of a era of >4.6

Filters
4 < month < 8
(SG = 1 or SG = 3)
10 > total > 6

A and STDSERA > 4.6 and 4 < month < 8 and line <= -115 and (SG = 1 or SG = 3) and 10 > total > 6

**Alex Vaile** · 07-30-14, 11:45 AM

After a huge scoring night in Texas lets go contrarian for third pick:

Under 9 -120 Yankees vs Rangers

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

**Alex Vaile** · 07-30-14, 11:49 AM

Originally posted by JMon

A bases query that hit last night on the Marlins under and active again today on the Marlins

p:HR = 0 and 4 > SG > 1 and op:HR = 0 and SGS = 3 and H and s:SRA < 6 and os:SRA != 0 and os:SWA != 0 and s:SPT > 86 and os:SPT < 122 and 163 > game number > 28 and site streak < 9 and o:site streak > -9 and ou streak > -7 and tS(hits, N=5) < 55 and tS(hits, N=20) < 198 and oS(hits, N=2) > 8 and oS(hits, N=5) > 29 and oS(hits, N=20) < 202 and oS(hits, N=10) > 66 and oS(runs, N=10) > 25 and oS(runs, N=2) < 15 and oS(runs, N=5) < 34 and tS(runs, N=2) > 1 and tS(runs, N=10) < 55 and 170 > line > -250 and team=Marlins

**JMon** · 07-30-14, 07:04 PM

Originally posted by JMon

taking a shot on a overreaction- road dog; winning team losing 5 or more out of 7 playing a losing team. Play Cardinals

A and Sum(L@team and season,N=7) >= 5 and line >= 100 and 54>=WP>=51 and o:WP<50 and 2008<=season

Again!

**Alex Vaile** · 07-31-14, 01:00 AM

2 and 1 today for + 1 unit
57 and 38 overall
+15.63 units

**Alex Vaile** · 07-31-14, 11:20 AM

First Posted Play for Thursday:
My own creation:

White Sox RL +1.5 -115

team = Tigers and HF and SG = 3 and SGS = 3 and (p:W) + (pp:W) = 1 and date >= 20130505

team = White Sox and AD and SG = 3 and SGS = 3 and (p:W) + (pp:W) = 1 and date >= 20130505

Good results for Sox runline in final game of series. Good luck!

**JMon** · 07-31-14, 11:23 AM

Originally posted by Alex Vaile

After a huge scoring night in Texas lets go contrarian for third pick:

Under 9 -120 Yankees vs Rangers

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

This is active again the LAA

**JMon** · 07-31-14, 11:27 AM

Originally posted by Alex Vaile

First Posted Play for Thursday:
My own creation:

White Sox RL +1.5 -115

team = Tigers and HF and SG = 3 and SGS = 3 and (p:W) + (pp:W) = 1 and date >= 20130505

team = White Sox and AD and SG = 3 and SGS = 3 and (p:W) + (pp:W) = 1 and date >= 20130505

Good results for Sox runline in final game of series. Good luck!

FYI...you can use shortcut 'RG3' instead of highligted above for a rubber game. good luck

**BeanTownClown88** · 07-31-14, 11:29 AM

You like the LAA under? right there on that CWS RL good luck!