MLB - Situation Plays - SDQL

Alex Vaile · 07-06-14, 01:35 PM

Originally posted by Cougs

Alex, caution, as I believe (someone correct me if i'm wrong)...but that hammer play is not applicable in July or August. too much juice to be playing that one, imo

When I don't play it it hits so I've decided to hammer it. Hope this one comes through as well. Thanks for the info though Cougs. I have been getting burned by big juice plays lately.

posey · 07-06-14, 01:52 PM

17-18 (-0.09, 48.6%)	avg line: 148.0 / -163.3	on / against: +$832 / -$1,122	ROI: +23.8% / -19.5%
22-11 (1.14, 66.7%)	avg line: -157.8 / 145.1	on / against: +$342 / -$508	ROI: +6.6% / -15.3%
16-19-0 (0.49, 45.7%)	avg total: 7.1	over / under: -$450 / +$160	ROI: -11.7% / +4.1%

posey · 07-06-14, 02:17 PM

Not active today, but maybe it comes up a few more times this season:

47-20 (1.70, 70.1%)	avg line: -157.6 / 143.3	on / against: +$1,751 / -$1,979	ROI: +16.6% / -29.5%
33-25 (0.43, 56.9%)	avg line: 112.2 / -122.5	on / against: +$1,199 / -$1,511	ROI: +19.7% / -20.8%
43-19-5 (1.99, 69.4%)	avg total: 7.9	over / under: +$2,155 / -$2,875	ROI: +29.2% / -39.1%

Alex Vaile · 07-06-14, 03:51 PM

Originally posted by Alex Vaile

Hammer play in effect:
I'll make that play #2 and 3 although I hate going against Arrieta who is one or hottest pitchers in the league.
H and p:margin > 7 and op:runs = 0 and season > 2008 and WP < 60 and o:WP > 38.5 and rest = 0

Washington - 173 W
Washington RL + 135 L

2 plays

Hammer play hits again!!
Run line close but no cigar!

Alex Vaile · 07-06-14, 06:17 PM

1 and 3 today got burned late on both totals. -2.2 units
28 and 19 overall
+6.55 units

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

First and second plays today 7/7:
Atlanta Braves -127
Braves RL -1.5 + 135
starter= Mike Minor and s:SWHIP>=2 and s:margin <=5

Alex Vaile · 07-07-14, 11:26 AM

Third posted play:

Under 8 -120 Cubs vs Reds

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)

BasesLoaded314 · 07-07-14, 04:58 PM

hot off the presses

p:HR = 0 and 4 > SG > 1 and op:HR = 0 and SGS = 3 and H and s:SRA < 6 and os:SRA != 0 and os:SWA != 0 and s:SPT > 86 and os:SPT < 122 and 163 > game number > 28 and site streak < 9 and o:site streak > -9 and o

u streak > -7 and tS(hits, N=5) < 55 and tS(hits, N=20) < 198 and oS(hits, N=2) > 8 and oS(hits, N=5) > 29 and oS(hits, N=20) < 202 and oS(hits, N=10) > 66 and oS(runs, N=10) > 25 and oS(runs, N=2) < 15 and oS(runs, N=5) < 34 and tS(runs, N=2) > 1 and tS(runs, N=10) < 55 and 170 > line > -250

s:SRA - os:SRA = -1 and s:SRA > 2 and 3 < s:SHA < 8 and s:SHRA < 3 and 0 < s:SSO < 8 and 32 > s:SHF > 22 and -6 < s:SHA - os:SHA < 4 and P:margin < 10 and 3 < P:hits < 18 and 2 < PP:hits < 18 and oP:hits < 19 and 3 < oPP:hits < 15 and os:SHRA < 3 and os:SPT > 25 and os:SHF > 20 and 4 < o:starter rest < 9 and day != Saturday and -240 < line < 230 and -16 < tS(margin, N=5) < 18 and oS(margin, N=5) > -15 and -20 < oS(margin, N=10) < 40

p:HR = 2 and ppp:HR = 2 and playoffs = 0 and SGS - SG != 1 and 2 < op:hits < 18 and opp:hits < 15 and oppp:hits < 17 and opppp:hits < 12 and oppppp:hits > 5 and os:SHRA < 3 and os:SRA < 7 and os:SSO != 0 and os:SPT > 58 and s:SSO > 2 and streak > -4 and -7 < o:streak < 4 and line < 135

tA(runs) > oA(runs) and STDSWHIP < o:STDSWHIP and 100 > line > -121 and (H or 5 > SG > 1) and (conference = AL or o:conference = NL) and (conference = NL or H) and day != Wednesday and day != Friday and s:SHF > 15 and s:SIP > 3.5 and starter rest < 7 and 4 < o:starter rest < 12 and os:SRA < 7 and os:SHA < 9 and op:HR < 3 and op:hits < 15 and opp:hits > 4

(p:TLOB - op:TLOB) = -1 and 12 > op:hits > 7 and 6 < p:hits < 12 and p:W and day != Saturday and day != Sunday and op:hits - p:hits != 0 and -130 < line < 140 and game number > 52

12 > p:hits > 6 and pp:hits = 9 and H and 0 < SG < 4 and playoffs = 0 and SGS - SG != 0 and day != Tuesday and (game number > 51 or game number < 27) and streak > -6 and -9 < site streak < 7 and -7 < p:margin < 7 and pp:margin < 7

p:HR + op:HR < 2 and H and (SG = 2 or SG = 3) and p:hits + op:hits < 16 and p:hits < 10 and 10 > op:hits > 4 and 27 > pp:hits + opp:hits > 10 and 2 < pp:hits < 18 and 4 < opp:hits < 17 and p:hits + pp:hits > 8 and (os:SHRA = 0 or s:SHRA = 0) and os:SRA + s:SRA > 2 and os:SHA < 11 and s:SHA < 11 and s:SWA != 0 and os:SSO < 10 and 0 < s:SSO < 9 and 8.1 > s:SIP > 5.5 and s:SPT > 82 and os:SPT < 122 and o:starter rest < 14 and opp:HR < 3 and oppp:hits < 18 and (game number < 59 or 161 > game number > 86)

7 > p:BL > 3 and op:BL = 0 and playoffs = 0 and 5 > SG > 1 and (A or SG < 4) and 2 < SGS < 5 and conference = o:conference and streak < 5 and o:streak > -4 and p:margin > 2 and 12 > op:hits > 3 and op:HR < 2 and site streak < 7 and -7 < o:site streak < 9 and opp:hits < 15 and opp:HR < 4 and p:SO < 12 and op:doubles < 5 and s:SRA < 7 and s:SHA > 1 and s:SWA < 6 and s:SHRA < 3 and s:SIP > 3.5 and s:SHF < 33 and s:SPT < 115 and os:SRA < 8 and os:SHA < 11 and os:SSO < 6 and s:SSO < 9 and os:SPT < 112 and (game number < 46 or game number > 73)

SGS = 3 and H and SG = 2 and streak = 1 and o:streak > -5 and o:streak != -2 and p:hits > 4 and p:HR < 4 and p:errors < 2 and p:BPRA < 5 and p:walks != 0 and op:hits > 4 and op:HR < 4 and 0 < op:walks < 8 and p:hits > op:hits and p:HR - op:HR > -2 and 0 < op:SO < 15 and os:SRA != 0 and s:SHA > 2 and s:SHRA < 2 and 2 < os:SHA < 8 and os:SHRA < 3 and os:SHF > 13 and o:starter rest < 13 and s:SIP > 2.9

H and (day = Saturday or day = Sunday) and -3 < streak < 4 and o:streak < 3 and -1 < site streak < 7 and o:site streak > -6 and SGS - SG < 2 and playoffs = 0 and s:SRA < 8 and s:SHA > 1 and s:SWA < 6 and s:SHRA < 2 and 18 < s:SHF < 32 and s:SIP > 4.5 and s:SPT < 121 and starter rest < 7 and (conference = AL or o:conference = NL) and os:SRA != 0 and os:SHA > 3 and o:starter rest < 7 and game number > 15 and oss:SHA < 12 and ss:SIP < 8.1 and 9 > s:starter rest > 4 and os:starter rest < 33 and line < 145 and 4 < op:hits < 16 and 3 < opp:hits < 17 and p:runs < 12 and op:runs < 8 and 0 < p:walks < 8 and op:walks < 8 and tS(margin, N=15) - oS(margin, N=15) > -36 and tS(margin, N=15) < 36 and oS(margin, N=15) > -38

streak = -2 and o:streak = 2 and 4 > SG > 1 and (H or day != Sunday) and (H or conference = NL) and SGS > 2 and 1 < p:hits < 13 and 2 < pp:hits < 13 and ppp:hits > 7 and p:margin > -9 and pp:margin > -11 and opp:margin < 11 and op:hits > 7 and opp:hits < 16 and op:HR + opp:HR != 0 and op:TLOB + opp:TLOB < 22 and 0 < s:SSO < 10 and os:SHRA < 4 and os:SHF < 33 and 4 < o:starter rest < 7 and line < 150

tS(W, N=10) > 5 and oS(W, N=10) = 6 and 4 > SG > 1 and 2 < SGS < 5 and ou streak < 2 and o

u streak < 2 and oS(O, N=10) < 8 and tS(O, N=10) < 8 and -25 < oS(ou margin, N=10) < 28 and -27 < tS(ou margin, N=10) < 30 and s:SHF < 33 and os:SHF < 33 and game number > 18 and (division != AL West or NDIV) and op:HR + p:HR < 7 and 16.9 < (p:SIP + pp:SIP + ppp:SIP + pppp:SIP) < 30.1 and -11 < site streak < 10 and o:site streak > -8 and 0 < s:SSO < 11 and os:SSO < 9 and ss:SSO < 11 and oss:SSO < 11

SG = 2 and streak = 1 and o:streak > -8 and SGS = 3 and -5 < site streak < 9 and p:runs + op:runs > 4 and game number > 37 and line < 120 and 2 < opp:SG < 5 and op:runs != 0 and (tS(margin, N=20) > 15 or tS(margin, N=20) < -1) and -56 < oS(margin, N=20) < 29 and tS(HR, N=20) - oS(HR, N=20) > -9 and tS(runs, N=20) - oS(runs, N=20) > -33 and tS(hits, N=20) - oS(hits, N=20) > -45 and s:SHA > 1 and 0 < s:SSO < 11 and s:SIP > 2.9 and 71 < s:SPT < 113 and os:SWA < 5 and os:SSO < 10 and os:SIP < 7.1 and os:SPT < 113

s:SWA = 2 and 2 < op:walks < 5 and (SG = 1 or SG = 3) and (A or day != Tuesday) and streak > -3 and o:streak < 3 and p:hits > 3 and 5 < pp:hits < 18 and s:SRA < 7 and s:SSO < 8 and 67 < s:SPT < 108 and starter rest < 8 and os:SPT < 122 and line > -200 and conference = o:conference and os:SRA + os:SWA > 1 and ss:SWA > 0 and ss:SRA < 7 and ss:SPT > 87 and s:SIP < 8 and s:SHF > 17 and ss:SHF > 21 and game number < 155 and ppp:hits < 19 and op:hits < 16 and opp:hits < 19

Alex Vaile · 07-07-14, 10:17 PM

0 and 3 again. -3.4 units
28 and 22 overall

+ 3.15 units

emceeaye · 07-08-14, 11:49 AM

good record but....

Here is one of Bases' active today:

p:runs = 6 and os:SRA = 2 and season>2007 and A and (SG = 2 or SG = 3) and conference = o:conference and 2 < SGS < 5 and os:SHA < 8 and os:SHRA < 2 and os:SWA < 3 and os:SPT < 116 and line > -155 and op:runs != 0 and op:errors < 3 and division != AL West

Alex Vaile · 07-08-14, 01:53 PM

First posted play for 7/8:

Over 7 -105 Atlanta vs Mets
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-08-14, 01:57 PM

Originally posted by emceeaye

Here is one of Bases' active today:

p:runs = 6 and os:SRA = 2 and season>2007 and A and (SG = 2 or SG = 3) and conference = o:conference and 2 < SGS < 5 and os:SHA < 8 and os:SHRA < 2 and os:SWA < 3 and os:SPT < 116 and line > -155 and op:runs != 0 and op:errors < 3 and division != AL West

Wow that's an amazing record. Morales sucks but you gotta go with the rockies here. Best of luck. I've been getting crushed last few days.

JMon · 07-08-14, 02:21 PM

perfect situation this year is active today...fading Verlander

-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-08-14, 02:43 PM

Originally posted by JMon

perfect situation this year is active today...fading Verlander

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

Verlander in interleague play

conference!=o:conference and starter='Justin Verlander' and H and team=Tigers

emceeaye · 07-08-14, 03:38 PM

Originally posted by JMon

Verlander in interleague play

conference!=o:conference and starter='Justin Verlander' and H and team=Tigers

Damn, I was getting so excited to go against Verlander...but in defense of your first query on this game, I feel like Verlander has not played as poorly in previous seasons compared to this one. And Ryu has been one of the most consistently solid pitchers on his team maybe 2nd only to Greinke. Plus, Dodger bats are pretty hot lately....tough call.

Alex Vaile · 07-08-14, 04:17 PM

2 Unders for today:

Phillies vs Brewers Under 8.5 -120
Orioles vs Nationals Under 8 -110

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

Already 1 and 0 today with reds under. Good luck

Alex Vaile · 07-08-14, 04:28 PM

Originally posted by emceeaye

Damn, I was getting so excited to go against Verlander...but in defense of your first query on this game, I feel like Verlander has not played as poorly in previous seasons compared to this one. And Ryu has been one of the most consistently solid pitchers on his team maybe 2nd only to Greinke. Plus, Dodger bats are pretty hot lately....tough call.

Ya Verlander been money against the NL. I like Detroit today

JMon · 07-08-14, 04:51 PM

Originally posted by emceeaye

Damn, I was getting so excited to go against Verlander...but in defense of your first query on this game, I feel like Verlander has not played as poorly in previous seasons compared to this one. And Ryu has been one of the most consistently solid pitchers on his team maybe 2nd only to Greinke. Plus, Dodger bats are pretty hot lately....tough call.

Ya me too. Laid off. I do hope the perfect situation this year, stays perfect!!!

JMon · 07-09-14, 07:48 AM

check out how the Tigers (team=Tigers) do within this interleague situation on the ML, RL and over

H and t:conference=AL and .279>=Sum(hits@team and season)/Sum(at bats@team and season)>=.265 and o:conference=NL and o:STDSERA<=2.70 and month<=7

1TimeLucky1 · 07-09-14, 08:51 AM

Any chance you could throw a newb a bone and translate. I don't speak sdql but I'll get Rosetta with my winnings

Please see understand that was an attempt at humor and not a dis. A dude on the other site was using but he has slipped off the radar. It has led me to you guys.

JMon · 07-09-14, 11:18 AM

Home
AL team
BA .279>=>.265
Against NL team
Opposing Pitcher era of <=2.70
First half of season

Alex Vaile · 07-09-14, 11:24 AM

1 and 1 yesterday for -.2 units
Overall 29 and 23 for + 2.95 units.

First plays today are on
Cincinnati - 151
Cincinnati -1.5 + 145
starter=Alfredo Simon and oA(SO)>=7.5 and line <150

Alex Vaile · 07-09-14, 11:25 AM

Originally posted by JMon

Ya me too. Laid off. I do hope the perfect situation this year, stays perfect!!!

Well must be some magic as the record continues for Verlander!

1TimeLucky1 · 07-09-14, 11:26 AM

Thank you for the breakdown are you playing or fading?

1TimeLucky1 · 07-09-14, 11:31 AM

Alex I'm on cinci as well but I am a lil concerned. Played them when line first came out at-175 with local line is now -149 which is inline with what you have, but to see the line drop like that on a guy with 1 start and a deflated team vs my ace worries me. Any comment on the drop?

Alex Vaile · 07-09-14, 11:39 AM

Originally posted by 1TimeLucky1

Alex I'm on cinci as well but I am a lil concerned. Played them when line first came out at-175 with local line is now -149 which is inline with what you have, but to see the line drop like that on a guy with 1 start and a deflated team vs my ace worries me. Any comment on the drop?

Alfredo Simon is now 16 and 0 in this situation facing a team that strikes out more than 7 times a game. The opposition pitcher has only pitched 1 game but did well. Simon is one of the best pitchers in the league no one knows about and sometimes people see a big favorite they don't recognize and go the other way hence the line movement. That's my opinion. Best of luck to u Lucky!

Alex Vaile · 07-09-14, 11:41 AM

Originally posted by JMon

check out how the Tigers (team=Tigers) do within this interleague situation on the ML, RL and over

H and t:conference=AL and .279>=Sum(hits@team and season)/Sum(at bats@team and season)>=.265 and o:conference=NL and o:STDSERA<=2.70 and month<=7

JMon it looks pretty good for Tigers. But I heard they're resting some of their best bats. Does that affect your play on Tigers?

1TimeLucky1 · 07-09-14, 11:45 AM

You to my man sorry for intruding on the thread but I'm leaning making the purchase and the plunge into sdql. Hope you guys don't mind if i tag along. Made the switch from covers and I like what I see.

The other game I like is cws, any chance you have looked or have info on that game

Alex Vaile · 07-09-14, 12:00 PM

Originally posted by 1TimeLucky1

You to my man sorry for intruding on the thread but I'm leaning making the purchase and the plunge into sdql. Hope you guys don't mind if i tag along. Made the switch from covers and I like what I see.

The other game I like is cws, any chance you have looked or have info on that game

All good my friend. I did the same as you a few months back. Some of these guys in this thread are very knowledgeable about sdql and all the queries. I'm still learning and I use their queries and try to offer up some plays using mostly other people's info. This thread is all positive and it's all for helping each other out. I don't have any info sdql on white sox but I'll try to find something for you.

Alex Vaile · 07-09-14, 12:05 PM

Two more plays for today:
Under 8.0 even= Marlins vs Dbacks
Under 7.5 - 125= Twins 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 · 07-09-14, 12:56 PM

starter= Chris Sale and AF and season > 2012 not great results limited sample
starter= Rubby De La Rosa and HD only 1 game
team=Red Sox and HD and season > 2012
team=White Sox and AF and season > 2012

starter = Chris Sale and AF is only 6 and 10
I couldn't find much info to support White Sox. Sale in this situation not great. None of the queries point strongly to either side. Best of luck

JMon · 07-09-14, 04:14 PM

Originally posted by JMon

check out how the Tigers (team=Tigers) do within this interleague situation on the ML, RL and over

H and t:conference=AL and .279>=Sum(hits@team and season)/Sum(at bats@team and season)>=.265 and o:conference=NL and o:STDSERA<=2.70 and month<=7

ML and RL winner

Alex Vaile · 07-09-14, 05:25 PM

Originally posted by JMon

ML and RL winner

I went with Detroit after seeing your query. Thanks Jmon

b1slickguy · 07-09-14, 06:47 PM

Not active today.
"Sounds like somebody's got a case of the Mondays" trend.

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

Another that is not active today.
Caution: this season only.
Good luck.

A and line<-105 and op:runs=0 and season=2014 and SG>1

Alex Vaile · 07-09-14, 10:59 PM

3 and 1 today + 2.2 units
32 and 24 overall
+ 5.15 units

Alfredo Simon situation now 16 and 0