2015 SDQL Baseball Thread

**Alex Vaile** · 06-17-15, 01:19 AM

Wednesday's plays :

Play Athletics - 1.5 RL + 125
Play Athletics Under 7.5 - 115

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

**Alex Vaile** · 06-17-15, 05:32 AM

Play Rockies + 121
Play D-Backs - 112

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

Fade this query has been money.

**Alex Vaile** · 06-17-15, 10:41 AM

Play Indians - 131
Play Royals -134
Play Royals Under 7.5 - 110

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

( JMon )

**Alex Vaile** · 06-18-15, 09:47 AM

Yesterday's results : 3-4 - 1.39 units
Season to date : 149-145 + .02 units

As RL, Royals and D-Backs winners and As under, Royals Under, Rockies and Indians losers

**Alex Vaile** · 06-18-15, 09:48 AM

Thursdays plays:

Play Under 8.5 - 110 Orioles vs Phillies

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

**Alex Vaile** · 06-18-15, 09:54 AM

Play Under 10.5 -105 Astros vs Rockies

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

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

Play Twins + 124

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

**Alex Vaile** · 06-18-15, 10:06 AM

Play Athletics - 139
Play Yankees - 137
Play Royals - 153
Play Blue Jays - 164
Play Mariners - 135
Play Indians - 142

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

( JMon )
ROI % 8.

All 6 plays high juice. Could b a slaughter today but this query been hot. Good luck to any and all following.

**Alex Vaile** · 06-18-15, 03:02 PM

2 and 0 start. Let's keep it rolling with the Rockies under

**Alex Vaile** · 06-18-15, 05:24 PM

So much for that. 2 and 2 with As loss also.

**Alex Vaile** · 06-19-15, 12:16 AM

Today's results: 6-3 + 2.45 units
Season to date: 155-148 + 2.47 units

Yankees, Royals, Indians, Twins, Jays, Phillies under winners and Mariners, Athletics, and Rockies under losers.

**Alex Vaile** · 06-19-15, 12:16 AM

**Alex Vaile** · 06-19-15, 12:49 AM

Fridays plays:

Play Under 10 + 105 Brewers vs Rockies
Play Under 8 - 110 Marlins vs Reds

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

**Alex Vaile** · 06-19-15, 12:51 AM

Play Under 7.5 - 105 Rays vs Indians

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

ROI % 43

**Alex Vaile** · 06-19-15, 02:03 PM

Play Giants Under 7 even

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 )

and

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 )

**Alex Vaile** · 06-19-15, 03:53 PM

Play Rays + 148

team=Rays and A and line>=140 and SG=1 and p:W and s:W and so:BL>0 and date>=20090506

starter=Carlos Carrasco and rest=0 and 5<=p:PU and season>=2011 (MTI)

**Alex Vaile** · 06-20-15, 12:33 AM

Today's results: 3-2 + 1.48 units
Season to date : 158-150 + 3.95 units

Rays under, Rays, Marlins Under winners and Giants under and Rockies Under losers

**leetreaper** · 06-20-15, 08:20 AM

The query is basically breaking even, maybe tweak it somehow???

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

Originally posted by leetreaper

The query is basically breaking even, maybe tweak it somehow???

Which one? There's lots of them.

**Alex Vaile** · 06-20-15, 09:49 AM

Today's plays :

Play Reds - 126

H and p:margin >= 3 and op:runs = 0 and WP < 60 and o:WP > 38.5 and line > -230 and conference = o:conference and (month != 7 and month != 8) and 2008 <= season and SG > 1 and total > 6.5
( JMon )

ROI % 16

**Alex Vaile** · 06-20-15, 09:51 AM

Play Tigers + 107

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 )

ROI % 35

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

Play Indians - 1.5 + 120

H and -8 > (starter wins - starter losses + o:starter losses - o:starter wins) > -14 and day != Wednesday and day != Thursday and day != Friday and 6 > s:SRA > 0 and p:hits < 13 and total > 6.5 and (1.4 > STDSWHIP>1.1 or tA(runs) > 4.8)

ROI % RL 16

**Alex Vaile** · 06-20-15, 10:04 AM

Play Blue Jays - 119

H and -115 > line > -160 and DIV and game number > 10 and month < 7 and 1 >= tA(W, N=10) >= .7 and .7 >= oA(W, N=10) >= .5 and season > 2008 and 7.5 < total < 10 and p:W
(Posey)

ROI % 27

**2buckluck** · 06-20-15, 10:06 AM

Alex, thanks for sharing these, I've checked these against other picks but never asked you what the ROI % is, is that how successful or accurate a query has been? I don't know Sdql and should have asked by now, any info would be awesome, thanks!

**Alex Vaile** · 06-20-15, 10:14 AM

Play Mariners + 111
Play Nationals - 127

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

**Alex Vaile** · 06-20-15, 10:16 AM

Originally posted by 2buckluck

Alex, thanks for sharing these, I've checked these against other picks but never asked you what the ROI % is, is that how successful or accurate a query has been? I don't know Sdql and should have asked by now, any info would be awesome, thanks!

You got it 2buck it pertains to how profitable or successful a query has been. Sample size is important as well when seeing how the success of a query is measured over time (seasons, months ) anything over 10 is solid and over 20 real nice.

**Alex Vaile** · 06-20-15, 10:21 AM

Play Under 8 - 110 Padres vs D-Backs

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

**2buckluck** · 06-20-15, 10:31 AM

Awesome thanks for the quick feedback, BOL to ya!

**Alex Vaile** · 06-20-15, 10:45 AM

Originally posted by 2buckluck

Awesome thanks for the quick feedback, BOL to ya!

No prob. You as well!

**Alex Vaile** · 06-21-15, 12:24 AM

That under losing in 9th hurt. 4 runs by terrible pitcher Reed from Arizona. Couldnt believe it. Had 4 runs to work with.

**Alex Vaile** · 06-21-15, 12:53 AM

Originally posted by Alex Vaile

Today's plays :

Play Reds - 126

H and p:margin >= 3 and op:runs = 0 and WP < 60 and o:WP > 38.5 and line > -230 and conference = o:conference and (month != 7 and month != 8) and 2008 <= season and SG > 1 and total > 6.5
( JMon )

ROI % 16

Reds no play due to pitching change.

**Alex Vaile** · 06-21-15, 12:58 AM

Today's results: 2-4 - 2.18 units
Season to date : 160-154 + 1.77 units

Mariners and Nationals winners, Jays, Tigers, Indians RL and BS Arizona under losers and Reds no play due to pitching change.

**Alex Vaile** · 06-21-15, 01:12 AM

Sunday's plays :

Play Nationals - 125

H and p:margin >= 3 and op:runs = 0 and WP < 60 and o:WP > 38.5 and line > -230 and conference = o:conference and (month != 7 and month != 8) and 2008 <= season and SG > 1 and total > 6.5
( JMon )

ROI % 16

**Alex Vaile** · 06-21-15, 01:14 AM

Play Under 8.5 - 120 Red Sox vs Royals

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

ROI % 48

**Alex Vaile** · 06-21-15, 01:07 PM

Play Under 8.5 - 115 Padres vs D-Backs

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