MLB - Situation Plays - SDQL

[emceeaye]

Conflicting query:

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

Limit query to SG=1 and month=9 and day=Monday and see what happens to RL

[JMon]

Fading DET today.
Good luck.

H and day=Monday and DIV and rest=0 and line>=-130 and p:start time>1900

ya had a play on the Royals too...didn't realize they started early...

[Alex Vaile]

Hi Alex.
I've been following this thread all season, and I've got to thank you guys for the work you all do. I've not had time to learn the SDQL language myself, so it's good to be able to copy and paste from here to KS.
I have a question re the conflicting query against the Nats above. To me this looks like an overly back-fitted query, with the specific numbers of fly balls/ground balls etc in the previous games of each team. Is this a fair comment, or do you have success with these types of queries? TIA for any replies.

Unfortunately I don't make any of the queries either Basesloaded and JMon are the creators of most. I just piggyback of their creations and see which ones are active for the day. Good luck

[Alex Vaile]

3 and 0 today for + 3 units
119 and 96 overall
+ 13.9 units

[hyahya]

25 180

under A's

30 80 -138

jays

12 800 138

rangers

30 210 -106

twins

19 200 -170

tigers

30 475

under mariners

28 280 105

phils

22 430 -133

jays
dodgers

23 800

under dodgers

29 450 -132

pirates
orioles

25 450

under nats

38 400 124

bosox

30 540

under pirates

26 500 -120

mariners

21 950

under jays

under nats

24 380

under mariners

96 40 152

twins

15 400 113

astros
rockies
orioles
cards

29 500 -132

pirates
orioles

29 300 -116

jays

30 420

under nats

under orioles

37 270 105

marlins

32 260

under nats

5 1800 -108

dodgers

orioles

A's

33 420 120

astros

39 130

under astros
under rockies


36 105

under yanks

27 500

under rockies

31 105 -122

jays

38 135 106

orioles

26 200 -105

phils

27 250 -160

dodgers

35 425 105

bosox

44 220 -132

mariners

31 71 147

giants RL

11.5 1100 -125

mariners

47 40 -134

brew

[mdunlap3]

I get "HTTP 599: Timeout" every time i try to run a query...how do I fix this???

[hyahya]

I get "HTTP 599: Timeout" every time i try to run a query...how do I fix this???

You can't the server is probably overloaded. I'm assuming some users are running automated scripts monopolizing all the bandwidth.

[Alex Vaile]

First play : ( Bases )

Under 8 - 120 Pirates vs Phillies

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]

Yankees/Redsox under

Not sure where I found it but here it is:

starter = Hiroki Kuroda and s:SIP > 6 and team = Yankees

Add SG=1, and see how record changes.

There is another query supporting this but can't find it...

[Alex Vaile]

Second and third plays: ( Bases )

Play Pirates - 140
Play Orioles - 133

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

[Alex Vaile]

Fourth play: ( Dr.M )

Play Seattle - 144

team =Astros and line>=135 and po:BPRA>po:SRA and p:L and season>=2013

Astros 0 and 16 in this spot.

[Alex Vaile]

2 and 2 yesterday for -. 84 units
121 and 98 overall
+ 13.04 units

[emceeaye]

Mets/Rockies under

Bases queries

SG = 3 and day=Wednesday and month=9 and H and p:runs < 10 and pp:runs < 10 and op:runs < 10 and opp:runs < 6 and s:SRA < 5 and s:SHA < 9 and ss:SHA < 10 and 2 < os:SHA < 11 and s:SPT > 52 and os:SPT < 121 and p:margin < 7 and p:margin != -1 and p:margin != -2 and p:margin != -3 and p:margin != -4 and 11.4 > oA(hits, N=10) > 7.3 and 10.8 > tA(hits, N=10) > 7.3 and (pp:hits + p:hits) < 27 and op:BPRA < 6 and streak < 5 and 5.8 > tA(runs, N=8) > 2.5 and division != NL West and 2.3 > tA(doubles,N=10) > 1.05 and oA(doubles, N=10) > 1.1 and STDSWHIP < 1.656 and o:STDSWHIP > 1

more support:

SG = 3 and H and -2 < p:margin < 4 and pp:margin < 7 and p:hits < 8 and 3 < op:hits < 12 and day != Thursday and pp:hits > 2 and opp:hits < 17 and 1 < p:HR + pp:HR + op:HR + opp:HR < 5 and s:SHA > 2 and 33 > os:SHF > 19 and 18 < s:SHF < 33 and 3.8 < s:SIP < 7.5 and 74 < os:SPT < 114 and s:SPT < 119

[emceeaye]

Nationals/Braves under

Bases query I believe:

H and SG=3 and day=Wednesday and month=9 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

[hyahya]

33 320 -107

twins

37 270 104

jays

angels

38 220

under pirates

33 220 -140

mariners
nats

29 260

under rockies

31 470 -112

rays

32 450

under rockies

36 100

under rays

46 175 -135

indians

30 250 103

mets

34 75 -135

angels

26 630

under tigers

27 500

under nats

under bosox

28 200 134

padres

37 220 -117

bosox

35 420 103

bosox

7.3 1400 135

dbacks
astros
braves

phils

bosox

33 350 -140

giants

12 800 -102

jays RL

A's RL

9 1200 -120

A's

57 70 145

twins

25 85 -134

angels

11.5 1200 124

chisox

43.5 41 -134

brew

29 160

under A's

21 400 107

dbacks

33 330 135

rockies


30 210
over brew

33 420

under angels

38 410 124

bosox

30 250 -140

mariners
nats

37 110 -108

marlins

24 400

under mariners

20 920

under nats

27 700 -117

pirates

32 220 -123

rangers

[Alex Vaile]

First and second plays: ( Bases )

Under 8.5 -115 Orioles vs Red Sox
Under 8 -105 Pirates vs Phillies

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]

Third play : ( Bases )

Under 8 - 105 Cubs vs Blue Jays


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

[Alex Vaile]

Fourth play: ( Dr.M )

Play Mets - 121

team=Mets and HF and SG=3 and SGS=3 and date>20130601

[hyahya]

51 110

over reds

27 700 -117

yanks

26 660 -101

brew

32 250 -118

chisox

30 380

over bosox

29 250

over reds

32 350 114

royals

22 165

under nats

8.5 1200 -120

angels

11 1100 -125

giants

44 42 -134

brew

[mdunlap3]

Brutal day yesterday gentlemen..here's to a bounce back day!

[emceeaye]

reds/cards over

Bases query:

SG = 4 and H and -4 < (ou streak + ou streak) < 11 and op:HR < 2 and (p:HR + pp:HR + ppp:HR) > 1 and oA(doubles, N=3) < 3.2 and tA(doubles, N=3) < 3.5 and 6.5 < oA(hits, N=3) < 13.5 and 7.25 < tA(hits, N=3) < 13 and tA(runs, N=3) < 7.5 and 1.75 < oA(runs, N=3) < 6.5 and s:SHRA < 3 and s:SWA < 5 and os:SWA < 5 and s:SHA > 2 and ss:SHRA < 3

Add month=9 and day=Thursday, then it gets better but small N...but take a look at what happens to ML.

Better yet, add day!=Saturday and day!=Sunday. It is better and favors Reds ML

[Alex Vaile]

1 and 3 yesterday for -2.25 units. Jays blew up under in 2 innings.

122 and 101 overall
+ 10.79 units

[mdunlap3]

Bases query:

SG = 4 and H and -4 < (ou streak + ou streak) < 11 and op:HR < 2 and (p:HR + pp:HR + ppp:HR) > 1 and oA(doubles, N=3) < 3.2 and tA(doubles, N=3) < 3.5 and 6.5 < oA(hits, N=3) < 13.5 and 7.25 < tA(hits, N=3) < 13 and tA(runs, N=3) < 7.5 and 1.75 < oA(runs, N=3) < 6.5 and s:SHRA < 3 and s:SWA < 5 and os:SWA < 5 and s:SHA > 2 and ss:SHRA < 3

Add month=9 and day=Thursday, then it gets better but small N...but take a look at what happens to ML.

Better yet, add day!=Saturday and day!=Sunday. It is better and favors Reds ML

This looks dead in the water...ugh

[evangelizelee]

Hi does anyone know the statistic for ou for the 2nd game on a team that has to play two games?

[JMon]

Hi does anyone know the statistic for ou for the 2nd game on a team that has to play two games?

Since 2004...second game of a double header

O-U: 121-135-17 (0.06, 47.3%)

[b1slickguy]

Anyone else notice today's ML, totals and starting pitcher data removed from KS?
They were there this morning... now gone.
SDB still has all, though.
Good luck.

H and day=Thursday and season>=2014

[neilb1973]

JA Happ Under

Saw this in the thread earlier in the summer by posey and should be a play today on the under.

starter = JA Happ and HF and season > 2010

[emceeaye]

Saw this in the thread earlier in the summer by posey and should be a play today on the under.

starter = JA Happ and HF and season > 2010

I like this, but the only concern I have is I'm not sure how good Karns is as a starter for the Rays. And of course that's another big factor in what will determine whether this game will go under or not. Along those lines I'm also concerned about other games where we have relief pictures turning into starting pitchers. It seems like in the situation of a relief pitcher turning into a starter, we're just not sure how they'll do as a starter, which makes it more questionable what the outcome is going to be.

[mdunlap3]

Anyone else notice today's ML, totals and starting pitcher data removed from KS?
They were there this morning... now gone.
SDB still has all, though.
Good luck.

H and day=Thursday and season>=2014

KS?

[Alex Vaile]

First play: ( Bases )

Under 7 - 110 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)

[Alex Vaile]

Second play : ( Bases )

Under 8 -110 Yankees vs Orioles

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

[emceeaye]

Second play : ( Bases )

Under 8 -110 Yankees vs Orioles

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

1st game

[JMon]

Play Mariners Under

SDQL (note space after p :

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 p: ou margin>-6.6 and streak<5 and o:streak<6 and -89 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 and team=Mariners

[b1slickguy]

KS?

KillerSports.
Good luck tonight everyone.

[Alex Vaile]

Third play : ( Bases )

Play Oakland + 129


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