MLB - Situation Plays - SDQL

[Alex Vaile]

It's been fun comrade . I appreciate your hard work and diligence in this thread. Many don't believe the power of SDQL, but proof is right in this 74 page thread with 70+K views. I will look forward to next season where I will start the thread with new and different conditions in regards to posting- more organized and tracking to say the least.

Now would be the time to concentrate on NFL!

Great season guys! Thanks for all your help and queries!
Just on the posted plays in this thread I was up over 17 units this season using mostly Base's queries and Dr.M and JMon. That's the best I've ever done in any season. Let's keep it rolling and thanks again!

[Alex Vaile]

Really gonna miss this thread here also..I learned so much from guys like vaile,nash,bases,jmon,etc...all the information you guys have provided me really is invaluable to me. Thank you. Really hope you all are down for some hoops this year tho eh?

Thanks for the props Dunlap. It's nice when we can profit together. Good luck to u in NFL and NBA! See u next year for Bases

[KeepItCummin]

guys, i came in at the wrong time here. the season is almost over and i feel your sentiments. i usually never have any interest in mlb until i saw this thread. a voice in my head told me to take a look in the mlb section to see if there are any thing to learn from anyone. well, i sure am trying to learn this sdql, for it sound to be pretty awesome. too bad it is the end of the season, just wish i would have came here earlier. next year it is guys/gals. until then, lets close this season out with a bang!!

[JMon]

guys, i came in at the wrong time here. the season is almost over and i feel your sentiments. i usually never have any interest in mlb until i saw this thread. a voice in my head told me to take a look in the mlb section to see if there are any thing to learn from anyone. well, i sure am trying to learn this sdql, for it sound to be pretty awesome. too bad it is the end of the season, just wish i would have came here earlier. next year it is guys/gals. until then, lets close this season out with a bang!!

Be looking for the NBA SDQL thread coming up.. we had a bunch of contributers in there

[KeepItCummin]

Be looking for the NBA SDQL thread coming up.. we had a bunch of contributers in there

Nice... i definitely will be keeping my eyes open for it. just out of curiosity, do you all save all these sdql's for future uses? if so, there must be thousands of formulas out there huh? im reading past posts on here and thats the impression i am getting.

[nash13]

my dream scenario would be two topics, one for discussion and another only for plays.

[JMon]

Nice... i definitely will be keeping my eyes open for it. just out of curiosity, do you all save all these sdql's for future uses? if so, there must be thousands of formulas out there huh? im reading past posts on here and thats the impression i am getting.

Ya I have mine saved through the KS database for all three sports NFL, NBA and MLB. They come active automatically. I believe others bookmark them, not sure tho.

[KeepItCummin]

Ya I have mine saved through the KS database for all three sports NFL, NBA and MLB. They come active automatically. I believe others bookmark them, not sure tho.

Sorry nash13, I'm not sure if there is another thread for asking sdql questions on sbr.

But JMod, I tried looking up myself what is KS database n it lead me to some Kansas U database and/or Kansas offender database..lol.. But what is a KS database? I remembered another poster was saying something about it but thought it was a typo.

[nash13]

Sorry nash13, I'm not sure if there is another thread for asking sdql questions on sbr.

But JMod, I tried looking up myself what is KS database n it lead me to some Kansas U database and/or Kansas offender database..lol.. But what is a KS database? I remembered another poster was saying something about it but thought it was a typo.

no problem at all, most of the plays and other things get lost in the discussion. so separating actual plays would be useful to follow.

[JMon]

Sorry nash13, I'm not sure if there is another thread for asking sdql questions on sbr.

But JMod, I tried looking up myself what is KS database n it lead me to some Kansas U database and/or Kansas offender database..lol.. But what is a KS database? I remembered another poster was saying something about it but thought it was a typo.

just a short cut we use for killer sports

[KeepItCummin]

just a short cut we use for killer sports

Lol JMon, duh me! I should have known that. Been reading that site.

[JMon]

Play




SDQL ( like to point out a playoff game within this situation, by using playoffs=1)

(s:SPT + ss:SPT) > 222 and s:SPT > 96 and ss:SPT < 132 and 58 < sss:SPT < 123 and s:SHA < 8 and s:SRA < 6 and ss:SRA < 7 and sss:SRA < 6 and ss:SHA > 3 and 7 > s:SWA > 0 and ss:SWA < 6 and sss:SWA < 4 and starter rest < 9 and s:starter rest < 8 and s:SSO > 3 and 12 > ss:SSO > 2 and total < 11 and p:hits < 16 and 19 > pp:hits > 3 and 1 < ppp:hits < 22 and streak < 6 and ou streak > -5 and game number > 30 and 8 > os:SRA > 0 and 14 > o:starter rest > 4 and 23 > os:starter rest > 3 and 24.5 > (s:SIP + ss:SIP + sss:SIP) > 16 and (os:SIP + oss:SIP + osss:SIP) > 11.35 and o:streak < 5 and oA(hits, N=10) < 11 and tA(doubles, N=10) < 2.9 and tA(BPRA, N=10) < 2.5 and oA(BPRA, N=10) > .4

And another playoff specific situation. Very good on the fade last year going 1-7, yet Mad Max went 1-1...so note that.

SDQL

(s:SRA + ss:SRA) = 3 and A and playoffs = 1 and season>2009 and os:SRA!=0

I should have posted this earlier but didn't think the line would fall this much. Some value still left...imo..

play at your own risk... I will track my playoffs..... currently at 1-0 +1.00

Another postseason winner! 2-0 +2.04

[JMon]

Play: GM2 -110






SDQL

Home playoff teams win 71.4% of the time (since 2004) following a playoff win of 5 or more runs. (note while Balt is not a dog here, dogs are 8-0 in this spot!)

playoffs = 1 and H and p:margin >= 5 and p: playoffs = 1 (space after : )

Look to see how AL conference Tigers do after a loss of more than 6 and are a dog on zero rest. They are 11-28 (1-2 they year) Note. KS has not updated the line in this game, but Det has moved to a dog.

SDQL

p:margin<-6 and conference=AL and 11>=total>=7 and SG<4 and line>=-200 and rest=0 and team=Tigers and D


Some teams like to feed off being the largest winner of all yesterday matchups. Orioles are 13-2 (2-0 this year) in this spot since 2011.

SDQL:

p:BL = Maximum(BL@date)[date-1] and p:date=date-1 and p:margin>1 and conference=AL and SG<4 and op:runs<8 and line < 200 and team=Orioles and 2011<=season

gl if you play and always use money management when betting

[KeepItCummin]

JMon, so det is the play yes? i saw the sdql and the over looked good to, am i correct?

[JMon]

JMon, so det is the play yes? i saw the sdql and the over looked good to, am i correct?

Balt ML is the play, hence the logo

[KeepItCummin]

crap, thats the picture of the balt mascot...lol.. you can tell i dont know anything about baseball here.

[KeepItCummin]

Balt ML is the play, hence the logo

im just looking for action to get me back some from last night my friend..

[JMon]

im just looking for action to get me back some from last night my friend..

Did you play the Orioles I posted yesterday?

[KeepItCummin]

Unfortunately I didn't. I saw it all day but was to focus on writing down queries n forgot all about that. When I saw ur post this morning, I could have kicked myself in the butt. No excuses, just my luck eh?.. Cheers to start an awesome wknd!

[Alex Vaile]

JMon what do u have for Giants Nats? I'm leaning Giants, I think they're hot going into this game.

[emceeaye]

Dodgers/Cards under and Nats/Giants under

be careful as sample size is small for playoffs=1:

total <= 7 and SG=1 and conference = NL and (p:runs + po:runs) <= 2 and 2011 <= season and o:team != Rockies and o:team != Brewers and o:team != Cubs and o:team != Pirates and o:team != Marlins and team != Mets and team != Brewers and team != Marlins

[emceeaye]

another on Nats/Giants under

bases query:

H and SG=1 and month >5 and day=Friday 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 pu margin>-6.6 and streak<5 and o:streak<6 and -8 < ou 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

[JMon]

JMon what do u have for Giants Nats? I'm leaning Giants, I think they're hot going into this game.

Not playing this game,, but one of Bases' points to fading SF

s:SRA = 1 and s:SIP < 7 and s:SHA < 7 and s:SWA < 6 and 0 < s:SSO < 8 and 74 < s:SPT < 109 and starter rest < 10 and day != Wednesday and day != Thursday and 6 < p:hits < 18 and 3 < pp:hits < 14 and game number < 165 and (game number < 79 or game number > 89) and (game number > 28 or game number < 20) and line > -220 and -5 < streak < 5 and o:streak < 4 and op:hits < 15

[JMon]

bases query:

H and SG=1 and month >5 and day=Friday 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 pu margin>-6.6 and streak<5 and o:streak<6 and -8 < ou 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

Pointing to the SF OVER

site==away and Average(runs@team and season)<=4.1 and os:starter era<=3.70 and conference=NL and Sum(starter hits+starter walks@starter and season)/Sum(starter innings pitched@starter and season and season=season)>=1.25 and Sum(starter hits+starter walks@starter and season)/Sum(starter innings pitched@starter and season and season=season)<=1.35 and o:conference=NL and total!=7 and division!=o:division and 2008<=season

[Alex Vaile]

bases query:

H and SG=1 and month >5 and day=Friday 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 pu margin>-6.6 and streak<5 and o:streak<6 and -8 < ou 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

Thanks emceeaye one of my favs! Add playoffs =1 and sample goes down but ROI up. Cheers!

[Alex Vaile]

Pointing to the SF OVER

site==away and Average(runs@team and season)<=4.1 and os:starter era<=3.70 and conference=NL and Sum(starter hits+starter walks@starter and season)/Sum(starter innings pitched@starter and season and season=season)>=1.25 and Sum(starter hits+starter walks@starter and season)/Sum(starter innings pitched@starter and season and season=season)<=1.35 and o:conference=NL and total!=7 and division!=o:division and 2008<=season

Right on JMon. Giving me some pause now on side.

[emceeaye]

Pointing to the SF OVER

site==away and Average(runs@team and season)<=4.1 and os:starter era<=3.70 and conference=NL and Sum(starter hits+starter walks@starter and season)/Sum(starter innings pitched@starter and season and season=season)>=1.25 and Sum(starter hits+starter walks@starter and season)/Sum(starter innings pitched@starter and season and season=season)<=1.35 and o:conference=NL and total!=7 and division!=o:division and 2008<=season

Thanks Jmon...This is enough for me to lay off of it.

[JMon]

Tigers BP in...let's go Balt

[emceeaye]

Tigers BP in...let's go Balt

Nice job, Jmon!!

[KeepItCummin]

Tigers BP in...let's go Balt

great work JMon!!

[b1slickguy]

Tigers BP in...let's go Balt

Joba puts a couple on and Soria let's 'em in!
Thanks, JMon.
Good luck.

[Alex Vaile]

Play: GM2 -110






SDQL

Home playoff teams win 71.4% of the time (since 2004) following a playoff win of 5 or more runs. (note while Balt is not a dog here, dogs are 8-0 in this spot!)

playoffs = 1 and H and p:margin >= 5 and p: playoffs = 1 (space after : )

Look to see how AL conference Tigers do after a loss of more than 6 and are a dog on zero rest. They are 11-28 (1-2 they year) Note. KS has not updated the line in this game, but Det has moved to a dog.

SDQL

p:margin<-6 and conference=AL and 11>=total>=7 and SG<4 and line>=-200 and rest=0 and team=Tigers and D


Some teams like to feed off being the largest winner of all yesterday matchups. Orioles are 13-2 (2-0 this year) in this spot since 2011.

SDQL:

p:BL = Maximum(BL@date)[date-1] and p:date=date-1 and p:margin>1 and conference=AL and SG<4 and op:runs<8 and line < 200 and team=Orioles and 2011<=season

gl if you play and always use money management when betting

What a comeback! Good run JMon

[JMon]

Thanks fellas. Love MLB postseason....great time too situational bet and score big!

Mighty scary after that Chen inning. Yet was hopeful that disgraceful Tiger's BP would pull through...AND they did

[JMon]

Joba puts a couple on and Soria let's 'em in!
Thanks, JMon.
Good luck.

And too think I was pissed when KC let Soria go

[JMon]

Postseason 3-0 (+3.04)

Not my favorite, but think it's worth a play.

Play Nats/SF under 7 -105

SDQL

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