2015 SDQL Baseball Thread

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

Getting crushed today. Not looking good!

**Alex Vaile** · 05-05-15, 09:59 PM

Season to date : 40-33 + 8.38
Today's results: 0-5 - 6.37 units ouch!!!

**b1slickguy** · 05-05-15, 10:43 PM

Get 'em tomorrow, AV.
Good luck.

**Alex Vaile** · 05-06-15, 05:09 AM

Today's plays :

Play Giants - 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)

More supporting the Giants

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

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

Originally posted by b1slickguy

Get 'em tomorrow, AV.
Good luck.

Thanks Slick. Gotta bounceback from that!

**Alex Vaile** · 05-06-15, 05:43 AM

Play Tigers +125
Play Orioles +105

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

**Alex Vaile** · 05-06-15, 10:37 AM

Play Under 7 -120 Marlins vs Nationals

p:HR = 0 and 4 > SG > 1 and op:HR = 0 and SGS = 3 and H and s:SRA < 6 and os:SRA != 0 and os:SWA != 0 and s:SPT > 86 and os:SPT < 122 and 163 > game number > 28 and site streak < 9 and o:site streak > -9 and ou streak > -7 and tS(hits, N=5) < 55 and tS(hits, N=20) < 198 and oS(hits, N=2) > 8 and oS(hits, N=5) > 29 and oS(hits, N=20) < 202 and oS(hits, N=10) > 66 and oS(runs, N=10) > 25 and oS(runs, N=2) < 15 and oS(runs, N=5) < 34 and tS(runs, N=2) > 1 and tS(runs, N=10) < 55 and 170 > line > -250 (Bases)

**Alex Vaile** · 05-06-15, 10:44 AM

Play Under 8 -115 Athletics vs Twins

p:HR + op:HR < 2 and H and (SG = 2 or SG = 3) and p:hits + op:hits < 16 and p:hits < 10 and 10 > op:hits > 4 and 27 > pp:hits + opp:hits > 10 and 2 < pp:hits < 18 and 4 < opp:hits < 17 and p:hits + pp:hits > 8 and (os:SHRA = 0 or s:SHRA = 0) and os:SRA + s:SRA > 2 and os:SHA < 11 and s:SHA < 11 and s:SWA != 0 and os:SSO < 10 and 0 < s:SSO < 9 and 8.1 > s:SIP > 5.5 and s:SPT > 82 and os:SPT < 122 and o:starter rest < 14 and opp:HR < 3 and oppp:hits < 18 and (game number < 59 or 161 > game number > 86) (Bases)

**mdunlap3** · 05-06-15, 07:04 PM

Tailing A's pick

**FlyinAir** · 05-06-15, 09:00 PM

Originally posted by Alex Vaile

Play Under 8 -115 Athletics vs Twins

p:HR + op:HR < 2 and H and (SG = 2 or SG = 3) and p:hits + op:hits < 16 and p:hits < 10 and 10 > op:hits > 4 and 27 > pp:hits + opp:hits > 10 and 2 < pp:hits < 18 and 4 < opp:hits < 17 and p:hits + pp:hits > 8 and (os:SHRA = 0 or s:SHRA = 0) and os:SRA + s:SRA > 2 and os:SHA < 11 and s:SHA < 11 and s:SWA != 0 and os:SSO < 10 and 0 < s:SSO < 9 and 8.1 > s:SIP > 5.5 and s:SPT > 82 and os:SPT < 122 and o:starter rest < 14 and opp:HR < 3 and oppp:hits < 18 and (game number < 59 or 161 > game number > 86) (Bases)

Saw this apart of my capping but didn't give cred

Thanks

**Alex Vaile** · 05-06-15, 10:59 PM

Wow another 0 and 5 day. Tigers give up 4 in 8th to blow that one too.

Season to date: 40-38 + 2.78 units
Today's results : 0-5 - 5.6 units

Tomorrows gonna b a better day. I can't say I've ever had back to back 0 and 5 days. That's tough to do

**bking79** · 05-07-15, 07:51 AM

Tuff card today out in baseball

**bking79** · 05-07-15, 07:52 AM

Only value i see is reds and baltimore plus money onboth

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

Today's plays :

Play D-Backs -105

HD and tA(W) < .42 and month < 7 and division = o:division ( green7 )

**bking79** · 05-07-15, 09:02 AM

-120 <= t:line <= 120 and p:margin >= 3 and SG = SGS and season >= 2011 and month < 6 brewers indians twins

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

Play Twins Even
Play Twins RL +1.5 -160

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)

**JMon** · 05-07-15, 10:33 AM

Not saying this a play, but it appears historically Sox have a tough time closing out a three game series vs div foe, Tigers..

H and p:W and pp:W and SG=SGS=SG=3 and team=White Sox and DIV and o:team=Tigers

**bking79** · 05-07-15, 10:57 AM

im rollin with whitesox here and runline

**bking79** · 05-07-15, 11:00 AM

also thinkin about indians game under8 kc team total under 4

**bking79** · 05-07-15, 11:02 AM

i got a funny feelin cluber actually pitches good today

**birdsfan** · 05-07-15, 11:39 AM

team = Athletics and p:runs = 0 and A

**Alex Vaile** · 05-07-15, 01:25 PM

Play Yankees -130

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

**escism** · 05-07-15, 09:23 PM

Pretty solid query here, not going to win today probably, but I'm loving the ROI on it.

D and 100< line < 150 and streak>=-4 and o:streak<=4 and o:WP>65

I've been messing w/ the streak numbers and the winning % and I settled on this one. BOL

**Alex Vaile** · 05-08-15, 12:01 AM

Season to date : 44-38 +6.78 units
Today's results : 4-0 + 4 units. That's more like it.

Yanks Twins Twins RL and D-Backs winners

**pacocn** · 05-08-15, 12:17 AM

Nice work!!!!!

**bking79** · 05-08-15, 07:35 AM

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 this is on 6 loses rite now its gotta win one day rite todays plays are ASTROS TWINS ROYALS ORIOLES

**Alex Vaile** · 05-08-15, 08:46 AM

Today's plays :

Play D-Backs Even
Play D-Backs RL + 1.5 - 160

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)

**Alex Vaile** · 05-08-15, 08:47 AM

Originally posted by bking79

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 this is on 6 loses rite now its gotta win one day rite todays plays are ASTROS TWINS ROYALS ORIOLES

Ya I agree I laid off yesterday and went other way and it paid off. Maybe May is a poor fit for query IDK. Good luck bking!

**Alex Vaile** · 05-08-15, 10:43 AM

Originally posted by pacocn

Nice work!!!!!

Thanks buddy. Needed it!

**Alex Vaile** · 05-08-15, 10:49 AM

Play Mariners + 112
Play Phillies + 123
Play Brewers + 101

HD and tA(W) < .42 and month < 7 and division = o:division ( green7 )

**Alex Vaile** · 05-08-15, 10:59 AM

More support for Mariners:

HD and DIV and STDSERA > 5 and month < 6 and WP < 50 and o:WP < 50 (posey)

**escism** · 05-08-15, 12:59 PM

Originally posted by Alex Vaile

Play Mariners + 112
Play Phillies + 123
Play Brewers + 101

HD and tA(W) < .42 and month < 7 and division = o:division ( green7 )

I'm with you on all but the Brewers, didn't have any sits pointing to them!

**Alex Vaile** · 05-08-15, 02:47 PM

Originally posted by escism

I'm with you on all but the Brewers, didn't have any sits pointing to them!

Nice. Here's to a winning day!

**Alex Vaile** · 05-08-15, 07:41 PM

Play Marlins + 106
Play Marlins RL +1.5 -200

team=Marlins and AD and p

W and NGT
team=Giants and HF and p:HFL and NGT
starter = Tim Lincecum and H and o:team=Marlins
starter=Jarred Cosart and AD

I think this Marlins lineup can hurt Timmy if he's not on his game. Im rolling with Marlins. I love the Giants but...

**Alex Vaile** · 05-08-15, 11:37 PM

Apparently I was wrong in all facets of this game.