MLB - Situation Plays - SDQL

**Alex Vaile** · 06-30-14, 05:49 PM

Originally posted by JMon

just a team trend for you to think about, not trying to get you off this play.

team=Royals and A and FGS and DIV and p:W and p:BPRA=0 and p:errors>0

Wow. Quite a trend there. Well I already played it but it'll most likely it'll turn out as ur query says. Yesterday I was 0 and 2 following some good trends though too so maybe it'll swing my way today. Thanks JMon good luck

**Alex Vaile** · 06-30-14, 10:45 PM

Kc Under cashes.
1 and 0 today
21-9 overall + 10.8 units

**Alex Vaile** · 07-01-14, 11:00 AM

First posted play 7/1:

Over 7.5 -110 Tampa vs Yankees

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

**Alex Vaile** · 07-01-14, 11:03 AM

Second posted play 7/1:

Under 6.5 -125 Reds vs Pads

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

u margin > -6.6 and streak < 5 and o:streak < 6 and -8 < o

u streak < 4 and os:SPT < 123 and team != Twins and team != Red Sox and o:team != Indians and (s:SSO + ss:SSO + sss:SSO + ssss:SSO) > 9 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

**Alex Vaile** · 07-01-14, 11:11 AM

Third posted play for 7/1:

Rays -124

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

**rutt723** · 07-01-14, 06:37 PM

whats the query for next start after no hitter timmy goes tonight?

thnx for the help

**Alex Vaile** · 07-02-14, 12:28 AM

1 and 2 today on posted plays. -1.35 units
22 and 11 overall.
+ 9.45 units

**JMon** · 07-02-14, 10:02 AM

Perfect 10-0 ml and rl this season, fading the astros today

-140<=line<=120 and p:margin<=-4 and pp:margin<=-4 and op:runs>=8 and H and SG<4 and total<11

**JMon** · 07-02-14, 10:26 AM

fade a team revenging a shut out loss, both winning team.

A and -150<=line<=-100 and line>=-150 and P:L and P:runs=0 and P:season=season and WP>50 and o:WP>50 and 2009<=season

**JMon** · 07-02-14, 10:36 AM

team=Athletics and P:L and PP:L and PPP:L and 20110816<=date

**JMon** · 07-02-14, 10:49 AM

Originally posted by Tornblau

Perfect stats

yes, good situations, but don't base your plays soley on them.

**Alex Vaile** · 07-02-14, 10:59 AM

Originally posted by JMon

fade a team revenging a shut out loss, both winning team.

A and -150<=line<=-100 and line>=-150 and P:L and P:runs=0 and P:season=season and WP>50 and o:WP>50 and 2009<=season

Ya I could see fading cards but Verlander just isn't the same guy he used to b. Look at this for more info on fading Verlander
starter=Justn Verlander and F and s:SSO>s:SHA and s:A and date>=20130407 I saw you're in the baseball contest. I joined yesterday too. Good luck Jmon.

**Alex Vaile** · 07-02-14, 11:01 AM

Ya As pretty good after losing a few in a row. I'm going As here.

**JMon** · 07-02-14, 11:12 AM

Ya,, not touching Verlander either for oak for that matter.

Now I found a conflict supporting the Astros as a dog...trying to weighs strength of query.

so far like Twins, SF, and Bos un 9

**JMon** · 07-02-14, 11:13 AM

Originally posted by Alex Vaile

Ya As pretty good after losing a few in a row. I'm going As here.

that query is triple revenge, does not have to be same season. P: = previous match up

**Alex Vaile** · 07-02-14, 11:13 AM

I like As Sf too. Playing Milwaukee just on a hunch too.

**Alex Vaile** · 07-02-14, 11:18 AM

My favorite query:
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)

2 posted plays:

Under 7.5 -110 Dbacks vs Pirates
Under 6.5 -115 Cards vs Giants

**Alex Vaile** · 07-02-14, 11:23 AM

Third posted play:
Giants + 133
courtesy of Bases

AF and -114 > line > -175 and SG < 4 and SGS = 3 and s:SRA < 7 and s:SWA < 5 and 0 < s:SSO < 9 and s:SHRA < 2 and s:SPT > 89 and starter rest < 7 and s:batters faced < 47 and s:SIP > 5.5 and ss:SHRA < 3 and ss:SPT < 121 and 48 > ss:batters faced > 33 and day != Friday and sss:batters faced < 45 and sss:SHRA < 3 and 52 < sss:SPT < 122 and os:SRA < 9 and os:SHA < 10 and os:SHRA < 2 and os:SSO != 0 and os:batters faced < 49 and os:SPT > 65 and oss:SHA > 1 and oss:batters faced < 54 and oss:SPT < 111 and osss:SHA > 1 and 31 < osss:batters faced < 46 and streak > -5

**posey** · 07-02-14, 11:27 AM

6-2 (2.12, 75.0%)	avg line: 103.2 / -113.2	on / against: +$470 / -$500	ROI: +53.7% / -52.6%
6-2 (2.50, 75.0%)	avg line: -126.3 / 112.6	on / against: +$431 / -$501	ROI: +38.2% / -49.3%
5-3-0 (1.00, 62.5%)	avg total: 7.9	over / under: +$175 / -$255	ROI: +20.1% / -28.7%

**posey** · 07-02-14, 11:29 AM

6-8 (-0.43, 42.9%)	avg line: -123.7 / 113.7	on / against: -$381 / +$303	ROI: -21.9% / +21.6%
5-9 (-1.71, 35.7%)	avg line: 156.9 / -171.9	on / against: -$154 / +$63	ROI: -10.4% / +2.6%
2-12-0 (-1.89, 14.3%)	avg total: 8.9	over / under: -$1,125 / +$990	ROI: -72.3% / +64.9%

Take a look at the OU margin, most times not even close.

**Alex Vaile** · 07-02-14, 11:37 AM

Originally posted by posey

6-8 (-0.43, 42.9%)	avg line: -123.7 / 113.7	on / against: -$381 / +$303	ROI: -21.9% / +21.6%
5-9 (-1.71, 35.7%)	avg line: 156.9 / -171.9	on / against: -$154 / +$63	ROI: -10.4% / +2.6%
2-12-0 (-1.89, 14.3%)	avg total: 8.9	over / under: -$1,125 / +$990	ROI: -72.3% / +64.9%

Take a look at the OU margin, most times not even close.

Ya Happ is tough to get a finger on. Did well in his last start but I'm hoping brewers get to him today. Although judging from your tables it'll b a low scoring game. I just saw Brewers are missing Khris Davis.
You see the query favoring Giants later. Needed that win yesterday right Posey and hopefully today.

**posey** · 07-02-14, 11:39 AM

15-22 (-0.89, 40.5%)	avg line: 104.5 / -114.5	on / against: -$663 / +$475	ROI: -16.9% / +11.0%
14-23 (-0.36, 37.8%)	avg line: -107.7 / -105.8	on / against: -$1,469 / +$1,339	ROI: -29.6% / +27.1%
12-24-1 (-0.59, 33.3%)	avg total: 7.1	over / under: -$1,365 / +$1,060	ROI: -34.3% / +25.5%

11-16 (-0.59, 40.7%)	avg line: 105.0 / -115.0	on / against: -$522 / +$409	ROI: -17.6% / +12.6%
9-18 (-0.31, 33.3%)	avg line: -113.4 / -101.1	on / against: -$1,414 / +$1,264	ROI: -36.9% / +34.2%
7-20-0 (-0.85, 25.9%)	avg total: 7.3	over / under: -$1,445 / +$1,320	ROI: -49.6% / +44.9%

**posey** · 07-02-14, 11:46 AM

Something favoring the As.

8-12 (0.35, 40.0%)	avg line: -175.7 / 156.6	on / against: -$1,369 / +$1,134	ROI: -38.2% / +56.6%
8-12 (-1.15, 40.0%)	avg line: 115.7 / -126.3	on / against: -$253 / +$157	ROI: -11.9% / +6.2%
10-10-0 (0.00, 50.0%)	avg total: 7.5	over / under: -$70 / -$145

**posey** · 07-02-14, 11:50 AM

13-3 (1.62, 81.2%)	avg line: -110.1 / 100.1	on / against: +$1,016 / -$1,106	ROI: +53.8% / -62.3%
11-5 (1.62, 68.8%)	avg line: 104.3 / -117.0	on / against: +$758 / -$823	ROI: +38.4% / -37.5%
7-9-0 (-0.91, 43.8%)	avg total: 8.3	over / under: -$270 / +$150	ROI: -15.3% / +8.5%

**Alex Vaile** · 07-02-14, 02:28 PM

Originally posted by JMon

Ya,, not touching Verlander either for oak for that matter.

Now I found a conflict supporting the Astros as a dog...trying to weighs strength of query.

so far like Twins, SF, and Bos un 9

Well the A's had plenty of chances. But got crushed in this 6th inning. 8 to 2 now wow.

**JMon** · 07-02-14, 03:09 PM

Originally posted by Alex Vaile

Well the A's had plenty of chances. But got crushed in this 6th inning. 8 to 2 now wow.

figures...I didn't play them...lol. Sea up too now

**Alex Vaile** · 07-02-14, 03:13 PM

Originally posted by JMon

figures...I didn't play them...lol. Sea up too now

Ya I guess your queries were on it today. Seattle pulling away. Jays got me on walk off hr and As no good either. Gonna b a grinder today!

**JMon** · 07-02-14, 04:42 PM

Originally posted by JMon

Perfect 10-0 ml and rl this season, fading the astros today

-140<=line<=120 and p:margin<=-4 and pp:margin<=-4 and op:runs>=8 and H and SG<4 and total<11

stays perfect this year

**Hopicap** · 07-02-14, 04:44 PM

Originally posted by JMon

stays perfect this year

Great work man 100% is unprecedented expecially this year

**Alex Vaile** · 07-03-14, 12:20 AM

2 and 1 today on posted plays for + 1 unit
24 and 12 overall
+ 10.45 units

**BasesLoaded314** · 07-03-14, 01:20 AM

woof woof

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

**BasesLoaded314** · 07-03-14, 01:53 AM

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

**Alex Vaile** · 07-03-14, 10:53 AM

Originally posted by BasesLoaded314

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

Looks pretty awesome. Thanks Bases.

**JMon** · 07-03-14, 11:08 AM

line <= -140 and DIV and month = 7 and conference = NL and (SG = 1 or SG = 4) and 2009 <= season

take a NL fav of 140 or more in a divisional game in JULY (series game 1 or 4). decent on the RL too. play LAD

**Alex Vaile** · 07-03-14, 12:06 PM

First posted play 7/3:
Under 7 Yankees vs Twins -110

Based on my favorite Bases query.
Gotta play the Jays too based on his amazing query from today as well