MLB - Situation Plays - SDQL

[emceeaye]

one straight from MLB bible

team=Blue Jays and date>=20100801 and p:PU=1 and pitches>=103 and p:M7>-3 and line>-230

check that one out for today!!!

[JMon]

Man, the Athletics pounded the Indians tonight. I wonder what happens when a winning AL team wins by 10 or more in the 1st game of a series on the road against a losing team, and is favored to win again the next day....

AF and p:W and SG=2 and p:margin > 9 and WP > 50 and o:WP < 50 and conference=AL

A and line<=-125 and Sum(hits@team and season)/Sum(at bats@team and season)<=.265 and t:conference=AL and 9 * oS(o:earned runs - starter earned runs) / oS(9 - starter innings pitched)<=3.75 and sA(SHRA)<=.5 and 2009<=season

look how the A's have fare here

[BasesLoaded314]

more As love

(p:margin = Maximum(margin@date)[date -1] and p:date = date -1) and conference=AL and month < 7 and D

(p:margin = Maximum(margin@date)[date -1] and p:date = date -1) and conference=AL and month < 7 and F

[BasesLoaded314]

here we take the dodgers again after they cruised to an easy win(they led by 3 or more after 6 innings and won by 5 or more), but their game before that wasn't a blowout (either a loss or a win by less than 6)

team=Dodgers and season>=2011 and line<=-110 and p:margin>=5 and pp:margin<=5 and p:M6>=3

I didn't make this, props if I snagged it from any of u all

[Roadkill86]

team=Blue Jays and date>=20100801 and p:PU=1 and pitches>=103 and p:M7>-3 and line>-230

check that one out for today!!!

That one is phenomenal. I'm hesitant to fade Buehrle, though, against the Rangers as he has owned them over the past 3 years. BOL!

[Roadkill86]

Simple. Elegant. Devastating. Just looking at how the Pirates fare on the road vs the AL when they have a losing record....

team=Pirates and o:conference=AL and A and WP<50

[JMon]

Simple. Elegant. Devastating. Just looking at how the Pirates fare on the road vs the AL when they have a losing record....

team=Pirates and o:conference=AL and A and WP<50

my god..lol. I was already on the yanks with another interleague situation.

[JMon]

Look and see how the Braves do since '05 trying to avoid a three game sweep on the road as a dog.

AD and p:L and pp:L and series game=series games=series game=3 and team=Braves and 2005<=season

[JMon]

Look and see how the Yankees do at home in a first game of a double header (side and total)

team=Yankees and double header=1 and H

[emceeaye]

One for today

Here's a May-specific one about home dogs who won their last game and who's bullpen runs allowed is lower than their opponent's

HD and DIV and p:W and month = 5 and DIV and p:W and month = 5 and tA(BPRA)<oA(BPRA)

Is this one respectable or no? If not, perhaps tweaks can improve it...

[Roadkill86]

Look and see how the Braves do since '05 trying to avoid a three game sweep on the road as a dog.

AD and p:L and pp:L and series game=series games=series game=3 and team=Braves and 2005<=season

But those Cardinals, tho...
F and p:W and pp:W and team=Cardinals and o:WP>50 and SG=3 and LSG and day=Sunday

[JMon]

But those Cardinals, tho...
F and p:W and pp:W and team=Cardinals and o:WP>50 and SG=3 and LSG and day=Sunday

Good find roadkill...enough to get me off this game entirely

[JMon]

Here's a May-specific one about home dogs who won their last game and who's bullpen runs allowed is lower than their opponent's

HD and DIV and p:W and month = 5 and DIV and p:W and month = 5 and tA(BPRA)<oA(BPRA)

Is this one respectable or no? If not, perhaps tweaks can improve it...

looks good..playing series game 1 and 2 one has 70% dogs win rate...

I had fun with it a bit...note SG=2 is the money maker

HD and DIV and p:W and (month != 6 and month != 7) and tA(BPRA) < oA(BPRA) and line<160 and total <= 10.5 and 4>SG>1 and rest=0

[emceeaye]

Nice, Jmon!

looks good..playing series game 1 and 2 one has 70% dogs win rate...

I had fun with it a bit...note SG=2 is the money maker

HD and DIV and p:W and (month != 6 and month != 7) and tA(BPRA) < oA(BPRA) and line<160 and total <= 10.5 and 4>SG>1 and rest=0

[Roadkill86]

Wait, what? How is this even...?

starter=David Price and p:runs<2 and AF

It can't be that simple, can it?

[JMon]

Look and see how the Yankees do at home in a first game of a double header (side and total)

team=Yankees and double header=1 and H

[Meestermike]

First and foremost I want to say a huge thank you to all participants for their valuable input and insights in this thread as we move farther into this season.

I personally have found numerous play scenarios; situations; spots; however you wish to call them for this season - 2014 quite a bit askew from many other seasons and I know the naysayers and critiques will say wait and behold; It will level out eventually. I have made some serious chump change so far if you will allow me to be blunt;

Here are some very simple, non complex doesn't involve much detail queries that I have been pursuing so far in 2014...

1. season >= 2014 and (-105 <= line <= 185) and p:AL and pp:L

(plon) ~ Play on any team and their line is -105 to +185 after losing their previous AWAY game and losing 2nd previous Hm or Aw game in a row...

58-44; (plon) ~ +$2,816; ROI: +27.5

1.a. season >= 2014 and (-105 <= line <= 185) and p:L and pp:AL

(plon) ~ Play on any team and their line is -105 to +185 after losing their previous Hm or Aw game and losing 2nd previous AWAY game in a row...

SU: 52-37; (plon) ~ +$2,904; ROI: +32.4%

1.b. season >= 2014 and (-105 <= line <= 185) and p:L and pp:L and op:W and opp:W

(plon) ~ Play on any team and their line is -105 to +185 after losing 2 Away games in a row and their opposition has won their last 2 in a row...

SU: 56-43; (plon) ~ +$2,591; ROI: +26.0%

1.c. season >= 2014 and (-105 <= line <= 185) and p:L and pp:L and op:HW and opp:HW

(plon) ~ Play on any team and their line is -105 to +185 after losing 2 games in a row and their opposition has won their last 2 in a row at home...

SU: 40-23; (plon) ~ +$2,696; ROI: +42.6%

****************************************
2. season >= 2014 and A and (-105 <= line <= 185) and op:W and opp:W

(plon) ~ Play on any AWAY team and their line is -105 to +185 and their opposition has won their last 2 games in a row...

SU: 65-51; plon: +$3,114; ROI: +26.7%

2.a. season >= 2014 and A and (-105 <= line <= 185) and op:HW and opp:HW

(plon) ~ Play on any AWAY team and their line is -105 to +185 and their opposition has won their last 2 games in a row at home...

SU: 50-33; plon: +$2,976; ROI: +35.6%

2.b. season >= 2014 and A and (-105 <= line <= 185) and p:AL and pp:AL and op:W and opp:W

(plon) ~ Play on any AWAY team and their line is -105 to +185 after losing last 2 in a row Away and their opposition has won their last 2 in a row...

SU: 35-16; plon: +$2,839; ROI: +55.4%

2.c. season >= 2014 and A and (-105 <= line <= 185) and p:AL and pp:AL and op:HW and opp:HW

(plon) ~ Play on any AWAY team and their line is -105 to +185 after losing last 2 in a row Away and their opposition has won their last 2 in a row at home...

SU: 37-22; plon: +$2,446; ROI: +41.2%

2.d. season >= 2014 and A and (-105 <= line <= 185) and p:AL and pp:L and op:HW and opp:HW

(plon) ~ Play on any AWAY team and their line is -105 to +185 after losing 2 games in a row; lost their previous AWAY game and lost their previous game 2 games back and their opposition has won their last 2 in a row at home...

41-25; plon: +$2,621; ROI: +39.5%

****************************************

3. season >= 2014 and A and line >=-105 and line <=150 and p:AL

(plon) ~ Play on any AWAY team and their line is -105 to +150 after losing their previous away game...

SU: 87-72; plon: +$3,124; ROI: +19.6%

3.a. season >= 2014 and A and (-105 <= line <= 150) and p:L and op:W

(plon) ~ Play on any AWAY team and their line is -105 to +150 after losing their previous game and their opposition won their last game...

SU: 87-74; plon: +$2,900; ROI: +17.9%

3.b. season >= 2014 and A and (-105 <= line <= 150) and p:AL and op:W

(plon) ~ Play on any AWAY team and their line is -105 to +150 after losing their previous AWAY game and their opposition won their last game...

SU: 80-65; plon: +$2,930; ROI: +20.1%

****************************************

4. season >= 2014 and A and (-105 <= line <= 150) and p:AL and pp:AL

(plon) ~ Play on any AWAY team and their line is -105 to +150 after losing their previous 2 AWAY games...

SU: 41-22; plon: +$2,724; ROI: +43.0%

4.a. season >= 2014 and A and (-105 <= line <= 150) and p:AL and pp:AL and op:W

(plon) ~ Play on any AWAY team and their line is -105 to +150 after losing their previous 2 AWAY games and their opposition won their last game...

SU: 37-18; plon: +$2,630; ROI: +47.5%

4.b. season >= 2014 and A and (-105 <= line <= 150) and p:L and pp:L and op:W

(plon) ~ Play on any AWAY team and their line is -105 to +150 after losing their previous 2 games and their opposition won their last game...

SU: 50-32; plon: +$2,687; ROI: +32.5%

****************************************

5. season >= 2014 and A and line >0 and line <=150 and p:AL and pp:AL

(plon) ~ Play on any AWAY team and their line is >0 to +150 after losing their previous 2 away games...

SU: 35-19 (plon) ~ +$2,438; ROI: +45.1%

************************************
6. season >= 2014 and line >0 and line <= 150 and p:L and pp:L and op:HW and opp:W

(plon) ~ Play on any team and their line is >0 to +150 after losing 2 games in a row and their opposition won their previous game @ HM and won their game 2 games previously at home or away...

SU: 30-17; plon: +$1,968; ROI: +41.9%

6.a. season >= 2014 and line >0 and line <= 150 and p:AL and pp:AL and op:HW and opp:HW

(plon) ~ Play on any team and their line is >0 to +150 after losing 2 AWAY games in a row and their opposition won their last 2 games at home...

SU: 23-11; plon: +$1,736; ROI: +51.1%

*********************************

[Roadkill86]

Good find roadkill...enough to get me off this game entirely

YOU'RE WELCOME!

[JMon]

YOU'RE WELCOME!

thanks, be humble in your approach .

[JR007]

[Capper1124]

[Roadkill86]

thanks, be humble in your approach .

Right, I was quite relieved when I posted that because it looked like I had talked you out of a winner and was none too happy about it until that rally... but, the David Price line blew up on me quite badly, so...

[emceeaye]

Update: the line and total has changed since yesterday, so here is the updated query that, although not as significant an effect, is still in favor of the same side SU and RL:

s:SO > 9 and s:W and A and season > 2005 and -185<=line<=100 and conference = o:conference and starter rest < 10 and rest = 0 and SG<3 and month<9 and 10>=total>=7

OK, Emancipactor's query tweaked by Jmon is live tomorrow.Pretty compelling record/ROI with respect to SU and RL, but the opponent makes me take pause given their recent significant success/performance. What do you guys think? Play or no?

played around with one a bit...never a losing season in DB..nice find!

s:SO > 9 and s:W and A and season > 2005 and -185 <= line <= -110 and conference = o:conference and starter rest < 10 and rest = 0 and SG<3 and month<9 and 10>=total>=7.5

[emceeaye]

OK, Emancipator's query tweaked by Jmon is live tomorrow. Pretty compelling record/ROI with respect to SU and RL, but the opponent makes me take pause given their recent significant success/performance. What do you guys think? Play or no?

Update: New line and total:
s:SO > 9 and s:W and A and season > 2005 and -185<=line<=100 and conference = o:conference and starter rest < 10 and rest = 0 and SG<3 and month<9 and 10>=total>=7

Update: but be careful:

DIV and D and p:W and 40>= o:WP <= 50 and season>=2010 and line<=166 and month=5

[Roadkill86]

season>2012 and p:W and p:S8 < po:S8 and SG=1 and op:L

Looking at how teams do when they come from behind in their final AB, against a team that just lost, and it's the first game of a new series.

[emceeaye]

Nice...Take a look at how Mike Minor does after a quality start in which they won.

starter=Mike Minor and HF and s:QS and s:W and date>=20120802

season>2012 and p:W and p:S8 < po:S8 and SG=1 and op:L

Looking at how teams do when they come from behind in their final AB, against a team that just lost, and it's the first game of a new series.

[emceeaye]

Nice...Take a look at how Mike Minor does after a quality start in which they won.

starter=Mike Minor and HF and s:QS and s:W and date>=20120802

OK, but now if we take into account the opposing pitcher's ERA, then the picture isn't rosy anymore:

season>2005 and p:W and p:S8 < po:S8 and SG=1 and op:L and o:STDSERA<=2.50

[House]

I wish I went to college just kidding ... I did and I still feel like Im looking at hieroglyphics in this thread Im gonna go back and attempt figuring this out , what class do I take

[b1slickguy]

I wish I went to college just kidding ... I did and I still feel like Im looking at hieroglyphics in this thread Im gonna go back and attempt figuring this out , what class do I take

House, google "sdql" and check out the bibles for the different sports, too.
Good luck.

[sunshine11]

Just post the f-c-ing plays!

[Alex Vaile]

Just post the f-c-ing plays!

Quit whining. Doesn't take much to copy and paste. These guys do all the work in coming up with the awesome querys.

[BasesLoaded314]

HD and season=2014 and line>109 and STDSERA + o:STDSERA<7.55

[BasesLoaded314]

check out SG=1

[BasesLoaded314]

month = 5 and streak = -4 and 0<o:streak<3

month = 5 and streak = 2 and -6<o:streak<-1 and (line>110 or line<-110)

[BasesLoaded314]

month = 5 and streak = 2 and -6<o:streak<-1 and (line>110 or line<-110)
month = 5 and streak = -4 and 0<o:streak<3