MLB - Situation Plays - SDQL

[JMon]

Damn Marlins...bad luck

I know freakin brutal

[Alex Vaile]

hasnt been active since last year but make sense to go with this team regardless of query.

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

Hard to back Verlander at this price especially on the road. But query pretty good

[Alex Vaile]

yep, I was waiting for this one to be active

Well if both you guys and Posey like it then I guess it's good.

[JMon]

First posted play 6/27:

Under 6 Reds vs Giants -115

The 2 long total queries from Bases point to this one.

on it... looks like Sea un is a play as well

[JMon]

nice total on a heater...good on the road as well. sub par season-to-date BA, NL team after a combined low scoring game..play under

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 and site = home

[JMon]

rays in the first game of a double header, total and possible side

team=Rays and double header=1 and 2004<=season

[emceeaye]

Very nice, Jmon. Thanks! [QUOTED=JMon;22145195]nice total on a heater...good on the road as well. sub par season-to-date BA, NL team after a combined low scoring game..play under

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 and site = home[/QUOTE]

[JMon]

Hard to back Verlander at this price especially on the road. But query pretty good

ya, i know...

[emceeaye]

OK, now both of you have me thinking...Houston's pitcher has been solid lately and they're playing at home. But Verlander also had a good outing last time out which is good, and Detroit bats are hot right now!

ya, i know...

[bobby29]

I first want to say thanks to everybody that posts these plays.

To the posters who post the queries, could you post what the actual plays are if you dont mind.

I have tried and tried to learn this query stuff and still cant get it.
Thank you and continued good luck

bobby

[otunj]

on it... looks like Sea un is a play as well

I've looked at Bases' queries and arent seeing that one. Which one is it? Thanks!

[Alex Vaile]

I've looked at Bases' queries and arent seeing that one. Which one is it? Thanks!

This is 1 for reds giants under

season > 2008 and H and 10 > month > 5 and SG < 4 and 5 > streak
> -5 and 1 > tA(HR) > .7 and s:SRA < 6 and p:hits < 11 and 16
> op:hits > 4 and sss:SRA < 4 and rest = 0 and p:home runs < 2 and
os:SSO < 11 and oss:SSO < 10 and os:SHA < 11 and 2 < oss:SHA < 11
and p:IT < 6 and p:LOB < 21 and s:SPT < 122 and ss:SPT < 119 and
team != Rockies and team != Athletics and o:team != Blue Jays and (p:errors +
pp:errors + ppp:errors + pppp:errors + ppppp:errors + pppppp:errors) < 10 and
(op:errors + opp:errors + oppp:errors + opppp:errors + oppppp:errors +
opppppp:errors) < 8 and (p:temperature < 91 or p:temperature = Indoors)

This is the other:
H and month > 5 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

[Alex Vaile]

rays in the first game of a double header, total and possible side

team=Rays and double header=1 and 2004<=season

Nice I was on the under. Seems like the morning games often going under

[Alex Vaile]

OK, now both of you have me thinking...Houston's pitcher has been solid lately and they're playing at home. But Verlander also had a good outing last time out which is good, and Detroit bats are hot right now!

Ya I don't feel great about it but I'll go with it. You'd figure he ll bounce back at some point over nite the line moved towards houston and now has come back towards detroit. Good luck

[Alex Vaile]

Found this one from a few weeks ago. Courtesy of Base's again: lot of under plays today according to queries.

month = 6 and season > 2009 and F and (SG = 2 or SG = 3) and day != Sunday and 14 > p:hits > 3 and 10.01 > total > 6.49 and op:hits < 17 and pp:hits < 12 and opp:hits > 3 and ppp:hits > 2 and 9 > os:SSO > 0 and oss:SSO < 7 and 15 > streak > -4 and 5 > o:streak > -6 and 10.01 > p:total > 6.49 and ou streak > -5 and 2 > (tA(runs) + oA(runs) - total) > -.6 and team!=Astros and team!=Brewers and o:team!=Rockies and o:team!=Red Sox and o:team!=Marlins

[otunj]

Cubs SU

streak = 1 and SG = 2 and s:earned runs < 9 and s:SHA < 10 and ss:SHA < 12 and 0 < os:SRA < 7 and 63 < s:SPT < 117 and 9.76 > oA(hits, N=4) > 5.76 and 5.0 > oA(walks, N=10) > 2.1 and o:streak > -7 and 2.2 < oA(runs, N=7) < 5.99 and 18 > p:hits > 3 and line > -225 and 1.7 > oA(HR, N=10) > .5 and tA(HR, N=10) > .3 and 2.6 > oA(doubles, N=10) > 1.05 and op:walks != 0 and STDSWHIP > .95 and o:STDSWHIP < 1.8 and ou streak > -6 and ou streak < 4 and p:rest < 3 and (STDSERA < 1.58 or STDSERA > 2.71) and (85 > game number > 11 or game number > 101)

s:SRA < 2 and 5 > ss:SRA > 0 and sss:SRA < 4 and ssss:SRA < 6 and 0 < sssss:SRA < 8 and os:SRA < 5 and SG < 4 and day != Tuesday and day != Thursday and 4 < starter rest < 10 and o:starter rest < 11 and 161 > game number > 27 and line > -165 and 2 > p:margin > -9 and 11.2 > tA(hits, N=10) > 6.7 and 6.2 < oA(hits, N=10) < 11.3 and STDSWHIP > .948 and ss:SPT > 67 and 40 < oss:SPT < 113 and tA(doubles, N=10) < 2.5 and tA(errors, N=10) > .1 and .3 < oA(BPRA, N=10) < 2.6 and tA(BPRA, N=10) < 2.8

[Alex Vaile]

Cubs SU

streak = 1 and SG = 2 and s:earned runs < 9 and s:SHA < 10 and ss:SHA < 12 and 0 < os:SRA < 7 and 63 < s:SPT < 117 and 9.76 > oA(hits, N=4) > 5.76 and 5.0 > oA(walks, N=10) > 2.1 and o:streak > -7 and 2.2 < oA(runs, N=7) < 5.99 and 18 > p:hits > 3 and line > -225 and 1.7 > oA(HR, N=10) > .5 and tA(HR, N=10) > .3 and 2.6 > oA(doubles, N=10) > 1.05 and op:walks != 0 and STDSWHIP > .95 and o:STDSWHIP < 1.8 and ou streak > -6 and ou streak < 4 and p:rest < 3 and (STDSERA < 1.58 or STDSERA > 2.71) and (85 > game number > 11 or game number > 101)

s:SRA < 2 and 5 > ss:SRA > 0 and sss:SRA < 4 and ssss:SRA < 6 and 0 < sssss:SRA < 8 and os:SRA < 5 and SG < 4 and day != Tuesday and day != Thursday and 4 < starter rest < 10 and o:starter rest < 11 and 161 > game number > 27 and line > -165 and 2 > p:margin > -9 and 11.2 > tA(hits, N=10) > 6.7 and 6.2 < oA(hits, N=10) < 11.3 and STDSWHIP > .948 and ss:SPT > 67 and 40 < oss:SPT < 113 and tA(doubles, N=10) < 2.5 and tA(errors, N=10) > .1 and .3 < oA(BPRA, N=10) < 2.6 and tA(BPRA, N=10) < 2.8

Wow those look great over large sample. Tanner Roark real hot right now but tough to go against those numbers. Thanks

[rutt723]

royals/angles over 30roi

(SG = 1 or SG = 4) and H and 10.5 > total > 7 and 12.6 > oA(hits, N=10) > 9.1 and 9.2 < tA(hits, N=10) < 12.6 and 12 > s:SHA > 4 and s:SRA != 0 and s:SPT > 83 and 119 > os:SPT > 69 and o:starter rest < 10 and 19 > p:hits > 4 and op:hits > 4 and oA(walks, N=10) < 4.7 and ss:SPT < 116 and oA(HR, N=10) < 1.8 and tA(HR, N=10) < 2 and p:HR < 4 and oA(errors, N=10) < 1.1 and tA(errors, N=10) > .1

looks good to me

[JMon]

rays in the first game of a double header, total and possible side

team=Rays and double header=1 and 2004<=season

cash it!

[Alex Vaile]

rays in the first game of a double header, total and possible side

team=Rays and double header=1 and 2004<=season

Winner on under. Thanks JMon

[Alex Vaile]

(SG = 1 or SG = 4) and H and 10.5 > total > 7 and 12.6 > oA(hits, N=10) > 9.1 and 9.2 < tA(hits, N=10) < 12.6 and 12 > s:SHA > 4 and s:SRA != 0 and s:SPT > 83 and 119 > os:SPT > 69 and o:starter rest < 10 and 19 > p:hits > 4 and op:hits > 4 and oA(walks, N=10) < 4.7 and ss:SPT < 116 and oA(HR, N=10) < 1.8 and tA(HR, N=10) < 2 and p:HR < 4 and oA(errors, N=10) < 1.1 and tA(errors, N=10) > .1

looks good to me

I second that opinion. Over it is!

[JMon]

I second that opinion. Over it is!

I'll play it with you guys!

[alldaykjp]

liking this thread

[Alex Vaile]

Here s another play over 30%:

tA(BPRA) < oA(BPRA) and SG = 2 and s:SRA < 5 and 8 > ss:SRA > 0 and (s:SHA + s:SWA) < 12 and os:SHRA > 0 and oss:SHRA < 2 and (game number < 41 or 87 > game number > 61 or 103 > game number > 90 or game number > 130) and op:HR < 4 and op:hits < 14 and p:margin > -7 and -10 < pp:margin < 9 and -10 < opp:margin < 9 and streak > -4 and tA(hits, N=10) > 8.1 and oA(runs, N=10) < 5.3 and -243 < line < 165 and s:SPT > 76 and os:SPT > 66 and SGS < 5 and oA(doubles, N=10) < 2.6 and tA(errors, N=10) < 1.2

SU: 323-117 (1.72, 73.4%) avg line: -132.3 / 119.5 on / against: +$18,758 / -$20,476 ROI: +31.0% / -43.1%
RL: 201-122 (1.19, 62.2%) avg line: 104.1 / -117.7 on / against: +$10,967 / -$12,802 ROI: +27.9% / -29.5%


Second and third posted plays for today 6/27:
Milwaukee Brewers - 205 to win 1
Brewers run line - 105 to win 1

So many good queries today. Hate the high price but Brewers hot!

[Alex Vaile]

I'll play it with you guys!

It's more fun when we re in it together. This is the only thread I've seen where people are happy and positive. I like that.

[JMon]

liking this thread

It's more fun when we re in it together. This is the only thread I've seen where people are happy and positive. I like that.

I agree.

[otunj]

It's more fun when we re in it together. This is the only thread I've seen where people are happy and positive. I like that.

f*ck off...you walked into that one

[otunj]

season >= 2011 and conference = AL and o:conference = NL and AF and 10 > total >= 7

OU 5-10-1 (-0.97, 33.3%) in 2014

Overall:

78-57 (0.82, 57.8%)	avg line: -131.2 / 120.8	on / against: +$527 / -$1,102	ROI: +3.0% / -8.2%
61-74 (-0.68, 45.2%)	avg line: 130.1 / -141.2	on / against: +$487 / -$1,160	ROI: +3.6% / -6.1%
47-81-7 (-0.53, 36.7%)	avg total: 7.9	over / under: -$4,125 / +$2,820	ROI: -28.1% / +18.8%

[b1slickguy]

It's more fun when we re in it together. This is the only thread I've seen where people are happy and positive. I like that.

^^^THIS^^^
Great work everyone. Best vibe on the forum IMO.
Good luck.

[otunj]

Cubs SU

streak = 1 and SG = 2 and s:earned runs < 9 and s:SHA < 10 and ss:SHA < 12 and 0 < os:SRA < 7 and 63 < s:SPT < 117 and 9.76 > oA(hits, N=4) > 5.76 and 5.0 > oA(walks, N=10) > 2.1 and o:streak > -7 and 2.2 < oA(runs, N=7) < 5.99 and 18 > p:hits > 3 and line > -225 and 1.7 > oA(HR, N=10) > .5 and tA(HR, N=10) > .3 and 2.6 > oA(doubles, N=10) > 1.05 and op:walks != 0 and STDSWHIP > .95 and o:STDSWHIP < 1.8 and ou streak > -6 and ou streak < 4 and p:rest < 3 and (STDSERA < 1.58 or STDSERA > 2.71) and (85 > game number > 11 or game number > 101)

s:SRA < 2 and 5 > ss:SRA > 0 and sss:SRA < 4 and ssss:SRA < 6 and 0 < sssss:SRA < 8 and os:SRA < 5 and SG < 4 and day != Tuesday and day != Thursday and 4 < starter rest < 10 and o:starter rest < 11 and 161 > game number > 27 and line > -165 and 2 > p:margin > -9 and 11.2 > tA(hits, N=10) > 6.7 and 6.2 < oA(hits, N=10) < 11.3 and STDSWHIP > .948 and ss:SPT > 67 and 40 < oss:SPT < 113 and tA(doubles, N=10) < 2.5 and tA(errors, N=10) > .1 and .3 < oA(BPRA, N=10) < 2.6 and tA(BPRA, N=10) < 2.8

[Alex Vaile]

Nice win. 2 and 0 so far! Thanks for posting. I got on it live at +140.

[otunj]

Nice win. 2 and 0 so far! Thanks for posting. I got on it live at +140.

My guess when they were down 0-1?

[Alex Vaile]

f*ck off...you walked into that one

Ha right. 8) good work everyone! Keep it rolling

[Alex Vaile]

My guess when they were down 0-1?

Yup got it right after that. I had missed opening pitch and waited. What a game!

[JMon]

Infante grand slam. KC over ..winner in the third.