2015 SDQL Baseball Thread

**Alex Vaile** · 07-20-15, 05:29 PM

Play D-Backs RL + 140

team=Marlins and D and SG=1 and p:L and s:L and ss:L and date>=20120917

(SDQG)

Marlins 2 and 10 versus RL
0 nd 12 SU in this spot

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

Today's results : 3-3 + .23 units
Season to date: 238-219 + 13.57 units

Angels, Pirates over and D-Backs RL winners and Seattle, Nats under and Red Sox Under losers.

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

Tuesday's plays:

Play Braves + 128

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

( JMon )
ROI % 25

**Alex Vaile** · 07-21-15, 01:09 AM

Play Pirates - 113

H and line > 100 and tA(HR) <= .9 and 1.4 >= STDSWHIP >= 1.3 and A(o:SHRA@o:starter and o:season) <= .5 and conference = AL and rest = 0 and SG < 4

( JMon )
ROI % 33

**Alex Vaile** · 07-21-15, 01:11 AM

Play Mariners -116

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

**Alex Vaile** · 07-21-15, 01:27 AM

Play Under 11 -105 Rangers vs Rockies

tA(runs, N=10) - oA(runs, N=10) > 0.5 and tA(BPRA, N=10) - oA(BPRA, N=10) < -0.5 and STDSERA - o:STDSERA < -0.5 and playoffs = 0 and H and line > -145 and month > 4

(Bases)

And

team=Rockies and H and p:WOW and total=11(0-5 under)

These pitchers are gascans and this total could b reached in 2 or 3 innings but I'm feeling a lower scoring game.

**Alex Vaile** · 07-21-15, 01:35 AM

Play Over 8.5 - 106 Orioles vs Yankees

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

( Bases )
ROI % 21

**Alex Vaile** · 07-21-15, 02:32 AM

Play Indians - 127
Play Indians RL + 135

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

(b1slickguy)
ROI % 36 ML 44-29
ROI % 10 RL 46-27

**Alex Vaile** · 07-21-15, 12:39 PM

Play Astros ML - 128
Play Astros RL + 160

F and SG = 1 and season > 2006 and H and SGS = 3 and (day = Monday or day = Tuesday) and -3 < streak < 2 and -7 < o:streak < 5 and p:hits > 6 and 11 > p:runs > 3 and 0 < op:runs < 10 and total > 7.5

ML ROI % 16
RL ROI % 38 I usually don't like home RLs but this query has been great for that.

**Alex Vaile** · 07-21-15, 08:54 PM

Play Padres + 116

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 )
ROI % 13

**Alex Vaile** · 07-21-15, 11:48 PM

Today's results : 5-5 + .42 units
Season to date: 243-224 + 13.99 units

Astros ML and RL, Rockies under, Mariners and Braves winners and Padres, Pirates, Yankees over, Indians ML and RL losers.

**Alex Vaile** · 07-22-15, 05:06 AM

Wednesday's plays :

Play Phillies + 149

180 >= line >= 100 and tA(runs) <= 4.2 and o:STDSERA <= 3.5 and o:conference = AL and (p:runs + po:runs) <= 3 and 2009 <= season and o:rest = 0 and total > 6.5

( JMon )
ROI % 41

**Alex Vaile** · 07-22-15, 05:08 AM

Play Braves + 138
Play Nationals - 119

(s:SRA + ss:SRA) = 3 and A and (month = 5 or month = 7) and os:SRA < 6 and oss:SRA > 2 and line > -184 and p:hits > 5 and pp:hits > 6 and (op:hits + opp:hits + oppp:hits) > 14

(Bases)
ROI % 26

**Alex Vaile** · 07-22-15, 05:10 AM

Play Marlins - 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** · 07-22-15, 10:35 AM

Play Under 8.5 + 100 Orioles vs Yankees

H and tS(o:runs<5,N=3) = 3 and op:margin = -1 and total > 8 and season>2009

(PCG)
ROI % 19

**Alex Vaile** · 07-22-15, 01:44 PM

Play Rangers + 148

(so:R1 = 3 or so:R1 = 4) and SG != 2 and 5 > SGS > 1 and s:SRA < 10 and 3 < s:SHA < 10 and s:SWA < 5 and 6 > s:SSO > 1 and starter rest < 17 and s:SPT > 56 and os:SRA < 8 and s:SHRA < 4 and os:SHRA < 2 and os:SPT > 69 and o:starter rest < 18 and p:hits < 12 and 0 < ss:SSO < 12 and ss:SPT > 66 and -8 < os:margin < 6 and tA(hits,N=10) > 6.8 and oA(LOB, N=10) < 18.5 and 1.4 < oA(walks, N=10) < 4.8 and tA(walks, N=10) > 1.7

( Bases )
ROI % 28

**Alex Vaile** · 07-22-15, 07:12 PM

Play Under 7 - 103 Blue Jays vs Athletics

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

( emceeaye )
ROI % 41

**Alex Vaile** · 07-23-15, 10:13 AM

Yesterday's results: 5-1-1 + 4.97 units
Season to date: 248-225 + 18.96 units

Phillies, Rangers, Yankee under, Nationals and Marlins winners and Braves losers and Jays under pushed.

**Alex Vaile** · 07-23-15, 10:28 AM

Today's plays:

Play Nationals + 165

team=Nationals and A and s:L and ss:L and date>=20150429

team=Nationals and oS:L and oS:season=season and SG=1 and date>=20140911

team=Nationals and D and SG=1 and STDSERA>o:STDSERA and date>=20140502

team=Pirates and H and STDSERA=20140805

team=Pirates and p:SO>=10 and p:AL and date>=20150620

All adds up to a big dog win I think.

**Alex Vaile** · 07-23-15, 10:58 AM

Play Under 7.5 + 105 Orioles vs Yankees

H and 10 >= total >= 7.5 and po:runs <= 4 and ppo:runs <= 4 and pppo:runs < 4 and op:L and op:margin = -1 and 2010<=season and rest = 0 and month!=8

( JMon )
ROI % 11

**Alex Vaile** · 07-23-15, 11:00 AM

Play Under 7 - 109 Royals vs Cardinals

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

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 )
ROI % 26

**Alex Vaile** · 07-23-15, 11:04 AM

Play Under 6.5 + 100 Marlins 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 % 23

And

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** · 07-23-15, 11:13 AM

Play Under 7.5 - 105 Red Sox vs Astros

tA(runs, N=10) - oA(runs, N=10) > 0.5 and tA(BPRA, N=10) - oA(BPRA, N=10) < -0.5 and STDSERA - o:STDSERA < -0.5 and playoffs = 0 and H and line > -145 and month > 4 and season>=2015

ROI % 19

Limited sample but both pitchers been solid should go 6 innings hopefully.

**Alex Vaile** · 07-23-15, 11:23 AM

Play Royals + 130

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

**Alex Vaile** · 07-23-15, 11:37 AM

Play Under 7 - 115 Nationals vs Pirates

WP>50 and o:WP>50 and month=7 and H and season>2008

(PCG)
ROI % 10

starter=Doug Fister and A and total<=9.5

ROI % 18

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

**inZane** · 07-23-15, 04:38 PM

Good job Alex, thanks for posting and best of luck tonight Bro.

**Alex Vaile** · 07-23-15, 10:15 PM

Originally posted by inZane

Good job Alex, thanks for posting and best of luck tonight Bro.

Thanks InZane. Not the best day but its been a nice few weeks.

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

Today's results: 1-5-1 - 4.2 units
Season to date: 249-230 + 14.76 units

Pads under winner, Nats ML and Under, Orioles under, Royals and Red Sox under losers and cards under push.

Red Sox bullpen so terrible. Cards closer gave up 1 in ninth. Couple tough ones and a few blowouts. That's baseball.

**Alex Vaile** · 07-24-15, 11:13 AM

Friday's plays:

Play Royals + 102

HF and p:A and -7 < p:margin < 0 and tS(W, N=12) > 6 and 0 < s:SRA < 5 and season > 2008

(Bases )
ROI % 24

**Alex Vaile** · 07-24-15, 11:15 AM

Play Padres -125

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** · 07-24-15, 11:17 AM

Play Pirates + 110

(s:SRA + ss:SRA)=3 and A and (month= 5 or month =7) and os:SRA<6 and oss:SRA>2 and line>-184

ROI % 16

And
(s:SRA + ss:SRA)=3 and A and (month= 5 or month =7) and os:SRA<6 and oss:SRA>2 and line>-184

ROI % 26

**Alex Vaile** · 07-24-15, 11:21 AM

Play Rockies - 105
Play Red Sox -133

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)

This query has turned to fade material since June.

**Alex Vaile** · 07-24-15, 11:23 AM

Play Over 7 +115 White Sox vs Indians

season = 2015 and team = Indians and division = o:division and H

( excism )
ROI % 68

Limited sample of this season and going against line movement overnite. Indians are 13-2 going over in Home divisional games this season and only 4-11 SU.

**Alex Vaile** · 07-24-15, 11:45 AM

Play Phillies + 245

The Cubs are 0-8 in a series opener when their starter has a lower ERA than their opponent's starter

team=Cubs and SG=1 and STDSERA< o:STDSERA and date>=20150609

THIS season, the Cubs have been the favorite in five series openers in which they are off a win and their starter is off a quality start.
season=2015 and team=Cubs and F and SG=1 and p:W and s:QS
Cubs are 0-9 as a favorite of AT LEAST 170 when they are off a win and facing a team with a worse record.

team=Cubs and line<=-170 and p:W and WP>o:WP and date>=20090912
Phillies are performing well off a win and a walkoff win and when opponent's starter ERA is better.

team=Phillies and 140<=line and 12<=po:hits and p:W and date>=20140617
(MTI)

**Cherubim571** · 07-24-15, 12:32 PM

Originally posted by Alex Vaile

Play Rockies - 105
Play Red Sox -133

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)

This query has turned to fade material since June.

So are saying that you will be fading the above picks, or that you are fading their competitors and thereby playing the teams listed above?