MLB - Situation Plays - SDQL

Alex Vaile · 07-03-14, 12:08 PM

Originally posted by JMon

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

I didn't see your query but did a bit of research on my own and went with dodgers today too. Rockies in shambles. Greinke lost there a month ago but I bet there's a better performance today. Good luck Jmon!

BasesLoaded314 · 07-04-14, 03:33 AM

heres the motherlode.... happy 4th everyone!!

[B]remove the phrase “p:inning runs” when it appears & causes errors, it is redundant.

Probation:

month = 6 and F and o:streak = 1 and SG != 1 and -120 > line and os:SRA < 7 and oss:SRA < 9 and s:SRA < 8 and ss:SRA != 0 and site streak < 6 and p:margin > -4

month = 6 and streak = 1 and F and 7 > s:SRA and 8 > os:SRA and (ss:SRA != 1 or ss:SRA != 2) and (sss:SRA > 4 or sss:SRA < 3) and SG < 4 and 15 > p:hits > 5 and op:hits > 6 and 14 > pp:hits and 26 > op:LOB > 5

month = 6 and season > 2009 and F and (SG = 2 or SG = 3) and day != Sunday and 14 > p:hits > 3 and 10.01 > total > 6.49 and op:hits < 17 and pp:hits < 12 and opp:hits > 3 and ppp:hits > 2 and 9 > os:SSO > 0 and oss:SSO < 7 and 15 > streak > -4 and 5 > o:streak > -6 and 10.01 > p:total > 6.49 and o

u streak > -5 and 2 > (tA(runs) + oA(runs) - total) > -.6 and team != Astros and team != Brewers and o:team != Rockies and o:team != Red Sox and o:team != Marlins

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

s:SRA = 1 and s:SIP < 7 and s:SHA < 7 and s:SWA < 6 and 0 < s:SSO < 8 and 74 < s:SPT < 109 and starter rest < 10 and day != Wednesday and day != Thursday and 6 < p:hits < 18 and 3 < pp:hits < 14 and 2 < ss:SHA < 11 and ss:SPT < 116 and op:hits < 14 and op:HR < 3 and month != 5 and os:SRA < 6 and os:SPT > 85

SG = 1 and (A or site != p:site) and 10 > s:SRA > 3 and 75 > game number > 56 and 8 > ss:SRA > 1 and sss:SRA < 6 and line < 199 and os:SRA < 9 and oss:SRA < 7 and op:margin < 6 and p:hits < 16 and o:starter rest < 11 and s:SPT < 110 and (starter wins - starter losses) > -6

175 >= line >= 135 and t:conference = AL and tA(runs) <= 4.5 and p:L and p:margin >= -2 and 9 * oS(o:earned runs - starter earned runs) / oS(9 - starter innings pitched) <= 3.75 and SG > 1 and day != Saturday and 2006 <= season

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

month = 6 and streak = 2 and 3.01 > (p:innings pitched - Starter

:innings pitched) > 1.32 and s:SRA < 5 and 163 > line > -236 and 8 > os:SRA > 2 and 8 > oss:SRA and SG != 3 and 10 > ss:SHA > 2 and oA(hits, N=10) < 10.6

season = 2014 and A and 6 < p:hits < 13 and op:hits < 12 and p:HR < 3 and op:HR < 3 and s:SHA > 2 and os:SWA < 5 and s:SWA < 5 and 30 < s:batters faced < 51 and 32 < os:batters faced < 40

month = 6 and season > 2009 and F and (SG = 2 or SG = 3) and day != Sunday and 14 > p:hits > 3 and 10.01 > total > 6.49 and op:hits < 17 and pp:hits < 12 and opp:hits > 3 and ppp:hits > 2 and 9 > os:SSO > 0 and oss:SSO < 7 and 15 > streak > -4 and 5 > o:streak > -6 and 10.01 > p:total > 6.49 and o

u streak > -5 and (2 > (tA(runs) + oA(runs) - total) > 1 or 4.6 > tA(runs) > 4.2)

Caution

H and streak = -1 and (SG = 2 or SG = 3) and 75 < s:SPT < 113 and starter rest < 21 and 4 < o:starter rest < 23 and playoffs = 0 and SGS < 5 and 88 < ss:SPT < 124 and s:SHA > 4 and 7 > s:SRA > 0 and 4 < ss:SHA < 10 and (p:BPRA + op:BPRA) < 9 and (p:HR + op:HR) < 5 and tA(doubles, N=10) < 2.5 and p:hits < 13 and day != Friday and (game number > 79 or game number < 60) and rest = 0 and .5 < oA(BPRA, N=10) < 2.3 and s:batters faced < 49 and 29 < os:batters faced < 49 and (p:start time - start time) < 700

s:SO > 9 and s:W and A and season > 2005 and -185 <= line <= -110 and conference = o:conference and starter rest < 10 and rest = 0 and SG < 3 and month < 9 and 10 >= total >= 7.5

streak = 1 and SG = 2 and s:earned runs < 9 and s:SHA < 10 and ss:SHA < 12 and 0 < os:SRA < 7 and 63 < s:SPT < 117 and 9.76 > oA(hits, N=4) > 5.76 and 5.0 > oA(walks, N=10) > 2.1 and o:streak > -7 and 2.2 < oA(runs, N=7) < 5.99 and 18 > p:hits > 3 and line > -225 and 1.7 > oA(HR, N=10) > .5 and tA(HR, N=10) > .3 and 2.6 > oA(doubles, N=10) > 1.05 and op:walks != 0 and STDSWHIP > .95 and o:STDSWHIP < 1.8 and ou streak > -6 and o

u streak < 4 and p:rest < 3 and (STDSERA < 1.58 or STDSERA > 2.71) and (85 > game number > 11 or game number > 101)

s:SRA < 2 and 5 > ss:SRA > 0 and sss:SRA < 4 and ssss:SRA < 6 and 0 < sssss:SRA < 8 and os:SRA < 5 and SG < 4 and day != Tuesday and day != Thursday and 4 < starter rest < 10 and o:starter rest < 11 and 161 > game number > 27 and line > -165 and 2 > p:margin > -9 and op:hits > 4 and opp:hits < 16 and (s:SWA + ss:SWA + sss:SWA + ssss:SWA) > 2 and os:SSO < 10 and s:SSO < 12 and ss:SSO > 0 and 0 < sss:SSO < 13 and (line < -117 or line > 99 or line = -110)

s:SHRA = 0 and ss:SHRA = 1 and sss:SHRA = 1 and SG < 4 and starter rest < 10 and s:SIP < 7.5 and s:SRA < 4 and ss:SRA < 9 and op:HR < 2 and p:HR < 3 and pp:HR < 3 and 3 < p:hits < 18 and 2 < pp:hits < 16 and ppp:hits > 2 and op:hits < 18 and opp:hits < 17 and oppp:hits < 18 and 1 < os:SHA < 9 and 1 < oss:SHA < 8 and os:SWA < 5 and os:SPT < 119 and day != Thursday and line < 200

6 > p:inning runs p:R1 > 1 and 2 < p:runs < 10 and 18 > p:hits > 9 and (SG = 1 or SG = 3) and 7 > SGS > 2 and s:SRA < 6 and 3 < s:SHA < 9 and s:SWA != 3 and 0 < s:SSO < 10 and s:SPT < 123 and starter rest > 4 and -3 < streak < 5 and 3 < os:SHA < 11 and os:SRA != 0 and os:SSO < 9 and op:runs < 14 and (line > 122 or line < 105) and game number > 14 and 1 < oA(doubles, N=10) < 2.8

(s:SPT + ss:SPT) > 222 and s:SPT > 96 and ss:SPT < 132 and 58 < sss:SPT < 123 and s:SHA < 8 and s:SRA < 6 and ss:SRA < 7 and sss:SRA < 6 and ss:SHA > 3 and 7 > s:SWA > 0 and ss:SWA < 6 and sss:SWA < 4 and starter rest < 9 and s:starter rest < 8 and s:SSO > 3 and 12 > ss:SSO > 2 and total < 11 and p:hits < 16 and 19 > pp:hits > 3 and 1 < ppp:hits < 22 and streak < 6 and ou streak > -5 and game number > 30 and 8 > os:SRA > 0 and 14 > o:starter rest > 4 and 23 > os:starter rest > 3 and 24.5 > (s:SIP + ss:SIP + sss:SIP) > 16 and (os:SIP + oss:SIP + osss:SIP) > 11.35 and o:streak < 5 and oA(hits, N=10) < 11 and tA(doubles, N=10) < 2.9 and tA(BPRA, N=10) < 2.5 and oA(BPRA, N=10) > .4

1.8 > tA(runs, N=10) - oA(runs, N=10) > -.2 and H and tA(hits, N=10) - oA(hits, N=10) < 2.2 and 3 < s:SRA < 8 and s:SWA < 6 and os:SRA < 7 and 15 > op:hits > 9 and 1.7 > oA(HR, N=10) > .6 and SG < 3 and line < 115 and os:SPT > 75 and 4 < starter rest < 7 and o:starter rest < 7 and day != Saturday and tA(doubles, N=10) < 2.8 and tA(SO, N=10) > 5.4 and STDSWHIP > 1.04

month = 6 and F and o:streak = 1 and SG != 1 and -120 > line and os:SRA < 7 and oss:SRA < 9 and s:SRA < 8 and ss:SRA != 0 and site streak < 6 and op:BPRA < 4

s:SHRA = 1 and 7.01 > s:SIP > 6.5 and s:SHA > 3 and s:SWA < 3 and 82 < s:SPT < 107 and s:SRA < 4 and s:SSO < 9 and (s:SG = 3 or s:SG = 1) and SG < 4 and 4 < starter rest < 8 and p:HR < 3 and pp:HR < 4 and 2 < p:hits < 15 and 3 < pp:hits < 14 and ppp:hits < 15 and p:walks < 8 and day != Tuesday and day != Thursday and day != Sunday

p:W and 10 > p:M8 > 6 and 3 < p:M7 < 11 and 0 < p:M6 < 9 and p:M5 < 6 and SGS - SG < 3 and (SG = 2 or SG = 3) and 0 < p:HR < 4 and p:doubles < 6 and p:ground balls < 17 and s:SRA < 6 and s:SHA > 2 and s:SHRA < 3 and starter rest < 13 and 8.01 > s:SIP > 4 and -210 < line < 170

AF and SGS = 3 and 5 < p:hits < 17 and 3 < pp:hits < 17 and 5 < ppp:hits < 20 and 5 < pppp:hits < 19 and ppppp:hits > 1 and 4 < op:hits < 17 and 2 < opp:hits < 12 and 2 < oppp:hits < 15 and 3 < opppp:hits < 14 and 1 < oppppp:hits < 19 and 5 < tS(HR, N=10) < 21 and tS(hits,N=10) > 71 and 10 < tS(doubles, N=10) < 32 and 2 < oS(HR, N=10) < 17 and 73 < oS(hits,N=10) < 112 and 24 < tS(runs, N=10) < 72 and tS(margin, N=10) < 18 and 27 > oS(margin, N=10) > -31 and 31 < p:at bats + p:walks < 48 and op:at bats + op:walks > 31 and (pp:at bats + pp:walks) < 43 and (opp:at bats + opp:walks) < 45 and 28 < (oppp:at bats + oppp:walks) < 47 and 31 < (ppp:at bats + ppp:walks) < 45 and line > -186 and 29 < (opppp:at bats + opppp:walks) < 48 and 31 < (pppp:at bats + pppp:walks) < 50 and tS(runs, N=10) - oS(runs,N=10) > -14 and streak > -5

-6 > p:margin > -10 and SG < 4 and day != Tuesday and month < 9 and s:SRA < 6 and ss:SRA < 7 and sss:SRA < 7 and os:SRA != 0 and os:SRA < 8 and line > -200 and p:hits < 13 and op:hits < 19 and opp:hits < 14 and oA(hits, N=10) < 11.5 and tA(runs, N=10) < 5.9 and total < 11.5 and tA(doubles, N=10) > 1 and oA(doubles, N=10) < 2.9 and 57 < s:SPT < 113 and os:SPT > 56 and starter rest < 11

month = 6 and H and (STDSERA + o:STDSERA) > 8.3 and s:SRA = 0 and total > 7 and os:SRA != 0

(SG = 2 or SG = 3) and SGS - SG < 2 and (p:runs + op:runs) < 6 and (p:HR + op:HR) < 2 and H and pp:HR < 4 and opp:HR < 5 and s:SHRA < 4 and os:SHRA < 3 and ppp:HR < 4 and pppp:HR < 4 and p:runs < 4 and op:runs < 7 and opp:runs < 11 and (pp:runs + opp:runs) > 2 and streak < 3 and o:streak > -4 and ou streak > -4 and o

u streak > -6 and opp:SG != 4 and p:hits < 10 and (p:hits - op:hits) > -9 and op:TLOB > 2 and tA(doubles, N=10) < 2.5 and oA(doubles, N=10) < 2.5 and (game number > 64 or game number < 54) and starter rest > 4 and o:starter rest < 29 and 28.9 > (p:SIP + pp:SIP + ppp:SIP + pppp:SIP) > 18.9 and (p:SIP + pp:SIP + ppp:SIP) > 14.9 and (s:SSO + ss:SSO) < 18 and -12 < tS(ou margin, N=10) < 24 and STDSERA + o:STDSERA > 3.07 and o:game number > 28

New Brew

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.

s:SIP = 9.0 and starter rest = 6 and 9 > s:SHA > 2 and s:SRA < 2 and s:SSO < 9 and line < 121 and SGS != 2 and day != Sunday

starter rest = 6 and s:starter rest = 6 and ss:starter rest < 9 and o:starter rest > 5 and os:starter rest = 5 and total > 7 and s:SRA < 7 and s:SHA < 8 and 0 < s:SWA < 6 and 1 < s:SSO < 9 and os:SRA != 0 and os:SHA < 11 and os:SSO < 10 and os:SHRA < 3 and SGS > 2 and ss:SRA < 6 and 3 < ss:SHA < 10 and 71 < s:SPT < 117 and 59 < os:SPT < 110 and month != 7

s:SIP = 6 and os:SIP = 5 and 2 < s:SRA < 6 and s:SSO < 6 and 116 > s:SPT > 82 and starter rest < 8 and line > -171 and os:SRA > 1 and os:SHA > 2 and 0 < os:SWA < 6 and os:SHRA < 3 and os:SPT > 75 and month != 4 and day != Thursday

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

p:margin = -4 and s:SHRA = 0 and 5 > SGS > 2 and 3 < p:hits < 8 and SG != 4 and p:HR < 2 and 0 < op:HR < 3 and os:SHRA < 3 and 1 < os:SHA < 9

AD and DIV and month = 8 and SG < 4 and day != Sunday and day != Monday and p:HR < 2 and op:HR < 3 and 0 < pp:HR < 4 and line < 191 and p:hits > 4 and op:hits < 14

s:SRA = 1 and s:SIP < 7 and s:SHA < 7 and s:SWA < 6 and 0 < s:SSO < 8 and 74 < s:SPT < 109 and starter rest < 10 and day != Wednesday and day != Thursday and 6 < p:hits < 18 and 3 < pp:hits < 14 and game number < 165 and (game number < 79 or game number > 89) and (game number > 28 or game number < 20) and line > -220 and -5 < streak < 5 and o:streak < 4 and op:hits < 15

H and SG = 1 and p:margin = 1 and op:hits < 13 and 0 < op:runs < 7 and p:HR - pp:HR > -2 and opp:hits < 11 and (p:A or op:A) and game number < 160 and (game number < 35 or 108 > game number > 53 or game number > 135) and line < 125 and o:starter rest < 9 and os:SPT < 108

(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

1 > sA(o:R1, N=10) > .5 and 6 > sA(SHA, N=10) > 4.4 and sA(SHRA, N=10) < 1 and 1.1 < sA(SWA, N=10) < 1.8 and s:SRA < 7 and s:SPT < 111 and s:SWA < 3 and (SGS = 3 or SGS = 4) and month < 10 and p:HR < 3 and os:SHRA <2

H and .5 < tA(HR, N=10) < 1.1 and p:HR < 2 and 1.6 > oA(HR, N=10) > .8 and op:HR < 2 and s:SHRA < 2 and os:SHRA < 2 and ss:SHRA = 0 and opp:HR < 2 and p:hits < 16 and op:hits > 5 and opp:hits > 4 and oppp:hits > 5 and 2 < opppp:hits < 18 and s:SPT < 111 and 74 < ss:SPT < 115 and starter rest < 8 and o:starter rest < 8 and SGS != 2 and day != Saturday and p:BPRA < 4

p:runs = 6 and os:SRA = 2 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

p:RMAX = 1 and p:runs = 2 and SG < 4 and SGS = 3 and op:runs < 5 and 0 < po:runs < 5 and op:HR < 2 and op:hits > 2 and 3 < p:hits < 13 and tS(HR, N=4) < 7 and 3 < oS(HR, N=10) < 14 and tS(hits, N=10) < 103 and oS(hits, N=10) < 104 and -23 < oS(ou margin, N=10) < 16 and os:SHRA < 3 and day != Wednesday and 0 > o

u streak > -6 and p:doubles < 4 and s:SHF < 33 and os:SHF < 33 and s:SPT < 115 and o:starter rest < 16

(p:inning runs p:R8 + p:inning runs p:R9) = 1 and SG < 5 and SG != 3 and SGS < 5 and -6 < p:margin < 10 and (conference = AL or o:conference = NL) and p:BPRA < 3 and p:HR < 3 and p:SIP > 5.9 and (p:TLOB + p:runs) > 8 and (pp:TLOB + pp:runs) > 4 and 2 < s:SHA < 10 and s:SWA < 5 and 6 > s:margin > -8 and starter rest < 25 and s:SPT < 112 and STDSWHIP > .94 and 45 > s:batters faced > 31 and day != Saturday and ss:SHA < 9 and ss:SWA != 0 and (ss:SPT < 61 or 113 > ss:SPT > 92) and -220 < line < 190 and pp:BPRA < 8 and ppp:TLOB + ppp:runs < 21

(p:inning runs p:R1 + p:inning runs p:R2 + p:inning runs p:R3) = 3 and SGS = 3 and day = Tuesday and (A or conference = o:conference) and -130 < line < 157 and p:margin > -5 and 15 > op:hits > 5 and -4 < o:streak < 4

(p:inning runs p:R1 + p:inning runs p:R2 + p:inning runs p:R3 + p:inning runs p:R4 + p:inning runs p:R5) = 0 and day = Tuesday and SG = 2 and SGS = 3 and (A or conference = AL) and p:inning runs p:R9 < 3 and p:inning runs p:R8 < 2 and p:inning runs p:R7 < 5 and p:margin > -5 and 2 > streak > -5 and line > -115 and o:streak < 4

site streak = -4 and -3 < streak < 2 and -7 < o:streak < 5 and -5 < p:margin < 4 and -4 < pp:margin < 7 and day != Monday and s:SRA < 5 and 14 > p:hits > 2 and pp:hits > 4 and p:TLOB < 11 and -175 < line < 195 and o:site streak > -6 and tS(margin, N=10) > -7 and ppp:hits < 16 and 4 < pppp:hits < 14 and ss:SRA < 7

A and -7 < site streak < -4 and SG > 2 and 4 > tS(runs, N=14) - oS(runs, N=14) > -26 and p:margin < 5 and 6 < p:hits < 13 and 3 < pp:hits < 10 and os:SRA < 6 and os:SHA < 8 and os:SHRA < 2 and os:SIP > 4 and o:starter rest < 7 and oS(margin, N=14) < 25

29 > tS(margin, N=20) - oS(margin, N=20) > -11 and -47 < tS(hits, N=20) - oS(hits, N=20) < -3 and A and SGS = 4 and (day = Thursday or day = Wednesday or day = Tuesday) and -5 < streak < 6 and -3 < o:streak < 5 and -4 < p:margin < 7 and line > -135

4 > site streak > 0 and -1 > o:site streak > -5 and H and SGS < 4 and day != Saturday and op:hits > 6 and 1 < opp:hits < 13 and 1 < p:hits < 16 and pp:hits < 17 and (conference = NL or o:conference = AL) and -230 < line < 130 and streak > -2 and o:streak < 2 and op:margin > -8 and 0 < s:SRA < 7 and os:SHA > 1 and os:SHRA < 2 and os:SWA < 6 and 33 > os:SHF > 21 and os:SSO < 10 and 4 < starter rest < 7

SG = 2 and H and p:runs + op:runs = 5 and SGS = 3 and 9 < p:hits + op:hits < 19 and p:hits < 10 and op:hits > 3 and s:SRA < 6 and os:SHA < 10 and p:errors + op:errors < 3 and p:errors < 2 and 6.5 < total < 10 and pp:SG != 2 and opp:SG > 2 and season > 2007

9 < p:hits < 12 and SG = 3 and 5 < op:hits < 8 and (site = away or conference = AL) and conference = o:conference and p:margin < 6 and pp:margin < 6 and opp:hits > 6 and p:runs > 1 and pp:runs > 0 and 4 < op:runs + opp:runs < 16

H and (SG = 2 or SG = 3) and day != Saturday and p:HR < 3 and op:HR < 2 and 2 < p:hits < 10 and 4 < op:hits < 13 and pp:HR < 4 and opp:HR < 3 and 2 < pp:hits < 13 and 4 < opp:hits < 17 and -3 < ou streak < 4 and -6.5 < p

u margin < 3.5 and pp:SG != 2 and 4 > ppp:SG > 1 and opp:SG < 4 and 3 < ppp:hits < 19 and 1 < oppp:hits < 16 and p:runs + op:runs < 11 and tA(HR, N=10) < 1.9 and oA(HR, N=10) < 1.6 and 1 < os:SRA < 7 and os:SHA > 2 and os:SHRA < 2 and 35 > os:SHF > 16 and os:SPT < 110

4 < so:inning runs so:R1 < 9 and s:SRA < 10 and s:SPT < 110 and starter rest < 40 and s:SHRA < 3 and SG != 3 and (game number > 118 or game number < 107) and os:SRA < 7 and os:SHA > 2 and os:SSO < 10 and os:SHRA < 3 and ou streak > -3

tA(doubles, N=10) < 1.9 and 8.9 < tA(hits, N=10) < 10.4 and .5 < tA(HR, N=10) < 1.3 and 1 < oA(doubles, N=10) < 1.7 and oA(hits, N=10) < 9.9 and oA(HR, N=10) < 1.1 and SG < 4 and 5 > SGS > 2 and p:HR < 3 and p:hits < 15 and 18 > pp:hits > 4 and 3 < ppp:hits < 16 and 3 < pppp:hits < 13 and ppppp:hits < 15 and pppppp:hits < 15 and ppppppp:hits > 6 and op:hits < 13 and s:SRA < 7 and s:SHRA < 2 and os:SRA < 8 and os:SPT < 122

p:margin = -1 and s:SHRA = 0 and (SGS = 3 or SGS = 4) and 2 < p:hits < 8 and p:HR < 2 and p:walks < 4 and p:SO < 13 and os:SHRA < 3 and o:starter rest < 11 and 93 < os:SPT < 112 and op:BPRA < 5 and op:hits < 15 and o:streak < 5 and tA(margin, N=10) > -2.1 and oA(margin,N=10) > -2.1 and oA(hits, N=10) > 7 and oA(BPRA, N=5) > .5

tS(margin, N=20) - oS(margin, N=20) > 16 and tS(hits, N=20) - oS(hits, N=20) > -12 and H and SG = 2 and SGS > 2 and 0 < p:margin < 10 and 19 > p:hits > 6 and p:walks < 7 and p:TLOB > 5 and 5 < p:ground balls < 17 and op:hits > 3 and 0 < s:SRA < 6 and 3 < s:SHA < 10 and s:batters faced < 49 and s:SPT < 119 and line < 135 and oS(runs, N=10) < tS(runs, N=10)

s:SHRA = 0 and SG = 2 and os:SHRA = 1 and SGS < 5 and -2 < streak < 2 and -7 < o:streak < 5 and p:HR < 4 and 5 < p:hits < 17 and p:doubles < 6 and os:SRA < 7 and os:batters faced > 33 and conference = o:conference and s:SPT > 50 and 2.5 < s:SIP < 7.5 and s:batters faced > 33 and 80 < os:SPT < 105

p

IV and D and p:W and o:WP >= 40 and o:WP <= 50 and total < 11 and DIV and p:HR < 3 and op:HR < 2 and -9 < o:streak < 0 and os:SRA > 0 and os:SHA > 2 and 3 < s:SHA < 11 and os:SSO < 11 and 73 < s:SPT < 113 and os:SPT > 67 and p:hits < 18

-171 < line < 140 and -12 < p:margin < -1 and -10 < pp:margin < -2 and op:runs > 7 and H and SGS < 4 and total < 11 and p:HR < 2 and op:HR < 4 and pp:runs < 6 and 2 < opp:runs < 12 and streak > -8 and site streak < 7

SG = 3 and H and -2 < p:margin < 4 and pp:margin < 7 and p:hits < 8 and 3 < op:hits < 12 and day != Thursday and pp:hits > 2 and opp:hits < 17 and 1 < p:HR + pp:HR + op:HR + opp:HR < 5 and s:SHA > 2 and 33 > os:SHF > 19 and 18 < s:SHF < 33 and 3.8 < s:SIP < 7.5 and 74 < os:SPT < 114 and s:SPT < 119

day = Sunday and (SG = 2 or SG = 3) and 0 < s:SRA < 8 and 0 < os:SRA < 6 and (163 > game number > 126 or 103 > game number > 77) and starter rest < 11 and 113 > s:SPT > 58 and 118 > os:SPT > 52 and (H or F) and (s:SWA + ss:SWA + sss:SWA) > 1 and 3.9 > (tA(BPRA) + oA(BPRA)) > 2.1 and (s:SHRA + ss:SHRA + sss:SHRA + ssss:SHRA) < 6 and os:SHRA < 3 and (p:HR + pp:HR + ppp:HR + pppp:HR) < 9 and streak > -5 and o:streak > -7 and o

u streak < 3 and (p:fly balls + pp:fly balls + ppp:fly balls) > 9 and (op:fly balls + opp:fly balls + oppp:fly balls + opppp:fly balls) > 14 and 3 < (s:SSO + ss:SSO) < 17 and os:SSO < 9

BasesLoaded314 · 07-04-14, 03:35 AM

month = 7 and F and season > 2007 and -149 > line > -190 and s:SRA < 6 and ss:SRA < 7 and 2.5 > STDSWHIP > 1.1 and day != Monday and day != Tuesday and conference = o:conference and (p:hits + pp:hits) < 28 and WP < 59 and (starter wins - starter losses + o:starter losses - o:starter wins) > -2
Overs
SG = 4 and SGS = 4 and H and p:HR != 0 and op:HR = 0 and pp:HR < 4 and opp:hits > 4 and op:hits < 11 and p:hits < 14 and s:SRA < 6 and os:SRA > 0 and s:SHA > 4 and os:SHA < 10

(ou streak = 4 or ou streak = 5) and s:SRA < 5 and os:SRA < 6 and SGS = 4 and 85 < s:SPT < 112 and starter rest < 8 and op:HR < 4 and o

u streak < 7
(ou streak + o

u streak) = 1 and SG = 1 and H and -2 < ou streak < 4 and 5 > s:SWA > 1 and p:HR < 2 and 4 > SGS > 1 and 7 > o:starter rest > 4
(SG = 1 or SG = 4) and H and 10.5 > total > 7 and 12.6 > oA(hits, N=10) > 9.1 and 9.2 < tA(hits, N=10) < 12.6 and 12 > s:SHA > 4 and s:SRA != 0 and s:SPT > 83 and 119 > os:SPT > 69 and o:starter rest < 10 and 19 > p:hits > 4 and op:hits > 4 and oA(walks, N=10) < 4.7 and ss:SPT < 116 and oA(HR, N=10) < 1.8 and tA(HR, N=10) < 2 and p:HR < 4 and oA(errors, N=10) < 1.1 and tA(errors, N=10) > .1
(SG = 1 or SG = 4) and H and 6 > ou streak > -2 and s:SRA < 6 and s:SPT > 50 and ss:SPT > 48 and os:SPT < 114 and oss:SPT < 107 and starter rest < 9 and p:runs < 10 and pp:runs < 12 and 3 < (op:runs + opp:runs) < 16 and tA(HR, N=10) > .8 and oA(HR, N=10) < 1.8 and oA(doubles, N=10) > 1.1 and tA(doubles, N=10) > .9 and tA(errors, N=10) < 1.1 and .3 < oA(errors, N=10) < .9 and oA(walks, N=10) > 1.9 and day != Wednesday and oA(hits, N=10) > 6.8 and total < 10 and 6.5 < p:total < 11 and (STDSWHIP + o:STDSWHIP) < 3.105 and (s:SSO + ss:SSO + sss:SSO) > 6 and s:SSO < 10 and (os:SSO + oss:SSO + osss:SSO) > 5 and op:BPRA < 3
SG = 2 and H and (ou streak + o

u streak) = 3 and s:SRA > 0 and os:SHA < 11 and os:SRA > 0 and p:HR < 4 and op:HR < 4 and day != Monday and day != Sunday and day != Thursday and s:SWA != 0 and os:SWA < 3 and 7 > o:starter rest > 4 and starter rest > 5 and s

u margin > -2 and total > 7.5
SG = 3 and H and 8 > (ou streak + o

u streak) > 4 and p:HR != 0 and op:HR < 4 and day != Wednesday and s:SHRA != 0 and os:SHRA != 0 and s:SWA < 4 and os:SWA < 5 and os:SPT > 84 and month > 4
SG = 4 and H and -4 < (ou streak + o

u streak) < 11 and op:HR < 2 and 11 > op:hits > 7 and os:SHA > 4 and s:SHA > 2 and 4 < p:hits < 14
SG = 4 and SGS = 4 and H and so:inning runs so:R1 = 0 and oso:inning runs oso:R1 < 2 and p

u margin < 7 and p:HR != 0 and s:SHRA < 2 and s:SHA > 2 and s:SWA < 4 and 1 < s:SSO < 9 and s:SPT > 81 and s:SRA < 6 and os:SHRA < 3 and os:SSO < 9 and os:SPT > 81
p:HR = 2 and op:HR < 3 and SG < 5 and SG != 3 and 1 < SGS < 5 and pp:HR < 2 and opp:HR < 3 and p:hits < 18 and pp:hits < 15 and ppp:hits < 14 and pppp:hits < 10 and op:hits < 18 and 3 < opp:hits < 17 and oppp:hits < 13 and 4 < opppp:hits < 18 and p:walks < 7 and op:walks < 6 and p:doubles != 0 and pp:doubles < 4 and ppp:doubles < 3 and pppp:doubles < 3 and op:doubles < 5 and opp:doubles < 5 and oppp:HR < 3 and conference = o:conference and o:division != AL West and s:SHRA < 3
SG = 4 and H and -4 < (ou streak + o

u streak) < 11 and op:HR < 2 and (p:HR + pp:HR + ppp:HR) > 1 and oA(doubles, N=3) < 3.2 and tA(doubles, N=3) < 3.5 and 6.5 < oA(hits, N=3) < 13.5 and 7.25 < tA(hits, N=3) < 13 and tA(runs, N=3) < 7.5 and 1.75 < oA(runs, N=3) < 6.5 and s:SHRA < 3 and s:SWA < 5 and os:SWA < 5 and s:SHA > 2 and ss:SHRA < 3
Stars
streak = 1 and SG = 2 and s:earned runs < 9 and s:SHA < 10 and ss:SHA < 12 and 0 < os:SRA < 7 and 63 < s:SPT < 117 and 9.76 > oA(hits, N=4) > 5.76 and 5.0 > oA(walks, N=10) > 2.1 and o:streak > -7 and 2.2 < oA(runs, N=7) < 5.99 and 4.6 < oA(SO, N=10) < 9.2 and 18 > p:hits > 3 and 70 < ss:SPT < 116 and SGS < 4 and (line < -120 or line > 99) and PP:margin > -8 and p:BPRA != 1 and p:HR < 3
H and 10 >= total >= 8 and po:runs <= 4 and ppo:runs <= 4 and pppo:runs < 4 and op:L and op:margin = -1 and 2010 <= season and rest = 0 and month != 8
SG = 3 and H and p:runs < 10 and pp:runs < 10 and op:runs < 10 and opp:runs < 6 and s:SRA < 5 and s:SHA < 9 and ss:SHA < 10 and 2 < os:SHA < 11 and s:SPT > 52 and os:SPT < 121 and p:margin < 7 and p:margin != -1 and p:margin != -2 and p:margin != -3 and p:margin != -4 and 11.4 > oA(hits, N=10) > 7.3 and 10.8 > tA(hits, N=10) > 7.3 and (pp:hits + p:hits) < 27 and op:BPRA < 6 and streak < 5 and 5.8 > tA(runs, N=8) > 2.5 and division != NL West and 2.3 > tA(doubles,N=10) > 1.05 and oA(doubles, N=10) > 1.1 and STDSWHIP < 1.656 and o:STDSWHIP > 1
p:RMAX = 1 and p:margin = 2 and 13 > p:hits > 7 and p:TLOB > 5 and SG < 4
H and rest = 0 and (p:start time - start time) > -400 and SG < 4 and s:SRA < 8 and 115 > s:SPT > 66 and 24 < os:SPT < 109 and (starter rest < 16 or starter rest > 68) and 4 < o:starter rest < 11 and 7 < total < 11 and p:HR < 6 and op:HR < 6 and 5 < p:hits < 19 and 3 < op:hits < 20 and (p:SIP + pp:SIP + ppp:SIP + pppp:SIP) < 27.2 and 19.8 < (op:SIP + opp:SIP + oppp:SIP + opppp:SIP) < 30.2 and -6 < ou streak < 4 and p:total < 11 and pp:total < 10.5 and ppp:total > 7 and 6.5 < op:total < 9.5 and 7.5 < opp:total < 10 and (101 > game number > 38 or 148 > game number > 140 or game number > 155) and tA(HR, N=10) > .3 and oA(HR, N=10) > .6 and 1 < tA(doubles, N=10) < 2.7 and oA(doubles, N=10) > 1.1 and oA(double plays, N=10) > .3 and tA(double plays, N=10) < 1.7 and tA(runs,N=10) > 2.4 and 2.7 < oA(runs, N=10) < 7.2 and 1.01 < STDSWHIP < 1.82 and o:STDSWHIP > 1.0545
SG = 1 and site = home and p:HR = 1 and op:hits > 3 and (day = Thursday or day = Friday or day = Saturday) and pp:HR != 0 and op:HR < 5 and s:SHRA = 0 and os:SHRA < 2 and line < 120 and oA(runs, N=10) < tA(runs, N=10) and month < 10 and p:SG + op:SG > 4
SG = 1 and site = home and p:HR = 1 and op:hits > 3 and (day = Thursday or day = Friday or day = Saturday) and pp:HR != 0 and op:HR < 5 and s:SHRA = 0 and os:SHRA < 2 and line < 120 and oA(runs, N=10) < tA(runs, N=10) and month < 10 and p:SG + op:SG > 4
(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 oA(doubles, N=10) < 2.6 and 3.1 > tA(doubles, N=10) > .9 and tA(HR, N=10) < 1.9 and tA(errors, N=10) < 1.2 and p:margin < 11 and o:streak < 4 and o:starter rest < 10 and 65 < ss:SPT < 114 and oA(hits, N=10) < 9.7
H and 8.5 >= total >= 7 and tA(runs) <= 4.2 and o:STDSERA <= 4.2 and o:conference = AL and po:runs <= 4 and ppo:runs <= 4 and pppo:runs <= 4 and ppppo:runs <= 4 and pppppo:runs <= 4
H and tA(W) >= .45 and p:margin >= 2 and 32 > tS(runs@team and season,N=6) > 29 and po:BL = 0 and 120 > line >= -216 and conference = o:conference and total <= 10 and SG > 1 and game number > 11 and playoffs = 0 and s:SPT < 118 and os:SPT > 85 and 6.5 < oA(hits, N=10) < 10.8
p:X and p:errors >= 2 and H and -260 <= line <= -145 and 10 > total > 7 and rest < 2
5 > (p:LOB - po:LOB) > 2 and tA(runs) / tA(hits) > oA(runs) / oA(hits) and tA(runs, N=11) > oA(runs, N=11) and 3 > (tA(hits, N=11) - oA(hits, N=11)) > -1.6 and HF and line > -176 and SG != 2 and SGS < 5 and s:SPT < 112 and starter rest < 12 and tA(doubles, N=10) > 1 and .9 < oA(doubles, N=10) < 2.5 and s:SHA < 10
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 < o

u 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
month = 6 and streak = 2 and 3.01 > (p:innings pitched - Starter

:innings pitched) > 1.32 and s:SRA < 5 and line > -191 and 8 > os:SRA > 2 and 8 > oss:SRA and 8 > osss:SRA and 6 > ossss:SRA and SG != 3
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
starter wins = 13 and ((site = away and SG = 2) or (site = home and SG = 1)) and o:starter wins < 17 and s:margin > -9 and os:SRA != 0 and os:SHA < 10 and os:SWA != 0 and os:SHRA < 3 and o:starter losses < 12 and day != Wednesday
SG = 2 and H and 10 > (p:hits - op:hits) > 1 and 10 > p:margin > -2 and 0 < s:SRA < 5 and s:SPT > 77 and 6 > os:SRA > 0 and os:SPT > 83 and PP:season = season and (PP:SG = 3 or PP:SG = 4) and 1 < oA(doubles, N=10) < 2.5 and 2.8 > tA(BPRA, N=10) > .4 and oA(BPRA, N=10) > .9 and PP:hits > 4 and 17 > PPo:hits > 4 and pp:runs < 10 and oss:SHA > 2 and oss:SRA < 7 and 2 < s:SSO < 9 and playoffs = 0 and (game number > 89 or game number < 78)
SGS = 3 and SG = 3 and A and 2 > streak > -2 and 157 > game number > 26 and s:SHA > 4 and os:SHA < 9 and os:SRA < 7 and os:SHRA = 0 and os:SWA < 4 and 3 > s:SHRA > 0 and s:SWA < 5 and starter rest < 16 and total > 6.5 and (p:hits + pp:hits + op:hits + opp:hits) < 47 and p:margin < 7 and pp:margin > -8 and line < 220
HD and DIV and p:W and (month != 6 and month != 7) and tA(BPRA) < oA(BPRA) and line < 160 and total <= 10.5 and 4 > SG > 1 and rest = 0

s:SIP = 9.0 and starter rest = 5 and s:SHA < 7 and s:SRA < 3 and s:SSO < 11 and s:SWA < 4 and line > -181 and (SGS = 3 or SGS = 4) and s:SPT < 121 and op:HR < 3 and op:hits > 5 and opp:HR < 3
AF and SGS = 3 and os:SHRA = 0 and s:SHRA + ss:SHRA != 0 and s:SRA < 8 and os:SRA < 7 and s:SHA > 2 and 2 < os:SHA < 10 and s:SWA < 5 and os:SWA != 0 and starter rest < 11 and s:SIP < 8 and o:starter rest < 14 and p:HR < 4 and p:hits < 16 and (p:SIP + pp:SIP + ppp:SIP + pppp:SIP) > 18 and op:hits > 2 and pp:hits < 14 and total > 7.5 and (game number > 153 or game number < 139) and streak < 4 and o:streak > -7 and -5 < o

u streak < 5
(SG = 1 or SG = 4) and 1 < SGS < 5 and p:HR = 2 and op:HR < 3 and s:SHRA = 1 and os:SHRA < 2 and ss:SHRA = 0 and sss:SHRA < 3 and s:SRA < 7 and s:SSO > 1 and p:hits < 16 and tA(hits, N=10) < 10.5 and oA(hits,N=10) > 7.3 and tA(HR, N=10) > .6 and oA(fly balls, N=10) < 10.5 and tA(SO, N=10) < 8.6
os:SRA < 7 and (A or F) and 112 > os:SPT > 82 and 10.2 > tA(hits, N=10) > 6.8 and oA(runs, N=10) < 5.1 and .3 < oA(HR, N=10) < .5 and 9.6 > oA(hits, N=10) > 6.6 and o:starter rest < 27 and SG < 4 and 13 > p:hits > 4 and p:margin < 7 and s:SRA < 7 and ss:SRA < 6 and 9 > os:SHA > 2
H and line > 100 and tA(HR) <= .9 and 1.4 >= STDSWHIP >= 1.3 and A(o:SHRA@o:starter and o:season) <= .5 and conference = AL and rest = 0 and SG < 4
total <= 7 and conference = NL and (p:runs + po:runs) <= 2 and 2011 <= season and o:team != Rockies and o:team != Brewers and o:team != Cubs and o:team != Pirates and o:team != Marlins and team != Mets and team != Brewers and team != Marlins
s:SRA < 2 and 5 > ss:SRA > 0 and sss:SRA < 4 and ssss:SRA < 6 and 0 < sssss:SRA < 8 and os:SRA < 5 and SG < 4 and day != Tuesday and day != Thursday and 4 < starter rest < 10 and o:starter rest < 11 and 161 > game number > 27 and line > -165 and 2 > p:margin > -9 and 11.2 > tA(hits, N=10) > 6.7 and 6.2 < oA(hits, N=10) < 11.3 and STDSWHIP > .948 and ss:SPT > 67 and 40 < oss:SPT < 113 and tA(doubles, N=10) < 2.5 and tA(errors, N=10) > .1 and .3 < oA(BPRA, N=10) < 2.6 and tA(BPRA, N=10) < 2.8
1 > (ou streak + o

u streak) > -4 and 3 > ou streak > -3 and SG < 4 and 5 > SGS > 2 and day != Tuesday and day != Saturday and p:HR < 5 and pp:HR < 3 and p:hits < 13 and 4 < pp:hits < 18 and 7 < ppp:hits < 16 and 3 < pppp:hits < 18 and 2 < ppppp:hits < 13 and pppppp:hits < 19 and 2 < ppppppp:hits < 17 and ppp:HR < 3 and pppp:HR < 4 and ppppp:HR < 4 and op:HR < 5 and opp:HR < 5 and oppp:HR < 3 and opppp:HR < 4 and 3 < op:hits < 20 and opp:hits > 4 and 4 < oppp:hits < 16 and 4 < opppp:hits < 17 and oppppp:hits < 17 and 2 < opppppp:hits < 19 and 3 < oppppppp:hits < 12 and s:SHRA < 4 and s:SPT < 118 and os:SPT < 117 and starter rest < 22 and 10 > month > 5 and total < 11 and (tA(hits, N=10) + oA(hits, N=10)) > 15.5 and tA(HR, N=10) > .2 and tA(doubles, N=10) < 2.8
P:margin = -1 and 3 > os:SRA > 0 and os:SHA < 9 and os:SWA < 5 and (site = away or P:site = home) and (conference = NL or o:conference = AL) and os:SPT < 107 and 87 < s:SPT < 119 and 0 < s:SRA < 5 and s:SWA < 5 and os:SSO < 9 and -6 < streak < 0 and o:streak > 0 and line < 185 and day != Saturday and day != Monday and p:hits < 15 and os:SHRA < 2
tA(BPRA) < 1.35 and (SG = 2 or SG = 3) and SGS = 3 and -8 < (ou streak + o

u 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
SG = 2 and H and p:margin < 10 and p:W and -4 < pp:margin < 4 and -4 < ppp:margin < 5 and month != 9 and (day = Wednesday or day = Tuesday or day = Saturday) and p:hits > 4 and pp:hits > 4 and ppp:hits < 13 and (p:hits - op:hits) > -3 and game number > 28 and 70 < s:SPT < 115 and 69 < os:SPT < 114 and starter rest < 25 and (pp:hits - ppo:hits) < 7 and (opp:hits - oppo:hits) < 10 and (WP - o:WP) > -14.9 and .8 < oA(doubles, N=10) < 2.6 and (s:SRA + ss:SRA) < 13 and oA(hits + walks, N=10) > 9 and tA(hits + walks, N=10) > 9.8

[/B]

BasesLoaded314 · 07-04-14, 03:36 AM

H and 10 >= total >= 8 and day = Wednesday and p:conference != o:conference and p2:conference != o:conference and p3:conference != o:conference and p4:conference != o:conference and p5:conference != o:conference and p6:conference != o:conference and 2009 <= season and month < 7
line > -106 and playoffs = 0 and ((SGS = 4 and (SG = 1 or SG = 3)) or (SGS = 3 and SG != 2) or SGS < 3 or SGS = 5) and day != Sunday and day != Saturday and streak > -7 and site streak < 0 and -9 < o:site streak < 7 and 5 < p:hits < 22 and 0 < p:runs < 13 and p:doubles < 5 and p:errors < 3 and p:SO < 15 and -7 < p:margin < 11 and 6 < pp:hits < 14 and 2 < ppp:hits < 14 and pppp:hits > 3 and ppppp:hits < 14 and 20 > pppppp:hits > 3 and ppppppp:hits < 19 and pp:runs < 7 and pp:SO < 10 and ppp:SO < 13 and conference = o:conference and s:SHRA < 3 and os:SHA < 12 and 72 < os:SPT < 117 and o:starter rest < 16 and op:inning runs op:R1 < 6 and p:inning runs p:R9 < 4
H and s:SHRA + os:SHRA < 2 and 10 < s:SHA + os:SHA < 15 and 5 < os:SRA + s:SRA < 14 and playoffs = 0 and ((SG = 3 and SGS = 3) or (SG = 2 and SGS = 3) or (SG = 3 and SGS = 4) or (SG = 2 and SGS = 2)) and os:SHA < 11 and s:SHF < 34 and os:SHF < 34 and 5 < p:hits < 19 and op:hits > 1 and 6 < pp:hits < 14 and 4 < opp:hits < 13 and oppp:hits > 4 and op:HR < 4 and p

u margin > -5.5 and starter rest < 12 and opp:runs < 9 and 3 < pp:runs + p:runs < 22 and game number > 13 and (game number < 78 or 102 > game number > 90 or game number > 114)
s:SRA = 3 and H and SG = 1 and 2 < SGS < 5 and playoffs = 0 and s:SHRA < 3 and s:SWA < 5 and starter rest > 4 and 57 < s:SPT < 112 and s:SHF > 17 and s:SSO != 0 and s:SHA > 4 and 2 < ss:SHA < 12 and s:SWA + s:SHA < 13 and s:starter rest < 16 and 77 < ss:SPT < 124 and 20 < ss:SHF < 33 and 0 < ss:SSO < 12 and 3 < os:SHA + os:SWA < 14 and os:SRA < 8 and os:SHRA < 3 and os:SHA > 4 and os:SIP > 4 and o:starter rest < 7 and line < 138 and game number > 21
p:HR > 1 and op:HR = 1 and H and playoffs = 0 and 12 > p:hits > 6 and op:hits < 16 and p:runs < 10 and op:runs < 8 and o:site streak < 3 and opp:HR < 3 and -4 < streak < 6 and o:streak > -5 and s:SRA < 7 and os:SRA != 0 and 75 < s:SPT < 110 and os:SPT > 66 and day != Sunday and line > -240
s:SHRA = 0 and p:HR < 5 and os:SHRA < 3 and op:HR + opp:HR < 5 and SG = 3 and game number > 51 and (159 < game number < 175 or 130 < game number < 144 or game number < 105) and p:hits + pp:hits < 28 and op:hits + opp:hits < 32 and tS(ou margin, N=3) < 13.5 and oS(ou margin, N=3) < 13.5 and tS(O, N=25) + oS(O, N=25) > 16 and 22 > tS(ou margin, N=3) + oS(ou margin, N=3) > -24 and s:SIP > 3 and total < 11 and ou streak > -5 and o

u streak > -5 and -12 < tS(ou margin, N=10) + oS(ou margin, N=10) < 44.5 and 146 < tS(hits, N=20) < 207 and oS(hits, N=20) < 210 and 13 < tS(HR, N=30) < 45 and oS(HR, N=10) > 3 and 3 < tS(HR, N=10) < 17 and PPP:hits + oPPP:hits < 22 and PPP:runs + oPPP:runs < 13 and s:SPT < 119 and 45 < os:SPT < 120
HF and season > 2006 and run line < 163 and 16 > op:hits > 10 and p:hits > 5 and p:margin < 6 and s:SHA < 9 and s:SRA < 7 and 67 < s:SPT < 123 and tS(margin, N=10) - oS(margin, N=10) > -19 and -22 < tS(hits, N=10) - oS(hits, N=10) < 34 and conference = o:conference and streak < 5 and -5 < o:streak < 4 and os:SHA > 3 and os:SIP > 4.9 and 35 > os:SHF > 22 and os:SPT < 117 and o:starter rest < 17 and s:SHF < 31 and P:margin < 5 and o:run line streak < 4
Misc
H and SG = 2 and p:margin = 8 and line > -190 and month != 4
A and -100 > line > -151 and P:runs = 0 and P:season = season and WP > 42 and 68 > o:WP > 50 and season > 2008
150 >= line >= 100 and P:A and P:season = season and P:margin <= -6 and 54 >= WP >= 51 and total > 8 and 2009 <= season
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 and s:SRA > 3
HF and p:innings pitched - Starter

:innings pitched < op:innings pitched - Starter

p:innings pitched and (op:innings pitched - Starter

p:innings pitched) > Starter

p:innings pitched and 4 < op:BPRA < 11 and WP > 44 and SG > 1 and STDSERA <= o:STDSERA
AD and line < 180 and p:AW and SG = 2 and division = o:division and day != Saturday and day != Sunday and p:runs < 5 and op:runs < 3 and (day = Tuesday or day = Wednesday)
H and -175 <= line < -130 and 5.2 >= tA(runs) >= 4.7 and o:STDSERA <= 4.2 and o:conference = AL and p:runs + po:runs <= 4 and total > 7 and month != 9
day = Sunday and s:day = Monday and H and SG = 3 and 10 > month > 6 and 11 > (s:SRA + ss:SRA + sss:SRA) > 6 and line < 121
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 > 0 and p:hits < 13 and tA(runs) > 4.8
s:SRA = 7 and s:SHA > 10 and (line > 121 or line < -106) and p:hits > 6 and s:SPT < 106 and day != Tuesday
HF and p:margin >= 7 and s:margin > 0 and SG > 1 and os:margin < 0 and tS(runs, N=9) > oS(runs, N=9) and tA(BPRA, N=10) < oA(BPRA, N=10) and o:site streak > -8 and WP > 48
A and (190 > line > 129 or 115 > line) and 4.11 > STDSERA > 2.97 and conference = NL and (p:innings pitched - Starter

:innings pitched) >= 5 and s:SRA < 7 and ss:SRA < 6 and os:SRA < 6 and (s:SSO + ss:SSO) < 18 and op:hits > 3 and 72 < s:SPT < 115 and 73 < ss:SPT < 117 and sss:SPT > 82 and total < 10
p:X and p:errors >= 2 and H and -260 <= line <= -145 and 10 > total > 7 and rest < 2 and o:conference = NL
A and 165 >= line >= -125 and tA(runs) <= 4.7 and conference = AL and p:margin <= -4 and pp:margin <= -4 and rest = 0 and (SG = 1 or SG = 3) and conference = o:conference and month < 9
P:L and PP:L and PPP:L and H and line > 130 and division != o:division and 12 > total > 6 and (SG = 1 or SG = 3) and rest = 0 and day != Tuesday and day != Sunday and day != Saturday
(p:margin = -1 or p:margin = -2) and SG = 3 and D and 99 < line < 141 and line != 130 and s:SRA > 0 and 9 > os:SRA > 1 and s:SHA < 10 and 3 < ss:SHA < 9 and starter rest < 7 and o:starter rest < 8 and os:SHA > 3 and oss:SHA > 2 and osss:SHA < 10 and (p:hits + pp:hits + ppp:hits) < 35 and (op:hits + opp:hits + oppp:hits) < 42 and (p:SO + pp:SO + ppp:SO) > 13 and (s:SSO + ss:SSO + sss:SSO) < 22 and (os:SWA + oss:SWA + osss:SWA) > 1 and o:streak > 1
p:RMAX = 1 and p:margin = 3 and p:hits > 8 and total < 9.5
season > 2011 and SG = 3 and playoffs = 0 and p:X and o:conference = NL and H and (streak <= -2 or streak >= 2) and team != Rockies and team != Brewers and o:team != Brewers and o:team != Rockies and o:team != Phillies
s:starter rest = 11 and s:SRA = 0 and starter losses + starter wins > 10 and (SGS < 3 or SGS > 3 or (SGS = 3 and SG < 3)) and line < 180
13 < ss:starter rest < 20 and 3 < s:starter rest < 8 and starter rest < 11 and (H or SG > 1) and SGS > 2 and playoffs = 0 and line < 140 and os:SHA < 9 and 4 < p:hits < 17
p:runs > 6 and p:AW and p:margin < 12 and 5 > pp:margin > -8 and (D) and SG = 3 and division = o:division and NGT and s:SRA != 0 and os:SRA < 7 and oss:SRA < 7 and osss:SRA < 7
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
-5 <= p:margin <= -3 and p:hits > po:hits and p:TLOB > po:TLOB and -205 <= line <= -115 and total < 10.5 and SG < 4 and day != Saturday and day != Sunday
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 > 0 and p:hits < 13 and total > 6.5 and 1.4 > STDSWHIP > 1.1 and line < 155
-9 > (s:SSO - s:SHA - s:SWA + ss:SSO - ss:SHA - ss:SWA + sss:SSO - sss:SHA - sss:SWA) > -14 and H and 7 > s:SRA > 1 and (month = 5 or month = 7 or month = 9 or month = 10) and (SG = 2 or SG = 3) and 134 > line > -166 and 20 > (os:SHA + oss:SHA) > 7 and (os:SRA + oss:SRA) > 1 and total < 11 and (p:hits + pp:hits) < 25 and p:hits > 6 and op:hits < 15 and 4 > o:streak > -5 and o:AWP > 30.01 and oA(BPRA) < 1.93
total <= 7 and Sum(hits@team and season) / Sum(at bats@team and season) <= 245 and conference = NL and (p:runs + po:runs) <= 2 and 2011 <= season
A and 160 > line > -130 and tA(TLOB) >= 7.5 and po:runs <= 2 and ppo:runs <= 2 and month != 7 and month != 8 and 2005 <= season and SG < 4
(p:margin = -1 or p:margin = -2) and SG = 3 and D and 99 < line < 141 and line != 130 and s:SRA > 0 and 9 > os:SRA > 1 and s:SHA < 10 and 3 < ss:SHA < 9 and starter rest < 7 and o:starter rest < 8 and os:SHA > 3 and oss:SHA > 2 and osss:SHA < 10 and (p:hits + pp:hits + ppp:hits) < 35 and (op:hits + opp:hits + oppp:hits) < 42 and (p:SO + pp:SO + ppp:SO) > 13 and (s:SSO + ss:SSO + sss:SSO) < 22 and (os:SWA + oss:SWA + osss:SWA) > 1
starter rest = 7 and month != 7 and (day = Sunday or day = Wednesday or day = Saturday) and (SG = 2 or SG = 3) and os:SRA > 2 and total > 7.5 and (op:SIP + opp:SIP + oppp:SIP + opppp:SIP) > 19.99 and (p:SIP + pp:SIP + ppp:SIP + pppp:SIP) > 22.01 and 9 > p:margin > -7 and (p:runs + op:runs - total) < 2.51 and 22 > (p:hits + op:hits) > 7 and line != -115 and line != -105 and (line < 111 or line > 126)
SG = 3 and month = 7 and H and (day = Wednesday or day = Saturday or day = Sunday) and p:W and pp:L and total < 11 and (s:SRA + os:SRA) < 11 and 8 > ss:SRA > 0 and oss:SRA < 7 and (p:runs + op:runs) < 19 and (line < -141 or line > -130)
(s:SRA + ss:SRA) = 3 and A and (month = 5 or month = 7) and os:SRA < 6 and oss:SRA > 2 and line > -184 and p:hits > 5 and pp:hits > 6 and (op:hits + opp:hits + oppp:hits) > 14
SG = 1 and rest > 2 and month = 7 and streak <= -3 and total >= 7

BasesLoaded314 · 07-04-14, 03:39 AM

welp, the formatting got all screwey there at the end, but u can see where one query ends and another begins by looking for the empty spaces in between

b1slickguy · 07-04-14, 07:17 AM

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

Good luck.

emceeaye · 07-04-14, 08:18 AM

Originally posted by b1slickguy

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

Good luck.

WP < 53 and A(SWHIP@starter and season) < 1.2 and A(SOPW@starter and season) >= .333 and A(SSPB@starter and season) >= .50 and conference = NL and line>100 and SG < 4 and month!= 9

b1slickguy · 07-04-14, 09:22 AM

Originally posted by emceeaye

WP < 53 and A(SWHIP@starter and season) < 1.2 and A(SOPW@starter and season) >= .333 and A(SSPB@starter and season) >= .50 and conference = NL and line>100 and SG < 4 and month!= 9

Very nice results, buddy. Not usually a fan of the short term queries, but I wanted to share. This is pretty much the only season in the db with such skewed results. Have a similar long term query below with added filters, but not active today. Some seasons not as good as others, though.

AD and LGS and line<195 and total>7 and p:SII>=4 and p:hits>12 and WP<50

Good luck.

JMon · 07-04-14, 10:05 AM

the is active again....ml/rl Tigers

(team=Tigers) and p:runs>=8 and pp:runs>=8 and 2009<=season

JMon · 07-04-14, 10:09 AM

Originally posted by b1slickguy

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

Good luck.

nice pup...this supposed to be active today?

b1slickguy · 07-04-14, 10:36 AM

Originally posted by JMon

nice pup...this supposed to be active today?

Was active when I posted, but the total shifted down to 7.
Good luck.

Alex Vaile · 07-04-14, 10:42 AM

0 and 1 yesterday -1.1 units
24 and 13
+ 9.35 units

Damn Bases that's a lot of queries!

nbilln · 07-04-14, 11:28 AM

How do I look up how home teams fared on July 4ths?

would it just be date=0704 and H?
doesnt seem to work for me and Ive never tried specific dates

JMon · 07-04-14, 11:43 AM

Originally posted by nbilln

How do I look up how home teams fared on July 4ths?

would it just be date=0704 and H?
doesnt seem to work for me and Ive never tried specific dates

int(str(date)[4:])=704 and H

which brings me to this query for series game 2. This will be interesting this 4th of July and so many plays and the Rockies as a big dog..

int(str(date)[4:])=704 and H and SG=2

b1slickguy · 07-04-14, 11:54 AM

Originally posted by JMon

int(str(date)[4:])=704 and H

which brings me to this query for series game 2. This will be interesting this 4th of July and so many plays and the Rockies as a big dog..

int(str(date)[4:])=704 and H and SG=2

Thanks for the lesson, JMon. Reminded me of the BOS curse on Ben Affleck's b-day.

int(str(date)[4:])=815 and team=Red Sox

Alex Vaile · 07-04-14, 11:56 AM

First posted play for 7 / 4: Cincinnati - 113
starter = Alfredo Simon and oA(SO)>=7.5 and line < 150
15 and 0 in this situation. Run line also 11 and 4. Straight from killer query video.

Second posted play: Under 7 -120 giants vs Pads
Third posted play: Under 8 -115 Jays vs As

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

JMon · 07-04-14, 01:38 PM

Originally posted by b1slickguy

Thanks for the lesson, JMon. Reminded me of the BOS curse on Ben Affleck's b-day.

int(str(date)[4:])=815 and team=Red Sox

Aug 15th baby...remind us of this one slicker

emceeaye · 07-04-14, 03:31 PM

Originally posted by Alex Vaile

First posted play for 7 / 4: Cincinnati - 113
starter = Alfredo Simon and oA(SO)>=7.5 and line < 150
15 and 0 in this situation. Run line also 11 and 4. Straight from killer query video.

starter wins = 13 and ((site = away and SG = 2) or (site = home and SG = 1)) and o:starter wins < 17 and s:margin > -9 and os:SRA != 0 and os:SHA < 10 and os:SWA != 0 and os:SHRA < 3 and o:starter losses < 12 and day != Wednesday

Alex Vaile · 07-04-14, 04:33 PM

Originally posted by emceeaye

starter wins = 13 and ((site = away and SG = 2) or (site = home and SG = 1)) and o:starter wins < 17 and s:margin > -9 and os:SRA != 0 and os:SHA < 10 and os:SWA != 0 and os:SHRA < 3 and o:starter losses < 12 and day != Wednesday

I guess one can always find queries that contradict others. Best of luck to u emceeaye I'm rolling with undefeated today.

Alex Vaile · 07-04-14, 09:23 PM

3 and 0 today. + 3 units
27 and 13 overall
+ 12.35 units

emceeaye · 07-05-14, 08:46 AM

Originally posted by BasesLoaded314

[B]remove the phrase “p:inning runs” when it appears & causes errors, it is redundant.

Probation:

month = 6 and F and o:streak = 1 and SG != 1 and -120 > line and os:SRA < 7 and oss:SRA < 9 and s:SRA < 8 and ss:SRA != 0 and site streak < 6 and p:margin > -4

month = 6 and streak = 1 and F and 7 > s:SRA and 8 > os:SRA and (ss:SRA != 1 or ss:SRA != 2) and (sss:SRA > 4 or sss:SRA < 3) and SG < 4 and 15 > p:hits > 5 and op:hits > 6 and 14 > pp:hits and 26 > op:LOB > 5

month = 6 and season > 2009 and F and (SG = 2 or SG = 3) and day != Sunday and 14 > p:hits > 3 and 10.01 > total > 6.49 and op:hits < 17 and pp:hits < 12 and opp:hits > 3 and ppp:hits > 2 and 9 > os:SSO > 0 and oss:SSO < 7 and 15 > streak > -4 and 5 > o:streak > -6 and 10.01 > p:total > 6.49 and o