2015 SDQL Baseball Thread

b1slickguy · 07-28-15, 11:37 AM

Originally posted by Alex Vaile

Play Under 7 even D-Backs vs Mariners

team=Diamondbacks and A and os:QS and p:W and date>=20140507

(SDQG )

Under 18 and 0 in this situation

I'm with you on this under.
Good luck.

team=Mariners and p:H and p:RMAX<=1 and season>=2014

Alex Vaile · 07-28-15, 12:21 PM

Originally posted by b1slickguy

I'm with you on this under.
Good luck.

team=Mariners and p:H and p:RMAX<=1 and season>=2014

What a query!! Let's get it.

Alex Vaile · 07-28-15, 07:19 PM

Play Giants - 146

A and line>135 and p:BL=0 and pp:BL=0 and SG<SGS and (p

or pp

) and date>=20130423

( Dr.M )
ROI % 13

Same query as yesterday let's play it again now 18-1 this season

Alex Vaile · 07-29-15, 12:16 AM

Today's results: 2-4 - 2.56 units
Season to date : 264-245 + 14.62 units

Mets under and Cards under winners and Giants, Angels under, Twins, and Arizona under losers. I really thought Twins would win that after scoring 4 in 8th to tie but nope.

Alex Vaile · 07-29-15, 10:34 AM

Play Under 7.5 -115 Reds vs Cardinals
Play Under 7 + 110 Brewers vs Giants
Play Under 8.5 + 100 White Sox vs Red Sox

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-29-15, 10:57 AM

Play Twins + 116

s:SRA < 2 and 5 > ss:SRA > 0 and sss:SRA < 4 and ssss:SRA < 6 and 0 < sssss:SRA < 8 and os:SRA < 5 and SG < 4 and day != Tuesday and day != Thursday and 4 < starter rest < 10 and o:starter rest < 11 and 161 > game number > 27 and line > -165 and 2 > p:margin > -9 and 11.2 > tA(hits, N=10) > 6.7 and 6.2 < oA(hits, N=10) < 11.3 and STDSWHIP > .948 and ss:SPT > 67 and 40 < oss:SPT < 113 and tA(doubles, N=10) < 2.5 and tA(errors, N=10) > .1 and .3 < oA(BPRA, N=10) < 2.6 and tA(BPRA, N=10) < 2.8

( Bases )
ROI % 27

Alex Vaile · 07-29-15, 01:21 PM

Play Under 7 - 120 Athletics vs Dodgers

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 and team=Dodgers

(JMon)
ROI % 34

This is a solid under query but I added dodgers and it got a little nicer.

Alex Vaile · 07-29-15, 11:30 PM

Today's results: 2-3 - 1.2 units
Season to date : 266-248 + 13.42 units

Cards under and Giants under winners and Red Sox Under, Twins and Dodger under losers

Alex Vaile · 07-30-15, 10:37 AM

Play Nationals vs Marlins Under 6.5 - 102
Play Rockies vs Cardinals 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 · 07-30-15, 11:42 AM

Play Indians vs Athletics Under 7 - 115

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

and

H and total<=7 and STDSERA<=3.5 and t:conference=AL and s:SWA<=1 and ss:SWA<=1 and 2009<=season

( ???)
ROI % 29

Alex Vaile · 07-30-15, 11:45 AM

Play Brewers + 127

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

(Bases)
ROI % 17

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 and p:hits > 5 and pp:hits > 6 and (op:hits + opp:hits + oppp:hits) > 14

(Bases)
ROI % 27

Alex Vaile · 07-31-15, 12:56 AM

Today's results: 2-2 - .1 units
Season to date : 268-250 + 13.32 units

Indians under and Nats under winners and Cards under and Brewers shit bullpen losers. Starter gives up 0 through 7 and they lost.

Alex Vaile · 07-31-15, 12:31 PM

Play Under 6.5 + 105 Nats 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 % 17

Alex Vaile · 07-31-15, 12:36 PM

Play Twins - 113

H and 100>=line>-290 and month=7 and 12>total>5.5 and day!=Monday and day!=Tuesday and n:series game!=2 and series games>2 and start time<2210 and rest=0 and conference=o:conference and p:margin>-6 and p:hits>3 and p:errors<2 and op:errors<3

( PCG )
ROI % 9

Alex Vaile · 07-31-15, 12:38 PM

Play Marlins - 111

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

( Bases )
ROI % 17

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 and p:hits > 5 and pp:hits > 6 and (op:hits + opp:hits + oppp:hits) > 14

( Bases )
ROI % 26

Alex Vaile · 07-31-15, 12:55 PM

Play Over 8.5 - 118 Giants vs Rangers
Play Over 8 - 112 Diamondbacks vs Astros

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

Alex Vaile · 07-31-15, 12:59 PM

Play Under 7.5 +107 Cubs vs Brewers
Play Under 7.5 + 101 Padres vs Marlins
Play Under 8.5 - 110 Yankees vs White Sox

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-31-15, 01:12 PM

Play Rays vs Red Sox Under 8.5 + 105

team=Rays and AD and o:WP <WP and date>=20150503
(SDQG )

0 and 13 over under in this spot

Alex Vaile · 08-01-15, 01:25 AM

Today's results : 4-5 - 1.22 units
Season to date: 272-255 + 12.1 units

Mets Under, Giants over , Dbacks over, Cubs under winners and White Sox under, Red Sox under, Padres Under gave up 5 in 11th, Twins and Marlins losers.

Alex Vaile · 08-01-15, 02:41 AM

Play Blue Jays - 125

starter=Mark Buehrle and HF and o:team=Royals
16-2 su

starter=Mark Buehrle and HF and p:W and pp:W and DAY

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

Fade last query

Alex Vaile · 08-01-15, 09:22 AM

Play Red Sox - 110

league = o:league and WP < 50 and o:WP < 50 and streak <= -2 and o:streak >= 1 and AWP > o:HWP and AD and season > 2010 and month > 4

( Bases )
ROI % 26

Alex Vaile · 08-01-15, 10:04 AM

Play Over 8 -118 Giants vs Rangers
Play Over 6 -117 Angels vs Dodgers
Play Over 7.5 -102 Dbacks vs Astros

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

Alex Vaile · 08-01-15, 10:08 AM

Play Athletics + 100

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

Alex Vaile · 08-01-15, 11:08 AM

Play Over 8 -105 Cubs vs Brewers

team=Brewers and D and p:HL and p:LOB>16 and date>=20090905

(SDQG )

19 and 0 over/ under in this spot

Alex Vaile · 08-01-15, 11:08 PM

Today's results: 4-3 + .53 units
Season to date : 276-258 + 12.63 units

Giants over, Astros over, Athletics and Red Sox winners and Brewers over, Jays and Dodger over losers.

Alex Vaile · 08-02-15, 11:10 AM

Sunday's plays:

Play Twins + 113

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

Alex Vaile · 08-02-15, 11:11 AM

Play Under 6 - 115 Padres vs Marlins

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 · 08-02-15, 11:26 AM

Play Blue Jays - 140
Play Royals RL - 155
Play Blue Jays Under 8.5 + 100

team=Royals and AD and p:W and pp:L and SG=SGS and DAY

team=Blue Jays and HF and and p:L and pp:W and SG=SGS

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)

( Bases )
ROI % 26

inZane · 08-02-15, 11:34 AM

Originally posted by Alex Vaile

Play Blue Jays - 140
Play Royals RL - 155
Play Blue Jays Under 8.5 + 100

team=Royals and AD and p:W and pp:L and SG=SGS and DAY

team=Blue Jays and HF and and p:L and pp:W and SG=SGS

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)

( Bases )
ROI % 26

So by playing both sides of the same game, you're basically banking on a one run Toronto win to make any money. Good luck Alex, I like the under, but I'm not gonna try that other option.

Alex Vaile · 08-02-15, 06:27 PM

Originally posted by inZane

So by playing both sides of the same game, you're basically banking on a one run Toronto win to make any money. Good luck Alex, I like the under, but I'm not gonna try that other option.

Ya it didn't turn out exactly like I planned but close. I should have in hindsight played side and total.

Alex Vaile · 08-03-15, 12:28 AM

Today's results: 2-3 - 1.7 units
Season to date : 278-261 + 10.93 units

Jays and Jays under winners and got burned bad on miami under (5 runs in 9th) and twins late and Royals RL losers.

This week was a struggle in comparison to last week. 6 unit loss in the week. On to the next one...

Alex Vaile · 08-03-15, 02:56 AM

Play Mets - 110

DIV and D and p:W and 40<=o:WP<48

ROI % 10

Play Mets vs Marlins Under 7.5 - 105

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 · 08-03-15, 02:58 AM

Play Brewers + 104

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 · 08-03-15, 03:02 AM

Play Cubs +123

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

( Bases )
ROI % 25

Alex Vaile · 08-03-15, 11:37 PM

Today's results : 1-2 - 1.05 units
Season to date : 279-263 + 9.08 units

Mets winners Mets Under and Brewers losers.
Cubs postponed