MLB - Situation Plays - SDQL

**emceeaye** · 08-16-14, 02:18 PM

more support for Pirates under, although don't have HyaHya's query supporting it:

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)

**JMon** · 08-16-14, 03:07 PM

Play HOU under

Supporting SDQL

9<=total and 5.7>=STDSERA>=5.2 and conference=AL and s:starter earned runs<=1 and (SG=2 or SG=3) and month!=7 and month!=9

**emceeaye** · 08-16-14, 03:19 PM

more support for white sox su

queries from website we know so well:

t:team=Blue Jays and A and date>=20140617

and

t:team=Blue Jays and A and date>=20140617 and p:L

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

Play HOU

Supporting SDQL...by unknown

H 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 and SG<4 and day!=Sunday

**emceeaye** · 08-16-14, 03:40 PM

query supporting Orioles

I want to play Indians, but results of this query and that Orioles are hot right now worries me:

t:team=Orioles and p:L and date>=20140630

**JMon** · 08-16-14, 03:42 PM

^ ya I crossed of the Indians off play list.

**emceeaye** · 08-16-14, 03:57 PM

Originally posted by JMon

^ ya I crossed of the Indians off play list.

great it's nice to have the support

what about Dodgers under? Just in case that is someone's pick, and this may be overly cautious, but when they score 3 or less in game prior, they it goes over 8-4 since June 8 as an F after game as an F, and when at home it's 6-2. Total is a bit lower than usual this game as well, if you look at total history:

t:team=Dodgers and F and p:F and date>=20140608 and p:runs<=3

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

Originally posted by emceeaye

great it's nice to have the support

what about Dodgers under? Just in case that is someone's pick, and this may be overly cautious, but when they score 3 or less in game prior, they it goes over 8-4 since June 8 as an F after game as an F, and when at home it's 6-2. Total is a bit lower than usual this game as well, if you look at total history:

t:team=Dodgers and F and p:F and date>=20140608 and p:runs<=3

Dodgers game, in general, is crossed off my list. Not touching it.

**emceeaye** · 08-16-14, 04:45 PM

Originally posted by JMon

Dodgers game, in general, is crossed off my list. Not touching it.

Why not dodgers su

I'm expecting Kershaw to at least go 7 or 8 innings..but am a bit worried about relievers until Jansen closes if that's necessary. Plus, it is juiced...but then again its the the best pitcher in baseball

**Alex Vaile** · 08-17-14, 12:37 AM

3 and 3 for -.35 units
Under query was 3 and 1
84 and 71 overall
+7.1 units

**JMon** · 08-17-14, 08:55 AM

ref post #750

Situation A: Fade a Sunday NL Getaway team

2014 tracking results on the fade: 23-36 (38.2%) (+747)

Last week (-65)

Fading (play against)

Brewers
Pirates

**JMon** · 08-17-14, 09:02 AM

ref post #750

Situation B: Sunday Under Getaway

2014 tracking results over-under-push: 27-33-3 (+320)

Last week: (+80)

Play Under:

Milw
Balt
Pitt
Laa
Sea
Tor

**JMon** · 08-17-14, 09:19 AM

Play TB under

I have been riding this under in the Yankees series. Scary to think I may hit three times in a row, but going to try.

Supporting SDQL- Ray are 9-0 under in this spot

H and 8.5 >= total >= 7 and tA(runs) <= 4.2 and o:STDSERA <= 4.2 and o:conference = AL and po:runs <= 4 and ppo:runs <= 4 and pppo:runs <= 4 and ppppo:runs <= 4 and pppppo:runs <= 4

I also like the fact that this game is a home divisional rubber match, which show tendencies to go under. Look to see how the Rays have done this year and since since 2004.

Supporting SDQL

RG3 and DIV and H and 2004<=season and month>6 and team=Rays

**JMon** · 08-17-14, 09:39 AM

This query, by bases, is 16-4 on the season. It's fading the Brewers, which also supports the Getaway fade above.

Play LAD

SDQL

p:HR = 2 and ppp:HR = 2 and playoffs = 0 and SGS - SG != 1 and 2 < op:hits < 18 and opp:hits < 15 and oppp:hits < 17 and opppp:hits < 12 and oppppp:hits > 5 and os:SHRA < 3 and os:SRA < 7 and os:SSO != 0 and os:SPT > 58 and s:SSO > 2 and streak > -4 and -7 < o:streak < 4 and line < 135 and 2014=season

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

play STL

Supporting SDQL

day=Sunday and site==home and p:L and p:line < -105 and SG>2 and -255< line<=-145 and team=Cardinals

**JMon** · 08-17-14, 10:23 AM

Play CHW

Supporting SDQL

site == home and -105 < line and p:L and op:site = away and (series game = 1 or SG = 3) and line < 200 and total > 7 and division != o:division and team=White Sox

**JMon** · 08-17-14, 10:29 AM

Play Bos ml and over

SDQL, by bases

H and (day = Saturday or day = Sunday) and -3 < streak < 4 and o:streak < 3 and -1 < site streak < 7 and o:site streak > -6 and SGS - SG < 2 and playoffs = 0 and s:SRA < 8 and s:SHA > 1 and s:SWA < 6 and s:SHRA < 2 and 18 < s:SHF < 32 and s:SIP > 4.5 and s:SPT < 121 and starter rest < 7 and (conference = AL or o:conference = NL) and os:SRA != 0 and os:SHA > 3 and o:starter rest < 7 and game number > 15 and oss:SHA < 12 and ss:SIP < 8.1 and 9 > s:starter rest > 4 and os:starter rest < 33 and line < 145 and 4 < op:hits < 16 and 3 < opp:hits < 17 and p:runs < 12 and op:runs < 8 and 0 < p:walks < 8 and op:walks < 8 and tS(margin, N=15) - oS(margin, N=15) > -36 and tS(margin, N=15) < 36 and oS(margin, N=15) > -38 and team=Red Sox

**emceeaye** · 08-17-14, 10:42 AM

nationals SU and Rays SU

HF and tA(W, N=10)>A(W, N=10)+.15 and tS(W, N=4)>S(W, N=4) and season>2012 and month=8 and o:site streak<=-4

**Alex Vaile** · 08-17-14, 10:43 AM

First play:
Play Under 7 - 125 in As vs Braves (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)

**hyahya** · 08-17-14, 11:01 AM

Today's results:

30 380bosox

32 160
rangers

29 550
pirates
rangers

41 460
rangers

30 420
under yanks
under reds

30 660
bosox

33 360
under yanks
under tigers

34 180
rangers
rockies

33 240
angels

40 260
under yanks

30 270
under brew
under yanks
under reds
under rangers

28 145
over cards

34 440
under A's

37 100
under yanks

27 620
under brew
under royals
under reds

28 490
under pirates
under indians

30 335
over reds

18 350
giants

50 150
under indians

41 215
mariners

42 300
dodgers

37 320
under yanks

29 620
bosox

53 1100
dodgers
rockies
rays
indians
tigers

11.5 980
chisox
rockies

33 85
over cards

29 160
under indians

24.5 110
A's

19 220
rays

25 440
under yanks
under tigers

31 320
brew
orioles

29 290
phils

35 220
under indians

29.5 490
pirates
rangers

31 500
under A's

41 460
rangers

19 75
over cards

21 900
under brew
under reds

29 670
angels

30 660
rockies

**Alex Vaile** · 08-17-14, 11:11 AM

Originally posted by JMon

This query, by bases, is 16-4 on the season. It's fading the Brewers, which also supports the Getaway fade above.

Play LAD

SDQL

p:HR = 2 and ppp:HR = 2 and playoffs = 0 and SGS - SG != 1 and 2 < op:hits < 18 and opp:hits < 15 and oppp:hits < 17 and opppp:hits < 12 and oppppp:hits > 5 and os:SHRA < 3 and os:SRA < 7 and os:SSO != 0 and os:SPT > 58 and s:SSO > 2 and streak > -4 and -7 < o:streak < 4 and line < 135 and 2014=season

Dr M. Supporting this Dodgers pick today as well. Im on it with you JMon.

**Alex Vaile** · 08-17-14, 11:13 AM

53 1100
dodgers
rockies
rays
indians
tigers

Hya which query is this?

**hyahya** · 08-17-14, 11:19 AM

Originally posted by Alex Vaile

53 1100
dodgers
rockies
rays
indians
tigers

Hya which query is this?

D and season > 2010 and A and line <= 115 and A(W, N=10) > 0.4 and S(W, N=4) >= 2

**JMon** · 08-17-14, 11:26 AM

This query is still baffling me, made by posey. Noticed that last two games (Atl and Clev, play on (Friday and Sat) were plays and both won but the line moved out of the line parameter so it wasn't tracked in the db. Today it's spitting out 5 games, where one Balt/clev the line has moved out of the line parameter. The others are still active. I mean if this query is in fact predictive and the numbers it is spitting out; it would be the only query one would ever need to unload on.

D and season > 2010 and A and line <= 115 and A(W, N=10) > 0.4 and S(W, N=4) >= 2

**JMon** · 08-17-14, 11:32 AM

Originally posted by Alex Vaile

Dr M. Supporting this Dodgers pick today as well. Im on it with you JMon.

What was his query? This get this one.

**JMon** · 08-17-14, 11:36 AM

Originally posted by JMon

This query is still baffling me, made by posey. Noticed that last two games (Oak and Clev, play on (Friday and Sat) were plays and both won but the line moved out of the line parameter so it wasn't tracked in the db. Today it's spitting out 5 games, where one Balt/clev the line has moved out of the line parameter. The others are still active. I mean if this query is in fact predictive and the numbers it is spitting out; it would be the only query one would ever need to unload on.

D and season > 2010 and A and line <= 115 and A(W, N=10) > 0.4 and S(W, N=4) >= 2

In fact you dont need a line parameter.. that has to be too good to be true.

D and A and A(W, N=10) > 0.4 and S(W, N=4) >= 2

**Alex Vaile** · 08-17-14, 11:48 AM

Originally posted by JMon

This query is still baffling me, made by posey. Noticed that last two games (Atl and Clev, play on (Friday and Sat) were plays and both won but the line moved out of the line parameter so it wasn't tracked in the db. Today it's spitting out 5 games, where one Balt/clev the line has moved out of the line parameter. The others are still active. I mean if this query is in fact predictive and the numbers it is spitting out; it would be the only query one would ever need to unload on.

D and season > 2010 and A and line <= 115 and A(W, N=10) > 0.4 and S(W, N=4) >= 2

Wow that is amazing. This is seemingly too easy! What a query!

**Alex Vaile** · 08-17-14, 11:48 AM

Originally posted by hyahya

D and season > 2010 and A and line <= 115 and A(W, N=10) > 0.4 and S(W, N=4) >= 2

Wow that's awesome! Thanks

**Alex Vaile** · 08-17-14, 11:54 AM

Originally posted by JMon

What was his query? This get this one.

Here it is JMon

team = Brewers and A and n:H and p:WD and pp:W and SG=3 and SGS=3

**JMon** · 08-17-14, 04:20 PM

Ah...a breath a fresh air after a bad couple of days.. 4-1 cashing CHW, STL, TB un, Hou OV...losing bos ml and it appears Lad is going to lose. But a winning day

**Alex Vaile** · 08-18-14, 02:49 AM

Push today in As under.

Tomorrow early: (my own creations)

Mets -120

team=Mets and HF and p:L and DAY and season > 2013
starter = Bartolo Colon and HF and DAY and season >2012
team=Cubs and AD and p:W and DAY and season > 2012

**emceeaye** · 08-18-14, 09:08 AM

Nats again today

Came up with this yesterday and it went 1-1 yesterday:

HF and tA(W, N=10)>A(W, N=10)+.15 and tS(W, N=4)>S(W, N=4) and season>2012 and month=8 and o:site streak<=-4

**Cougs** · 08-18-14, 09:18 AM

Originally posted by JMon

In fact you dont need a line parameter.. that has to be too good to be true.

D and A and A(W, N=10) > 0.4 and S(W, N=4) >= 2

JMon et al, can you translate the meaning? specifically, the "A(W, N=10)>0.4" and "S(W, N=4)>=2". Something doesn't really feel right about this SDQL and i'm trying to figure out what...

Thanks!

**Alex Vaile** · 08-18-14, 09:45 AM

Second posted play: ( Dr.M )

Play Minnesota +151 twins 9 and 0 in this spot
Play Under 8.5 -115 under is 1 and 8 in this situation.

team=Twins and SG> 1 and p:margin<=-5 and date> 20140510

**emceeaye** · 08-18-14, 10:09 AM

Originally posted by Cougs

JMon et al, can you translate the meaning? specifically, the "A(W, N=10)>0.4" and "S(W, N=4)>=2". Something doesn't really feel right about this SDQL and i'm trying to figure out what...

Thanks!

I have been thinking about this since Posey posted it the other day. As Jmon indicated initially (and confirmed by Joe in the Google discussion group) , "A() shows average league-wide. So presumably it would spit out any game(s) on a day when win % is at least 40% over the past 10 days (or game-days).

"S(W, N=4)>=2": This one is trickier for me to get, and Joe hasn't answered my post yet about this in the discussion group (it was really a follow up question to the original question in the same post about A(W, N=10)). If S() reflects league-wide sum, then perhaps it means the sum of wins for any team league-wide over the past 4 days' games that has won at least 2 of their past 4 games.

Please clarify if I'm wrong.

Why exactly the win rate of the home favorite team would be higher with a higher rate of AD wins league wide I don't know.