2016 SDQL Plays

**Alex Vaile** · 05-19-16, 10:58 AM

Play Indians vs Reds Under 8 + 100

team=Indians and line <=-120 and po:HR>=3 and p:SIP<6 and season >= 2009

Indians 1/20 o/u in this spot

**Spartak** · 05-19-16, 12:30 PM

Hi Alex,
which query to use for teams that has pass the total in last 3 games with 3+runs
10x in advance
GL with your plays.

**Alex Vaile** · 05-19-16, 12:34 PM

Originally posted by Spartak

Hi Alex,
which query to use for teams that has pass the total in last 3 games with 3+runs
10x in advance
GL with your plays.

Depending on what teams you could try team=XXX and ou streak=3 and date>=20160517

But I am not sure I understand your question about passing total 3 runs 10X?

Are you referring to TT team totals?

**Alex Vaile** · 05-19-16, 12:43 PM

Play Cubs RL -120
Play Cubs -190

F and p:A and p:W and date>=20150724

ROI 24%

team=Brewers and HD and s:W and ss:W and date>=20060801

1-23 SU 7-23 RL

**Spartak** · 05-19-16, 12:44 PM

I mean games that has finished with margin 3+ over the total, not TT.
For example the bookie is giving 7.5 and the games went with 12 runs scored.

**Alex Vaile** · 05-19-16, 02:53 PM

Originally posted by Spartak

I mean games that has finished with margin 3+ over the total, not TT.
For example the bookie is giving 7.5 and the games went with 12 runs scored.

I believe the parameter you seek is ou margin and that is either + or - for the total.

For example team=Dodgers and ou streak =3 and date>=20160520

**Alex Vaile** · 05-19-16, 03:28 PM

Play Angels - 119

conference=NL and o:conference=AL and A and 230>=line>-105 and month<8 and 9.5>=total>=7

ROI 7% 900 game sample

**Alex Vaile** · 05-19-16, 03:30 PM

Play White Sox - 170

WP>12+o:WP and s:starter strike outs>=.81*so:hits and s:A and HF and season>=2010 and s:SRA<6 and tA(BPRA, N=6)<2 and s:SPT/s:SIP<=15 and s:SPT/so:at bats<3.9

ROI 9%

And

team = White Sox and SG > 1 and p:SIP<8 and p:BPRA = 0 and po:SO>=5 and season >= 2016

White Sox 11-1 this season in this spot

**Spartak** · 05-19-16, 03:32 PM

Originally posted by Alex Vaile

I believe the parameter you seek is ou margin and that is either + or - for the total.

For example team=Dodgers and ou streak =3 and date>=20160520

Thank you Alex,
there is what I was looking for:
p

u margin>2.5 and pp

u margin>2.5 and ppp

u margin>2.5 and team

**Alex Vaile** · 05-19-16, 03:35 PM

Play Blue Jays -140

team = Twins and p: D and p: BL = 0 and p:L and date >= 20151004

Twins 0-13 SU in this spot including 0-12 this season.

And

team=Twins and HD and season =2016

Twins 2-6 this season as home dog including 0-4 last 4.

**Alex Vaile** · 05-19-16, 03:36 PM

Originally posted by Spartak

Thank you Alex,
there is what I was looking for:
p

u margin>2.5 and pp

u margin>2.5 and ppp

u margin>2.5 and team

Yup there you go no prob. Put a space in between the : and o so that smileys don't show up.

**Alex Vaile** · 05-19-16, 03:43 PM

Play Nationals - 118

team=Mets and HD and o:team=Nationals

Mets 3-22 SU in this spot losing their last 17/18 games as home dog to Nats

starter=Stephen Strasburg and s: pitches>100 and date>=20150803

Nats 15-2 when Strasburg pitched more than 100 pitches in his last start

**Alex Vaile** · 05-19-16, 07:46 PM

Play Dodgers vs Angels Under 7.5 + 105

team=Angels and F and po:BPRA>po:SRA and p:H and SG>1 and date>=20140506

Angels 10 straight unders in this situation

**Alex Vaile** · 05-20-16, 08:38 AM

Yesterday's results: 7-4 + 1.9 units
Season to date: 111-103-3 + 6.24 units

Winners: Nats, White Sox, Jays, Angels, Mariners RL, Mariners ML, and Mariners over total

Losers: Cubs ML and RL, Angels Under and Indians under

**Alex Vaile** · 05-20-16, 04:03 PM

Friday:

Play Over 7.5 + 105 Yankees vs Athletics

AD and tS(o:hits-starter hits + o:walks - starter walks) / tS(9-starter innings pitched) <= 1.15 and line <= 150 and month < 9 and rest < 2

ROI 8%

On a nice run this query. CC coming off DL and Gray been off.

**Alex Vaile** · 05-20-16, 04:05 PM

Play Nationals - 137
Play Nats RL + 135

p:RMAX > 5 and AF and month!=4 and p:A and n:series game<4 and total>7

ROI ML 13%
ROI RL 31%

And

team = Nationals and F and p:F and po:hits <= 6 and date >= 20151001

Nats 10-0 in this spot

**Alex Vaile** · 05-20-16, 04:08 PM

Play Orioles + 112

team=Orioles and line>=-140 and p:margin <=-5 and p:H and date>=20120729

Orioles 24-0 in this spot

**Alex Vaile** · 05-20-16, 04:08 PM

Play Blue Jays -128

F and p:A and p:W and date>=20150724

ROI 16%

**Alex Vaile** · 05-20-16, 04:12 PM

Play Astros -150

starter rest - o:starter rest = 1 and (A or day != Monday) and (H or day != Friday) and 4 < starter rest < 11 and -2 < p:margin < 9 and -11 < op:margin < 8 and -10 < streak < 3 and -10 < o:streak < 6 and site streak < 8 and o:site streak < 8 and -29 < tS(margin, N=10) < 24 and -13 < oS(margin, N=10) < 15 and 15 < tS(hits, N=3) < 36 and tS(HR, N=10) < 14 and 18 < oS(hits, N=3) < 36 and 4 < oS(HR, N=10) < 17 and os:SSO < 10 and os:SWA < 5 and oS(margin, N=10) - tS(margin, N=10) > -15 and tS(hits, N=10) - oS(hits, N=10) > -23 and (game number > 139 or game number < 122)

ROI 24%

And

team = Astros and H and p:TLOB < 5 and date >=
20150629

Astros 11-0 in this spot

**Alex Vaile** · 05-20-16, 04:15 PM

Play Over 8.5 -120 Mariners vs Reds

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

ROI 18%

And

team = Mariners and F and po:LOB<=10 and p:W and SG = 1 and date >= 20130708

9/2 o/u in this spot

**Alex Vaile** · 05-20-16, 06:11 PM

Play Cardinals -153

team=Cardinals and H and line<-120 and SG=1 and date>=20120915

ROI 14%

**Alex Vaile** · 05-21-16, 09:44 AM

Yesterday's results: 6-2 + 3.49 units
Season to date: 117-105-3 + 9.73 units

Winners: Nats RL and ML, Mariners over, Blue Jays, Orioles and As over

Losers: Astros and Cardinals

**BKLYN921** · 05-21-16, 09:47 AM

**Alex Vaile** · 05-21-16, 11:00 AM

Saturday:

Play Orioles -125
Play Orioles RL + 135
Play Indians +129

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

ROI 30%

And

AF and total>7 and p:SII>=4 and p:hits>12 and WP>50 and season>=2011 and pp:SII<4 and conference=AL and SG>1

ROI ML 32%
ROI RL 39%

**Alex Vaile** · 05-21-16, 11:29 AM

Play Rockies + 108

starter rest - o:starter rest = 1 and (A or day != Monday) and (H or day != Friday) and 4 < starter rest < 11 and -2 < p:margin < 9 and -11 < op:margin < 8 and -10 < streak < 3 and -10 < o:streak < 6 and site streak < 8 and o:site streak < 8 and -29 < tS(margin, N=10) < 24 and -13 < oS(margin, N=10) < 15 and 15 < tS(hits, N=3) < 36 and tS(HR, N=10) < 14 and 18 < oS(hits, N=3) < 36 and 4 < oS(HR, N=10) < 17 and os:SSO < 10 and os:SWA < 5 and oS(margin, N=10) - tS(margin, N=10) > -15 and tS(hits, N=10) - oS(hits, N=10) > -23 and (game number > 139 or game number < 122)

ROI 24% 700 game sample

**Alex Vaile** · 05-21-16, 11:35 AM

Play Royals - 119

F and p:A and p:W and date>=20150724

ROI 17%

team = White Sox and o:STL and season=2016

3-6 SU this season vs left handed pitching. 0-4 last 4.

And

team=White Sox and H and o:team=Royals and season >2013

Sox 6-15 SU facing Royals last few years.

**Alex Vaile** · 05-21-16, 12:06 PM

Play Rangers vs Astros Under 9 -110

team = Rangers and p:SO >= 10 and p:A and SG > 1 and date >= 20150520

Rangers 1/15 o /u in this spot

**Alex Vaile** · 05-21-16, 12:08 PM

Play Nationals vs Marlins Under 7 +100

team=Nationals and A and oS:W and oS:season = season and p:A and date >= 20140916

Going under when seeking same season revenge against pitcher

Nats 0/16 o/u in this spot

And

team = Nationals and A and line>=140 and p:HR > po:HR and date >= 20110922

Nats 0/12 o/u in this spot

**Alex Vaile** · 05-21-16, 01:21 PM

Play Rangers + 173

D and p:W and p:runs < 4 and SGS < 5 and SG != 3 and -4 < p:streak < 2 and 6 > o:streak > -4 and line > 134 and op:runs < 10 and 0 < op:TLOB < 11 and p:SG < 4 and p:SGS > 2

ROI 19%

And

D and p: DW and p:runs <= 3 and SG < 5 and total < 10 and conference=o:conference

ROI 7% 1200 game sample

**Alex Vaile** · 05-21-16, 02:08 PM

Play Marlins -145

starter = Jose Fernandez and H and s:SSO > s:SHA
and date >= 20130413

Marlins 21-0 SU when Fernandez at home had more strikeouts than hits allowed in his last start

And

175>=line>=125 and Sum(hits@team and season)/Sum(at bats@team and season)<=.250 and os:starter era<=3.7 and o:conference=NL and Average(starter hits@starter and season)<=5.5 and 2008<=season

ROI 9%

**Alex Vaile** · 05-22-16, 01:06 AM

Today's results: 8-1 + 8.16 units
Season to date: 125-106-3 + 17.89 units

Winners: Orioles ML and RL what a finish, Rangers ML and Rangers under, Royals, Marlins ML and Marlins under and Rockies all won

Losers: Indians

Hell of a day Orioles down to 2 outs top 9 and Wieters hits a 3 run bomb.

**POOLSIDE** · 05-22-16, 02:21 AM

Nice fccking day my man

**Alex Vaile** · 05-22-16, 10:32 AM

Originally posted by POOLSIDE

Nice fccking day my man

Thank you sir!

**bking79** · 05-22-16, 10:43 AM

reds should get it done today

**Alex Vaile** · 05-22-16, 10:46 AM

Sunday:

Play Rays + 104
Play Rays RL -205

team=Rays and AD and o:WP <WP and date>=20150503

ROI ML 34%
ROI RL 27% 23-5 against RL