2015 SDQL Baseball Thread

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sballen
    SBR Wise Guy
    • 02-26-14
    • 815

    #1576
    Nice work on the Sox game. Is this a public database you're pulling from or you're own?
    Comment
    • Alex Vaile
      SBR MVP
      • 04-19-14
      • 3724

      #1577
      Originally posted by sballen
      Nice work on the Sox game. Is this a public database you're pulling from or you're own?
      Its 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 Vaile
        SBR MVP
        • 04-19-14
        • 3724

        #1578
        Yesterday'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 Vaile
          SBR MVP
          • 04-19-14
          • 3724

          #1579
          Play 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 RL
          Comment
          • Alex Vaile
            SBR MVP
            • 04-19-14
            • 3724

            #1580
            Play 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 < ou 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 % 22
            Comment
            • Alex Vaile
              SBR MVP
              • 04-19-14
              • 3724

              #1581
              Play 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
              • Loder222
                SBR Rookie
                • 08-29-15
                • 9

                #1582
                Pittsburgh is risky i think but on under approve
                Comment
                • b1slickguy
                  SBR Posting Legend
                  • 11-24-11
                  • 11959

                  #1583
                  Originally posted by Alex Vaile
                  Play 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 RL

                  Like these as well as the over.
                  Good luck today.
                  Comment
                  • Loder222
                    SBR Rookie
                    • 08-29-15
                    • 9

                    #1584
                    Under fired and gone :/
                    Comment
                    • Alex Vaile
                      SBR MVP
                      • 04-19-14
                      • 3724

                      #1585
                      Shit start. Morton got rocked. Blanton too
                      Comment
                      • Alex Vaile
                        SBR MVP
                        • 04-19-14
                        • 3724

                        #1586
                        Originally posted by b1slickguy
                        Like these as well as the over.
                        Good luck today.
                        Thanks Slicker u too bud!
                        Comment
                        • Alex Vaile
                          SBR MVP
                          • 04-19-14
                          • 3724

                          #1587
                          Juicy 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 RL
                          Comment
                          • Alex Vaile
                            SBR MVP
                            • 04-19-14
                            • 3724

                            #1588
                            NFL 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 pooints<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 Vaile
                              SBR MVP
                              • 04-19-14
                              • 3724

                              #1589
                              Today'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 Vaile
                                SBR MVP
                                • 04-19-14
                                • 3724

                                #1590
                                Play 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 % 19
                                Comment
                                • Alex Vaile
                                  SBR MVP
                                  • 04-19-14
                                  • 3724

                                  #1591
                                  Play Brewers - 112

                                  team=Reds and p:AL and po:hits>=12 and date>=20140500

                                  Reds 0-15 in this spot
                                  Comment
                                  • Alex Vaile
                                    SBR MVP
                                    • 04-19-14
                                    • 3724

                                    #1592
                                    Play Indians + 133

                                    team=Indians and FGS and date>=20150811

                                    Indians have won their last 11 first games of series.
                                    Comment
                                    • Alex Vaile
                                      SBR MVP
                                      • 04-19-14
                                      • 3724

                                      #1593
                                      Play 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 RL
                                      Comment
                                      • Alex Vaile
                                        SBR MVP
                                        • 04-19-14
                                        • 3724

                                        #1594
                                        Play 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 runs
                                        Comment
                                        • Alex Vaile
                                          SBR MVP
                                          • 04-19-14
                                          • 3724

                                          #1595
                                          Play 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 % 20
                                          Comment
                                          • Alex Vaile
                                            SBR MVP
                                            • 04-19-14
                                            • 3724

                                            #1596
                                            Play Tigers - 103

                                            p:WADX and site = home and FGS and streak < 4 and o:streak > -2

                                            (? ??)
                                            ROI % 36
                                            Comment
                                            • b1slickguy
                                              SBR Posting Legend
                                              • 11-24-11
                                              • 11959

                                              #1597
                                              Originally posted by Alex Vaile
                                              Play 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 RL
                                              On this side, too.

                                              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 Vaile
                                                SBR MVP
                                                • 04-19-14
                                                • 3724

                                                #1598
                                                Originally posted by b1slickguy
                                                On this side, too.

                                                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.

                                                Let's make it 10!
                                                Comment
                                                • Alex Vaile
                                                  SBR MVP
                                                  • 04-19-14
                                                  • 3724

                                                  #1599
                                                  Yesterday'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 postponed
                                                  Comment
                                                  • Alex Vaile
                                                    SBR MVP
                                                    • 04-19-14
                                                    • 3724

                                                    #1600
                                                    Play 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 Vaile
                                                      SBR MVP
                                                      • 04-19-14
                                                      • 3724

                                                      #1601
                                                      Play 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 Vaile
                                                        SBR MVP
                                                        • 04-19-14
                                                        • 3724

                                                        #1602
                                                        Play 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 % 20
                                                        Last edited by Alex Vaile; 09-20-15, 02:13 AM.
                                                        Comment
                                                        • Alex Vaile
                                                          SBR MVP
                                                          • 04-19-14
                                                          • 3724

                                                          #1603
                                                          Play 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 RL
                                                          Comment
                                                          • Alex Vaile
                                                            SBR MVP
                                                            • 04-19-14
                                                            • 3724

                                                            #1604
                                                            Today'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 Vaile
                                                              SBR MVP
                                                              • 04-19-14
                                                              • 3724

                                                              #1605
                                                              Play 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 spot
                                                              Comment
                                                              • Alex Vaile
                                                                SBR MVP
                                                                • 04-19-14
                                                                • 3724

                                                                #1606
                                                                Play Cardinals + 118

                                                                team=Cardinals and p:L and pp:L and LGS and SG=3 and date>=20130800

                                                                Cards 13-0 in this spot
                                                                Comment
                                                                • Alex Vaile
                                                                  SBR MVP
                                                                  • 04-19-14
                                                                  • 3724

                                                                  #1607
                                                                  Play 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 % 12
                                                                  Comment
                                                                  • Alex Vaile
                                                                    SBR MVP
                                                                    • 04-19-14
                                                                    • 3724

                                                                    #1608
                                                                    Yesterday's results: 1-2 - .82 units
                                                                    Season to date : 431-427 - 14.44 units

                                                                    Cards winners, Phillies and Red Sox over losers
                                                                    Comment
                                                                    • Alex Vaile
                                                                      SBR MVP
                                                                      • 04-19-14
                                                                      • 3724

                                                                      #1609
                                                                      Tigers 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 Vaile
                                                                        SBR MVP
                                                                        • 04-19-14
                                                                        • 3724

                                                                        #1610
                                                                        Play 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 22
                                                                        Last edited by Alex Vaile; 09-21-15, 04:46 PM. Reason: Line drop
                                                                        Comment
                                                                        SBR Contests
                                                                        Collapse
                                                                        Top-Rated US Sportsbooks
                                                                        Collapse
                                                                        Working...