2015 SDQL Baseball Thread

**Alex Vaile** · 05-15-15, 04:53 PM

Originally posted by bking79

Thanx alex

Your welcome

**Alex Vaile** · 05-15-15, 04:53 PM

Originally posted by posey

Blue Jays @ Astros
Under 8.5 -107

A - starter = RA Dickey and A and team = Blue Jays and C and o:starter != David Price
OU: 8-19-1 (-0.82, 29.6%) avg total: 8.1 over / under: -$1,255 / +$1,020 ROI: -41.4% / +32.5%

B - team = Blue Jays and C and division != o:division and A and 115 <= line < 150 and date > 20100701 and o:team != Rangers and 4 < month < 10
OU: 12-23-1 (-0.43, 34.3%) avg total: 8.1 over / under: -$1,325 / +$960 ROI: -33.8% / +24.0%

C - starter = Dallas Keuchel and HF
OU: 2-9-0 (-2.50, 18.2%) avg total: 8.2 over / under: -$740 / +$690 ROI: -63.2% / +55.2%

This under looks solid. I'll play along.

**Alex Vaile** · 05-15-15, 05:46 PM

Although you never know when Dickey is on th mound. He has given up the most HR in baseball since 2013.

**Alex Vaile** · 05-15-15, 06:01 PM

Play Under 8 - 105 Tigers vs Cardinals

pp: points < ppo: points and po: points < p: points and rest = 0 and p:runs < 6 and division != o:division and -220 <= line <= -110 and 8 > month > 4 and day != Sunday (Jmon)

**Alex Vaile** · 05-15-15, 11:47 PM

Season to date : 58-56 + 2.72 units
Todays results: 3-1 +2.23 units

Tigers, Royals ML and Royals RL winners and Cards under loser.

**Alex Vaile** · 05-15-15, 11:50 PM

Tomorrow's plays:

Play Yankees + 110

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 ( JMon )

This query smokin...

**posey** · 05-16-15, 01:42 AM

5/15

Giants ML -140, W, +0.71 u
Giants RL +123, W, +1.23 u
Dodgers RL -119, W, +0.84 u
Nationals ML -125, W, +0.80 u
Nationals RL +141, W, +1.41 u
Blue Jays @ Astros Under 8.5 -107, L, -1.00 u

5-1, +3.99 u.

Record: 29-21, +11.19 u.

Sometimes the simple ones are enough...

**posey** · 05-16-15, 02:15 AM

5/16

Red Sox @ Mariners
Under 6.5 -109

A - starter = Felix Hernandez and SG > 1 and line < -120 and p

u margin < 0 and date > 20090601 and C
OU: 8-24-1 (-1.29, 25.0%) avg total: 7.1 over / under: -$1,785 / +$1,495 ROI: -50.3% / +40.2%

B - starter = Felix Hernandez and SG > 1 and HF and p:W
OU: 12-28-3 (-0.76, 30.0%) avg total: 7.4 over / under: -$1,850 / +$1,425 ROI: -39.8% / +29.5%

C - team = Mariners and season > 2014 and H and o:STR
OU: 6-10-1 (-0.24, 37.5%) avg total: 7.2 over / under: -$510 / +$310 ROI: -27.7% / +16.2%

D - starter = Rick Porcello and AD and (day = Friday or day = Saturday or day = Sunday)
OU: 10-16-2 (-0.59, 38.5%) avg total: 8.7 over / under: -$835 / +$475 ROI: -26.7% / +15.7%

E - starter = Rick Porcello and o:STDSERA < 4 and month > 4 and A and C
OU: 6-20-2 (-1.36, 23.1%) avg total: 8.6 over / under: -$1,610 / +$1,340 ROI: -52.2% / +43.5%

**posey** · 05-16-15, 05:55 AM

Nationals @ Padres
Nationals ML -121

A - team = Nationals and p:W and SG > 1 and AF and STDSERA < o:STDSERA and season > 2012 and C and 4 < month < 10
SU: 13-5 (1.00, 72.2%) avg line: -144.5 / 133.9 on / against: +$615 / -$665 ROI: +23.4% / -36.9%

B - starter = Max Scherzer and season > 2012 and AF and p:W and SG > 1
SU: 8-2 (4.40, 80.0%) avg line: -153.5 / 140.3 on / against: +$527 / -$547 ROI: +33.7% / -54.7%

C - team = Nationals and AF and SG > 1 and p:margin > 3 and season > 2010 and line < -110 and total < 8
SU: 11-3 (0.86, 78.6%) avg line: -142.1 / 132.1 on / against: +$617 / -$647 ROI: +30.7% / -46.2%

D - team = Padres and HD and SG > 1 and total < 7 and 136 > line > 105
SU: 12-27 (-2.15, 30.8%) avg line: 120.2 / -130.2 on / against: -$1,258 / +$1,138 ROI: -32.3% / +22.4%

E - team = Padres and HD and SG > 1 and p:runs < 1 and season > 2009
SU: 2-6 (-1.00, 25.0%) avg line: 118.6 / -128.6 on / against: -$346 / +$326

F - starter = Andrew Cashner and H and s:L and date > 20130601
SU: 4-7 (-1.36, 36.4%) avg line: -118.3 / 108.3 on / against: -$489 / +$421 ROI: -35.5% / +35.9%

G - SG > 1 and p:margin > 8 and A and p:AF and -200 < line < -116 and season > 2009
SU: 32-8 (2.15, 80.0%) avg line: -143.5 / 133.1 on / against: +$2,133 / -$2,213 ROI: +37.0% / -55.3%

(IMO especially the 'G'-query is interesting)

**Alex Vaile** · 05-16-15, 09:49 AM

Originally posted by posey

Nationals @ Padres
Nationals ML -121

A - team = Nationals and p:W and SG > 1 and AF and STDSERA < o:STDSERA and season > 2012 and C and 4 < month < 10
SU: 13-5 (1.00, 72.2%) avg line: -144.5 / 133.9 on / against: +$615 / -$665 ROI: +23.4% / -36.9%

B - starter = Max Scherzer and season > 2012 and AF and p:W and SG > 1
SU: 8-2 (4.40, 80.0%) avg line: -153.5 / 140.3 on / against: +$527 / -$547 ROI: +33.7% / -54.7%

C - team = Nationals and AF and SG > 1 and p:margin > 3 and season > 2010 and line < -110 and total < 8
SU: 11-3 (0.86, 78.6%) avg line: -142.1 / 132.1 on / against: +$617 / -$647 ROI: +30.7% / -46.2%

D - team = Padres and HD and SG > 1 and total < 7 and 136 > line > 105
SU: 12-27 (-2.15, 30.8%) avg line: 120.2 / -130.2 on / against: -$1,258 / +$1,138 ROI: -32.3% / +22.4%

E - team = Padres and HD and SG > 1 and p:runs < 1 and season > 2009
SU: 2-6 (-1.00, 25.0%) avg line: 118.6 / -128.6 on / against: -$346 / +$326

F - starter = Andrew Cashner and H and s:L and date > 20130601
SU: 4-7 (-1.36, 36.4%) avg line: -118.3 / 108.3 on / against: -$489 / +$421 ROI: -35.5% / +35.9%

G - SG > 1 and p:margin > 8 and A and p:AF and -200 < line < -116 and season > 2009
SU: 32-8 (2.15, 80.0%) avg line: -143.5 / 133.1 on / against: +$2,133 / -$2,213 ROI: +37.0% / -55.3%

(IMO especially the 'G'-query is interesting)

Nice support for these plays!

**posey** · 05-16-15, 10:13 AM

Thanks! My 'standard' non team related queries didn't work well this month, so I tried to switch things up a little bit and went a little bit more team and pitcher oriented.

**Alex Vaile** · 05-16-15, 10:28 AM

Play Indians - 135
Play Twins -102

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) (Bases)

ROI % 26

**Alex Vaile** · 05-16-15, 11:13 AM

Originally posted by posey

5-1, +3.99 u.

Record: 29-21, +11.19 u.

Sometimes the simple ones are enough...

Nice job Posey!

**bking79** · 05-16-15, 04:39 PM

nice record on mad max

**twestacott** · 05-16-15, 05:54 PM

Texas +140

DOD 10-7, +5.34

**Alex Vaile** · 05-16-15, 10:55 PM

Season to date : 61-56 + 5.82 units

Today's results : 3-0 + 3.1 units.
Needed some heroics from Indians in 9th but got it done.

Twins, Indians and Yankees winners!

**posey** · 05-17-15, 04:59 AM

5/16

Red Sox @ Mariners, Under 6.5 -109, W, +0.92 u.
Nationals @ Padres, Nationals ML -121, W, +0.83 u.

2-0, +1.75 u.

Record: 31-21, +12.94 u.

**posey** · 05-17-15, 06:03 AM

5/17

Braves @ Marlins
Under 7 -107

A - starter = Shelby Miller and season = 2015
OU: 1-6-0 (-1.71, 14.3%) avg total: 7.3 over / under: -$595 / +$505 ROI: -72.6% / +69.2%

B - starter = Henderson Alvarez and DIV and season > 2012 and o:starter != Zack Wheeler
OU: 6-19-1 (-1.35, 24.0%) avg total: 7.3 over / under: -$1,460 / +$1,230 ROI: -51.9% / +42.3%

C - starter = Henderson Alvarez and HF and season > 2012 and C
OU: 3-7-0 (-1.10, 30.0%) avg total: 7.3 over / under: -$485 / +$345 ROI: -44.5% / +31.1%

D - team = Braves and LGS and A and season > 2013 and DIV
OU: 5-10-1 (-1.53, 33.3%) avg total: 7.2 over / under: -$605 / +$435 ROI: -34.4% / +24.6%

E - team = Marlins and o:team = Braves and H and season > 2012 and o:STR
OU: 6-9-0 (0.17, 40.0%) avg total: 7.4 over / under: -$420 / +$240 ROI: -24.9% / +14.7%

F - DIV and LGS and STDSERA + o:STDSERA <= 7 and 20 <= game number <= 45 and HF and league = NL and total > 6 and season > 2006 and team != Diamondbacks and o:team != Rockies
OU: 17-33-4 (-0.46, 34.0%) avg total: 7.9 over / under: -$1,810 / +$1,475 ROI: -30.9% / +24.4%

Look at B, D and F!

**posey** · 05-17-15, 07:02 AM

Giants @ Reds
Under 8 +101

A - team = Reds and HF and o:STR and season > 2013 and -145 < line < -110
OU: 8-21-1 (-0.67, 27.6%) avg total: 7.5 over / under: -$1,425 / +$1,190 ROI: -44.7% / +34.7%

B - team = Reds and H and LGS and C and date > 20130421 and o:team != Cardinals and starter != Johnny Cueto and total < 9 and day != Thursday
OU: 5-16-1 (-1.48, 23.8%) avg total: 7.7 over / under: -$1,255 / +$1,040 ROI: -52.4% / +42.4%

C - SG > 2 and p:L and pp:L and 45 < WP < 55 and 45 < o:WP < 55 and ou streak >= 2 and total < 9 and 110 > line > -150 and H and C
OU: 7-18-0 (-1.30, 28.0%) avg total: 8.1 over / under: -$1,280 / +$1,055 ROI: -46.1% / +38.7%

D - team = Giants and A and o:team = Reds and o:STDSERA < 5 and total > 7 and month > 4 and starter != Barry Zito
OU: 3-11-1 (-1.87, 21.4%) avg total: 8.9 over / under: -$875 / +$775 ROI: -54.5% / +45.9%

E - team = Giants and AD and p:home runs > 1 and pp:home runs > 1 and SG > 2
OU: 4-10-2 (-0.94, 28.6%) avg total: 8.7 over / under: -$680 / +$560 ROI: -39.5% / +31.1%

F - A and team != Nationals and 60 > game number > 30 and tA(home runs) < 1 and o:team != Rockies and p:home runs > 1 and pp:home runs > 1 and SG > 2 and C and league = NL
OU: 6-13-2 (-1.00, 31.6%) avg total: 8.8 over / under: -$830 / +$660 ROI: -35.6% / +28.8%

**leetreaper** · 05-17-15, 07:42 AM

Thank you Alex and Posey, keep up the great job guys!!!

**Alex Vaile** · 05-17-15, 10:53 AM

Today's plays:

Play Indians - 136

A and total>7 and p:SII>=4 and p:hits>12 and WP<50 and season>=2014 (b1slickguy )

starter= Carlos Carrasco and AF
starter = Nicholas Martinez and HD

**mdunlap3** · 05-17-15, 03:24 PM

Nick Martinez kid looks legit...

**Alex Vaile** · 05-17-15, 07:02 PM

Originally posted by mdunlap3

Nick Martinez kid looks legit...

yeah he really improved from last year that's for sure s***** play for me sorry

**Alex Vaile** · 05-18-15, 12:32 AM

Season to date : 61-57 + 4.46 units
Today's results : 0-1 -1.36 units

Indians losers

**posey** · 05-18-15, 12:53 AM

5/17

Braves @ Marlins, Under 7 -107, W, +0.93 u.
Giants @ Reds, Under 8 +101, L, -1.00 u.

1-1, -0.07 u.

Record: 32-22, +12.87 u.

**Alex Vaile** · 05-18-15, 07:48 AM

Today's plays :

Play Marlins -134

HF and p:FL and p:SG = 3 and SG = 1 and p:line > -190 and streak > -6 and o:streak < 4 and p:runs < 8 and op:hits < 12 and op:runs < 9 ( Bases )

**posey** · 05-18-15, 12:03 PM

Record: 32-22, +12.87 u.

5/18

Brewers @ Tigers
Tigers ML -137

A - starter = Mike Fiers and A
SU: 2-5 (-0.43, 28.6%) avg line: 126.8 / -136.8 on / against: -$245 / +$230 ROI: -33.5% / +23.7%

B - team = Brewers and A and 100 < line < 150 and SG = 1 and p:AL and season > 2011
SU: 6-12 (-1.06, 33.3%) avg line: 117.2 / -127.2 on / against: -$497 / +$437 ROI: -27.6% / +19.2%

C - team = Brewers and AD and line < 150 and league != o:league and season > 2009 and 8 > month > 4
SU: 2-13 (-2.87, 13.3%) avg line: 120.0 / -130.0 on / against: -$1,077 / +$1,057 ROI: -71.8% / +54.5%

D - team = Brewers and AD and o:STL and season > 2011 and month < 8
SU: 9-21 (-0.67, 30.0%) avg line: 131.7 / -142.0 on / against: -$923 / +$833 ROI: -30.8% / +19.5%

E - team = Tigers and HF and SG = 1 and league != o:league and season > 2007 and month < 9
SU: 16-5 (1.86, 76.2%) avg line: -157.7 / 142.9 on / against: +$891 / -$941 ROI: +26.8% / -44.8%

F - team = Tigers and o:WP < 40 and 4 < month < 6 and o:STR and F and season > 2010
SU: 13-2 (3.40, 86.7%) avg line: -195.8 / 174.2 on / against: +$902 / -$952 ROI: +30.1% / -63.5%

G - 70 > WP > 50 and o:WP < 40 and F and -132 > line > -165 and league = AL and month = 5 and o:team != Rays and team != Yankees
SU: 29-12 (1.85, 70.7%) avg line: -145.0 / 135.0 on / against: +$1,179 / -$1,299 ROI: +19.8% / -31.7%

**Alex Vaile** · 05-18-15, 12:23 PM

Shoot I had Angels play today but didn't realize early start.
Not counting as a play but here's query. Maybe a live bet?

s:SIP = 8 and 0 < s:SRA < 3 and s:SSO > 3 and 0 < s:SWA < 5 and s:SHF < 34 and starter rest < 7 and 3 < s:SHA < 6 and (A or day != Saturday) and (A or SG < 4) and line < 147 and 2 < p:hits < 16 and op:margin > -9 and game number < 154

**posey** · 05-18-15, 12:49 PM

No live bet.

**Alex Vaile** · 05-18-15, 05:50 PM

Originally posted by posey

No live bet.

Yes good thing i missed that

**inZane** · 05-18-15, 06:40 PM

I didn't but the over bailed me out, keep up the hard work guys, we all have our own ways. I respect the time and energy you put into yours.

**Alex Vaile** · 05-18-15, 11:38 PM

Season to date : 61-58 +3.12 units
Today's results : 0-1 -1.34 units

Marlins lose in 13

**Alex Vaile** · 05-18-15, 11:41 PM

Tomorrow's plays:

Play Giants even
Play Under 7 even Dodgers vs Giants

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

**Alex Vaile** · 05-18-15, 11:46 PM

Play Royals - 120
Play Tigers RL - 1.5 + 120

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

**Alex Vaile** · 05-19-15, 07:15 AM

Originally posted by inZane

I didn't but the over bailed me out, keep up the hard work guys, we all have our own ways. I respect the time and energy you put into yours.