MLB - Situation Plays - SDQL

[Alex Vaile]

First and second plays for Saturday: (My own creation )

Yanks RL - 160
Under 8 even Yanks vs Orioles

team=Yankees and AD and p:L and pp:L and season>= 2013

[Alex Vaile]

1-1-1 yesterday for 0 units
123 and 102 overall
+ 10.79 units

[Alex Vaile]

Third play: ( Bases )

Under 6.5 - 105 Nationals vs Mets

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]

Play Giants

Look to see how the Giants do after shutting out a divisional rivial.

SDQL (note space after : DIV)

H and team=Giants and po:runs=0 and p: DIV and SG<4

[Alex Vaile]

Play Giants

Look to see how the Giants do after shutting out a divisional rivial.

SDQL (note space after : DIV)

H and team=Giants and po:runs=0 and p: DIV and SG<4

Wow 25 and 4 is pretty darn good

[emceeaye]

Play Giants

Look to see how the Giants do after shutting out a divisional rivial.

SDQL (note space after : DIV)

H and team=Giants and po:runs=0 and p: DIV and SG<4

Nice!

[JMon]

ref post #750

Situation A: Fade a Sunday NL Getaway team

2014 tracking results on the fade: 26-47 (35.6%) (+1525)

Last week (+210) , fading Ari ended up being a play as well.

Fading (play against)

Cin
Col
SD
Mia
Cubs

[JMon]

ref post #750

Situation B: Sunday Under Getaway

2014 tracking results over-under-push: 35-43-3 (+450)

Last week: (+190)

Play under

Hou
Cin
Col
SD
Oak
Cubs
Clev
Min

[JMon]

Play Marlins under

SDQL

tA(doubles, N=10) < 1.9 and 8.9 < tA(hits, N=10) < 10.4 and .5 < tA(HR, N=10) < 1.3 and 1 < oA(doubles, N=10) < 1.7 and oA(hits, N=10) < 9.9 and oA(HR, N=10) < 1.1 and SG < 4 and 5 > SGS > 2 and p:HR < 3 and p:hits < 15 and 18 > pp:hits > 4 and 3 < ppp:hits < 16 and 3 < pppp:hits < 13 and ppppp:hits < 15 and pppppp:hits < 15 and ppppppp:hits > 6 and op:hits < 13 and s:SRA < 7 and s:SHRA < 2 and os:SRA < 8 and os:SPT < 122 and team=Marlins

[emceeaye]

As/Mariners under

Bases Query I believe:

SGS = 3 and day = Sunday and month = 9 and SG = 3 and A and 2 > streak > -2 and 157 > game number > 26 and s:SHA > 4 and os:SHA < 9 and os:SRA < 7 and os:SHRA = 0 and os:SWA < 4 and 3 > s:SHRA > 0 and s:SWA < 5 and starter rest < 16 and total > 6.5 and (p:hits + pp:hits + op:hits + opp:hits) < 47 and p:margin < 7 and pp:margin > -8 and line < 220

[emceeaye]

5 unders today worth taking a look at...

May be a Bases query...correct me if wrong please:

day = Sunday and month = 9 and SG = 3 and 0 < s:SRA < 8 and 0 < os:SRA < 6 and (163 > game number > 126 or 103 > game number > 77) and starter rest < 11 and 113 > s:SPT > 58 and 118 > os:SPT > 52 and (H or F) and (s:SWA + ss:SWA + sss:SWA) > 1 and 3.9 > (tA(BPRA) + oA(BPRA)) > 2.1 and (s:SHRA + ss:SHRA + sss:SHRA + ssss:SHRA) < 6 and os:SHRA < 3 and (p:HR + pp:HR + ppp:HR + pppp:HR) < 9 and streak > -5 and o:streak > -7 and ou streak < 3 and (p:fly balls + pp:fly balls + ppp:fly balls) > 9 and (op:fly balls + opp:fly balls + oppp:fly balls + opppp:fly balls) > 14 and 3 < (s:SSO + ss:SSO) < 17 and os:SSO < 9

[Alex Vaile]

Play Giants

Look to see how the Giants do after shutting out a divisional rivial.

SDQL (note space after : DIV)

H and team=Giants and po:runs=0 and p: DIV and SG<4

Too bad Hudson sucks.

[JMon]

Too bad Hudson sucks.

freakin horrific call on my end...lol

[Alex Vaile]

2 and 1 yesterday for + .95 units
125 and 103 overall
+ 11.74 units

[Alex Vaile]

First play : ( Bases )

Play Under 8.5 -105 Astros vs Angels

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

[mdunlap3]

Wow...

[Alex Vaile]

1 and 0 today. + 1 unit
126 and 103 overall
+ 12.74 units

[mdunlap3]

Got two today fading Scherzer.

Lots of unders as well,
Dbacks
Mets
Braves
Padres
Angels

Also on Rays

[Alex Vaile]

First play : ( Bases )

Under 7.5 + 105 Giants 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)

[Alex Vaile]

Second play : ( Bases )

Play Marlins + 130


s:SRA < 2 and 5 > ss:SRA > 0 and sss:SRA < 4 and ssss:SRA < 6 and 0 < sssss:SRA < 8 and os:SRA < 5 and SG < 4 and day != Tuesday and day != Thursday and 4 < starter rest < 10 and o:starter rest < 11 and 161 > game number > 27 and line > -165 and 2 > p:margin > -9 and 11.2 > tA(hits, N=10) > 6.7 and 6.2 < oA(hits, N=10) < 11.3 and STDSWHIP > .948 and ss:SPT > 67 and 40 < oss:SPT < 113 and tA(doubles, N=10) < 2.5 and tA(errors, N=10) > .1 and .3 < oA(BPRA, N=10) < 2.6 and tA(BPRA, N=10) < 2.8

[Alex Vaile]

Third play : ( Dr.M )

Play Atlanta + 125

team=Nationals and p:M6=0 and p:W and date>20140415

[Alex Vaile]

Fourth and Fifth plays: ( Bases )

Play Phillies + 153
Play Phillies RL +1.5 - 150

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

Doesn't paste well but good results 18% with 1600 games

[b1slickguy]

Fading BAL.
Good luck.


H and day=Monday and DIV and rest=0 and line>=-130 and p:start time>1900

[emceeaye]

Fading BAL.
Good luck.


H and day=Monday and DIV and rest=0 and line>=-130 and p:start time>1900

Nice.

Anyone discover a query pointing in opposite direction?

[Alex Vaile]

2 and 3 today for -.7 units
128 and 106 overall
+ 12.04 units

[Alex Vaile]

First play : ( Bases )

Over 7 - 105 Brewers vs Cardinals

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

[Alex Vaile]

Second play : ( Bases )

Under 8.5 - 120 Tigers vs Twins

tA(BPRA) < oA(BPRA) and SG = 2 and s:SRA < 5 and 8 > ss:SRA > 0 and (s:SHA + s:SWA) < 12 and os:SHRA > 0 and oss:SHRA < 2 and (game number < 41 or 87 > game number > 61 or 103 > game number > 90 or game number > 130) and op:HR < 4 and op:hits < 14 and p:margin > -7 and -10 < pp:margin < 9 and -10 < opp:margin < 9 and streak > -4 and tA(hits, N=10) > 8.1 and oA(runs, N=10) < 5.3 and -243 < line < 165 and s:SPT > 76 and os:SPT > 66 and SGS < 5 and oA(doubles, N=10) < 2.6 and tA(errors, N=10) < 1.2

[emceeaye]

Fading BAL.
Good luck.



H and day=Monday and DIV and rest=0 and line>=-130 and p:start time>1900

Just add p:BPRA<=2 and see the record improve for o/u:

H and day=Wednesday and DIV and rest=0 and line>=-130 and p:start time>1900 and season>=2014 and p:BPRA<=2

4 active today

Or try this one:

H and day=Wednesday and DIV and rest=0 and line>=-130 and p:NGT and DAY and season>=2014 and p:BPRA<=2

[Alex Vaile]

They banned me yesterday. And I had the under in the yankee game and the Giants RL. Said I had multiple accounts which I did not.

Here's to a good day today!

[emceeaye]

pirates su

Here's a Jmon or Bases query supporting pirates su today:

p:site = home and site = home and op:site = away and p:line <= -140 and line <= -140 and 0 < op:line and total <= 8 and po:runs + 5 <= p:runs and op:runs + 5 < opo:runs and 10 <= p:hits and 5 <= op:hits and op:runs <= 2 and p:errors <= 1 and op:errors <= 1 and 2004 <= season

[emceeaye]

Hey Jmon where you at?

[b1slickguy]

Here's a Jmon or Bases query supporting pirates su today:

p:site = home and site = home and op:site = away and p:line <= -140 and line <= -140 and 0 < op:line and total <= 8 and po:runs + 5 <= p:runs and op:runs + 5 < opo:runs and 10 <= p:hits and 5 <= op:hits and op:runs <= 2 and p:errors <= 1 and op:errors <= 1 and 2004 <= season

Here's another supporting PIT that you posted (I think) earlier in the season and tarosill modified.
Nice mods in post #2513, too.
Good luck.

HF and p:margin>=7 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) and o:site streak > -8 and WP > 48

[emceeaye]

Here's another supporting PIT that you posted (I think) earlier in the season and tarosill modified.
Nice mods in post #2513, too.
Good luck.

HF and p:margin>=7 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) and o:site streak > -8 and WP > 48

Oh yeah, that's a nice one. I didn't have time to go through all of my queries today...thanks for posting

Lets get it! GL man!

[emceeaye]

Here's another supporting PIT that you posted (I think) earlier in the season and tarosill modified.
Nice mods in post #2513, too.
Good luck.

HF and p:margin>=7 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) and o:site streak > -8 and WP > 48

[emceeaye]

Yankees/Blue Jays under

two queries pointing to Yankees/Blue Jays under:

starter = Hiroki Kuroda and s:SIP > 6 and team = Yankees and SG=2

H and SG = 2 and day=Friday and p:HR < 3 and op:HR < 2 and 2 < p:hits < 10 and 4 < op:hits < 13 and pp:HR < 4 and opp:HR < 3 and 2 < pp:hits < 13 and 4 < opp:hits < 17 and -3 < ou streak < 4 and -6.5 < p: ou margin < 3.5 and pp:SG != 2 and 4 > ppp:SG > 1 and opp:SG < 4 and 3 < ppp:hits < 19 and 1 < oppp:hits < 16 and p:runs + op:runs < 11 and tA(HR, N=10) < 1.9 and oA(HR, N=10) < 1.6 and 1 < os:SRA < 7 and os:SHA > 2 and os:SHRA < 2 and 35 > os:SHF > 16 and os:SPT < 110

remove space after colon in 3rd line of 2nd query.