MLB - Situation Plays - SDQL

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

Wow Rays down 5 to 0 first inning. So much for their pitcher being HOT at home. Ouch! Not looking good there

**JMon** · 08-03-14, 03:06 PM

Originally posted by Alex Vaile

Sounds good buddy, let's have a winning day!

Figures 2 runs bottom of the 9th....ugh hoping for a push

**Alex Vaile** · 08-03-14, 04:03 PM

Originally posted by JMon

Figures 2 runs bottom of the 9th....ugh hoping for a push

I know both my other plays got rocked too need push here (rays currently down). Did well in contest today after terrible day yesterday.

**JMon** · 08-03-14, 04:28 PM

Originally posted by Alex Vaile

I know both my other plays got rocked too need push here (rays currently down). Did well in contest today after terrible day yesterday.

lol..I thought you were going to play some management...21 plays in the first day?

**JMon** · 08-03-14, 04:30 PM

Originally posted by JMon

Play Nats

a whopping 41-3, but it has lost this year!!!!, caution

p:site=home and site=home and op:site=away and p:line<=-140 and line<=-140 and 0 < op: line and total<=8 and po:runs+5<=p:runs and op:runs+5 < opo : runs and 10<=p:hits and 5<=op:hits and op:runs<=2 and p:errors<=1 and op:errors<=1 and 2004<=season

should have hammered this one, but that loss this year had me on edge a bit

**JMon** · 08-03-14, 04:32 PM

shields

**Alex Vaile** · 08-03-14, 07:49 PM

0-2-1 today for -2.12 units
61 and 46 overall
+9.91 units

**Alex Vaile** · 08-03-14, 07:50 PM

Originally posted by JMon

should have hammered this one, but that loss this year had me on edge a bit

Ya I played it on my own and in both contests. Strasburg was due! I can't catch a break with posted plays last few days.

**Alex Vaile** · 08-03-14, 08:09 PM

Originally posted by JMon

lol..I thought you were going to play some management...21 plays in the first day?

Right what a first day ha. I think it was coming from the Runline contest where plays are fewer I just went for it. Not good on results. Today was a bit better. Man u were killing it first few days. Keep it up!

**emceeaye** · 08-04-14, 12:18 AM

Originally posted by JMon

You are probably right, I misunderstood the description and put the opponent as AL conference, whereas you put the querying team as AL .

Not sure--the description was unclear.

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

First posted play for Monday: From From Dr. M

Detroit Tigers -127
starter=Max Scherzer and os:W and oss:W and F and s:SIP<9 and date> 20110901
17 and 0 in this spot.

**Alex Vaile** · 08-04-14, 01:17 PM

Second posted play:
Courtesy of Bases query
Under 7 -105
Baltimore vs Washington

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)

**Meestermike** · 08-04-14, 05:29 PM

Originally posted by Alex Vaile

First posted play for Monday: From From Dr. M

Detroit Tigers -127
starter=Max Scherzer and os:W and oss:W and F and s:SIP<9 and date> 20110901
17 and 0 in this spot.

Have another which really goes against Scherzer
The Tigers are 6-15 since Jul 28, 2008 as a road favorite after a win at home

Within this query, Scherzer is 0-4 since June 04 2010

**Alex Vaile** · 08-04-14, 05:40 PM

Originally posted by Meestermike

Have another which really goes against Scherzer
The Tigers are 6-15 since Jul 28, 2008 as a road favorite after a win at home

Within this query, Scherzer is 0-4 since June 04 2010

Right on. Thanks for the info!

**Alex Vaile** · 08-05-14, 01:03 AM

Originally posted by Alex Vaile

Right on. Thanks for the info!

U called it Meestermike. Wasn't meant to be for Tigers who had many chances to blow game open.

**Alex Vaile** · 08-05-14, 01:06 AM

0 and 2 today -2.32 units. Can't buy a win lately.
61 and 48 overall
+ 7.59 units

**Alex Vaile** · 08-05-14, 01:50 AM

Originally posted by JMon

Play Nats

a whopping 41-3, but it has lost this year!!!!, caution

p:site=home and site=home and op:site=away and p:line<=-140 and line<=-140 and 0 < op: line and total<=8 and po:runs+5<=p:runs and op:runs+5 < opo : runs and 10<=p:hits and 5<=op:hits and op:runs<=2 and p:errors<=1 and op:errors<=1 and 2004<=season

JMon whats even more surprising you didn't play this game was that it was a Hammer play also. I just noticed on query page it was active yesterday. I normally check it out everyday. It was destined to be a winner!

**JMon** · 08-05-14, 07:48 AM

Originally posted by Alex Vaile

JMon whats even more surprising you didn't play this game was that it was a Hammer play also. I just noticed on query page it was active yesterday. I normally check it out everyday. It was destined to be a winner!

Not showing the Hammer play was active yesterday? Also the play isn't active in months July or Aug. Which one are you referring too?

**Alex Vaile** · 08-05-14, 11:05 AM

First posted play for Tuesday:

Miami Marlins + 135
Courtesy of Bases

so:inning runs so:R1 = 3 or so:inning runs so:R1 = 4) and SG != 2 and 5 > SGS > 1 and s:SRA < 10 and 3 < s:SHA < 10 and s:SWA < 5 and 6 > s:SSO > 1 and starter rest < 17 and s:SPT > 56 and os:SRA < 8 and s:SHRA < 4 and os:SHRA < 2 and os:SPT > 69 and o:starter rest < 18 and p:hits < 12 and 0 < ss:SSO < 12 and ss:SPT > 66 and -8 < os:margin < 6 and tA(hits,N=10) > 6.8 and oA(LOB, N=10) < 18.5 and 1.4 < oA(walks, N=10) < 4.8 and tA(walks, N=10) > 1.7

**Alex Vaile** · 08-05-14, 11:08 AM

Originally posted by JMon

Not showing the Hammer play was active yesterday? Also the play isn't active in months July or Aug. Which one are you referring too?

H and p:margin > 7 and op:runs = 0 and season > 2008 and WP < 60 and o:WP > 38.5 and rest = 0
O I didnt know it wasnt active in those months but it spit out that Nats game. Im over 500 in contest now ha. Good luck today buddy!

**Alex Vaile** · 08-05-14, 11:15 AM

Second posted play:

Under 7 -105
Mets vs Nationals

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)

**JMon** · 08-05-14, 03:36 PM

bases query

Milw under

H and -7 < ou streak < 2 and -6 < o: 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

**emceeaye** · 08-05-14, 04:25 PM

more support for Brewers under

Jmon's or Bases' query:

Sum(hits@team and season) / Sum(at bats@team and season) <= .255 and 9 * oS(o:earned runs - starter earned runs) / oS(9 - starter innings pitched) <= 3.33 and 8.5>=total>=8 and starter rest >= 7 and conference=o:conference and rest<4 and 2012<=season

**b1slickguy** · 08-05-14, 09:04 PM

The basis for this one is actually taken from an NFL sdql JMon shared with me 2 years ago. I have used similar in NBA, too. Sorry so late.
Good luck.

(HF or HD) and (po:team=Orioles or po:team=Rockies or po:team=Cubs) and p:AL and SG=1 and season>=2010

**Alex Vaile** · 08-05-14, 10:22 PM

Originally posted by emceeaye

Jmon's or Bases' query:

Sum(hits@team and season) / Sum(at bats@team and season) <= .255 and 9 * oS(o:earned runs - starter earned runs) / oS(9 - starter innings pitched) <= 3.33 and 8.5>=total>=8 and starter rest >= 7 and conference=o:conference and rest<4 and 2012<=season

winner today and active again tomorrow

**Alex Vaile** · 08-05-14, 10:26 PM

1-0-1 today for + 1.35 units
62 and 48 overall
+ 8.94 units

**JMon** · 08-06-14, 07:52 AM

Originally posted by b1slickguy

The basis for this one is actually taken from an NFL sdql JMon shared with me 2 years ago. I have used similar in NBA, too. Sorry so late.
Good luck.

(HF or HD) and (po:team=Orioles or po:team=Rockies or po:team=Cubs) and p:AL and SG=1 and season>=2010

nice one slicker

**JMon** · 08-06-14, 10:33 AM

geez..anyone else having major slow response time with the database?

**emceeaye** · 08-06-14, 10:41 AM

Originally posted by JMon

geez..anyone else having major slow response time with the database?

Yes me too! Horrible lag!

**JMon** · 08-06-14, 10:42 AM

Originally posted by emceeaye

Yes me too! Horrible lag!

Horrible, getting too popular and it's bogging down the server. Have you emailed anyone yet? I'm getting ready too. Will not be able to catch the early games at this rate.

**b1slickguy** · 08-06-14, 10:53 AM

Originally posted by JMon

geez..anyone else having major slow response time with the database?

Sportsdatabase lag not as bad as Killersports, but both are slow right now.
Good luck.

**JMon** · 08-06-14, 10:57 AM

Originally posted by b1slickguy

Sportsdatabase lag not as bad as Killersports, but both are slow right now.
Good luck.

doesn't help me any...lol with everything saved at KS

**b1slickguy** · 08-06-14, 11:22 AM

Originally posted by JMon

doesn't help me any...lol with everything saved at KS

LOL. Sorry, still using the "OPEN ALL TABS" method with my folders of bookmarks.
Good luck.

**Alex Vaile** · 08-06-14, 12:28 PM

First three plays: Courtesy of Bases

Under 7.5 +100 Royals vs Dbacks
Under 7 -115 Braves vs Mariners
Under 7 + 100 Mets vs Nationals

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)

**emceeaye** · 08-06-14, 12:28 PM

query on Baltimore SU and RL (by Jmon or Bases)

Solid one supporting hot Orioles:

-171 < line < 140 and SG=2 and - 12 < p:margin < -1 and -10 < pp:margin < -2 and op:runs > 7 and H and SGS < 4 and total < 11 and p:HR < 2 and op:HR < 4 and pp:runs < 6 and 2 < opp:runs < 12 and streak > -8 and site streak < 7