MLB - Situation Plays - SDQL

Alex Vaile · 08-09-14, 11:12 AM

First posted plays for Sat: (Bases)

Yankees - 102
Astros + 150

H and -8 > (starter wins - starter losses + o:starter losses - o:starter wins) > -14 and day != Wednesday and day != Thursday and day != Friday and 6 > s:SRA

Alex Vaile · 08-09-14, 11:15 AM

Third Fourth posted plays: (JMon)

White Sox +162
White Sox RL -140
season >= 2014 and A and (-105 <= line <= 185) and p:AL and pp:AL and op:W and opp:W and SG=3 and o:WP>50 and WP<50

Alex Vaile · 08-10-14, 12:56 AM

3 and 1 today for + 3.08 units
68 and 59 overall
+ 4.41 units

JMon · 08-10-14, 09:05 AM

ref post #750

Situation A: Fade a Sunday NL Getaway team

2014 tracking results on the fade: 21-34 (38.2%) (+812)

Last week (+110)

Fading (play against):

Rockies
Padres
Marlins
Giants

JMon · 08-10-14, 09:11 AM

ref post #750

Situation B: Sunday Under Getaway

2014 tracking results over-under-push: 25-30-3 (+240)

Last week: (+60)

Play Under:

Rangers
Rockies
Padres
Giants

Alex Vaile · 08-10-14, 10:13 AM

First posted play for Sunday:
(Bases) supporting JMon's getaway under.

Under 7 -120
Marlins vs Reds

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)

Alex Vaile · 08-10-14, 10:21 AM

Second posted play: (Dr.M one day I didnt post him he had pads yesterday)
Juicy but good results

Cincinnati Reds -205
Reds RL + 105
Starter=Johnny Cueto and H and p:LF and SG>1 and season>=2012

JMon · 08-10-14, 10:29 AM

Here we go with the database lag again...

JMon · 08-10-14, 10:56 AM

Originally posted by Alex Vaile

Second posted play: (Dr.M one day I didnt post him he had pads yesterday)
Juicy but good results

Cincinnati Reds -205
Reds RL + 105
Starter=Johnny Cueto and H and p:LF and SG>1 and season>=2012

addition support. Cueto vs. a team that strikes out 7+ a game as a fav of 140 or more.

SDQL is

starter=Johnny Cueto and line<=-140 and oA(strike outs)>=7 and 20110731<=date

Alex Vaile · 08-10-14, 10:57 AM

Third posted play:
( Bases )

Under 8.5 -115 Texas vs Houston

H and -7 < ou streak < 2 and -6 < ou streak < 2 and SG < 4 and 5 > SGS > 2 and 11.5 > total > 6 and p:hits < 18 and op:hits < 17 and pp:hits < 18 and 3 < ppp:hits < 17 and pppp:hits < 16 and ppppp:hits < 15 and pppppp:hits > 2 and opp:hits < 15 and s:SRA < 5 and 0 < os:SRA < 10 and 2 < s:SHA < 10 and s:SHRA < 2 and os:SHRA < 3 and os:SWA < 7 and s:SSO > 3 and s:SHF < 33 and 16 < os:SHF < 34 and 73 < os:SPT < 110 and 76 < s:SPT < 117 and starter rest < 13 and o:starter rest < 11 and day != Monday and -22.5 < tS(ou margin, N=6) < 10.5 and -15 < oS(ou margin, N=6) < 18.5 and ss:SRA < 6 and ss:SHA > 2 and ss:SSO > 1 and ss:SHF > 19 and oss:SHF < 32 and 4 < s:starter rest < 9 and os:starter rest < 22 and game number < 154 and tS(O, N=10) < 7 and 23 < tS(runs, N=10) < 63 and 36 < tS(hits, N=6) < 65 and 1 < oS(errors, N=10) < 10

Alex Vaile · 08-10-14, 10:59 AM

Here u go JMon and emceeaye: good piece of info to put into sdql. I tried with one yesterday and it hit but I couldn't sdql it properly.
•Play On - All favorites with a money line of -150 or more (SEATTLE) - poor hitting team (AVG <=.260) against an average starting pitcher (ERA=4.70 to 5.70) - American League, with an on base percentage of .310 or worse over their last 20 games.
(39-3 since 1997.)

Alex Vaile · 08-10-14, 11:03 AM

Why is Price more expensive than Kershaw? Strange line for dodgers he should b -180 at least he owns a .82 ERA at Miller Park.

JMon · 08-10-14, 11:07 AM

In support of the getaway fade, since 2013 the rockies are 1-13 (3-8 RL) when trying to avoid a three games sweep on the road.

SDQL is

A and p:L and pp:L and SG = SGS = SG = 3 and team = Rockies and 2013<=season

emceeaye · 08-10-14, 11:15 AM

Originally posted by Alex Vaile

Here u go JMon and emceeaye: good piece of info to put into sdql. I tried with one yesterday and it hit but I couldn't sdql it properly.
•Play On - All favorites with a money line of -150 or more (SEATTLE) - poor hitting team (AVG <=.260) against an average starting pitcher (ERA=4.70 to 5.70) - American League, with an on base percentage of .310 or worse over their last 20 games.
(39-3 since 1997.)

less than -150 (e.g., -160) or more than -150 (e.g., -140)?

JMon · 08-10-14, 11:17 AM

Originally posted by emceeaye

less than -150 (e.g., -160) or more than -150 (e.g., -140)?

line<=-150

I don't know how to work OBP

Alex Vaile · 08-10-14, 11:22 AM

Originally posted by JMon

line<=-150

I don't know how to work OBP

What's OBP?

JMon · 08-10-14, 11:23 AM

on base percentage

Alex Vaile · 08-10-14, 11:28 AM

Fourth play:

( Bases )

Brewers + 140 line fishy to me im going with it.

H and -8 > (starter wins - starter losses + o:starter losses - o:starter wins) > -14 and day != Wednesday and day != Thursday and day != Friday and 6 > s:SRA

emceeaye · 08-10-14, 11:51 AM

Originally posted by JMon

line<=-150

I don't know how to work OBP

I keep getting this error: "HTTP 599: Timeout" with the following query:

F and line<=-150 and Sum(hits)/Sum(at bats)<=.260 and 4.50< o:STDSERA < 5.40 and conference=AL and Sum((o:hits+o:walks) @ team and season, N=20)/ Sum(o:at bats@team and season, N=20)<=.310 and season>1997

This may be at least in part due to database technical difficulties and/or that my query is wrong.

Perhaps Tarrosil or Bases know how to correct the syntax when the database stops malfunctioning.

JMon · 08-10-14, 11:56 AM

play Yanks

SDQL

A and 300>line>=120 and sA(SHRA)<=.5 and o:conference=AL and o:STDSWHIP<=1.3 and SG<4 and rest=0 and month<9

JMon · 08-10-14, 12:08 PM

Play LAA/Bos un

SDQL, by bases

-5 < ou streak < 2 and SG = 3 and H and o: ou streak > -4 and tS(ou margin, N=10) < 11 and 6 < tS(O, N=20) < 11 and oS(total, N=10) > 81.5 and tS(total, N=10) > 76 and s:SHF > 20 and os:SHF > 13 and os:SPT > 73 and 76 < s:SPT < 117 and -3.5 < s: ou margin < 5.5 and os: ou margin < 4.5 and p:hits + pp:hits > 9 and op:hits + opp:hits < 27 and p:margin > -6 and p:RMAX < 6 and op:SII < 4 and pp:RMAX < 6 and opp:SII < 6

emceeaye · 08-10-14, 12:18 PM

I saw 3 queries supporting Braves/Nats under today

Bases queries that I'm having trouble locating however. I'll post as I find them.

update: here's one:
1 > (ou streak + ou streak) > -4 and 3 > ou streak > -3 and SG < 4 and 5 > SGS > 2 and day != Tuesday and day != Saturday and p:HR < 5 and pp:HR < 3 and p:hits < 13 and 4 < pp:hits < 18 and 7 < ppp:hits < 16 and 3 < pppp:hits < 18 and 2 < ppppp:hits < 13 and pppppp:hits < 19 and 2 < ppppppp:hits < 17 and ppp:HR < 3 and pppp:HR < 4 and ppppp:HR < 4 and op:HR < 5 and opp:HR < 5 and oppp:HR < 3 and opppp:HR < 4 and 3 < op:hits < 20 and opp:hits > 4 and 4 < oppp:hits < 16 and 4 < opppp:hits < 17 and oppppp:hits < 17 and 2 < opppppp:hits < 19 and 3 < oppppppp:hits < 12 and s:SHRA < 4 and s:SPT < 118 and os:SPT < 117 and starter rest < 22 and 10 > month > 5 and total < 11 and (tA(hits, N=10) + oA(hits, N=10)) > 15.5 and tA(HR, N=10) > .2 and tA(doubles, N=10) < 2.8

another:
tA(BPRA) < 1.35 and (SG = 2 or SG = 3) and SGS = 3 and -8 < (ou streak + ou streak) < 6 and op:HR < 4 and 12 > s:SHA > 2 and s:SSO < 8 and s:SHRA = 0 and 123 > s:SPT > 83 and ss:SHRA < 2 and 2 < ss:SHA < 11 and 8 > os:SRA > 0 and ((site = home and conference = NL and o:conference = NL) or (site = home and conference = AL and o:conference = AL) or (site = away and conference = AL and o:conference = AL)) and os:SHRA < 3 and os:SHA > 4 and os:SWA < 4 and s:SWA < 5 and os:SPT < 118 and oss:SHRA != 2 and s:SIP > 4.5 and os:SSO < 10 and p:BPRA < 6 and op:BPRA < 5 and oA(hits,N=10) < 10.9

another:
H and s:SHRA + os:SHRA < 2 and 10 < s:SHA + os:SHA < 15 and 5 < os:SRA + s:SRA < 14 and playoffs = 0 and ((SG = 3 and SGS = 3) or (SG = 2 and SGS = 3) or (SG = 3 and SGS = 4) or (SG = 2 and SGS = 2)) and os:SHA < 11 and s:SHF < 34 and os:SHF < 34 and 5 < p:hits < 19 and op:hits > 1 and 6 < pp:hits < 14 and 4 < opp:hits < 13 and oppp:hits > 4 and op:HR < 4 and pu margin > -5.5 and starter rest < 12 and opp:runs < 9 and 3 < pp:runs + p:runs < 22 and game number > 13 and (game number < 78 or 102 > game number > 90 or game number > 114)

Alex Vaile · 08-10-14, 12:29 PM

Originally posted by JMon

on base percentage

O I got it now thanks.

Alex Vaile · 08-10-14, 12:31 PM

Originally posted by emceeaye

Bases queries that I'm having trouble locating however. I'll post as I find them.

update: here's one:
1 > (ou streak + ou streak) > -4 and 3 > ou streak > -3 and SG < 4 and 5 > SGS > 2 and day != Tuesday and day != Saturday and p:HR < 5 and pp:HR < 3 and p:hits < 13 and 4 < pp:hits < 18 and 7 < ppp:hits < 16 and 3 < pppp:hits < 18 and 2 < ppppp:hits < 13 and pppppp:hits < 19 and 2 < ppppppp:hits < 17 and ppp:HR < 3 and pppp:HR < 4 and ppppp:HR < 4 and op:HR < 5 and opp:HR < 5 and oppp:HR < 3 and opppp:HR < 4 and 3 < op:hits < 20 and opp:hits > 4 and 4 < oppp:hits < 16 and 4 < opppp:hits < 17 and oppppp:hits < 17 and 2 < opppppp:hits < 19 and 3 < oppppppp:hits < 12 and s:SHRA < 4 and s:SPT < 118 and os:SPT < 117 and starter rest < 22 and 10 > month > 5 and total < 11 and (tA(hits, N=10) + oA(hits, N=10)) > 15.5 and tA(HR, N=10) > .2 and tA(doubles, N=10) < 2.8

another:
tA(BPRA) < 1.35 and (SG = 2 or SG = 3) and SGS = 3 and -8 < (ou streak + ou streak) < 6 and op:HR < 4 and 12 > s:SHA > 2 and s:SSO < 8 and s:SHRA = 0 and 123 > s:SPT > 83 and ss:SHRA < 2 and 2 < ss:SHA < 11 and 8 > os:SRA > 0 and ((site = home and conference = NL and o:conference = NL) or (site = home and conference = AL and o:conference = AL) or (site = away and conference = AL and o:conference = AL)) and os:SHRA < 3 and os:SHA > 4 and os:SWA < 4 and s:SWA < 5 and os:SPT < 118 and oss:SHRA != 2 and s:SIP > 4.5 and os:SSO < 10 and p:BPRA < 6 and op:BPRA < 5 and oA(hits,N=10) < 10.9

another:
H and s:SHRA + os:SHRA < 2 and 10 < s:SHA + os:SHA < 15 and 5 < os:SRA + s:SRA < 14 and playoffs = 0 and ((SG = 3 and SGS = 3) or (SG = 2 and SGS = 3) or (SG = 3 and SGS = 4) or (SG = 2 and SGS = 2)) and os:SHA < 11 and s:SHF < 34 and os:SHF < 34 and 5 < p:hits < 19 and op:hits > 1 and 6 < pp:hits < 14 and 4 < opp:hits < 13 and oppp:hits > 4 and op:HR < 4 and pu margin > -5.5 and starter rest < 12 and opp:runs < 9 and 3 < pp:runs + p:runs < 22 and game number > 13 and (game number < 78 or 102 > game number > 90 or game number > 114)

Another in support: I posted it with the Houston under and left off wash game as Gonzalez has been terrible lately and sunday nite games always seem to screw me.

H and -7 < ou streak < 2 and -6 < ou streak < 2 and SG < 4 and 5 > SGS > 2 and 11.5 > total > 6 and p:hits < 18 and op:hits < 17 and pp:hits < 18 and 3 < ppp:hits < 17 and pppp:hits < 16 and ppppp:hits < 15 and pppppp:hits > 2 and opp:hits < 15 and s:SRA < 5 and 0 < os:SRA < 10 and 2 < s:SHA < 10 and s:SHRA < 2 and os:SHRA < 3 and os:SWA < 7 and s:SSO > 3 and s:SHF < 33 and 16 < os:SHF < 34 and 73 < os:SPT < 110 and 76 < s:SPT < 117 and starter rest < 13 and o:starter rest < 11 and day != Monday and -22.5 < tS(ou margin, N=6) < 10.5 and -15 < oS(ou margin, N=6) < 18.5 and ss:SRA < 6 and ss:SHA > 2 and ss:SSO > 1 and ss:SHF > 19 and oss:SHF < 32 and 4 < s:starter rest < 9 and os:starter rest < 22 and game number < 154 and tS(O, N=10) < 7 and 23 < tS(runs, N=10) < 63 and 36 < tS(hits, N=6) < 65 and 1 < oS(errors, N=10) < 10

Alex Vaile · 08-10-14, 12:40 PM

Originally posted by emceeaye

I keep getting this error: "HTTP 599: Timeout" with the following query:

F and line<=-150 and Sum(hits)/Sum(at bats)<=.260 and 4.50< o:STDSERA < 5.40 and conference=AL and Sum((o:hits+o:walks) @ team and season, N=20)/ Sum(o:at bats@team and season, N=20)<=.310 and season>1997

This may be at least in part due to database technical difficulties and/or that my query is wrong.

Perhaps Tarrosil or Bases know how to correct the syntax when the database stops malfunctioning.

Nice try on it. I used the same format you guys gave me last week but kept getting error too. Thanks. It seems to set up nicely for a query. Good luck today!

JMon · 08-10-14, 12:54 PM

Originally posted by emceeaye

I keep getting this error: "HTTP 599: Timeout" with the following query:

F and line<=-150 and Sum(hits)/Sum(at bats)<=.260 and 4.50< o:STDSERA < 5.40 and conference=AL and Sum((o:hits+o:walks) @ team and season, N=20)/ Sum(o:at bats@team and season, N=20)<=.310 and season>1997

This may be at least in part due to database technical difficulties and/or that my query is wrong.

Perhaps Tarrosil or Bases know how to correct the syntax when the database stops malfunctioning.

I think you had a problem with BA. Yet I am not getting the indicating results either. I am also assuming yoru OBP is correct.

Sum(hits@team and season)/Sum(at bats@team and season)<=.260 and line<=-150 and 5.70>= o:STDSERA >=4.70 and Sum((o:hits+o:walks) @ team and season, N=20)/ Sum(o:at bats@team and season, N=20)<=.310 and conference=AL

FYI: HTTP 599: timeout is the server timing out. One gets 20 seconds per query. If the database can not generate data within that time it will time out. Twenty seconds is generally enough time, but when a query has many averages (tA or tS) within; it may take extra time for the database to pull data, thus giving a timeout error. Once a member, I believe they can give one extra time if wanted, but I believe at a fee. You will need to email Joe, if interested.

Alex Vaile · 08-10-14, 01:10 PM

It worked when I switched first 5.7 to < as to me it meant starters era was less than 5.7 and more than 4.7 but only lists a 13 and 5 record and didnt highlight the seattle game. Fun to tinker with!
Sum(hits@team and season)/Sum(at bats@team and season)<=.260 and line<=-150 and 5.70<= o:STDSERA >=4.70 and Sum((o:hits+o:walks) @ team and season, N=20)/ Sum(o:at bats@team and season, N=20)<=.310 and conference=AL

JMon · 08-10-14, 01:21 PM

Originally posted by Alex Vaile

It worked when I switched first 5.7 to < as to me it meant starters era was less than 5.7 and more than 4.7 but only lists a 13 and 5 record and didnt highlight the seattle game. Fun to tinker with!
Sum(hits@team and season)/Sum(at bats@team and season)<=.260 and line<=-150 and 5.70<= o:STDSERA >=4.70 and Sum((o:hits+o:walks) @ team and season, N=20)/ Sum(o:at bats@team and season, N=20)<=.310 and conference=AL

5.70<= o:STDSERA would indicate greater than or equal too, you can see this by removing the >=4.70 and the results remain the same!

Alex Vaile · 08-10-14, 03:27 PM

I meant to post this earlier pointed to Rangers (already playing)and later
Fifth play:
Nationals + 112
(Bases)
H and -8 > (starter wins - starter losses + o:starter losses - o:starter wins) > -14 and day != Wednesday and day != Thursday and day != Friday and 6 > s:SRA

Alex Vaile · 08-10-14, 03:29 PM

Originally posted by JMon

5.70<= o:STDSERA would indicate greater than or equal too, you can see this by removing the >=4.70 and the results remain the same!

O ok thanks JMon. The greater than less than concept is more complex to me sometimes.

tarosill · 08-10-14, 05:05 PM

Originally posted by emceeaye

I keep getting this error: "HTTP 599: Timeout" with the following query:

F and line<=-150 and Sum(hits)/Sum(at bats)<=.260 and 4.50< o:STDSERA < 5.40 and conference=AL and Sum((o:hits+o:walks) @ team and season, N=20)/ Sum(o:at bats@team and season, N=20)<=.310 and season>1997

This may be at least in part due to database technical difficulties and/or that my query is wrong.

Perhaps Tarrosil or Bases know how to correct the syntax when the database stops malfunctioning.

I'm not sure about the original query, but this one looks good enough to me.

F and line <= -130 and s:SRA < 7 and 5 <= s:SIP < 9 and tS(hits) / tS(at bats) < 0.265 and 4.7 <= o:STDSERA <= 6.0 and oS(hits+walks, N=18) / oS(at bats, N=18) > 0.365 and conference = AL

Alex Vaile · 08-10-14, 06:13 PM

Originally posted by tarosill

I'm not sure about the original query, but this one looks good enough to me.

F and line <= -130 and s:SRA < 7 and 5 <= s:SIP < 9 and tS(hits) / tS(at bats) < 0.265 and 4.7 <= o:STDSERA <= 6.0 and oS(hits+walks, N=18) / oS(at bats, N=18) > 0.365 and conference = AL

Nice adjustment Tarosill. Ill use that when I can.

JMon · 08-10-14, 06:26 PM

Alex you have mail

emceeaye · 08-10-14, 07:54 PM

Originally posted by tarosill

I'm not sure about the original query, but this one looks good enough to me.

F and line <= -130 and s:SRA < 7 and 5 <= s:SIP < 9 and tS(hits) / tS(at bats) < 0.265 and 4.7 <= o:STDSERA <= 6.0 and oS(hits+walks, N=18) / oS(at bats, N=18) > 0.365 and conference = AL

Nice one Tarosill!

tarosill · 08-11-14, 10:46 AM

Originally posted by tarosill

I'm not sure about the original query, but this one looks good enough to me.

F and line <= -130 and s:SRA < 7 and 5 <= s:SIP < 9 and tS(hits) / tS(at bats) < 0.265 and 4.7 <= o:STDSERA <= 6.0 and oS(hits+walks, N=18) / oS(at bats, N=18) > 0.365 and conference = AL

Here is another one similar to the previous query. These two, combined together make a nice set of complementary queries.

HF and line < -130 and tS(hits) / tS(at bats) < 0.25 and p:RMAX < 6 and o:STDSERA >= 4.8 and 1 < os:SIP < 9 and o:starter rest < 8 and 0.21 < tS(o:hits, N=18) / tS(o:at bats, N=18) < 0.26 and conference = AL