2015 SDQL Baseball Thread

**Alex Vaile** · 06-26-15, 10:48 AM

Play Under 6.5- 115 Reds vs Mets

total<=7 and Sum(hits@team and season)/Sum(at bats@team and season)<=245 and conference=NL and (p:runs+po:runs)<=2 and 2011<=season

( Jmon )
ROI % 18

**Alex Vaile** · 06-27-15, 09:43 AM

Yesterday's results : 2-3 - 1.04 units
Season to date : 169-176 - 12.14

Reds under and Cards winners, 3 bullpen collapses in Arizona and White Sox losers and Houston losers. Shitty day by pens cost a winning day.

**Alex Vaile** · 06-27-15, 09:46 AM

Today's plays :

Play Under 8.5 even Indians vs Orioles

p:L and p:hits>7.5 and op:SO>5 and D and season>=2015 and o:STDSERA>4.05 and total>7.5

(Bking )
ROI % 39

**Alex Vaile** · 06-27-15, 09:55 AM

Play Mets - 174
Play Mets RL + 135
Play Reds vs Mets Under 6.5 - 115

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 and day=Saturday

ROI % ML 28
ROI % RL 9
ROI % o/u 6

**Alex Vaile** · 06-27-15, 10:01 AM

Play Under 6.5 +105 D-Backs vs Padres

(team = Padres or team = Giants or team = Mariners) and H and total > 6 and (SGS < 4 or (SGS = 4 and SG != 4 and SG != 2)) and 1605 < start time < 2215 and p:hits < 10 and day != Friday and p:HR + op:HR < 3 and tS(HR, N=10) + oS(HR, N=10) < 23 and 2 < pp:hits < 14 and p

u margin +op

u margin < 8 and tS(ou margin, N=10) > -12.5

(Bases)
ROI % 24

**Alex Vaile** · 06-27-15, 11:29 AM

Play Giants -137

starter=Tim Lincecum and HF and DAY
team=Giants and HF and p:L and p:margin>=-2 and DAY
starter=Christopher Rusin and AD

Lincecum has won his last 8 home Day starts. Giants after a home loss haven't been great this year but I like Giants to win today and Timmy to be better after last few awful starts.

**Alex Vaile** · 06-27-15, 08:47 PM

Giants needed that!

**Alex Vaile** · 06-28-15, 09:32 AM

Yesterday's results : 1-1 even.
Season to date : 170-177 -12.14 units

Giants winner and Pads under losers. The rest postponed.

**Alex Vaile** · 06-28-15, 09:39 AM

Today's plays :

Play Twins + 143

month = 6 and F and o:streak = 1 and SG != 1 and -120 > line and os:SRA < 7 and oss:SRA < 9 and s:SRA < 8 and ss:SRA != 0 and site streak < 6 and p:margin > -4

( Bases )
ROI % 30

**Alex Vaile** · 06-28-15, 09:42 AM

Play Red Sox vs Rays Under 6.5 +105
Play Red Sox +161
Play Red Sox RL + 1.5 - 145

team = Red Sox and A and DAY and season > 2011 and o:STDSERA < 3.5 and month > 4

ROI % 41

**Alex Vaile** · 06-28-15, 09:50 AM

Play Twins vs Brewers Under 8 - 110
Play Dodgers vs Marlins Under 7 - 110

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)

( Bases )
ROI % 29

**Alex Vaile** · 06-28-15, 09:52 AM

Play Under 7 - 115 Mariners vs Angels

H and month > 5 and season>2009 and 1.2 > tA(BPRA) > .6 and 8>(s:SRA-os:SRA)>-4 and (p:hits + os:walks)<15 and month!=8 and s:SRA<6 and os:SRA<5 and 30.7>(p:SIP + pp:SIP + ppp:SIP + pppp:SIP)>18.7 and (op:SIP + opp:SIP + oppp:SIP + opppp:SIP)>19.4 and total>6.4 and p

u margin>-6.6 and streak<5 and o:streak<6 and -8 < o

u streak<4 and os:SPT<123 and team!=Twins and team!=Red Sox and o:team!=Indians and (s:SSO + ss:SSO + sss:SSO + ssss:SSO)>9 and (s:SSO + ss:SSO + sss:SSO)<26 and (os:SSO + oss:SSO + osss:SSO +ossss:SSO +osssss:SSO)>13 and (os:SSO + oss:SSO + osss:SSO +ossss:SSO)<31

( Bases )
ROI % 26

**b1slickguy** · 06-28-15, 11:48 AM

Games following a rain out/postponed game or scheduled weather days.
Good luck.

HD and rest=1 and SG>1 and playoffs=0 and total<=8

**Alex Vaile** · 06-28-15, 11:56 AM

Originally posted by b1slickguy

Games following a rain out/postponed game or scheduled weather days.
Good luck.

HD and rest=1 and SG>1 and playoffs=0 and total<=8

Thanks for stopping by Slick and the query too.

**Alex Vaile** · 06-28-15, 12:01 PM

Ill post that for those that didn't know.

Play Phillies + 160
Play Phillies Under 8 - 110

HD and rest=1 and SG>1 and playoffs=0 and total<=8

( b1slickguy )
ROI % 28 ML
ROI % 43 under

**Alex Vaile** · 06-28-15, 12:04 PM

Play Mets - 140

t:team=Mets and HF and SG=SGS and date>=20130616 and o:wins<wins

(SDQG)
ROI % 71

**Alex Vaile** · 06-28-15, 12:07 PM

Play Under 9 +100 Rangers vs Blue Jays

t:team=Rangers and p:SO>=10 and date>=20150520

(SDQG)
ROI % 94

**Alex Vaile** · 06-28-15, 09:23 PM

Today's results: 6-2-1 + 4.61 units
Season to date: 176-179 -7.53 units

Mets, Red Sox RL, Red Sox ML, Dodgers under, Angels under, Jays Under winners and Twins ML and Red Sox Under losers and Brewers Under pushed.
Phillies and under weren't my plays so I didn't count them. They went 1 and 1. Coming back towards positive.

**Alex Vaile** · 06-29-15, 12:20 PM

Play Rangers vs Orioles Under 9 - 115

p:L and p:hits>7.5 and op:SO>5 and D and season>=2015 and o:STDSERA>4.05 and total>7.5

( Bking )
ROI % 39

And

4 < so:R1 < 9 and s:SRA < 10 and s:SPT < 110 and starter rest < 40 and s:SHRA < 3 and SG != 3 and (game number > 118 or game number < 107) and os:SRA < 7 and os:SHA > 2 and os:SSO < 10 and os:SHRA < 3 and ou streak > -3

ROI % 41

**Alex Vaile** · 06-29-15, 12:23 PM

Play D-Backs + 140

s:SO > 9 and s:W and A and season > 2005 and -185<=line<=100 and conference = o:conference and starter rest < 10 and rest = 0 and SG<3 and month<9 and 10>=total>=7

ROI % 24

**Alex Vaile** · 06-29-15, 12:31 PM

Play Athletics - 1.5 + 130
Play Athletics - 160

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

( b1slickguy )
ROI % 5 RL
ROI % 8 ML

**Alex Vaile** · 06-29-15, 12:35 PM

Play Royals + 125

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 % 11

This query heating up now again.

**Alex Vaile** · 06-30-15, 07:07 AM

Yesterday's results : 3-1-1 +2.7 units
Season to date : 179-180 - 4.83 units

D-Backs, As ML, As RL winners and Royals losers and Rangers under push. Nice comeback from D-Backs!

**Alex Vaile** · 06-30-15, 07:45 AM

Today's plays :

Play Nationals - 117

WP < 53 and A(SWHIP@starter and season) < 1.2 and A(SOPW@starter and season) >= .333 and A(SSPB@starter and season) >= .50 and D and conference = NL and SG < 4 and line > 100 and month!= 9

(JMon)
ROI % 8

**Alex Vaile** · 06-30-15, 07:52 AM

Play Athletics - 1.5 + 110

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

( b1slickguy )
ROI % 8

**Alex Vaile** · 06-30-15, 08:25 AM

Play Under 7 - 115 Rays 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)

( Bases )
ROI % 28

**inZane** · 06-30-15, 08:39 AM

Good job Alex, keep 'em coming!

**Alex Vaile** · 06-30-15, 12:54 PM

Thanks inZane. Coming back a little now... good luck today!

**Alex Vaile** · 06-30-15, 06:37 PM

Originally posted by Alex Vaile

Play Athletics - 1.5 + 110

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

( b1slickguy )
ROI % 8

Athletics no play today due to pitching change.

**joco** · 06-30-15, 09:57 PM

time to slowly bring ur way into the black my man. u got this

**Alex Vaile** · 06-30-15, 11:11 PM

Originally posted by joco

time to slowly bring ur way into the black my man. u got this

Thanks Joco ya Ive been up and down for sure and now coming up I'm hoping. Another win for you buddy. I had Mariners too but didn't post in time. Let's keep it rolling

**Alex Vaile** · 06-30-15, 11:12 PM

Originally posted by Alex Vaile

Play Under 7 - 115 Rays 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)

( Bases )
ROI % 28

The teams scored 7 runs in last 2 innings. Was 1 to 0 in 7th. What a loss.

**Alex Vaile** · 06-30-15, 11:25 PM

Today's results : 1-1 - .15 units
Season to date : 180-181 -4.98 units

Nats win and got burned on Rays under loser. As no play due to pitching change

**joco** · 07-01-15, 12:03 AM

roll baby roll

**Alex Vaile** · 07-01-15, 01:50 AM

Tomorrow's plays:

Play Red Sox + 129

p:errors = 0 and op:errors = 1 and (H or SG > 1) and SG < 5 and SGS > 2 and SGS - SG < 3 and (H or day != Saturday) and ((H and -215 < line < 142) or (A and -200 < line < 175)) and (conference = AL or o:conference = NL) and op:HR < 3 and p:runs > 2 and p:margin > -2 and 12 > pp:margin > -9 and streak < 5 and -7 < o:streak < 3 and p:SO < 14 and game number > 13 and -21 < tS(margin, N=10) < 29 and -30 < oS(margin, N=10) < 26 and s:SHA > 1 and s:SWA < 6 and s:SSO < 11 and s:SIP > 1.9 and s:SHF > 21 and s:SPT < 121 and 4 < starter rest < 17 and os:SRA < 7 and os:SWA < 6 and 20 < os:SHF < 33 and os:SIP < 8.1 and o:starter rest < 10 and op:runs < 9 and opp:runs < 13 and oppp:runs < 11 and oS(runs, N=10) > 21 and tS(HR, N=10) < 19 and tS(walks, N=10) > 16 and 42 < tS(SO, N=10) < 86 and site streak > -10 and o:site streak > -8 and op:SII < 5 and p:RMAX > 1 and oss:SHF > 13 and oss:SPT > 73 and -5 < tS(W, N=10) - oS(W, N=10) < 6 and -8 < tS(errors, N=10) - oS(errors, N=10) < 6 and opp:RMAX < 5

( Bases )
ROI % 26