MLB - Situation Plays - SDQL

[emceeaye]

Here's one in dispute kind sir, also shows a play on the Rays. Thoughts?

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

Add SG=1 and day=Friday and record favors Orioles

[emceeaye]

Nats su

heavy juice I know, but at least this will give you pause about going with Phillies:

season=2014 and H and line<=-185 and p:W and month>7

[emceeaye]

a hammer play active today supporting Jmon's white sox su pick

p:margin = -7 and s:SHRA = 0 and SGS = 3 and 3 < p:hits < 8 and ((SG = 3 and site = away) or (SG = 2 and site = away) or (SG = 1 and site = home)) and p:HR < 2 and line > -150 and starter rest < 8

[bobby29]

Guys, do you have football threads for the sdql stuff? I cant seem to find them in either football section? If so could you post the links so i can bookmark for them for the season.
Thank you
Bobby

[Alex Vaile]

3 and 1 today for + 2 units
115 and 95 overall
+ 12.33 units

[emceeaye]

3 and 1 today for + 2 units
115 and 95 overall
+ 12.33 units

nice limited selections, Vaile!


I got worked yesterday...I'd like to turn that around today.

[JMon]

Guys, do you have football threads for the sdql stuff? I cant seem to find them in either football section? If so could you post the links so i can bookmark for them for the season.
Thank you
Bobby

http://www.sportsbookreview.com/forum/nfl-betting/2935861-nfl-situational-plays-sdql.html#post22517065

[JMon]

Play Indians

SDQL, note space : o :

A and line>=130 and STDSERA<=3.50 and t:conference=AL and A(Starter: o :innings pitched@o:starter and season) >6.5 and 2004<=season and team=White Sox

[Alex Vaile]

nice limited selections, Vaile!


I got worked yesterday...I'd like to turn that around today.

Thanks emceeaye! Been a hard few days! Good luck

[hyahya]

13 700 138

royals

8.6 850

under yanks

under indians

19 200 -170

indians

25 450

under indians

42 100 161

phils

29 280 105

yanks

37 50

under phils

33 330 135

orioles

23.5 820

over jays

29 500 -110

marlins

47 100 138

chisox
royals

26 500 -119

dodgers

30 660 -104

brew

33 310 -106

bosox

30 150 -135

bosox

30 400

under indians

under rays

30 670 -108

tigers

32 360

under indians

37 250 107

jays

29 450 -132

dodgers
nats

36 300 -113

orioles

30 470 -112

dodgers
rays

47 175 -135

nats
rays

27 500

under dodgers

29 360 127

bosox RL

32 105 -123

marlins

57 105 120

rangers

27 200 -105

yanks

42 220 118

rangers

37 320 -118

indians

31 430

under rays

under yanks

28 580 113

cards

44 215 -132

rays

7.5 1400 138

padres
royals

33 350 -140

bosox

57 37 -134

brew

22 70 -147

bosox

11 1100 -125

angels

[mdunlap3]

Any SDQL CFB thread started yet?

[Alex Vaile]

First play : ( Bases )

Under 8 -105 Phillies vs Nationals
Under 6.5 +105 Dbacks vs Dodgers

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]

I put a few Dr. M NFL queries in the new thread. They look pretty solid.

[FlyinAir]

Glad to see this thread still rollin, Jmon, thx for the CLE play

[bobby29]

Thanks JMon for the link, appreciate it

[FlyinAir]

Glad to see this thread still rollin, Jmon, thx for the CLE play

[Alex Vaile]

1 and 1 today for 0 units Dodgers squeaked over in late innings. Bummer at least it was plus odds.
116 and 95 overall
+12.33 units

[hyahya]

19.5 100
under angels

12.7 700 138

phils

12.5 1400 127

rockies

36 250 117

bosox

32 330 135

mets

30 470

under phils

29 275 105

brew

rays

21 400 107

pirates

34 220

under indians

29 220 -120

braves

33 420

under braves

33 500 117

reds

31 530

under indians

under dodgers

25 420

under jays

30 280 120

mets

27.5 680 -117

A's

30 165 153

astros

30 430

under nats

under orioles

39 225

under padres

35 180 -109

marlins

41 270

under dodgers

39 430

under royals
under braves

under dodgers

under mets

under jays

36 250 117

bosox

29 340 -105

padres

27 500

under orioles

32 110 -147

A's

bosox

27 200 -104

brew

rays

42 220 118

mets


11.4 110 -125

angels


54 38 -135

brew


14 110
under pirates
under braves
undre padres

[JMon]

Play Clev Under

SDQL

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) and team=Indians

[JMon]

ref post #750

Situation A: Fade a Sunday NL Getaway team

2014 tracking results on the fade: 26-45 (36.6%) (+1315)

Last week (+500) Monster week

Fading (play against)

SD

don't really care for this play

[JMon]

ref post #750

Situation B: Sunday Under Getaway

2014 tracking results over-under-push: 34-40-3 (+260)

Last week: (-135)

Play Under:

White Sox
Blue Jays
Padres

[Alex Vaile]

Play Clev Under

SDQL

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) and team=Indians

This query lists another game too JMon.
Take under 7 -115 in Diamondbacks vs Dodgers

[emceeaye]

Play Clev Under

SDQL

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) and team=Indians

more support for under Indians:

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

Play Clev Under

SDQL

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) and team=Indians

More support :
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]

Right on emceeaye I guess we're thinking about the same things! Good luck today buddy! Hope you hit that teaser!

[JMon]

more support for under Indians:

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

Nice...

[Alex Vaile]

First play : ( Bases )

Play Atlanta -143

(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

[hyahya]

34 320 -107

A's

30 670 -107

jays

37 270 106

dodgers

5.2 1800 -104

jays

A's

25 180

under A's

39 200 123

rockies

31 250 103

bosox

28 380 -109

nats

7.3 1400 139

astros

chisox

royals

43 150 154

astros

12 1000 124

phils

55 120 155

astros

30 450

under nats

22 425 -133

nats

23 800

over bosox

30 530

under mariners

under bosox

44 100 138

chisox

24 380

under mariners

27 700 -117

tigers

38 220 138

tigers RL

30 290 -120

chisox

30 670 -104

astros

26 660 -104

astros

[Alex Vaile]

0 and 1 yesterday for -1.43 units
116 and 96 overall
+10.9 units

[Alex Vaile]

First play : ( Bases )

Play Washington -137

(p:LOB - po:LOB) > 5 and (tA(runs) / tA(hits)) - (oA(runs) / oA(hits)) > -.0173 and 3.4 > (tA(runs, N=11) - oA(runs, N=11)) > -.5 and -.05 < (tA(hits, N=11) - oA(hits, N=11)) < 3.05 and line > -157 and HF and s:SRA < 8 and os:SHA > 2 and os:SHRA < 3 and os:SPT > 73 and day != Friday and o:starter rest < 10

[Alex Vaile]

Second and third plays: ( Bases )

Under 9 -120 Orioles vs Red Sox
Under 6.5 -110 Astros vs Mariners

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]

More support :
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

Nice easy winner here.

[Alex Vaile]

First play : ( Bases )

Play Washington -137

(p:LOB - po:LOB) > 5 and (tA(runs) / tA(hits)) - (oA(runs) / oA(hits)) > -.0173 and 3.4 > (tA(runs, N=11) - oA(runs, N=11)) > -.5 and -.05 < (tA(hits, N=11) - oA(hits, N=11)) < 3.05 and line > -157 and HF and s:SRA < 8 and os:SHA > 2 and os:SHRA < 3 and os:SPT > 73 and day != Friday and o:starter rest < 10

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

[Martinr]

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.

[b1slickguy]

Fading DET today.
Good luck.

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