2015 SDQL Baseball Thread

[Alex Vaile]

Tuesday's plays:

Play Under 7 + 100 Orioles vs Athletics
Play Under 6.5 + 105 Rays vs White Sox

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

( Jmon)
ROI % 30

[Alex Vaile]

Play Tigers + 103

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

[Alex Vaile]

Play Nationals RL + 120

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 % RL 9

[Alex Vaile]

Play Cubs - 131

team=Pirates and -120<=line<=120 and SG=1 and p:margin>-8 and date>=20120824

(Dr.M )
ROI % 29

[Alex Vaile]

Yesterday's results : 2-3 - 1 unit
Season to date : 281-266 + 8.08 units

Cubs and As under winners and Nats RL, White Sox under and Tigers losers. Need to get back over 10 units. Today is the day!!

[Alex Vaile]

Play Under 7.5 -120 Padres vs Brewers

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

[Alex Vaile]

Play Indians + 108
Play Indians RL - 200

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 % ML 40
ROI % RL 20

[Alex Vaile]

Play Rays vs White Sox Under 8 - 105

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

( SDQG )
ROI % 89

[Alex Vaile]

Play Rays vs White Sox Under 8 - 105

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

( SDQG )
ROI % 89

So much for that under in 3rd inning.

[Alex Vaile]

Play Reds + 145

D and p:W and p:runs < 4 and SGS < 5 and SG != 3 and -4 < p:streak < 2 and 6 > o:streak > -4 and line > 134 and op:runs < 10 and 0 < op:TLOB < 11 and p:SG < 4 and p:SGS > 2

(? ??)
ROI % 19

[granlalo]

hi Alex Valie
thanks so much for posting these picks.

i want to know if there is anyway to search records of the 1st position in a league, conference or overall. for example:

Position=1 and HF and season=2015

returning the Wins and Loses of the first place (at that momment) as home favorite i this season.

[Alex Vaile]

Play Indians + 108
Play Indians RL - 200

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 % ML 40
ROI % RL 20

Another terrible bullpen meltdown in 9th blows the ML. Guy walks 3, has 2 wild pitches and gives 3 runs in ninth. Terrible

[Alex Vaile]

hi Alex Valie
thanks so much for posting these picks.

i want to know if there is anyway to search records of the 1st position in a league, conference or overall. for example:

Position=1 and HF and season=2015

returning the Wins and Loses of the first place (at that momment) as home favorite i this season.

If u mean by searching who is in first place in standings not really a query but you can search winning percentage

Such as

team=Giants and HF and o:WP> 50 and season=2015

[granlalo]

If u mean by searching who is in first place in standings not really a query but you can search winning percentage

Such as

team=Giants and HF and o:WP> 50 and season=2015

Thanks very much, i think im gonna have to make the search manually

[Alex Vaile]

Today's results : 1-4 - 3.25 units
Season to date: 282-270 + 4.83 units

Indians RL winner and the rest lost with 2 terrible bullpens.

[Alex Vaile]

Thanks very much, i think im gonna have to make the search manually

No prob. Hope u find what you're looking for.

[Alex Vaile]

Play Red Sox + 135

(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 % 29

[Alex Vaile]

Play Brewers - 114

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

[Alex Vaile]

Play Over 9 +100 Red Sox vs Yankees

team=Red Sox and LGS and STDSERA<o:STDSERA and season =2015


Red sox 10 and 0 over under in last game of series when their starter's era is lower than opponent's starter's era.

[Alex Vaile]

Play Athletics + 104

team=Athletics and H and SG=1 and p:H and po:runs>=6 and season>=2013

(SDQG)

As 11 and 0 in this spot.

[birdsfan]

team = Twins and A and p:L and pp:L and ppp:L and SG = 4 and date > 20090701
SU: 7-2 (2.00, 77.8%) avg line: 158.9 / -176.9 on / against: +$838 / -$938 ROI: +93.1% / -58.2%
RL: 8-1 (3.50, 88.9%) avg line: -137.6 / 126.4 on / against: +$716 / -$734 ROI: +57.4% / -77.2%
OU: 6-3-0 (1.44, 66.7%) avg total: 8.6 over / under: +$295 / -$370 ROI: +30.9% / -36.1%

[Alex Vaile]

Yesterday's results : 1-3 - 2 units
Season to date : 283-273 + 2.83 units

Brewers win the rest losers.

[Alex Vaile]

Play Under 6.5 -120 Mets vs Rays

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

( Jmon )
ROI % 29

[Alex Vaile]

Play Under 6.5 + 105 Phillies vs Pads
Play Under 8 + 100 White Sox vs Royals
Play Under 7.5 - 120 Giants vs Cubs

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

[Alex Vaile]

Play Padres - 142
Play Cardinals - 135

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

[Alex Vaile]

Play Angels - 122
Play Yankees - 110

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 )

Fade this query so that means take Yanks and Angels.

[Alex Vaile]

Play Tigers - 111

team=Tigers and H and SG=1 and streak<3 and C and date>=20120704

(Dr.M )
ROI % 15

[Alex Vaile]

Play Twins + 117

team=Indians and SG=1 and p:AL and p:hits<=6 and date>=20140526

(SDQG )

Indians 0-10 in this spot.

[inZane]

Lotsa plays Alex, "...have a hunch, bet a bunch". Good luck, Bro...

[Alex Vaile]

Lotsa plays Alex, "...have a hunch, bet a bunch". Good luck, Bro...

Yes sir going for it today as a I've been getting killed last few weeks. Good luck to u as well!

[Alex Vaile]

Yesterday's results: 4-6 - 2.86 units
Season to date : 287-279 - .03 units (lost 18 units in last month)

Angels, White Sox under, Twins and Cardinals winners and Pads, Mets Under, Pads under, Yankees and damn Tigers losers.

[Alex Vaile]

Saturday's plays :

Play Braves - 102
Play Braves RL - 185
Play Royals + 106
Play Royals RL - 195

Sum(hits@team and season) / Sum(at bats@team and season) <= .255 and 5.7 >= o:STDSERA >= 5.2 and day = Saturday and 2009 <= season and -145 < line <= 170 and conference = o:conference

(JMon )
ROI % 28 ML
ROI % 24 RL

[Alex Vaile]

Play Pirates -123
Play Blue Jays - 143

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

And more support for Pirates 20-0 in this spot.

t:team=Pirates and F and p:HW and p:QS and date>=20150511

( SDQG )

[Alex Vaile]

Play Phillies + 185

team = Padres and p:L and p:SF and date>=20150600

(SDQG )
Pads 0 and 11 in this spot, Tyson Ross 0 and 4 in this spot.

[Alex Vaile]

Today's results: 7-0 + 7.91 units (finally)
Season to date: 294-279 + 7.88 units

They all came through today after a shit week. Let's keep it rolling