MLB - Situation Plays - SDQL

[JMon]

Everything is timing out now???? Working fine this morning. Had some queries to post for STL, DET, Tor and Oak un..

[Alex Vaile]

Second/Third plays: ( Dr.M )

Giants + 150
Giants RL -150

starter=Stephen Strasburg and o:WP>=50 and date>=20140614

Small sample but Strasburg 0 and 6 in this spot this season last 6 starts.

[Alex Vaile]

Play Lad

SDQL by base. Extra support with Mets in getaway spot (0-3 this year).

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 and SG != 4 and conference = o:conference and total > 6.5

I see this game points to Yankees also. What do u think about it? Sale not great as road fav and I know you mentioned how Yanks do at home on weekends.

[JMon]

I see this game points to Yankees also. What do u think about it? Sale not great as road fav and I know you mentioned how Yanks do at home on weekends.

I found no other reason to take the Yank, other than that query..so just not enough for me to play..not saying they won't win...but as my good friend, slicker says, Yanks are my kryptonite....LOL

[JMon]

Second/Third plays: ( Dr.M )

Giants + 150
Giants RL -150

starter=Stephen Strasburg and o:WP>=50 and date>=20140614

Small sample but Strasburg 0 and 6 in this spot this season last 6 starts.

Had a reason to play SF too, but everything is timing out on my end so I can't give you the SDQL, but I'm on them.

[Alex Vaile]

I found no other reason to take the Yank, other than that query..so just not enough for me to play..not saying they won't win...but as my good friend, slicker says, Yanks are my kryptonite....LOL

Ya. I was trying to get a query going for Sale and Capuano but timed out. Maybe it'll come back soon. Weird stuff happening at this site. Thanks and good luck!

[Alex Vaile]

Its working on and off

[Alex Vaile]

This query is only 8 and 11 in August but points to Angels and Mets with an 18% ROI and over 1500 games

Fourth and fifth plays:

Angels + 118
Mets + 110

AD and (SG = 1 or SG = 3) and playoffs = 0 and streak > -4 and -8 < o:streak < 6 and -7 < p:margin < 10 and -10 < op:margin < 9 and p:runs < 13 and op:runs != 0 and p:hits > 1 and 3 < op:hits < 15 and op:doubles < 6 and p:triples < 3 and op:triples < 2 and p:SO > 3 and 2 < op:SO < 17 and 3 < p:ground balls < 21 and 2 < op:ground balls < 24 and p:fly balls < 16 and 2 < op:fly balls < 16 and op:BPRA < 9 and 1.5 < p:SIP < 8.1 and 1.9 < op:SIP < 8.5 and 33 < p:SPT < 116 and 48 < op:SPT < 111 and op:SHF < 34 and 27 < p:batters faced < 46 and 28 < op:batters faced < 57 and p:at bats + p:walks < 48 and op:at bats + op:walks < 46 and 0 < p:TLOB < 12 and 0 < op:TLOB < 13 and (14 > site streak > 5 or -1 > site streak > -12) and (1 < o:site streak < 10 or -11 < o:site streak < -5) and (conference = AL or o:conference = NL) and op:RMAX < 8 and op:inning runs op:R1 < 5 and op:inning runs op:R2 < 4 and op:inning runs op:R3 < 3 and p:errors < 3 and op:errors < 4 and os:SHA < 12 and os:SRA < 7 and 0 < os:SWA < 5 and s:SPT > 83 and starter rest < 12 and s:SIP > 4.9

[Alex Vaile]

6th play: ( Bases or JMon )

Under 8 - 110 Orioles vs Cubs

H and 9.5 > total > 7.5 and SG = 3 and SGS < 6 and playoffs = 0 and 73 < os:SPT < 109 and o:starter rest > 6 and month != 6 and 2 < p:hits < 16 and 1 < tA(doubles, N=10) < 2.3

ROI% 35 over 200 games

[staf]

This query is only 8 and 11 in August but points to Angels and Mets with an 18% ROI and over 1500 games

AD and (SG = 1 or SG = 3) and playoffs = 0 and streak > -4 and -8 < o:streak < 6 and -7 < p:margin < 10 and -10 < op:margin < 9 and p:runs < 13 and op:runs != 0 and p:hits > 1 and 3 < op:hits < 15 and op:doubles < 6 and p:triples < 3 and op:triples < 2 and p:SO > 3 and 2 < op:SO < 17 and 3 < p:ground balls < 21 and 2 < op:ground balls < 24 and p:fly balls < 16 and 2 < op:fly balls < 16 and op:BPRA < 9 and 1.5 < p:SIP < 8.1 and 1.9 < op:SIP < 8.5 and 33 < p:SPT < 116 and 48 < op:SPT < 111 and op:SHF < 34 and 27 < p:batters faced < 46 and 28 < op:batters faced < 57 and p:at bats + p:walks < 48 and op:at bats + op:walks < 46 and 0 < p:TLOB < 12 and 0 < op:TLOB < 13 and (14 > site streak > 5 or -1 > site streak > -12) and (1 < o:site streak < 10 or -11 < o:site streak < -5) and (conference = AL or o:conference = NL) and op:RMAX < 8 and op:inning runs op:R1 < 5 and op:inning runs op:R2 < 4 and op:inning runs op:R3 < 3 and p:errors < 3 and op:errors < 4 and os:SHA < 12 and os:SRA < 7 and 0 < os:SWA < 5 and s:SPT > 83 and starter rest < 12 and s:SIP > 4.9

KS is giving me a "returned no results" message.
Anybody else having this problem?

[staf]

3-2 +0.88 units yesterday
9-5 +4.3 units overall

SU: 869-795 52.2% +$17,160 ROI:+9.0%
Baltimore Orioles -110

RL: 717-589 54.9% +$15,912 ROI:+9.7%
Washington Nationals -1.5 +118
Colorado Rockies +1.5 -155

SU: 1484-1263 54% +$23,008 ROI:+6.9%
Milwaukee Brewers -138

SU: 459-405 53.1% +$13,748 ROI: +15.6%
Toronto Blue Jays +109

adding
SU: 869-795 52.2% +$17,160 ROI:+9.0%
Colorado Rockies -107

[JMon]

Where is emc today.. The guy is leading the Aug. MLB contest, I'm 7th... SDQL guys taking advantage of SBR

[Alex Vaile]

KS is giving me a "returned no results" message.
Anybody else having this problem?

Not sure why it's not working but here is the info on the above mentioned query.

SU: 729-716 (0.12, 50.4%) avg line: 137.2 / -150.3 on / against: +$27,176 / -$36,617 ROI: +18.8% / -16.9%
RL: 708-391 (1.47, 64.4%) avg line: -161.2 / 147.0 on / against: +$9,024 / -$14,434 ROI: +5.1% / -12.9%
OU: 676-688-80 (0.38, 49.6%) avg total: 8.5 over / under: -$7,180 / -$5,625 ROI: -4.6% / -3.5%

[emceeaye]

Everything is timing out now???? Working fine this morning. Had some queries to post for STL, DET, Tor and Oak un..

I more or less gave up on trying to run queries after getting through about 1/5 of them that produced results, but its nice to see some of my picks supported by other queries in here.

As under: I found 3 or 4 queries in only the few that I ran supporting this.

Angels SU: found 2 queries supporting this one as well.

Dodgers/mets under: I found several supporting this as well

Unfortunately, not having luck successfully rerunning them in order to show results, because its timing out every time

Good luck!

[JMon]

I more or less gave up on trying to run queries after getting through about 1/5 of them that produced results, but its nice to see some of my picks supported by other queries in here.

As under: I found 3 or 4 queries in only the few that I ran supporting this.

Angels SU: found 2 queries supporting this one as well.

Dodgers/mets under: I found several supporting this as well

Unfortunately, not having luck successfully rerunning them in order to show results, because its timing out every time

Good luck!

Frustrating to say the least. I think it's a server overload and crashed. Too many catching on. I remember 4 years ago...it was nothing but fast.

If I were you, I would set on that lead in the contest. You already have the minimum picks and with a week left I would make people catch you! Just my opinion of course...bol bud.

[Alex Vaile]

This query is only 8 and 11 in August but points to Angels and Mets with an 18% ROI and over 1500 games

AD and (SG = 1 or SG = 3) and playoffs = 0 and streak > -4 and -8 < o:streak < 6 and -7 < p:margin < 10 and -10 < op:margin < 9 and p:runs < 13 and op:runs != 0 and p:hits > 1 and 3 < op:hits < 15 and op:doubles < 6 and p:triples < 3 and op:triples < 2 and p:SO > 3 and 2 < op:SO < 17 and 3 < p:ground balls < 21 and 2 < op:ground balls < 24 and p:fly balls < 16 and 2 < op:fly balls < 16 and op:BPRA < 9 and 1.5 < p:SIP < 8.1 and 1.9 < op:SIP < 8.5 and 33 < p:SPT < 116 and 48 < op:SPT < 111 and op:SHF < 34 and 27 < p:batters faced < 46 and 28 < op:batters faced < 57 and p:at bats + p:walks < 48 and op:at bats + op:walks < 46 and 0 < p:TLOB < 12 and 0 < op:TLOB < 13 and (14 > site streak > 5 or -1 > site streak > -12) and (1 < o:site streak < 10 or -11 < o:site streak < -5) and (conference = AL or o:conference = NL) and op:RMAX < 8 and op:inning runs op:R1 < 5 and op:inning runs op:R2 < 4 and op:inning runs op:R3 < 3 and p:errors < 3 and op:errors < 4 and os:SHA < 12 and os:SRA < 7 and 0 < os:SWA < 5 and s:SPT > 83 and starter rest < 12 and s:SIP > 4.9

Good day for this query!

[emceeaye]

Frustrating to say the least. I think it's a server overload and crashed. Too many catching on. I remember 4 years ago...it was nothing but fast.

If I were you, I would set on that lead in the contest. You already have the minimum picks and with a week left I would make people catch you! Just my opinion of course...bol bud.

Hmm....I like that idea, Jmon. No need to risk more than I need to and protect the lead.

Thank you for the support!

I'm hoping that database gets less taxed tomorrow, so we can get through our queries. That makes sense that it has become more popular, and that being the reason why it's been slower. Its a bummer!

[Alex Vaile]

3 and 3 for -.37 units
101 and 78 overall
+17.28 units
Giants looked good until giving up 12 runs in last 3 innings. Wow.

[staf]

4-2 +2.08 units yesterday
13-7 +6.38 units overall

SU: 699-496 58.5% +$16,749 ROI: +10.7%
Los Angeles Angels -150

SU: 1263-1485 (-0.24, 46.0%) on / against: -$37,381 / +$23,108 ROI: -10.9% / +6.9%
Milwaukee Brewers -126

SU: 796-870 (-0.13, 47.8%) on / against: -$26,166 / +$17,148 ROI: -11.6% / +8.9%
St. Louis Cardinals +131

Will probably have a run line play, waiting on line movement.

[staf]

What does everybody think of starting a google group so we would have a place that we could post links?

[staf]

4-2 +2.08 units yesterday
13-7 +6.38 units overall

SU: 699-496 58.5% +$16,749 ROI: +10.7%
Los Angeles Angels -150

SU: 1263-1485 (-0.24, 46.0%) on / against: -$37,381 / +$23,108 ROI: -10.9% / +6.9%
Milwaukee Brewers -126

SU: 796-870 (-0.13, 47.8%) on / against: -$26,166 / +$17,148 ROI: -11.6% / +8.9%
St. Louis Cardinals +131

adding
RL: 589-719 (-0.25, 45.0%) on / against: -$23,688 / +$16,224 ROI: -13.7% / +9.9%
St. Louis Cardinals +1.5 -185

[Alex Vaile]

First play : ( Bases )

Yankees + 124

AD and (SG = 1 or SG = 3) and playoffs = 0 and streak > -4 and -8 < o:streak < 6 and -7 < p:margin < 10 and -10 < op:margin < 9 and p:runs < 13 and op:runs != 0 and p:hits > 1 and 3 < op:hits < 15 and op:doubles < 6 and p:triples < 3 and op:triples < 2 and p:SO > 3 and 2 < op:SO < 17 and 3 < p:ground balls < 21 and 2 < op:ground balls < 24 and p:fly balls < 16 and 2 < op:fly balls < 16 and op:BPRA < 9 and 1.5 < p:SIP < 8.1 and 1.9 < op:SIP < 8.5 and 33 < p:SPT < 116 and 48 < op:SPT < 111 and op:SHF < 34 and 27 < p:batters faced < 46 and 28 < op:batters faced < 57 and p:at bats + p:walks < 48 and op:at bats + op:walks < 46 and 0 < p:TLOB < 12 and 0 < op:TLOB < 13 and (14 > site streak > 5 or -1 > site streak > -12) and (1 < o:site streak < 10 or -11 < o:site streak < -5) and (conference = AL or o:conference = NL) and op:RMAX < 8 and op:inning runs op:R1 < 5 and op:inning runs op:R2 < 4 and op:inning runs op:R3 < 3 and p:errors < 3 and op:errors < 4 and os:SHA < 12 and os:SRA < 7 and 0 < os:SWA < 5 and s:SPT > 83 and starter rest < 12 and s:SIP > 4.9

[emceeaye]

Jmon or Bases query supporting Angels su

The record is good but this Leblanc guy seems pretty bad, and Cosart is pretty solid. Also, Marlins are dangerous. So I have reservations about making this play:

F and SG = 1 and season > 2006 and H and SGS = 3 and (day = Monday or day = Tuesday) and -3 < streak < 2 and -7 < o:streak < 5 and p:hits > 6 and 11 > p:runs > 3 and 0 < op:runs < 10 and total > 7.5

[staf]

The record is good but this Leblanc guy seems pretty bad, and Cosart is pretty solid. Also, Marlins are dangerous. So I have reservations about making this play:

F and SG = 1 and season > 2006 and H and SGS = 3 and (day = Monday or day = Tuesday) and -3 < streak < 2 and -7 < o:streak < 5 and p:hits > 6 and 11 > p:runs > 3 and 0 < op:runs < 10 and total > 7.5

Looks better for the RL

[mdunlap3]

What does everybody think of starting a google group so we would have a place that we could post links?

Love it so long as i can join it

[mdunlap3]

Per Jmon - This appears to have three plays today per the database, how do I know which side it is backing and/or which side of the total it is backing? Sorry..trying to learn :/

p:HR = 2 and ppp:HR = 2 and playoffs = 0 and SGS - SG != 1 and 2 < op:hits < 18 and opp:hits < 15 and oppp:hits < 17 and opppp:hits < 12 and oppppp:hits > 5 and os:SHRA < 3 and os:SRA < 7 and os:SSO != 0 and os:SPT > 58 and s:SSO > 2 and streak > -4 and -7 < o:streak < 4 and line < 135 and 2014=season

[staf]

Per Jmon - This appears to have three plays today per the database, how do I know which side it is backing and/or which side of the total it is backing? Sorry..trying to learn :/

p:HR = 2 and ppp:HR = 2 and playoffs = 0 and SGS - SG != 1 and 2 < op:hits < 18 and opp:hits < 15 and oppp:hits < 17 and opppp:hits < 12 and oppppp:hits > 5 and os:SHRA < 3 and os:SRA < 7 and os:SSO != 0 and os:SPT > 58 and s:SSO > 2 and streak > -4 and -7 < o:streak < 4 and line < 135 and 2014=season

The on / against in the results refer to the columns Team (on) / Opp (against) in the predictions.

[mdunlap3]

Yeah i don't see it :/....can you tell

[Alex Vaile]

Per Jmon - This appears to have three plays today per the database, how do I know which side it is backing and/or which side of the total it is backing? Sorry..trying to learn :/

p:HR = 2 and ppp:HR = 2 and playoffs = 0 and SGS - SG != 1 and 2 < op:hits < 18 and opp:hits < 15 and oppp:hits < 17 and opppp:hits < 12 and oppppp:hits > 5 and os:SHRA < 3 and os:SRA < 7 and os:SSO != 0 and os:SPT > 58 and s:SSO > 2 and streak > -4 and -7 < o:streak < 4 and line < 135 and 2014=season

This query indicates a play on the Astros Rockies and Cards.

[hyahya]

Keep getting "no results" when I run this as if there's a query grammar error. Haven't been able to spot it though.

[staf]

Yeah i don't see it :/....can you tell which..

Today's predictions will be at the bottom of the page, or if you click on the Date column it will sort to descending, bringing today's predictions to the top.

[emceeaye]

pirates su

This simple one from the DB looks interesting:

A and D and p:F and p:L and date>=20140801

[mdunlap3]

Yeah but how do you know if its a play on the home away team or o/u?

[JMon]

Yeah i don't see it :/....can you tell which..

mdunlap3 please do not post links in this thread. It is not allowed by SBR or mods, so please edit your post.

[JMon]

Play SD

SDQL

site==home and 145>line>=100 and tA(SSO)>=5 and tA(TLOB)<=6.9 and 2008<=season and SG<4 and team=Padres