Nice work on the Sox game. Is this a public database you're pulling from or you're own?
2015 SDQL Baseball Thread
Collapse
X
-
sballenSBR Wise Guy
- 02-26-14
- 815
#1576Comment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1577Its a public database that you can run the queries on, however the actual queries I have collected and saved and am saving on an ongoing basis at the site. If you google the SDQL process then you will get the info on where and what to do. Can't promote sites in here. Hope this helps ! I find it fun to use these to help guide my plays each day.Comment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1578Yesterday's results: 2-2 - .49 units
Season to date: 422-417 - 13.47 units
Red Sox over and Cards winners and Astros and Rocks losers.Comment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1579Play Orioles - 111
Play Orioles RL + 145
team=Orioles and line>=-140 and p:margin <=-5 and p:H and date>=20120729
Orioles 19-0 in this spot ML
17-2 RLComment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1580Play Under 8 - 103 Cubs vs Pirates
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 pu 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
( Bases )
ROI % 22Comment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1581Play Pirates - 119
team=Pirates and p:XLH and season>=2011
Pirates 11-0 in this spot.
Pirates off a Home extra inning loss 11 and 0.Comment -
Loder222SBR Rookie
- 08-29-15
- 9
#1582Pittsburgh is risky i thinkbut on under approve
Comment -
Loder222SBR Rookie
- 08-29-15
- 9
#1584Under fired and gone :/Comment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1585Shit start. Morton got rocked. Blanton tooComment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1587Juicy but I like it.
Play Jays - 200
Play Jays RL - 130
A and A(starter whip@starter and season, N=3)<2.50 and A(o:starter whip@o:starter and o:season, N=3)>=2.25 and 2012<=season and line<=160 and rest=0 and 9.5>=total>=8 and month!=8
( JMon )
ROI % 29 ML
ROI % 10 RLComment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1588NFL Bonus
Denver +3 over KANSAS CITY -- Manning has never lost the Chiefs as a member of the Broncos. Here are some supporting queries I picked up today.
team=Broncos and A and surface=grass and o:wins-o:losses>-8 and date>=20111023
12 and 0 ats
-3.5<=line<=3.5 and p:F and NB and pTD>0 and po
oints<27 and p:sacks>=2 and date>=20131200
11-0 ats
team=Chiefs and -7<=line<=3 and DIV and season=P:season + 1 and date>=20071100
Chiefs 0-10 in this spot.
(MTI)Comment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1589Today's results : 3-3 - .22 units
Season to date: 425-420 - 13.69 units
Orioles what a comeback winner, Jays and Jays RL winners and Pirates ML and under and Orioles RL losers.
Broncos winner!Comment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1590Play Under 6.5 + 105 Pirates vs Dodgers
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
( Jmon )
ROI % 19Comment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1591Play Brewers - 112
team=Reds and p:AL and po:hits>=12 and date>=20140500
Reds 0-15 in this spotComment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1592Play Indians + 133
team=Indians and FGS and date>=20150811
Indians have won their last 11 first games of series.Comment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1593Play Angels - 112
Play Angels RL + 145
p:RMAX > 5 and AF and month!=4 and p:A and n:series game<4 and total>7
ROI % 12 ML
ROI % 32 RLComment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1594Play Red Sox + 170
team=Blue Jays and F and po:BL=0 and p:W and ppo:BL=0 and pp:W and date>=20150814
0-4
team=Red Sox and D and 2<=o:streak and SG=1 and date>=20140905
6-0
Red Sox are 5-0 as a 140+ dog when they are off a road game and facing a divisional opponent that is ahead of them in the standings, including a perfect 4-0 this season.
Finally, Boston is 4-0 after a road game in which they hit multiple home runs, winning by an average of 4.75 runsComment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1595Play Marlins vs Nationals Over 6.5 - 120
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
( Bases )
ROI % 20Comment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1596Play Tigers - 103
p:WADX and site = home and FGS and streak < 4 and o:streak > -2
(? ??)
ROI % 36Comment -
b1slickguySBR Posting Legend
- 11-24-11
- 11959
#1597
AF and total>7 and p:SII>=4 and p:hits>12 and WP>50 and season>=2011 and pp:SII<4 and conference=AL and SG>1
Teams are 9-0 vs Twins in this situation.
Good luck.
Comment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1599Yesterday's results : 3-3 + .21 units
Season to date: 428-423 - 13.48 units
Nats over, Indians, Tigers winners and Brewers, Dodger under, Red Sox losers and Angels postponedComment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1600Play Giants - 105
team=Giants and F and DIV and WP>o:WP and SG>1 and date>=20150624
Giants also 19-0 when seeking same season revenge on starter and previous loss.Last edited by Alex Vaile; 09-20-15, 02:13 AM.Comment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1601Play Mets - 129
team=Mets and F and p:W and p:SIP<8 and p:BPRA=0 and SG>1 and season=2015
Mets 17-0 in this spot this season.Comment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1602Play Over 7 - 115 Indians vs White Sox
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
( Bases )
ROI % 20Last edited by Alex Vaile; 09-20-15, 02:13 AM.Comment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1603Play Rangers - 173
Play Rangers RL + 120
team=Rangers and F and p:hits<=6 and p:L and SG<SGS and date>=20100804 and p:runs<5 and p:HR<2
( Dr.M )
46-8 SU
35-19 RLComment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1604Today's results : 2-2-1 -.14 units
Season to date : 430-425 - 13.62 units
Rangers ML and RL winners and Giants and Mets lost and White Sox over pushed.Comment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1605Play Red Sox vs Blue Jays Over 9 + 100
team=Red Sox and LGS and STDSERA<o:STDSERA and season =2015
Red Sox 12/1 over under this season in this spotComment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1606Play Cardinals + 118
team=Cardinals and p:L and pp:L and LGS and SG=3 and date>=20130800
Cards 13-0 in this spotComment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1607Play Phillies + 130
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
( Emceeaye )
ROI % 12Comment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1608Yesterday's results: 1-2 - .82 units
Season to date : 431-427 - 14.44 units
Cards winners, Phillies and Red Sox over losersComment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1609Tigers play cancelled as theyve lost 11 out of last 13 games on mondays for some reason and major line move, although early, has gotten me off this game. Good luck today I'll have some plays in a bit..Last edited by Alex Vaile; 09-21-15, 10:37 AM.Comment -
Alex VaileSBR MVP
- 04-19-14
- 3724
#1610Play Mets - 165
Play Mets RL + 115
(so:R1 = 3 or 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
( Bases )
ROI % ML 29
ROI % RL 22Comment
SBR Contests
Collapse
Top-Rated US Sportsbooks
Collapse
#1 BetMGM
4.8/5 BetMGM Bonus Code
#2 FanDuel
4.8/5 FanDuel Promo Code
#3 Caesars
4.8/5 Caesars Promo Code
#4 DraftKings
4.7/5 DraftKings Promo Code
#5 Fanatics
#6 bet365
4.7/5 bet365 Bonus Code
#7 Hard Rock
4.1/5 Hard Rock Bet Promo Code
#8 BetRivers
4.1/5 BetRivers Bonus Code