MLB - Situation Plays - SDQL

**JMon** · 05-04-14, 06:40 AM

Winners galore in here

**JMon** · 05-04-14, 06:40 AM

Originally posted by Alex Vaile

Great queries as Both the tigers and that over in pads hit. Thanks u guys. Roadkill and Jmon! !

and Rockies

**Roadkill86** · 05-04-14, 10:18 AM

The Rockies was the final leg of a 5-team parlay I hit, no less!

**Alex Vaile** · 05-04-14, 10:24 AM

Nice job

**Alex Vaile** · 05-04-14, 10:25 AM

And rockies. Nice Job JMon

**LiarGame** · 05-04-14, 10:39 AM

Anyone know how to get the number of home and away wins and losses in the season? Thanks

**JMon** · 05-04-14, 10:52 AM

Originally posted by LiarGame

Anyone know how to get the number of home and away wins and losses in the season? Thanks

edit..not going to work

**Roadkill86** · 05-04-14, 10:53 AM

Originally posted by LiarGame

Anyone know how to get the number of home and away wins and losses in the season? Thanks

In what context? You just want to know a team's home or road record for the season? I use the following;

MLB Standings - 2025 season - ESPN

http://espn.go.com/mlb/standings

Visit ESPN for the complete 2025 MLB season standings. Includes league, conference and division standings for regular season and playoffs.

**JMon** · 05-04-14, 10:56 AM

geez the number of plays today with Nick's "may bomb" query. I do like the halos, sillies, pirates and reds out of that bunch.

**JMon** · 05-04-14, 10:56 AM

Originally posted by Roadkill86

The Rockies was the final leg of a 5-team parlay I hit, no less!

Nice...I bet you were sweatin the rockies game....lol

**LiarGame** · 05-04-14, 11:32 AM

Originally posted by Roadkill86

In what context? You just want to know a team's home or road record for the season? I use the following;
http://espn.go.com/mlb/standings

I wanted to test a system that uses the exact season away/home wins/losses. Was hoping there was something that would make it easier

**Roadkill86** · 05-04-14, 11:35 AM

Originally posted by JMon

geez the number of plays today with Nick's "may bomb" query. I do like the halos, sillies, pirates and reds out of that bunch.

Holy crap. That's a lot to sort through. I'm going to try playing them all with a 1/3 Kelly on each (calls for far less money on the heavy faves). I'll let you know how that goes.

Originally posted by JMon

Nice...I bet you were sweatin the rockies game....lol

Oh yeah, I was doing my happy dance as I went from being way down for the day to a 37% ROI instead.

I nearly tilt-bet heavily on the over in Live Betting, too, after the Mets went up 6-0 in the 3rd, and am kicking myself for not trusting this query.
team=Rockies and S3 > = 6 and o:runs > 5

**Roadkill86** · 05-04-14, 11:50 AM

(starter= Alex Wood or starter=Madison Bumgarner) and S5
(starter= Justin Verlander or starter=Jason Vargas) and S5 and season>2011

Here I'm looking at the aggregate score totals through 5 innings in games involving either of today's starters in the Giants/Braves game and the Tigers/Royals game.

Simple, but powerful, IMO.

**Cougs** · 05-04-14, 12:16 PM

nice find!

**bignick410** · 05-04-14, 01:01 PM

Originally posted by JMon

geez the number of plays today with Nick's "may bomb" query. I do like the halos, sillies, pirates and reds out of that bunch.

Haha it's funny those are the pretty much the same as what I chose out of that query and I love this thread as Jmon said it's raining winners in here BOL everyone

**JR007** · 05-04-14, 02:13 PM

so you can use this query for all first five plays just plugging in the pitchers..

**Roadkill86** · 05-04-14, 04:14 PM

Correcting my earlier query...
(starter = Madison Bumgarner or starter= Alex Wood) and (S5 + o:S5) and season >= 2013

What I typed previously only yielded the pitcher's own team's runs.

**Roadkill86** · 05-04-14, 04:22 PM

For you 1st inning prop players (runs or no runs)...
(starter = Jose Quintana or starter= Jeff Samardzija) and (S1 + o:S1) and date>=20130901

**Alex Vaile** · 05-05-14, 10:01 AM

Hi guys. I'm curious how I would write a query for the royals who have lost 4 in a row and are now an away favorite for interleave match up with pads. Thanks!

**EVfollower** · 05-05-14, 01:04 PM

Been following this thread last couple days. Could someone post the link of the site(s) they are using for these capping statistics? Really like what is going on here but to be honest, couple plays I couldn't play because I didn't know what the actual play was. Could someone list out what all the variables are and their letters? Thank you and I appreciate it. All about following +EV cappers or systems.

**Alex Vaile** · 05-05-14, 02:32 PM

Google the topic sdql database

**Mako-SBR** · 05-05-14, 03:04 PM

Originally posted by EVfollower

Been following this thread last couple days. Could someone post the link of the site(s) they are using for these capping statistics? Really like what is going on here but to be honest, couple plays I couldn't play because I didn't know what the actual play was. Could someone list out what all the variables are and their letters? Thank you and I appreciate it. All about following +EV cappers or systems.

As has been said prior in the thread: Google "SDQL".

Follow all the links that show up for it, read all instructions that you find, absorb all the information. Only way to do it.

We would link sites directly, but it isn't allowed on SBR. Best of luck.

**JMon** · 05-05-14, 04:32 PM

geez Zach appears to do well (even with 3 different clubs) after throwing 100+ pitches and showing a loss.

s:starter pitches>100 and starter='Zack Greinke' and 2011<=season and p: points<po: points

**JMon** · 05-05-14, 04:39 PM

good fielding team; after putting up 10 or more runs...

tA(double plays)>=1.1 and -125<=line<=125 and p:runs>=10 and 2006<=season

**JMon** · 05-05-14, 05:04 PM

Look how the nationals do in this total play, team=Nationals

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

**Alex Vaile** · 05-06-14, 12:32 AM

Nicely done. Thanks JMon

**Roadkill86** · 05-07-14, 07:04 AM

season > 2011 and SG=3 and playoffs=0 and p:X and o:conference=NL and H and (streak< = -2 or streak> = 2) and team!=Rockies and team!=Brewers and o:team!=Brewers and o:team!=Rockies

Looking for games where someone is going for a 3rd straight win over someone after an extra inning game, the road team is an NL one, and we are excluding the Brewers and Rockies.

**JMon** · 05-07-14, 10:00 AM

total play

H and 10 >= total >= 8 and po:runs <= 4 and ppo:runs <= 4 and pppo:runs < 4 and op:L and op:margin = -1 and 2010<=season and rest = 0 and month!=8

**JMon** · 05-07-14, 10:06 AM

Originally posted by JMon

looks good: did you want oppt previous game or team's previous oppt? Anyway I played around with a bit. Very nice! Never a losing season. Not active today though.

p:X and SG>1 and division!=o:division and p:PU > 4 and p:PU < po:PU and A and 9>=total>=8 and 8>month>4

Premise was from Nick...I added to it...total play here active

**JMon** · 05-07-14, 10:18 AM

I posted this interleague play awhile back, which clicking at 11-5 this year on the fade..

conference=NL and o:conference=AL and A and 230>=line>-105 and month<8 and 9.5>=total>=7

**Tillos** · 05-07-14, 05:46 PM

When: team=Braves and LGS and H and STL and p:W - Mike Minor is 1-6 o/u when pitching

**Tillos** · 05-07-14, 05:54 PM

The over is 8-0 since July 22 2012 when: team=Twins and p:L and pp:W and o:STDSERA>5.90

(That is when the twins are facing a pitcher with a horriable ERA)

**FIRSTand13** · 05-07-14, 10:26 PM

Streak as dog/fav

D and Sum(DW@team, N=4)=4

60-60 (0.34, 50.0%)

avg line: -141.1 / 127.7

on / against: -$2,202 / +$1,512

ROI: -12.7% / +11.9%

So this is a start on something I'm trying to explore. Amazing 2013 results. It yields a dog with a win streak as a dog vs current opponent. I am trying to find streaks involving all opponents. Need to replace the term "team" with something?

**emceeaye** · 05-08-14, 03:20 PM

phillies-blue jays

Here are 2 queries already posted in this thread I think by Jmon that point to same outcome of Phillies/Blue Jays tonight:

conference=NL and o:conference=AL and A and 230>=line>-105 and month<8 and 9.5>=total>=7

H and p:margin > 7 and op:runs = 0 and season > 2008 and WP < 60 and o:WP > 38.5 and rest = 0

**Alex Vaile** · 05-08-14, 03:44 PM

Thanks for posting!