MLB - Situation Plays - SDQL

[JMon]

Play COL ml/rl

SDQL by Slicker

A and total>7 and p:SII>=4 and p:hits>12 and WP<50 and season=2014 and pp:SII<4

[JMon]

Play Lastros

Warning not a big sample

SDQL

-200<=line<-155 and 5.2>=tA(runs)>=4.7 and 4.7>=o:STDSERA>=4.2 and o:conference=AL and po:runs>=8 and month>6

[mdunlap3]

Sorry JMON, wasn't aware. Done.

[JMon]

Sorry JMON, wasn't aware. Done.

no problem, thanks. Few of us have a lot of time in this thread, hate to see something happen to it.

[Alex Vaile]

Second and third play: ( Dr.M )

Giants -182
Giants RL +110

team=Rockies and A and line >= 145 and o:streak<=-2 and SG<3 and C and date>=20040801
team=Giants and line<=-140 and p:margin <=-5 and SG=1 and rest=0

[staf]

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

Look at the profits

[emceeaye]

keep going with this into September?

Jmon,
What has your experience been running queries and making wagers based on them for MLB into September? I ask, because I'd like to do so, but if some factors are introduced in September (e.g., roster expansions) that can detrimentally impact the outcomes, then I'll sit it out. It would be good to get your thoughts.

Thanks in advance.

[Alex Vaile]

Play COL ml/rl

SDQL by Slicker

A and total>7 and p:SII>=4 and p:hits>12 and WP<50 and season=2014 and pp:SII<4

I knew the Giants would lose no way Peavy should b favored that high. Nice one guys. Obviously I followed Dr.M with my post but knew mine would b a loser.

[Alex Vaile]

1 and 2 for -1.58 units.
I'll never back Peavy again even though he pitched relatively well and the Umpire was horrible calling balls and strikes. Really bad!
102 and 80 overall
+ 15.7 units

[emceeaye]

bad day yesterday

It was one of those days when many of the games' results went against the SDQL...It may be that factors such as hunger for making playoffs operated, and the SDQL query did not accommodate it (e.g., Marlins, Brewers)...

Hoping for a better SDQL day today!

[staf]

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

This is the reason why I'm suggesting we start a google group, so we can post links.

[JMon]

Jmon,
What has your experience been running queries and making wagers based on them for MLB into September? I ask, because I'd like to do so, but if some factors are introduced in September (e.g., roster expansions) that can detrimentally impact the outcomes, then I'll sit it out. It would be good to get your thoughts.

Thanks in advance.

Not so much last year, but months=9 and 10 have been my favorite months to bet on using SDQL. Look for dogs in these months!

[JMon]

This is the reason why I'm suggesting we start a google group, so we can post links.

Not sure what you are asking. There is already a google group for SDQL. We use SBR to post and share queries and help each other out through those queries.

[staf]

Not sure what you are asking. There is already a google group for SDQL. We use SBR to post and share queries and help each other out through those queries.

We can't post links here on SBR. We're having problems with the SDQL you guy's are posting here, because it's being corrupted in some way. Posting links in a google group would make it possible to share the SDQL in an uncorrupted form.

[staf]

3-1 +1.81 units yesterday
16-8 +8.19 units overall

SU: 699-497 (0.65, 58.4%) avg line: -116.9 / 103.4 on / against: +$16,591 / -$22,714 ROI: +10.6% / -15.9%
Baltimore Orioles -103
Detroit Tigers -120

SU: 459-406 (0.22, 53.1%) avg line: 119.1 / -130.0 on / against: +$13,648 / -$18,354 ROI: +15.5% / -16.3%
Cleveland Indians +112

RL: 589-719 (-0.25, 45.0%) on / against: -$23,688 / +$16,224 ROI: -13.7% / +9.9%
Philadelphia Phillies +1.5 -185 this is still good if it moves to -1.5

SU: 1263-1486 (-0.24, 45.9%) avg line: -108.7 / -104.0 on / against: -$37,481 / +$23,208 ROI: -11.0% / +6.9%
Los Angeles Angels -171

SU: 796-871 (-0.13, 47.8%) avg line: -124.5 / 111.4 on / against: -$26,301 / +$17,273 ROI: -11.7% / +9.0%
Washington Nationals -103
Colorado Rockies +198

For what it's worth I've started a google group called SBR SDQL. Check the post I made as an example of what I'm suggesting.

[hyahya]

3-1 +1.81 units yesterday
16-8 +8.19 units overall

SU: 699-497 (0.65, 58.4%) avg line: -116.9 / 103.4 on / against: +$16,591 / -$22,714 ROI: +10.6% / -15.9%
Baltimore Orioles -103
Detroit Tigers -120

SU: 459-406 (0.22, 53.1%) avg line: 119.1 / -130.0 on / against: +$13,648 / -$18,354 ROI: +15.5% / -16.3%
Cleveland Indians +112

RL: 589-719 (-0.25, 45.0%) on / against: -$23,688 / +$16,224 ROI: -13.7% / +9.9%
Philadelphia Phillies +1.5 -185 this is still good if it moves to -1.5

SU: 1263-1486 (-0.24, 45.9%) avg line: -108.7 / -104.0 on / against: -$37,481 / +$23,208 ROI: -11.0% / +6.9%
Los Angeles Angels -171

SU: 796-871 (-0.13, 47.8%) avg line: -124.5 / 111.4 on / against: -$26,301 / +$17,273 ROI: -11.7% / +9.0%
Washington Nationals -103
Colorado Rockies +198

For what it's worth I've started a google group called SBR SDQL. Check the post I made as an example of what I'm suggesting.

Searched for "SBR SDQL" in Google Groups but nothing relevant comes up.

[emceeaye]

Site down again...bummer

[staf]

Site down again...bummer

The group should show in a search now. Had to list it in the directory to make it show in a search.

[JMon]

We can't post links here on SBR. We're having problems with the SDQL you guy's are posting here, because it's being corrupted in some way. Posting links in a google group would make it possible to share the SDQL in an uncorrupted form.

Share SDQL indeed. That's what this thread is about. Will you be sharing your queries in your new group?

[emceeaye]

The group should show in a search now. Had to list it in the directory to make it show in a search.

I was referring to the site you run queries on. But sounds like a good group you're starting.

[staf]

I was referring to the site you run queries on. But sounds like a good group you're starting.

I was responding to hyahya. Must have hit the wrong button.

[hyahya]

Anybody hear anything from site admins?

[mdunlap3]

Staf you're backing the Phils RL but the nats SU?

[emceeaye]

Anybody hear anything from site admins?

I emailed them too and haven't heard back.

[staf]

Staf you're backing the Phils RL but the nats SU?

That's correct.

[staf]

Share SDQL indeed. That's what this thread is about. Will you be sharing your queries in your new group?

If you post an SDQL that doesn't work, are you really sharing anything?

[emceeaye]

If you post an SDQL that doesn't work, are you really sharing anything?

What query or queries were you having trouble with? Maybe we can help you to correct them.

[staf]

What query or queries were you having trouble with? Maybe we can help you to correct them.

This one's been giving me a "returned no results" message at KS and acts like there's a typo at SDB.
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]

This one's been giving me a "returned no results" message at KS and acts like there's a typo at SDB.
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

When this query was posted originally and another time recently in this thread, instructions were given on how to correct it. You should look back at previous posts to get that information.

Remove all "op:inning runs" and that should take care of it.

Are the sites up and running for you?

[hyahya]

When this query was posted originally and another time recently in this thread, instructions were given on how to correct it. You should look back at previous posts to get that information.

Remove all "op:inning runs" and that should take care of it.

Are the sites up and running for you?

Nope.

[JMon]

If you post an SDQL that doesn't work, are you really sharing anything?

lol, are you referring a few out of hundreds posted here that are fully functional. By posting plays without allowing others to see the sdql behind it, are you really sharing anything?

[staf]

Here's the cleaned up SDQL (hopefully). It appears to only work at KS. I'll post a link in the google group.

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:R1 < 5 and op:R2 < 4 and 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]

lol, are you referring a few out of hundreds posted here that are fully functional. By posting plays without allowing others to see the sdql behind it, are you really sharing anything?

I agree with this. Unfortunately, I'm unable to benefit from the results of a query I can't even see.

[emceeaye]

Here's the cleaned up SDQL (hopefully). It appears to only work at KS. I'll post a link in the google group.

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

So you were just today able to enter it and get it to work??
Interesting, I have been trying all day and it hasn't worked for me. I'm guessing that Hyahya has had the same experience.

[hyahya]

Frustrating to say the least. Site seemed to load on my phone earlier while I was at lunch but now that I'm back at my desk it's back down.