2015 SDQL Baseball Thread

**sballen** · 09-16-15, 08:36 PM

Nice work on the Sox game. Is this a public database you're pulling from or you're own?

**Alex Vaile** · 09-17-15, 10:12 AM

Originally posted by sballen

Nice work on the Sox game. Is this a public database you're pulling from or you're own?

Its a public database that you can run the queries on, however the actual queries I have collected and saved and am saving on an ongoing basis at the site. If you google the SDQL process then you will get the info on where and what to do. Can't promote sites in here. Hope this helps ! I find it fun to use these to help guide my plays each day.

**Alex Vaile** · 09-17-15, 10:14 AM

Yesterday's results: 2-2 - .49 units
Season to date: 422-417 - 13.47 units

Red Sox over and Cards winners and Astros and Rocks losers.

**Alex Vaile** · 09-17-15, 10:16 AM

Play Orioles - 111
Play Orioles RL + 145

team=Orioles and line>=-140 and p:margin <=-5 and p:H and date>=20120729

Orioles 19-0 in this spot ML
17-2 RL

**Alex Vaile** · 09-17-15, 10:22 AM

Play Under 8 - 103 Cubs vs Pirates

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

**Alex Vaile** · 09-17-15, 10:29 AM

Play Pirates - 119

team=Pirates and p:XLH and season>=2011

Pirates 11-0 in this spot.

Pirates off a Home extra inning loss 11 and 0.

**Loder222** · 09-17-15, 11:20 AM

Pittsburgh is risky i think

but on under approve

**b1slickguy** · 09-17-15, 12:26 PM

Originally posted by Alex Vaile

Play Orioles - 111
Play Orioles RL + 145

team=Orioles and line>=-140 and p:margin <=-5 and p:H and date>=20120729

Orioles 19-0 in this spot ML
17-2 RL

Like these as well as the over.
Good luck today.

**Loder222** · 09-17-15, 01:27 PM

Under fired and gone :/

**Alex Vaile** · 09-17-15, 01:32 PM

Shit start. Morton got rocked. Blanton too

**Alex Vaile** · 09-17-15, 01:32 PM

Originally posted by b1slickguy

Like these as well as the over.
Good luck today.

Thanks Slicker u too bud!

**Alex Vaile** · 09-17-15, 01:36 PM

Juicy but I like it.

Play Jays - 200
Play Jays RL - 130

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 % 29 ML
ROI % 10 RL

**Alex Vaile** · 09-17-15, 02:17 PM

NFL Bonus

Denver +3 over KANSAS CITY -- Manning has never lost the Chiefs as a member of the Broncos. Here are some supporting queries I picked up today.

team=Broncos and A and surface=grass and o:wins-o:losses>-8 and date>=20111023
12 and 0 ats

-3.5<=line<=3.5 and p:F and NB and p

TD>0 and po

oints<27 and p:sacks>=2 and date>=20131200
11-0 ats

team=Chiefs and -7<=line<=3 and DIV and season=P:season + 1 and date>=20071100

Chiefs 0-10 in this spot.

(MTI)

**Alex Vaile** · 09-17-15, 11:30 PM

Today's results : 3-3 - .22 units
Season to date: 425-420 - 13.69 units

Orioles what a comeback winner, Jays and Jays RL winners and Pirates ML and under and Orioles RL losers.

Broncos winner!

**Alex Vaile** · 09-18-15, 12:57 PM

Play Under 6.5 + 105 Pirates 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

( Jmon )
ROI % 19

**Alex Vaile** · 09-18-15, 01:05 PM

Play Brewers - 112

team=Reds and p:AL and po:hits>=12 and date>=20140500

Reds 0-15 in this spot

**Alex Vaile** · 09-18-15, 01:06 PM

Play Indians + 133

team=Indians and FGS and date>=20150811

Indians have won their last 11 first games of series.

**Alex Vaile** · 09-18-15, 01:08 PM

Play Angels - 112
Play Angels RL + 145

p:RMAX > 5 and AF and month!=4 and p:A and n:series game<4 and total>7

ROI % 12 ML
ROI % 32 RL

**Alex Vaile** · 09-18-15, 01:11 PM

Play Red Sox + 170

team=Blue Jays and F and po:BL=0 and p:W and ppo:BL=0 and pp:W and date>=20150814
0-4

team=Red Sox and D and 2<=o:streak and SG=1 and date>=20140905
6-0

Red Sox are 5-0 as a 140+ dog when they are off a road game and facing a divisional opponent that is ahead of them in the standings, including a perfect 4-0 this season.

Finally, Boston is 4-0 after a road game in which they hit multiple home runs, winning by an average of 4.75 runs

**Alex Vaile** · 09-18-15, 01:13 PM

Play Marlins vs Nationals Over 6.5 - 120

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** · 09-18-15, 01:16 PM

Play Tigers - 103

p:WADX and site = home and FGS and streak < 4 and o:streak > -2

(? ??)
ROI % 36

**b1slickguy** · 09-18-15, 01:27 PM

Originally posted by Alex Vaile

Play Angels - 112
Play Angels RL + 145

p:RMAX > 5 and AF and month!=4 and p:A and n:series game<4 and total>7

ROI % 12 ML
ROI % 32 RL

On this side, too.

AF and total>7 and p:SII>=4 and p:hits>12 and WP>50 and season>=2011 and pp:SII<4 and conference=AL and SG>1

Teams are 9-0 vs Twins in this situation.
Good luck.

**Alex Vaile** · 09-18-15, 02:19 PM

Originally posted by b1slickguy

On this side, too.

AF and total>7 and p:SII>=4 and p:hits>12 and WP>50 and season>=2011 and pp:SII<4 and conference=AL and SG>1

Teams are 9-0 vs Twins in this situation.
Good luck.

Let's make it 10!

**Alex Vaile** · 09-19-15, 10:23 AM

Yesterday's results : 3-3 + .21 units
Season to date: 428-423 - 13.48 units

Nats over, Indians, Tigers winners and Brewers, Dodger under, Red Sox losers and Angels postponed

**Alex Vaile** · 09-19-15, 10:28 AM

Play Giants - 105

team=Giants and F and DIV and WP>o:WP and SG>1 and date>=20150624

Giants also 19-0 when seeking same season revenge on starter and previous loss.

**Alex Vaile** · 09-19-15, 10:41 AM

Play Mets - 129

team=Mets and F and p:W and p:SIP<8 and p:BPRA=0 and SG>1 and season=2015

Mets 17-0 in this spot this season.

**Alex Vaile** · 09-19-15, 10:44 AM

Play Over 7 - 115 Indians vs White Sox

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** · 09-19-15, 04:36 PM

Play Rangers - 173
Play Rangers RL + 120

team=Rangers and F and p:hits<=6 and p:L and SG<SGS and date>=20100804 and p:runs<5 and p:HR<2

( Dr.M )

46-8 SU
35-19 RL

**Alex Vaile** · 09-20-15, 02:16 AM

Today's results : 2-2-1 -.14 units
Season to date : 430-425 - 13.62 units

Rangers ML and RL winners and Giants and Mets lost and White Sox over pushed.

**Alex Vaile** · 09-20-15, 07:58 AM

Play Red Sox vs Blue Jays Over 9 + 100

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

Red Sox 12/1 over under this season in this spot

**Alex Vaile** · 09-20-15, 08:24 AM

Play Cardinals + 118

team=Cardinals and p:L and pp:L and LGS and SG=3 and date>=20130800

Cards 13-0 in this spot

**Alex Vaile** · 09-20-15, 11:33 AM

Play Phillies + 130

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

**Alex Vaile** · 09-21-15, 10:21 AM

Yesterday's results: 1-2 - .82 units
Season to date : 431-427 - 14.44 units

Cards winners, Phillies and Red Sox over losers

**Alex Vaile** · 09-21-15, 10:24 AM

Tigers play cancelled as theyve lost 11 out of last 13 games on mondays for some reason and major line move, although early, has gotten me off this game. Good luck today I'll have some plays in a bit..

**Alex Vaile** · 09-21-15, 10:49 AM

Play Mets - 165
Play Mets RL + 115

(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 % ML 29
ROI % RL 22