[JMon]

I posted Laa, Det, Laa under, and Cubs. Play at your own risk, especially if you dont understand sdql. The guys may have other plays or plays that contradict mine.

[Alex Vaile]

A scary query.

D and starter wins - o:starter wins < -8 and s:W and os:L and oss:W and o:starter rest < 8 and SG < 4 and season > 2011

2 and 0 today with this. Nice job!

[Alex Vaile]

Second play: ( Bases or JMon )

Under 8.5 +105 Athletics vs Astros

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

Such bulls h t they score 4 in the ninth. I waited and bet this at 9 -120 also but posted play lost.

[Alex Vaile]

0 and 4 for -5.04 units.
102 and 84
+10.66 units
Glad I hit that yankees and pirates and angels plays from u guys.

[emceeaye]

0 and 4 for -5.04 units.
102 and 84
+10.66 units
Glad I hit that yankees and pirates and angels plays from u guys.

Alex, thanks for posting good Bases' unders lately overall. Bummer of an Angels game for the under.

[emceeaye]

Not sure whose query this is, so forgive me if I didn't give you credit:

This one has a great record and if you add "LGS" or "SG=4" it looks even better. Also take a look at day=Thursday and although N gets smaller, it looks promising.

STR and o:STR and s:margin = -1 and s:streak = 2 and s:biggest lead < 3 and s:errors < 2 and -9 < p:M8 < 3 and p:M8 != -2 and -4 < p:M1 < 3

[Alex Vaile]

Alex, thanks for posting good Bases' unders lately overall. Bummer of an Angels game for the under.

Yup. They look great on paper but haven't cashed much this week. Had a good run last week I feel today as a good day! Thanks emceeaye!

[Alex Vaile]

First play: ( Bases )

Under 7 -110 Braves vs Mets

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)

[mdunlap3]

N/A

[Alex Vaile]

I still don't understand this query but it just looks so good.
I think slickguy made it.


D and A and A(W, N=10) > 0.4 and S(W, N=4) >= 2

Points to royals, angels, giants, orioles, and astros.

[emceeaye]

Here's a beauty by b1slick or Jmon:

(team=Twins or team=Rangers) and D and oS:W and oS:season=season and season>=2012

Add SG=3 and take a look at just team=Twins...

[mdunlap3]

N/a

[JMon]

I still don't understand this query but it just looks so good.
I think slickguy made it.


D and A and A(W, N=10) > 0.4 and S(W, N=4) >= 2

Points to royals, angels, giants, orioles, and astros.

This is the one that part of the query is not predictive. I made reference to this back awhile ago...do not use.

[mdunlap3]

N/A again...sorry i keep messing up.

[emceeaye]

Anyone having trouble with db?

[mdunlap3]

Anyone having trouble with db?

Yup 502 Bad gateway error here.

[emceeaye]

Yup 502 Bad gateway error here.

Yeah, I'm getting no query box...oh well, so much for lunch break query running

[emceeaye]

HyaHya,
Did you happen to run queries and create a list of results for today...they have been helpful as I can cross-reference my results with yours to look for consistencies and conflicting results, which helps to narrow down picks...

Then again if this db keeps acting up until the end of the day, then we won't be able to run anymore queries before game time

[mdunlap3]

Ugh extremely frustrating....

[JMon]

I remember back several years ago, them selling their db, per sport. But one would have to maintain it going forward. Thus enter matchups, lines, wins/losses,etc. Doesn't sound like a bad idea now.

[Alex Vaile]

BRUCE CHEN IS TRASH. Top 10th line
6 hits 6 runs 2 walks 36 pitches in what was a tie game. Add him to Phil Coke and Bellasario, Tony Sipp on Astros. Just awful.

[JMon]

Slicker's beauty is active today on the Phillies and Twins. Both would be nice, but only need to catch one for a profit!

SDQL

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

[JMon]

Play Bos

SDQL

AD and season > 2010 and month != 7 and p:hits < 8 and pp:hits > 6 and 18 > ppp:hits > 2 and pppp:hits > 5 and 17 > ppppp:hits > 4 and 16 > op:hits > 6 and s:SRA < 6 and streak > -5 and SG < 4 and line < 190 and total < 10.01 and 1.9 > STDSWHIP > 1.2 and team=Red Sox

[JMon]

Play Milw

SDQL by bases

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 and s:SHF > 21 and s:SSO < 10 and op:BL < 8 and 2 < p:PU < 7 and -39 < tS(margin, N=10) - oS(margin, N=10) < 32 and oS(HR, N=10) > 4 and 3 < tS(HR, N=10) < 19 and oS(doubles, N=10) < 29 and tS(hits, N=10) > 63 and 65 < oS(hits, N=10) < 105 and line < 225 and day != Sunday and oss:SHA < 11 and oss:SHRA < 3 and game number > 24 and tS(margin, N=20) - oS(margin, N=20) < 43 and tS(hits, N=20) - oS(hits, N=20) < 27 and team=Brewers

[JMon]

Play Atl under

SDQL by bases (note space after o:

H and -7 < ou streak < 2 and -6 < o: 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

[JMon]

Play Sea over

SDQL by bases

p:HR = 2 and op:HR < 3 and SG < 5 and SG != 3 and 1 < SGS < 5 and s:SRA < 6 and os:SRA < 6 and (s:SHA + ss:SHA) < 17 and (os:SHA + oss:SHA) < 17 and 2.6 < tA(runs, N=10) < 6.8 and oA(runs, N=10) < 6.6 and total < 10.5 and 84 < os:SPT < 119 and starter rest < 20 and o:starter rest < 25 and (rest = 1 or rest = 0) and p:hits < 17 and 3 < op:hits < 18 and .8 < tA(doubles, N=10) < 2.5 and .8 < oA(doubles, N=10) < 3.1 and day != Wednesday and -2 < ou streak < 5 and -2 < ou streak < 3 and month < 10 and (game number < 107 or game number > 116) and tA(walks, N=10) > 1.9 and 1.9 < oA(walks, N=10) < 4.7 and tA(BPRA, N=10) > .4 and p:hits > 5 and (start time - p:start time < -306 or start time - p:start time > -102) and (p:SO + op:SO) > 7

[hyahya]

HyaHya,
Did you happen to run queries and create a list of results for today...they have been helpful as I can cross-reference my results with yours to look for consistencies and conflicting results, which helps to narrow down picks...

Then again if this db keeps acting up until the end of the day, then we won't be able to run anymore queries before game time

Just saw this EMC, will post my list whenever I have the chance.

[mdunlap3]

BRUCE CHEN IS TRASH. Top 10th line
6 hits 6 runs 2 walks 36 pitches in what was a tie game. Add him to Phil Coke and Bellasario, Tony Sipp on Astros. Just awful.

Ugh...feel your pain man, tough couple of days. Lets make it up this weekend bro.

[b1slickguy]

BRUCE CHEN IS TRASH. Top 10th line
6 hits 6 runs 2 walks 36 pitches in what was a tie game. Add him to Phil Coke and Bellasario, Tony Sipp on Astros. Just awful.

I was watching the game and when I saw Chen on the mound to start the 10th I knew it was over. He's THE weak link in the Royals bullpen. If Hochevar was healthy, Chen would be gone.
Good luck.

[mdunlap3]

SDQL by bases-

Mets under
Giants under




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)

[hyahya]

29 230

rangers
cubs

dodgers

reds

bosox

indians

37 270

braves

38 250

A's

yanks

5.1 1800

A's

tigers

39 200

indians

33 350

rays

43 150

angels

28 570

rangers
reds
bosox

26 630

under braves

29 370

cubs

18 75

cards

17 1570

brew

phils
dodgers
reds

37 165

under braves

11 1350

phils

dodgers

31 320

bosox

23.5 800

over nats

29 500

angels

31 530

under brew

under phils

8.3 800

cards

21 900

under braves

31 400

cards RL

royals RL

mariners RL

17 70

cards

29 430

giants

[mdunlap3]

SDQL (not sure of source, forgive me)

Play Dbacks

This query is extremely hot this season.... 21-1 last 22, and 24-7 this season.

HF and line < -130 and tS(hits) / tS(at bats) < 0.25 and p:RMAX < 6 and o:STDSERA >= 4.8 and 1 < os:SIP < 9 and o:starter rest < 8 and 0.21 < tS(o:hits, N=18) / tS(o:at bats, N=18) < 0.26 and conference = NL

[mdunlap3]

Slicker's beauty is active today on the Phillies and Twins. Both would be nice, but only need to catch one for a profit!

SDQL

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

I don't see Phils coming up on this one, see the Twins though. On it with you man.

[b1slickguy]

I don't see Phils coming up on this one, see the Twins though. On it with you man.

Total dropped to 7 on the PHI/NYM game.
Good luck.

[Alex Vaile]

I was watching the game and when I saw Chen on the mound to start the 10th I knew it was over. He's THE weak link in the Royals bullpen. If Hochevar was healthy, Chen would be gone.
Good luck.

Glad I wasn't the only one! Garbage man that's what they should call him. Or giver, not pitcher!