MLB - Situation Plays - SDQL

**Alex Vaile** · 09-02-14, 12:31 PM

First play: ( Bases )

Play Cincinnati + 130

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

**Alex Vaile** · 09-02-14, 12:50 PM

Second and third plays: ( Bases )

Under 7.5 -110 Phillies vs Braves
Under 6 - 120 Nats vs Dodgers

**b1slickguy** · 09-02-14, 12:55 PM

Fade DET.
Good luck.

AD and total>7 and p:SII>=4 and p:hits>12 and WP>=50 and season=2014 and conference=AL

**JMon** · 09-02-14, 04:16 PM

Play Yankees under

SDQL by bases, note space after o:

H and -7 < ou streak < 2 and -6 < o: ou 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) and team=Yankees

**Alex Vaile** · 09-02-14, 04:27 PM

Originally posted by b1slickguy

Fade DET.
Good luck.

AD and total>7 and p:SII>=4 and p:hits>12 and WP>=50 and season=2014 and conference=AL

Looks great thanks slick!

**JMon** · 09-02-14, 04:34 PM

Originally posted by Alex Vaile

Looks great thanks slick!

Be careful Slicker wants Det to lose, LOL

**JMon** · 09-02-14, 04:38 PM

Play Marlins ML and RL

SDQL

NL home dogs on Tuesday...

H and -105 <line and day=Tuesday and conference=NL and team=Marlins and 2014=season

**JMon** · 09-02-14, 04:40 PM

Play Cubs

SDQL- also a NL home dog on tues

SG = 2 and streak = 1 and o:streak > -8 and SGS = 3 and -5 < site streak < 9 and p:runs + op:runs > 4 and game number > 37 and line < 120 and 2 < opp:SG < 5 and op:runs != 0 and (tS(margin, N=20) > 15 or tS(margin, N=20) < -1) and -56 < oS(margin, N=20) < 29 and tS(HR, N=20) - oS(HR, N=20) > -9 and tS(runs, N=20) - oS(runs, N=20) > -33 and tS(hits, N=20) - oS(hits, N=20) > -45 and s:SHA > 1 and 0 < s:SSO < 11 and s:SIP > 2.9 and 71 < s:SPT < 113 and os:SWA < 5 and os:SSO < 10 and os:SIP < 7.1 and os:SPT < 113

**JMon** · 09-02-14, 04:40 PM

double post**

**b1slickguy** · 09-02-14, 06:01 PM

Originally posted by JMon

Be careful Slicker wants Det to lose, LOL

Really need them to lose so KC can keep the lead in the AL Central. Go Royals!
Good luck.

**Alex Vaile** · 09-02-14, 06:47 PM

Fourth play : ( Bases )

Play Pirates + 135

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** · 09-03-14, 07:46 AM

braves/phillies under and Indians/Tigers under

Bases' unders:

Braves/phillies
Indians/Tigers

season > 2008 and H 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)

add: month=9 and SG=3 and day=Wednesday

**emceeaye** · 09-03-14, 09:23 AM

orioles su

HF and tA(W, N=15)>.26+oA(W, N=15) and WP>o:WP and op:L and SG=2 and os:SRA<s:SRA

Add: and day=Wednesday and month>=8

Update: looks like this one going in opposite direction, though only small N...

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

**mdunlap3** · 09-03-14, 10:23 AM

Play BoSox (emcee query I believe)

D and starter wins - o:starter wins < -8 and s:W and os:L and oss:W and o:starter rest < 8 and SG < 4 and season > 2011

**JMon** · 09-03-14, 10:39 AM

Play Balt

SDQL

175 >= line >= 120 and P:margin = -1 and s:SRA = 0 and site = away

**hyahya** · 09-03-14, 10:45 AM

Header numbers: ROI, # of samples, avg line (for side plays only)

31.2 163 153

rangers

29 550 -114

astros
reds

30 430 106

marlins

38 250 107

cubs
rockies

5.4 1800 -108

astros

33 410 121

mets

33.5 240 -118

orioles

28 500 126

mets

25 180

under rangers

28 800 134

pirates

mets
chisox

38 130 107

marlins
reds

56 70 142

mets

37 320 -117

cards

43 120 104

mariners

39 230 -121

dbacks

8 1350 139

pirates

rangers

22 380 108

pirates
giants

30 475

under braves

31 430 107

marlins

32 420

under mariners

32 475 -110

astros

31 530

under braves

under tigers

48 96 138

rangers

31 125 -156

orioles

100 40 151

bosox

**Alex Vaile** · 09-03-14, 11:06 AM

2 and 2 for 0 units yesterday
110 and 91 overall
+ 11.34 units

**Alex Vaile** · 09-03-14, 11:10 AM

First play : ( Bases )

Under 7.5 - 125 Phillies vs Braves
Under 8 - 110 Tigers vs Indians

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** · 09-03-14, 11:13 AM

Geez do the Cubs have the Brewers number in this spot!!! Crazy ML, RL and Under

SDQL

site==home and 145>line>=100 and tA(SSO)>=5 and tA(TLOB)<=6.9 and 2008<=season and SG<4 and team=Cubs and o:team=Brewers

**emceeaye** · 09-03-14, 01:46 PM

white Sox RL

195>line > 105 and line < 200 and division = o:division and op:WP < 47 and season > 2002 and month>=8 and SG=2 and season>=2011

Try month=9

**hyahya** · 09-04-14, 08:41 AM

34.5 180 -109

bosox

29 145

over padres

35 190

over mariners

28 800 134

rangers

50 75 109

indians

8 1400 138

rangers

35 170

under orioles

10.5 1400 126

jays

30 475

under orioles

30 210

over angels

35 220

under bosox

37 105 -108

cards

25 460

under bosox

**emceeaye** · 09-04-14, 08:42 AM

Originally posted by JMon

Geez do the Cubs have the Brewers number in this spot!!! Crazy ML, RL and Under

SDQL

site==home and 145>line>=100 and tA(SSO)>=5 and tA(TLOB)<=6.9 and 2008<=season and SG<4 and team=Cubs and o:team=Brewers

beautiful job!!!!

**mdunlap3** · 09-04-14, 08:47 AM

Originally posted by JMon

Geez do the Cubs have the Brewers number in this spot!!! Crazy ML, RL and Under

SDQL

site==home and 145>line>=100 and tA(SSO)>=5 and tA(TLOB)<=6.9 and 2008<=season and SG<4 and team=Cubs and o:team=Brewers

Wow what a query! Amazing job bro.

**emceeaye** · 09-04-14, 09:52 AM

padres/d-backs over

Here's a Bases query on the d-backs/padres over:

SG = 4 and month>=8 and H and -4 < (ou streak + ou streak) < 11 and op:HR < 2 and 11 > op:hits > 7 and os:SHA > 4 and s:SHA > 2 and 4 < p:hits < 14

See also month=9

**mdunlap3** · 09-04-14, 10:17 AM

Angels/Twins over

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

**emceeaye** · 09-04-14, 10:43 AM

Originally posted by mdunlap3

Angels/Twins over

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

Nice!

Add month=9 and see what happens.

**mdunlap3** · 09-04-14, 11:57 AM

Mariners/Rangers Over

(SG = 1 or SG = 4) and 1 < SGS < 5 and p:HR = 2 and op:HR < 3 and s:SHRA = 1 and os:SHRA < 2 and ss:SHRA = 0 and sss:SHRA < 3 and s:SRA < 7 and s:SSO > 1 and p:hits < 16 and tA(hits, N=10) < 10.5 and oA(hits,N=10) > 7.3 and tA(HR, N=10) > .6 and oA(fly balls, N=10) < 10.5 and tA(SO, N=10) < 8.6

Update: Found a conflicting query pointing to the under. Any thoughts?

tp:runs<=2 and op:runs<=2 and conference=AL andA

**Alex Vaile** · 09-04-14, 12:00 PM

1 and 1 yesterday for -.15 units
111 and 92 overall

+11.19 units

**mdunlap3** · 09-04-14, 12:02 PM

Yanks/BoSox under

-5 < ou streak < 2 and SG = 3 and H and o

ustreak > -4 and tS(ou margin, N=10) < 11 and 6 < tS(O, N=20) < 11and oS(total, N=10) > 81.5 and tS(total, N=10) > 76 and s:SHF > 20 andos:SHF > 13 and os:SPT > 73 and 76 < s:SPT < 117 and -3.5 < s

umargin < 5.5 and os

u margin < 4.5 and p:hits + pp:hits > 9 andop:hits + opp:hits < 27 and p:margin > -6 and p:RMAX < 6 and op:SII< 4 and pp:RMAX < 6 and opp:SII < 6

**Alex Vaile** · 09-04-14, 12:07 PM

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

**mdunlap3** · 09-04-14, 12:13 PM

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

**mdunlap3** · 09-04-14, 12:13 PM

Originally posted by Alex Vaile

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

Woot! Got another one above this post supporting this play as well.

**Alex Vaile** · 09-04-14, 12:20 PM

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!

**emceeaye** · 09-04-14, 01:04 PM

Originally posted by mdunlap3

Mariners/Rangers Over

(SG = 1 or SG = 4) and 1 < SGS < 5 and p:HR = 2 and op:HR < 3 and s:SHRA = 1 and os:SHRA < 2 and ss:SHRA = 0 and sss:SHRA < 3 and s:SRA < 7 and s:SSO > 1 and p:hits < 16 and tA(hits, N=10) < 10.5 and oA(hits,N=10) > 7.3 and tA(HR, N=10) > .6 and oA(fly balls, N=10) < 10.5 and tA(SO, N=10) < 8.6

Update: Found a conflicting query pointing to the under. Any thoughts?

tp:runs<=2 and op:runs<=2 and conference=AL andA

For me its now a no play for that reason.

**RollinDo** · 09-04-14, 01:14 PM

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