MLB - Situation Plays - SDQL

[mdunlap3]

For me its now a no play for that reason.

Agreed. I would lean to the side of the over just on my gut feeling, but pass.

[emceeaye]

Second play: ( Bases )

Play Toronto + 119

AD and (SG = 1 or SG = 3) and playoffs = 0 and streak > -4 and -8 < o:streak < 6 and -7 < p:margin < 10 and -10 < op:margin < 9 and p:runs < 13 and op:runs != 0 and p:hits > 1 and 3 < op:hits < 15 and op:doubles < 6 and p:triples < 3 and op:triples < 2 and p:SO > 3 and 2 < op:SO < 17 and 3 < p:ground balls < 21 and 2 < op:ground balls < 24 and p:fly balls < 16 and 2 < op:fly balls < 16 and op:BPRA < 9 and 1.5 < p:SIP < 8.1 and 1.9 < op:SIP < 8.5 and 33 < p:SPT < 116 and 48 < op:SPT < 111 and op:SHF < 34 and 27 < p:batters faced < 46 and 28 < op:batters faced < 57 and p:at bats + p:walks < 48 and op:at bats + op:walks < 46 and 0 < p:TLOB < 12 and 0 < op:TLOB < 13 and (14 > site streak > 5 or -1 > site streak > -12) and (1 < o:site streak < 10 or -11 < o:site streak < -5) and (conference = AL or o:conference = NL) and op:RMAX < 8 and op:inning runs op:R1 < 5 and op:inning runs op:R2 < 4 and op:inning runs op:R3 < 3 and p:errors < 3 and op:errors < 4 and os:SHA < 12 and os:SRA < 7 and 0 < os:SWA < 5 and s:SPT > 83 and starter rest < 12 and s:SIP > 4.9

This one doesn't paste well but been hot!

Nice...supports the runline in general.

[mdunlap3]

Under 9 in Texas one of my top plays today...I don't do the queries though...just looked into it a lot.

Best of luck to you man, just not feeling confident about it.

[mdunlap3]

Nice...supports the runline in general.

Line up to +125, ML worth a shot at that price.

[Alex Vaile]

Third play: ( Dr.M )

Play Red Sox +132

Yanks 2 and 16 as favorite in rubber game since 2013.

Sdql: team=Yankees and F and SG=3 and SGS =3 and (p:W)+(pp:W)=1 and date>=20130505

[Alex Vaile]

Nice...supports the runline in general.

Let's have a great day!

[JMon]

beautiful job!!!!

Wow what a query! Amazing job bro.

thanks guys

[Alex Vaile]

O's/Reds under

2 supporting:

STR and o:STR and s:margin = -1 and s:streak = 2 and s:biggest lead < 3 and s:errors < 2 and -9 < p:M8 < 3 and p:M8 != -2 and -4 < p:M1 < 3

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=9 and o:site streak<=-4

Looks good! Let's get it!

[emceeaye]

Third play: ( Dr.M )

Play Red Sox +132

Yanks 2 and 16 as favorite in rubber game since 2013.

Sdql: team=Yankees and F and SG=3 and SGS =3 and (p:W)+(pp:W)=1 and date>=20130505

More support:

(I think Jmon's query)

9 < p:hits < 12 and SG = 3 and 5 < op:hits < 8 and (site = away or conference = AL) and conference = o:conference and p:margin < 6 and pp:margin < 6 and opp:hits > 6 and p:runs > 1 and pp:runs > 0 and 4 < op:runs + opp:runs < 16

[mdunlap3]

Third play: ( Dr.M )

Play Red Sox +132

Yanks 2 and 16 as favorite in rubber game since 2013.

Sdql: team=Yankees and F and SG=3 and SGS =3 and (p:W)+(pp:W)=1 and date>=20130505

Wow this one looks sexy. On this one also.

[emceeaye]

orioles su

One of Jmon's I believe:

line <= -155 and Sum(hits@team and season) / Sum(at bats@team and season) <= .265 and t:conference = AL and os:earned runs <= 1 and total < 9.5 and SG < 4

Add day=Thursday and month=9

[JMon]

First play : ( Bases )

Play Under 8.5 -105 Red Sox vs Yankees

H and 9.5 > total > 7.5 and SG = 3 and SGS < 6 and playoffs = 0 and 73 < os:SPT < 109 and o:starter rest > 6 and month != 6 and 2 < p:hits < 16 and 1 < tA(doubles, N=10) < 2.3

I also like the fact it's a divisional rubber game as well.

[JMon]

One of Jmon's I believe:

line <= -155 and Sum(hits@team and season) / Sum(at bats@team and season) <= .265 and t:conference = AL and os:earned runs <= 1 and total < 9.5 and SG < 4

Add day=Thursday and month=9

Ya...that's one of mine. Don't like the juice, but I'm playing them.. we shall see.

[Armbar99]

Red sox +135 looking great now !!!

[Alex Vaile]

1 and 2 for -.86 units
well red sox and under looked great till the typical shiit bullpen comes in and blows both for us giving up 2 homers in bottom of the 9th. Jays winner.

112 and 94 overall
+ 10.33 units

[emceeaye]

1 and 2 for -.86 units
well red sox and under looked great till the typical shiit bullpen comes in and blows both for us giving up 2 homers in bottom of the 9th. Jays winner.

112 and 94 overall
+ 10.33 units

Yeah, another dud bullpen...probably the result of Boston's effort to unload all of their overpaid pitching staff...and one of the consequences is blowing leads in late innings.

[mdunlap3]

Tough day yesterday. O's are just hitting a million home runs at Camden. Better day today.

[Alex Vaile]

First and second plays: ( Dr.M )

Play Seattle RL - 115
Play Seattle -200

team = Mariners and p:walks>=5 and p:W and SG <SGS and date>=20130831

11 and 0 after drawing 5+ walks
-200 on road wow juicy!

[mdunlap3]

First and second plays: ( Dr.M )

Play Seattle RL - 115
Play Seattle -200

team = Mariners and p:walks>=5 and p:W and SG <SGS and date>=20130831

11 and 0 after drawing 5+ walks
-200 on road wow juicy!

Here's one in dispute kind sir, also shows a play on the Rays. Thoughts?

H and -8 > (starter wins - starter losses + o:starter losses - o:starter wins) > -14 and day != Wednesday and day != Thursday and 6 > s:SRA

[mdunlap3]

Play Angels

F and line <= -130 and s:SRA < 7 and 5 <= s:SIP < 9 and tS(hits) / tS(at bats) < 0.265 and 4.7 <= o:STDSERA <= 6.0 and oS(hits+walks, N=18) / oS(at bats, N=18) > 0.365 and conference = AL

[mdunlap3]

Reds/Mets 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

[hyahya]

30 165 153

twins

29 550 -114

braves

36 370 -109

dodgers

30 440 106

rays

49 75 -135

chisox

39 220

under mets


32 250 -118

orioles

26 630

under cards

under pirates

27 820 134

dbacks

41 300 120

royals

54 130 131

braves

7.5 1400 139

rangers
padres

royals

8.6 1200 -120

chisox

mariners

25 160 -160

angels

57 36 -135

brew

29.5 85

under nats

10.7 1400 127braves
orioles


29 160
under mariners


23 115 -143
chisox
angels


30 450
over giants


24 800
over dodgers
over nats


29 500 -110
braves


21 900
under braves
under padres


29.4 420 142
marlins RL


30 280 -120
reds


31 150 110
orioles


28 435 -103
angels

[emceeaye]

Play Angels

F and line <= -130 and s:SRA < 7 and 5 <= s:SIP < 9 and tS(hits) / tS(at bats) < 0.265 and 4.7 <= o:STDSERA <= 6.0 and oS(hits+walks, N=18) / oS(at bats, N=18) > 0.365 and conference = AL

Interesting one. Add day=Friday

[mdunlap3]

Interesting one. Add day=Friday

Not too shabby...not a huge N but worth a shot in my opinion.

[Alex Vaile]

Third play: ( Bases )
More support for Angels

Play Angels - 167

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

This query has been cold but I like it today.

[JMon]

Play White Sox

SDQL

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 2004<=season and team=White Sox


-see you guys over in the NFL thread

[Alex Vaile]

Play 4: ( Bases )

Play Padres + 115

AD and (SG = 1 or SG = 3) and playoffs = 0 and streak > -4 and -8 < o:streak < 6 and -7 < p:margin < 10 and -10 < op:margin < 9 and p:runs < 13 and op:runs != 0 and p:hits > 1 and 3 < op:hits < 15 and op:doubles < 6 and p:triples < 3 and op:triples < 2 and p:SO > 3 and 2 < op:SO < 17 and 3 < p:ground balls < 21 and 2 < op:ground balls < 24 and p:fly balls < 16 and 2 < op:fly balls < 16 and op:BPRA < 9 and 1.5 < p:SIP < 8.1 and 1.9 < op:SIP < 8.5 and 33 < p:SPT < 116 and 48 < op:SPT < 111 and op:SHF < 34 and 27 < p:batters faced < 46 and 28 < op:batters faced < 57 and p:at bats + p:walks < 48 and op:at bats + op:walks < 46 and 0 < p:TLOB < 12 and 0 < op:TLOB < 13 and (14 > site streak > 5 or -1 > site streak > -12) and (1 < o:site streak < 10 or -11 < o:site streak < -5) and (conference = AL or o:conference = NL) and op:RMAX < 8 and op:inning runs op:R1 < 5 and op:inning runs op:R2 < 4 and op:inning runs op:R3 < 3 and p:errors < 3 and op:errors < 4 and os:SHA < 12 and os:SRA < 7 and 0 < os:SWA < 5 and s:SPT > 83 and starter rest < 12 and s:SIP > 4.9

[emceeaye]

Reds/Mets 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

I really like this one...add SG=1, and win % for unders goes to 75%.

[emceeaye]

nice

Reds/Mets 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

I really like this one...add SG=1, and win % for unders goes to 75%

[JMon]

Play Det Over

SDQL

(SG = 1 or SG = 4) 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 and team=Tigers

[emceeaye]

Not too shabby...not a huge N but worth a shot in my opinion.

Anyone have the one query on Twins that Hyahya lists in above post?

[mdunlap3]

Anyone ever get the " HTTP timeout " error when you try to run a larger query? Which browser do yall use?

[emceeaye]

Anyone ever get the " HTTP timeout " error when you try to run a larger query? Which browser do yall use?

I got that error a few times today when trying to post a response to a query using native browser on android and using chrome on laptop. But, I haven't had any problems since then (about 2 hours ago).

[Alex Vaile]

I really like this one...add SG=1, and win % for unders goes to 75%.

On it with u guys!

[Alex Vaile]

I got that error a few times today when trying to post a response to a query using native browser on android and using chrome on laptop. But, I haven't had any problems since then (about 2 hours ago).

Yes I got also when doing the sra query. Kind of annoying but I did receive a response from Ed Meyer saying that they were upgrading to sdql 2.0 and b patient.