2015 SDQL Baseball Thread

**FUqer** · 09-21-15, 12:50 PM

Good job & Good Luck Alex.

The Mets are 13-0 OU since Aug 02, 2015 as a favorite after a game in which they struck out their opponent at least ten times.

**Alex Vaile** · 09-21-15, 04:44 PM

Play Cardinals - 167

team=Cardinals and H and line<-120 and SG=1 and date>=20120915 and o:team=Reds

Cards 6 and 0 in game 1 against reds at home when favored over -120 since 2012 and 48-20 overall

**inZane** · 09-21-15, 04:51 PM

I hate the big juice, but the Cards look good. Thanks for the posts Alex and FUqer, good luck gentlemen...

**Alex Vaile** · 09-22-15, 07:25 AM

Yesterday's results : 3-0 + 3.15 units
Season to date : 434-427 - 11.29 units

Mets ML, RL and cards won!

**Alex Vaile** · 09-22-15, 07:27 AM

Play Rangers - 121
Play Rangers RL + 135

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 )

Money query as Rangers are 47-8 SU 36-19 RL

**Alex Vaile** · 09-22-15, 07:45 AM

Play Mariners - 114
Play Mariners RL + 145

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

( biz?)

ROI % ML 12
ROI % RL 33

**biz1127** · 09-22-15, 12:27 PM

What's up Alex, do you have a question??

**Alex Vaile** · 09-22-15, 12:44 PM

Originally posted by biz1127

What's up Alex, do you have a question??

No when I list the query I try to give credit to whoever presented it. Hope all is well!

**Alex Vaile** · 09-22-15, 12:48 PM

Play Indians - 119

team=Indians and FGS and date>=20150811

12-0 in this spot

**b1slickguy** · 09-22-15, 01:46 PM

Originally posted by Alex Vaile

Play Indians - 119

team=Indians and FGS and date>=20150811

12-0 in this spot

team=Twins and D and oS:W and oS:season=season and season>=2012

Good luck today!

**FUqer** · 09-22-15, 03:01 PM

The Angels are 0-16 since Sep 27, 2014 as an underdog vs a team that has won at least their last two games.
The Braves are 0-18 since Jul 08, 2014 on the road after a loss in which they allowed 5+ walks.
The Braves are 0-14 since Jun 25, 2015 after a loss in which they allowed 5+ walks and it is not the first game of a series
The Royals are 12-0 OU since Jun 15, 2010 at home as a favorite after a game in which they scored in at least five separate innings.
The Phillies are 0-7 since Sep 02, 2015 on the road

I get my data from Killer Sports and from continuous tracking of previous Diamond Trends from Vince Akins.

**Alex Vaile** · 09-22-15, 06:28 PM

I have a lot of those picks today too just posting my most successful queries. Astros should win but I've been burned a few times this season with Mccullers on mound.

**Alex Vaile** · 09-22-15, 06:31 PM

Originally posted by b1slickguy

team=Twins and D and oS:W and oS:season=season and season>=2012

Good luck today!

Slicker u have some great queries man. Good job and continued good luck!

**inZane** · 09-22-15, 06:52 PM

keep hitting it gentlemen...

**Alex Vaile** · 09-23-15, 05:33 AM

Yesterday's results: 4-1 + 3.61 units
Season to date : 438-428 - 7.68 units

Mariners ML, RL, Rangers ML and RL winners and Indians losers.

**b1slickguy** · 09-23-15, 01:45 PM

Originally posted by Alex Vaile

Slicker u have some great queries man. Good job and continued good luck!

Thanks, Alex.
Good luck to you as well.
Same query active on the Twins fade again today...maybe better results.

**FUqer** · 09-23-15, 02:14 PM

+++Lance Lynn has produced a team record of 0-19-1 OU since September 2012 after a start where he faced less than 29 batters and his WHIP was more than 1.8.

+++The Dodgers are 13-0 since Apr 30, 2014 as a 140+ favorite after a 5+ run loss

+++The Diamondbacks are 0-10 since Jun 26, 2012 on the road after a win in which they had fewer than five team-left-on-base.

+++The Royals are 0-11-1 OU since Jul 29, 2014 at home as a 140+ favorite after a loss in which they used 5+ pitchers.

++ The Royals are 1-11-1 OU since Sep 27, 2009 as a 140+ favorite after a 5+ run home loss.

(Akins)
----------------------------------------------
Please note that I don't play all these games, in fact, I play less than half. I'm just trying to share some useful info.

**Alex Vaile** · 09-23-15, 04:20 PM

Play Under 8 -107 Phillies vs Marlins
Play Under 11 - 112 Pirates vs Rockies

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

**Alex Vaile** · 09-23-15, 04:20 PM

Originally posted by b1slickguy

Thanks, Alex.
Good luck to you as well.
Same query active on the Twins fade again today...maybe better results.

Ya im going with it. Good luck to us!

**Alex Vaile** · 09-23-15, 04:25 PM

Play Under 7.5 - 125 Brewers vs Cardinals

starter = Lance Lynn and s:SWHIP>1.85 and date>=20120705

(SDQG ) cards 0/20 over/under in this spot

**Alex Vaile** · 09-23-15, 04:37 PM

Play Nationals - 175

team=Nationals and HF and p:SO>=10 and date>=20140914

Nats 16-1 in this spot

**biz1127** · 09-23-15, 05:14 PM

Originally posted by Alex Vaile

No when I list the query I try to give credit to whoever presented it. Hope all is well!

Gotcha.

Been deep into football, hope you guys finish strong.

AD and o:WP <=46 and o:WP >=42 and division=o:division and total>=8.5 and p:W and WP >=36 and WP <=56 and season>=2008

Road Dog (Win 36-56%) Won Previous Game, division game vs average team (Win 42-46), Total 8.5 or higher

76-51 (0.85, 59.8%)	avg line: 122.3 / -132.7	on / against: +$3,951 / -$4,724	ROI: +31.1% / -28.1%
90-37 (2.26, 70.9%)	avg line: -165.5 / 151.9	on / against: +$3,185 / -$3,684	ROI: +15.0% / -28.3%
74-49-4 (1.23, 60.2%)	avg total: 9.1	over / under: +$2,065 / -$3,260	ROI: +14.9% / -23.2%

Philadelphia +153 AND OVER 8.5

**inZane** · 09-23-15, 05:25 PM

Here's an example of how this is confusing to an observer like me. Alex has the #'s to show that under 8 in the Phils is a good %. Then we have biz saying the #'s point to over 8.5 in the same game. Do you guys use the same data base but just ask different questions or what? Thanks for your posts...

**RavensFan2k3** · 09-23-15, 05:50 PM

Originally posted by biz1127

Gotcha.

Been deep into football, hope you guys finish strong.

AD and o:WP <=46 and o:WP >=42 and division=o:division and total>=8.5 and p:W and WP >=36 and WP <=56 and season>=2008

Road Dog (Win 36-56%) Won Previous Game, division game vs average team (Win 42-46), Total 8.5 or higher

76-51 (0.85, 59.8%)	avg line: 122.3 / -132.7	on / against: +$3,951 / -$4,724	ROI: +31.1% / -28.1%
90-37 (2.26, 70.9%)	avg line: -165.5 / 151.9	on / against: +$3,185 / -$3,684	ROI: +15.0% / -28.3%
74-49-4 (1.23, 60.2%)	avg total: 9.1	over / under: +$2,065 / -$3,260	ROI: +14.9% / -23.2%

Philadelphia +153 AND OVER 8.5

Was this for yesterday or for today?

**RavensFan2k3** · 09-23-15, 08:58 PM

Originally posted by RavensFan2k3

Was this for yesterday or for today?

Wish I would have gotten an answer but I see that was for today

**biz1127** · 09-24-15, 04:04 AM

Originally posted by RavensFan2k3

Wish I would have gotten an answer but I see that was for today

I'm not going to post a play that has already been played.

**FUqer** · 09-24-15, 05:45 AM

I noticed some of the stats I posted from tracking Akins weren't up to date, so I will try to query them myself to verify.

------------------------------------
The Diamondbacks are 1-12 since Aug 17, 2014 as a dog after a loss in which they left fewer than 10 men on base.
team=Diamondbacks and 0<t:line and p:L and p:LOB<10 and date>=20140814
----
The Red Sox are 14-1-1 OU since Jul 20, 2015 after a loss in which they never led.
team=Red Sox and p:IL=0 and p:runs<po:runs and date>=20150720
----
The Athletics are 1-11 since Sep 27, 2012 as a 140+ dog and it is the last game of the series.
team=Athletics and 140<=t:line and LGS and date>=20120927
----
The Pirates are 14-3 since Jul 02, 2015 as a favorite it is the last game of the series.
team=Pirates and line<-105 and LGS and date>=20150702

The Pirates are 6-1 since Jul 02, 2015 as an away favorite and it is the last game of the series.
team=Pirates and A and line<-105 and LGS and date>=20150702
----

I played the Pirates ML and Red Sox Over, waiting on -1 for Texas to be released.

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

Originally posted by inZane

Here's an example of how this is confusing to an observer like me. Alex has the #'s to show that under 8 in the Phils is a good %. Then we have biz saying the #'s point to over 8.5 in the same game. Do you guys use the same data base but just ask different questions or what? Thanks for your posts...

Its not really the database but the information entered into it which determines the play.

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

Yesterday's results : 1-3 - 3.12 units
Season to date: 439-431 - 10.8 units

Marlins under winner, Rockies under, Nats blew it, and Cards under a joke.

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

Play Pirates - 123
Play Pirates RL + 130

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

( biz)
ROI % ML 12
ROI % RL 32

**RavensFan2k3** · 09-24-15, 11:16 AM

Damn, I'm on Colorado here

**Alex Vaile** · 09-24-15, 11:49 AM

Originally posted by RavensFan2k3

Damn, I'm on Colorado here

A lot of good info for Pirates today. Good luck to u Raven. I've seen you post in many of the threads.

**Alex Vaile** · 09-24-15, 11:53 AM

Play Rays + 110
Play Rays RL - 180

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

Rays 14-10 SU and 19-5 against the RL in this situation.

**Alex Vaile** · 09-24-15, 11:54 AM

No play on Giants. They are terrible as F against Padres for some reason.

**FUqer** · 09-24-15, 03:23 PM

** When Madison Bumgarner starts the Giants are 7-0 since 2014 when they lost his last start as a favorite of at least -160.
----
** The Mets are 9-1 since Jul 03, 2015 on the road after allowing 6+ runs.
team=Mets and site=away and 6<=op:runs and date>=20150703
----
*** The Red Sox are 0-13 since Jul 08, 2012 at home as a favorite vs a divisional opponent that is ahead of them in the standings and in the last game of a series.
----