MLB - Situation Plays - SDQL

**b1slickguy** · 08-22-14, 12:46 PM

SG=1 and p:H and p:hits + p:runs + po:hits + po:runs<=6

Created this one earlier in the season.
Rare situation and very small sample size.
Good luck.

**mdunlap3** · 08-22-14, 01:35 PM

Originally posted by b1slickguy

SG=1 and p:H and p:hits + p:runs + po:hits + po:runs<=6

Created this one earlier in the season.
Rare situation and very small sample size.
Good luck.

Who's the play bro?

**b1slickguy** · 08-22-14, 02:15 PM

Originally posted by mdunlap3

Who's the play bro?

TB.
Good luck.

**emceeaye** · 08-22-14, 02:36 PM

Originally posted by b1slickguy

SG=1 and p:H and p:hits + p:runs + po:hits + po:runs<=6

Created this one earlier in the season.
Rare situation and very small sample size.
Good luck.

Nice. What's the logic behind it?

**b1slickguy** · 08-22-14, 03:09 PM

Originally posted by emceeaye

Nice. What's the logic behind it?

Closed out previous series with little or no hitting/runs scored for team and previous opposition.
Contrarian point of view: offense to come alive. (hopefully)
Good luck.

**JMon** · 08-22-14, 08:42 PM

Originally posted by b1slickguy

Closed out previous series with little or no hitting/runs scored for team and previous opposition.
Contrarian point of view: offense to come alive. (hopefully)
Good luck.

slicker you are a sharp muther fukker bro...

**JMon** · 08-22-14, 09:50 PM

Originally posted by JMon

This is active again on the Phillies.

cash it bros...big dog

**b1slickguy** · 08-22-14, 10:30 PM

Originally posted by JMon

cash it bros...big dog

Very nice! Dogs barking in the ballparks tonight.
Good luck.

**JMon** · 08-22-14, 10:45 PM

Originally posted by b1slickguy

Very nice! Dogs barking in the ballparks tonight.
Good luck.

Indeed....

WON: 902 Phillies (+146) AT risk 150.00 win 219.00 (MLB) Score: 5-4

08/22/14 17:04:27

$219.00

#30078241

WON: 915 Astros (+180) AT risk 150.00 win 270.00 (MLB) Score: 5-1

08/22/14 17:04:27

$270.00

#30078241

WON: 905 Braves (-103) AT risk 150.00 win 145.63 (MLB) Score: 3-1

08/22/14 17:04:27

$145.63

#30078241

**b1slickguy** · 08-22-14, 10:53 PM

Originally posted by JMon

slicker you are a sharp muther fukker bro...

Just mining oddities from box scores. Most go nowhere, a few are nuggets.
Thank YOU for all the SDQL schooling.
Real version of the "Give a man a fish/Teach a man to fish" saying.
Good luck.

**emceeaye** · 08-22-14, 11:16 PM

Originally posted by b1slickguy

Closed out previous series with little or no hitting/runs scored for team and previous opposition.

Contrarian point of view: offense to come alive. (hopefully)
Good luck.

Nice work 1Slick!! It appears to have worked like a charm!

**emceeaye** · 08-22-14, 11:17 PM

Originally posted by Alex Vaile

Second play: ( Dr.M )

Play Arizona - 113
Arizona RL +170

Padres no good in this spot recently.

team=Padres and A and o:streak<=-2 and season >= 2014
team=Padres and A and p:L and p:M6=0 and date >= 20130420

Nice, Alex. Went with it. Thanks!!

**emceeaye** · 08-22-14, 11:20 PM

Originally posted by JMon

This is active again on the Phillies.

Thanks, Jmon. Decided to go with this baby as well. Good job!

**Alex Vaile** · 08-23-14, 12:06 AM

Originally posted by b1slickguy

SG=1 and p:H and p:hits + p:runs + po:hits + po:runs<=6

Created this one earlier in the season.
Rare situation and very small sample size.
Good luck.

Nice query sharp thinking Slick. Thanks for posting!

**Alex Vaile** · 08-23-14, 12:07 AM

Originally posted by JMon

cash it bros...big dog

Nice one Jmon! Played it with you thanks!

**Alex Vaile** · 08-23-14, 12:10 AM

3 and 0 today for + 3.7 units
98 and 74
+ 18.8 units

**emceeaye** · 08-23-14, 07:51 AM

Bases query on Rays/Jays under and Brewers/Pirates under

tA(BPRA) < 1.35 and SG = 2 and SGS = 3 and -8 < (ou streak + ou streak) < 6 and op:HR < 4 and 12 > s:SHA > 2 and s:SSO < 8 and s:SHRA = 0 and 123 > s:SPT > 83 and ss:SHRA < 2 and 2 < ss:SHA < 11 and 8 > os:SRA > 0 and ((site = home and conference = NL and o:conference = NL) or (site = home and conference = AL and o:conference = AL) or (site = away and conference = AL and o:conference = AL)) and os:SHRA < 3 and os:SHA > 4 and os:SWA < 4 and s:SWA < 5 and os:SPT < 118 and oss:SHRA != 2 and s:SIP > 4.5 and os:SSO < 10 and p:BPRA < 6 and op:BPRA < 5 and oA(hits,N=10) < 10.9

**staf** · 08-23-14, 08:55 AM

1-0 +1 unit yesterday
6-3 +3.42 units overall

SU: 699-494 58.6% +$16,949 ROI: +10.9%
Tampa Bay Rays +101

RL: 715-589 54.8% +$15,712 ROI: +9.6%
Philadelphia Phillies +1.5 -155
Cincinnati Reds +1.5 -150

SU: 1483-1262 54% +$23,020 ROI: +6.9%
Washington Nationals -166
San Diego Padres -112

**Alex Vaile** · 08-23-14, 09:27 AM

First posted play : ( Bases )

Under 7.5 - 115 Giants 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** · 08-23-14, 09:36 AM

Originally posted by emceeaye

tA(BPRA) < 1.35 and SG = 2 and SGS = 3 and -8 < (ou streak + ou streak) < 6 and op:HR < 4 and 12 > s:SHA > 2 and s:SSO < 8 and s:SHRA = 0 and 123 > s:SPT > 83 and ss:SHRA < 2 and 2 < ss:SHA < 11 and 8 > os:SRA > 0 and ((site = home and conference = NL and o:conference = NL) or (site = home and conference = AL and o:conference = AL) or (site = away and conference = AL and o:conference = AL)) and os:SHRA < 3 and os:SHA > 4 and os:SWA < 4 and s:SWA < 5 and os:SPT < 118 and oss:SHRA != 2 and s:SIP > 4.5 and os:SSO < 10 and p:BPRA < 6 and op:BPRA < 5 and oA(hits,N=10) < 10.9

This looks great. Ill play them with u!

**emceeaye** · 08-23-14, 09:45 AM

Twins RL and SU

I believe this is courtesy of JMON:

HD and DIV and p:W and (month != 6 and month != 7) and day=Saturday and SG=2 and tA(BPRA) < oA(BPRA) and line < 160 and total <= 10.5 and 4 > SG > 1 and rest = 0

I added day=Saturday

check it out

**emceeaye** · 08-23-14, 09:49 AM

[Errno 111] Connection refused

anyone know what this message is all about from database? [Errno 111] Connection refused

**hyahya** · 08-23-14, 09:58 AM

Anybody getting the following error when running queries:

[Errno 111] Connection refused

?

**Alex Vaile** · 08-23-14, 10:00 AM

I think the site is down

**hyahya** · 08-23-14, 10:19 AM

It's intermittent, comes and goes every 5 minutes.

**emceeaye** · 08-23-14, 10:27 AM

Originally posted by hyahya

It's intermittent, comes and goes every 5 minutes.

yeah, when you tweak a filter in a query that already showed up

**hyahya** · 08-23-14, 10:56 AM

26 70

dodgers RL

59 42

under braves

35 250

twins GM1

30 210

chisox

30 270

dbacks

bosox
reds

24 800

over angels

over pirates

over royals

over rockies

29 490

pirates

32 520
under giants

29 400
under rangers

30 660
A's

29 430
royals

39 63
pirates

35 180
mariners RL

36 360
giants

34.5 310
padres

28.5 300
rays

29 550
pirates

28 450
rays

30 250
padres
indians

36 290
giants
marlins

44 175
pirates

30 500
dbacks

30 490
A's
dbacks

39 200
cubs

47 170
A's

35 250
twins gm1

28 500
under rays
under pirates

29 410
phils

29 350
nats RL

56 105
reds

29 190
dbacks
bosox
reds

42 215
reds

49 150
under phils

35 415
indians

39 230
brew

27.5 850
under cubs

8 1400
bosox
chisox
reds

9 1200
rays
twins gm1

44 150
chisox

11 1000
reds

57 115
chisox

**emceeaye** · 08-23-14, 11:10 AM

sucks..can't run queries

sucks..can't run queries
database down

**JMon** · 08-23-14, 11:25 AM

Not sure what is going one. I have all my trends (600 of them) saved and I am only showing one active... I have emailed twice with no response.

**staf** · 08-24-14, 06:40 AM

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

**JMon** · 08-24-14, 09:00 AM

ref post #750

Situation A: Fade a Sunday NL Getaway team

2014 tracking results on the fade: 24-37 (38.2%) (+732)

Last week (-15)

Fading (play against)

Pirates
Padres
Mets
Cardinals
Marlins

**JMon** · 08-24-14, 09:43 AM

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

**JMon** · 08-24-14, 10:24 AM

ref post #750

Situation B: Sunday Under Getaway

2014 tracking results over-under-push: 31-35-3 (+95)

Last week: (-225)

Play Under:

Pitt
SD
Hou
Stl
Kc

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

0 and 1 yesterday for -1.15 units
98 and 75
+17.65 units

Pablos error allowed that total to go over even with Lincecum getting rocked.

**Alex Vaile** · 08-24-14, 11:16 AM

First posted play: ( Bases )

Under 7.5 - 115 Mets vs Dodgers

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)