MLB - Situation Plays - SDQL

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

A and tS(L, N=7)>=5 and 54>=WP>=51 and 54>o:WP>=51 and 2005<=season and line<=180 and SG<4

Here we want to fade a losing team (5 or 6 out of last 7) both winning teams. Fading the fav should be looked at...bol

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

A and p:runs = 0 and p: DIV and s:SRA >= 7 and rest = 0 and SG!=2

Under play; road team after getting shut out by a division rival starting a pitcher that gave up 7 or more runs in his last outing. zero rest and not series game 2

**sunshine11** · 04-30-14, 05:51 PM

Is this a free site. It's so confusing. Can you please post the plays each day.

**JR007** · 04-30-14, 07:02 PM

do you guys have any references on how teams are scoring for the 1st five innings, cannot seem to find those stats Thanks

**b1slickguy** · 04-30-14, 07:40 PM

Originally posted by JR007

do you guys have any references on how teams are scoring for the 1st five innings, cannot seem to find those stats Thanks

Check out armadillo sports.
Short and simple info.
Good luck.

**JMon** · 04-30-14, 09:21 PM

Originally posted by JMon

Hammer play is active tonight. Post 280. Good luck if you play

Originally posted by green7

Rolling with you on the Marlins.

Nice query,...good fortune.

Hammer play hits again, green

WON: 906 Marlins (-105) AT risk 525.00 win 500.00 (MLB) Score: 9-3

04/30/14 17:33:29

$500.00

#2934244

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

Tiger under and cards both cashed. Thanks for the queries

**bignick410** · 05-02-14, 11:12 AM

Hey guys now that the calendar has flipped to May thought I'd put these 2 queries up that I found in newsletters for this month that look interesting

HD and DIV and p:W and month = 5
SU: 130-116 (-0.43, 52.8%) avg line: 121.7 / -132.3 on / against: +$4,219 / -$5,564 ROI: +17.1% / -17.1%
RL: 108-67 (0.95, 61.7%) avg line: -134.2 / 120.5 on / against: +$1,807 / -$2,737 ROI: +7.5% / -14.7%
OU: 123-111-12 (0.44, 52.6%) avg total: 8.7 over / under: +$170 / -$2,360 ROI: +0.6% / -8.7%

And

H and total >= 7.5 and total <= 9.5 and month = 5 and (day = Sunday or day = Monday or day = Tuesday)
SU: 816-554 (0.35, 59.6%) avg line: -128.0 / 115.9 on / against: +$14,573 / -$21,122 ROI: +7.9% / -14.1%
RL: 460-498 (-0.25, 48.0%) avg line: 120.5 / -135.2 on / against: +$4,502 / -$10,480 ROI: +4.1% / -7.5%
OU: 656-661-53 (0.48, 49.8%) avg total: 8.6 over / under: -$6,735 / -$6,375 ROI: -4.5% / -4.2%

The second one if it's a home dog has a 14.4 ROI
BOL

**JMon** · 05-02-14, 11:43 AM

Originally posted by bignick410

Hey guys now that the calendar has flipped to May thought I'd put these 2 queries up that I found in newsletters for this month that look interesting

HD and DIV and p:W and month = 5
SU: 130-116 (-0.43, 52.8%) avg line: 121.7 / -132.3 on / against: +$4,219 / -$5,564 ROI: +17.1% / -17.1%
RL: 108-67 (0.95, 61.7%) avg line: -134.2 / 120.5 on / against: +$1,807 / -$2,737 ROI: +7.5% / -14.7%
OU: 123-111-12 (0.44, 52.6%) avg total: 8.7 over / under: +$170 / -$2,360 ROI: +0.6% / -8.7%

And

H and total >= 7.5 and total <= 9.5 and month = 5 and (day = Sunday or day = Monday or day = Tuesday)
SU: 816-554 (0.35, 59.6%) avg line: -128.0 / 115.9 on / against: +$14,573 / -$21,122 ROI: +7.9% / -14.1%
RL: 460-498 (-0.25, 48.0%) avg line: 120.5 / -135.2 on / against: +$4,502 / -$10,480 ROI: +4.1% / -7.5%
OU: 656-661-53 (0.48, 49.8%) avg total: 8.6 over / under: -$6,735 / -$6,375 ROI: -4.5% / -4.2%

The second one if it's a home dog has a 14.4 ROI
BOL

Ill have to look into those more deeply, thanks nick

**JMon** · 05-02-14, 11:45 AM

Simple logic here with good results..

H and line >= 125 and Sum(hits@team and season) / Sum(at bats@team and season) <= .265 and 5.7>=o:STDSERA >= 4.7 and o:conference = AL and SG < 3 and day!=Saturday

**Alex Vaile** · 05-02-14, 11:54 AM

Good info thanks.
I have a question for u Bignick. At what ROI % does a query indicate a play for u.

**Alex Vaile** · 05-02-14, 12:11 PM

Thanks JMON for posting. I liked the Rays already and now it sealed it for me.

**bignick410** · 05-02-14, 12:55 PM

Originally posted by Alex Vaile

Good info thanks.
I have a question for u Bignick. At what ROI % does a query indicate a play for u.

I am not one that play just because a query says to although there are one that I give more credit to then others I save a lot of situation listed here as well as finding some in newsletters and on my own, I look at them when they have games active and weigh them individually. But to try and answer your question I give more credit to a situation that say has 1000 games then one that has 50 even if the ROI may be a little less it really goes back to what Jmon said earlier in the thread about trend analysis and understanding long and short term trends

**green7** · 05-02-14, 02:57 PM

Nice finds Nick...thanks for sharing.

The second query is particularly strong in the NL with a return of 9.9% ROI.

The first query when using the filter of a better bullpen brings the ROI over 38%....with a worse bullpen there is no advantage.

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

**bignick410** · 05-02-14, 06:36 PM

Originally posted by green7

Nice finds Nick...thanks for sharing.

The second query is particularly strong in the NL with a return of 9.9% ROI.

The first query when using the filter of a better bullpen brings the ROI over 38%....with a worse bullpen there is no advantage.

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

Nice filter work there well done green

**Alex Vaile** · 05-02-14, 07:25 PM

Ok thanks ill keep that in mind

**JMon** · 05-02-14, 08:16 PM

Originally posted by green7

Nice finds Nick...thanks for sharing.

The second query is particularly strong in the NL with a return of 9.9% ROI.

The first query when using the filter of a better bullpen brings the ROI over 38%....with a worse bullpen there is no advantage.

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

green, as you know the difference of runs allowed and earned. For your (and anyone) reference if you ever need Bull pen era the following may be used...enjoy.

Sum(o:earned runs-starter earned runs@team and season)/Sum(9-starter innings pitched@team and season)

**JMon** · 05-02-14, 08:44 PM

Originally posted by bignick410

Hey guys now that the calendar has flipped to May thought I'd put these 2 queries up that I found in newsletters for this month that look interesting

HD and DIV and p:W and month = 5
SU: 130-116 (-0.43, 52.8%) avg line: 121.7 / -132.3 on / against: +$4,219 / -$5,564 ROI: +17.1% / -17.1%
RL: 108-67 (0.95, 61.7%) avg line: -134.2 / 120.5 on / against: +$1,807 / -$2,737 ROI: +7.5% / -14.7%
OU: 123-111-12 (0.44, 52.6%) avg total: 8.7 over / under: +$170 / -$2,360 ROI: +0.6% / -8.7%

And

H and total >= 7.5 and total <= 9.5 and month = 5 and (day = Sunday or day = Monday or day = Tuesday)
SU: 816-554 (0.35, 59.6%) avg line: -128.0 / 115.9 on / against: +$14,573 / -$21,122 ROI: +7.9% / -14.1%
RL: 460-498 (-0.25, 48.0%) avg line: 120.5 / -135.2 on / against: +$4,502 / -$10,480 ROI: +4.1% / -7.5%
OU: 656-661-53 (0.48, 49.8%) avg total: 8.6 over / under: -$6,735 / -$6,375 ROI: -4.5% / -4.2%

The second one if it's a home dog has a 14.4 ROI
BOL

H and DIV and p:W and month = 5 and 165 >= line >= 105 and SG!=3
(look up rest=1, which fell on the Cubs today!)

H and DIV and p:W and month = 5 and 165 >= line >= 105 and SG!=3 and 9.5>=total>=9
70%dog; limited opportunity with under propensity

**JMon** · 05-02-14, 08:56 PM

H and 9.5>=total >= 7.5 and month = 5 and (day = Sunday or day = Monday or day = Tuesday)

this is really a good find...no sense messing around with this one. Nice find!!

Curious though, Nick, when you say Newsletter; whom are you referring too? Need to be careful posting someone's work (unless it's a public newsletter).

**bignick410** · 05-02-14, 09:51 PM

Those two are from a free newsletter I've been getting emailed for a while, others I've posted have been mine that I found. The newsletter is from Mr. East he sometimes goes over a set of parameters then I translate to sdql. I saw somewhere that he used sdql (which you can tell when reading them) which lead me there then to here.

**bignick410** · 05-02-14, 09:57 PM

Originally posted by JMon

H and DIV and p:W and month = 5 and 165 >= line >= 105 and SG!=3
(look up rest=1, which fell on the Cubs today!)

H and DIV and p:W and month = 5 and 165 >= line >= 105 and SG!=3 and 9.5>=total>=9
70%dog; limited opportunity with under propensity

Very nice work again Jmon on cleaning that up

**figue** · 05-02-14, 10:46 PM

WP > 50 and H and 165 > line >= 100 and o:WP > 50 and SG < 4 and month = 5

**bignick410** · 05-02-14, 11:16 PM

Watching the Yankees game has now has inspired me to find this

p:X and SG > 1 and p:PU > 4 and p:PU < op:PU and A and total > 7 and total < 10

For tomorrow under might be in play

**JMon** · 05-03-14, 04:42 AM

Originally posted by bignick410

Those two are from a free newsletter I've been getting emailed for a while, others I've posted have been mine that I found. The newsletter is from Mr. East he sometimes goes over a set of parameters then I translate to sdql. I saw somewhere that he used sdql (which you can tell when reading them) which lead me there then to here.

ok, cool

**JMon** · 05-03-14, 09:41 AM

Here we want to fade a team that lost their last two games by 4 more and their oppt is coming off 8 or more runs. simply logic here, only two losing season. bol

-140<=line<=120 and p:margin<=-4 and pp:margin<=-4 and op:runs>=8 and H and SG<4 and total<11

**JMon** · 05-03-14, 10:05 AM

Originally posted by bignick410

Watching the Yankees game has now has inspired me to find this

p:X and SG > 1 and p:PU > 4 and p:PU < op:PU and A and total > 7 and total < 10

For tomorrow under might be in play

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

**Roadkill86** · 05-03-14, 11:42 AM

This is a JMon play posted earlier in the season that is active today...
total <= 7 and tA(runs) <= 3.3 and oA(runs) <= 3.8 and conference = NL and o:conference = NL and rest = 0 and 2011<=season

33-37 (-0.49, 47.1%)	avg line: -101.9 / -110.4	on / against: -$465 / +$184	ROI: -5.5% / +2.1%
44-14-12 (1.63, 75.9%)	avg total: 6.7	over / under: +$2,900 / -$3,380	ROI: +37.5% / -44.1%

(spoiler; play the OVER in the Dbacks/Padres game)

**Alex Vaile** · 05-03-14, 11:45 AM

Thanks for clarifying Roadkill

**Roadkill86** · 05-03-14, 11:51 AM

15 < p:hits < 22 and p:runs < 10 and HF

This is a straightforward play where a home favorite banged out a lot of hits yesterday but scored in the single digits. Played on the RL, they win just under half the time, but the return is worth it...

115-56 (1.44, 67.3%)	avg line: -155.6 / 141.3	on / against: +$2,646 / -$3,478	ROI: +9.9% / -20.3%
54-57 (-0.03, 48.6%)	avg line: 143.7 / -158.2	on / against: +$2,146 / -$2,839	ROI: +18.9% / -16.0%
87-75-9 (0.79, 53.7%)	avg total: 8.7	over / under: +$500 / -$2,145	ROI: +2.7% / -11.3%

Pirates and Yankees fit the bill for this one.

**Mako-SBR** · 05-03-14, 02:36 PM

Originally posted by green7

Nice finds Nick...thanks for sharing.

The second query is particularly strong in the NL with a return of 9.9% ROI.

The first query when using the filter of a better bullpen brings the ROI over 38%....with a worse bullpen there is no advantage.

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

Looks like the better bullpen portion of the query got chopped off by the message board software, remember guys whenever using a less than or better than sign (< or > ) you must put a space in intentionally to throw off the auto-correct software.

Here you go:

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

**Mako-SBR** · 05-03-14, 02:45 PM

Originally posted by Roadkill86

This is a JMon play posted earlier in the season that is active today...
(spoiler; play the OVER in the Dbacks/Padres game)

Nice RK, good heads up! Remember though not to give the actual picks in the thread, just the queries.

We want people to be forced to educate themselves on SDQL and then come back with their own new scenarios once they master it so that we all benefit.

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

Originally posted by Roadkill86

This is a JMon play posted earlier in the season that is active today...
total <= 7 and tA(runs) <= 3.3 and oA(runs) <= 3.8 and conference = NL and o:conference = NL and rest = 0 and 2011<=season

33-37 (-0.49, 47.1%)	avg line: -101.9 / -110.4	on / against: -$465 / +$184	ROI: -5.5% / +2.1%
44-14-12 (1.63, 75.9%)	avg total: 6.7	over / under: +$2,900 / -$3,380	ROI: +37.5% / -44.1%

(spoiler; play the OVER in the Dbacks/Padres game)

I personally don't like this play tonight, but good luck to those on it!

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

Revenge is not so sweet, eh? Need a translation...chime away, Kentucky Derby time!

150>=line>=100 and P:A and P:season=season and P:margin<=-6 and 54>=WP>=51 and total>8 and 2009<=season

**Roadkill86** · 05-03-14, 07:41 PM

For people who like the smaller markets, such as the "Will a run score in the 1st?" prop, try a search such as...
(team=Rangers or team=Angels) and S1 and season=2014
It won't show you the ROI, but the search will sort the games by frequency of total runs in the 1st (S1).

Want First Five O/U? Try
team=Cardinals and S5 and season=2014
Again, it'll give you a frequency table of the total score through 5 innings in their games.

**Alex Vaile** · 05-03-14, 10:52 PM

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