MLB - Situation Plays - SDQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Alex Vaile
    SBR MVP
    • 04-19-14
    • 3724

    #1821
    Originally posted by emceeaye
    Alex, you a Dodger fan too who couldn't wait for Bellisario to be traded?
    No I live in the Bay Area and like the Giants out here but was born in Toronto and like the Jays out there. I just can't stand relievers that "add" not relieve. Coke and Bellasario 2 of the worst!
    Comment
    • BeanTownClown88
      SBR MVP
      • 08-08-13
      • 1961

      #1822
      Joba is THE WORST!
      Comment
      • Alex Vaile
        SBR MVP
        • 04-19-14
        • 3724

        #1823
        Good start to today with Tigers holding on for RL and SU win. Also tailed the under with JMon.
        Comment
        • Alex Vaile
          SBR MVP
          • 04-19-14
          • 3724

          #1824
          Originally posted by mdunlap3
          Nice hits on DET yall...OAk and KC just went over though
          Ya that sucked. Looked good there for minute. Query still rocks!
          Comment
          • JMon
            SBR Hall of Famer
            • 12-11-09
            • 9800

            #1825
            damn..thought we had that KC under
            Comment
            • Alex Vaile
              SBR MVP
              • 04-19-14
              • 3724

              #1826
              Originally posted by JMon
              emc was right...wow how did I miss this query. Killer dog spot and close to 30u won this season
              Glad it worked!
              Comment
              • Alex Vaile
                SBR MVP
                • 04-19-14
                • 3724

                #1827
                Originally posted by emceeaye
                What do you guys think of these 2 queries on Rays su? First one is from website trends and the next I came up with

                t:team=Rays and A and date>=20140615

                AF and LGS and p:margin>=9 and tA(W, N=9)>oA(W, N=9)+.11
                Looks good to me!
                Comment
                • inZane
                  SBR MVP
                  • 11-13-13
                  • 1206

                  #1828
                  Originally posted by JMon
                  damn..thought we had that KC under
                  I liked this also, and added the Chubs under as well.... Not a very good way to start a day
                  Comment
                  • emceeaye
                    SBR Wise Guy
                    • 08-20-13
                    • 704

                    #1829
                    Originally posted by Alex Vaile
                    Looks good to me!
                    Yah, this Robbie Ross isn't that good and the Rangers suck as well
                    Comment
                    • JMon
                      SBR Hall of Famer
                      • 12-11-09
                      • 9800

                      #1830
                      Originally posted by emceeaye
                      Yah, this Robbie Ross isn't that good and the Rangers suck as well
                      emc,, have this one fading TEX as well.

                      H and tA(runs)<=4.2 and o:STDSERA<=4.2 and o:conference=AL and p:margin<=-8 and conference=o:conference

                      Comment
                      • JMon
                        SBR Hall of Famer
                        • 12-11-09
                        • 9800

                        #1831
                        I'll roll with you on TB
                        Comment
                        • emceeaye
                          SBR Wise Guy
                          • 08-20-13
                          • 704

                          #1832
                          Originally posted by JMon
                          emc was right...wow how did I miss this query. Killer dog spot and close to 30u won this season
                          Just saw this one that goes with Red Sox, or any other team that is playing on the road as a dog after a loss as a home favorite. Add in SG=1 and month=8 and its even more compelling:

                          A and D and p:H and p:F and p:L and date>=20110926
                          Comment
                          • emceeaye
                            SBR Wise Guy
                            • 08-20-13
                            • 704

                            #1833
                            Originally posted by JMon
                            I'll roll with you on TB
                            Let's go!
                            Comment
                            • JMon
                              SBR Hall of Famer
                              • 12-11-09
                              • 9800

                              #1834
                              playing around with your query, good in both conferences but nice in the AL

                              AF and LGS and p:margin >= 9 and tA(W, N=9) > oA(W, N=9) + .11 and conference=AL and day!=Wednesday
                              Comment
                              • emceeaye
                                SBR Wise Guy
                                • 08-20-13
                                • 704

                                #1835
                                Originally posted by JMon
                                playing around with your query, good in both conferences but nice in the AL

                                AF and LGS and p:margin >= 9 and tA(W, N=9) > oA(W, N=9) + .11 and conference=AL and day!=Wednesday
                                Wow, very nice!!
                                Comment
                                • emceeaye
                                  SBR Wise Guy
                                  • 08-20-13
                                  • 704

                                  #1836
                                  reds/rockies over supported by Bases query

                                  Add in SG=1 and month=8:

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

                                    #1837
                                    Under in houston looked good until feldman decided to stop trying. 5 runs in the inning wow.
                                    Comment
                                    • b1slickguy
                                      SBR Posting Legend
                                      • 11-24-11
                                      • 11959

                                      #1838
                                      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
                                      Active tomorrow fading BOS.
                                      Good luck.
                                      Comment
                                      • posey
                                        SBR MVP
                                        • 05-23-14
                                        • 1112

                                        #1839
                                        D and season > 2010 and A and line <= 115 and A(W, N=10) > 0.4 and S(W, N=4) >= 2
                                        Comment
                                        • emceeaye
                                          SBR Wise Guy
                                          • 08-20-13
                                          • 704

                                          #1840
                                          Originally posted by posey
                                          D and season > 2010 and A and line <= 115 and A(W, N=10) > 0.4 and S(W, N=4) >= 2
                                          Wow, good work!! Thank you.
                                          Comment
                                          • posey
                                            SBR MVP
                                            • 05-23-14
                                            • 1112

                                            #1841
                                            Switch the 0.4 to 0.5. LOL.
                                            Comment
                                            • emceeaye
                                              SBR Wise Guy
                                              • 08-20-13
                                              • 704

                                              #1842
                                              Originally posted by posey
                                              Switch the 0.4 to 0.5. LOL.
                                              What is "A" in your term "A(W, N=10)" ? I guess not the same as "tA(W, N=10)"
                                              Comment
                                              • Alex Vaile
                                                SBR MVP
                                                • 04-19-14
                                                • 3724

                                                #1843
                                                Originally posted by emceeaye
                                                Add in SG=1 and month=8:

                                                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
                                                Nice call on the Rays and the over in Colorado. I played it with you!
                                                Comment
                                                • Alex Vaile
                                                  SBR MVP
                                                  • 04-19-14
                                                  • 3724

                                                  #1844
                                                  Originally posted by posey
                                                  D and season > 2010 and A and line <= 115 and A(W, N=10) > 0.4 and S(W, N=4) >= 2
                                                  Wow that's a query! !
                                                  Nice one Posey!
                                                  Comment
                                                  • Alex Vaile
                                                    SBR MVP
                                                    • 04-19-14
                                                    • 3724

                                                    #1845
                                                    2 and 2 posted yesterday for an even day.
                                                    80 and 64 overall
                                                    +11.31 units
                                                    Comment
                                                    • emceeaye
                                                      SBR Wise Guy
                                                      • 08-20-13
                                                      • 704

                                                      #1846
                                                      Originally posted by Alex Vaile
                                                      Nice call on the Rays and the over in Colorado. I played it with you!
                                                      Cheers!!!
                                                      Comment
                                                      • JMon
                                                        SBR Hall of Famer
                                                        • 12-11-09
                                                        • 9800

                                                        #1847
                                                        Originally posted by emceeaye
                                                        What is "A" in your term "A(W, N=10)" ? I guess not the same as "tA(W, N=10)"

                                                        tA would be team average, where A would be league average..that's my understanding.

                                                        Something doesn't look right with the query, at first glance I didn't think it would be predictive with the astromical numbers is spitting out, especially putting the .5 in there for a perfect record. But it's telling us to fade Oak today.
                                                        Comment
                                                        • emceeaye
                                                          SBR Wise Guy
                                                          • 08-20-13
                                                          • 704

                                                          #1848
                                                          Originally posted by JMon
                                                          tA would be team average, where A would be league average..that's my understanding.

                                                          Something doesn't look right with the query, at first glance I didn't think it would be predictive with the astromical numbers is spitting out, especially putting the .5 in there for a perfect record. But it's telling us to fade Oak today.
                                                          Yeah, I mean its not as if Braves would be a bad pick anyway, but something is suspicious about the record
                                                          Comment
                                                          • BeanTownClown88
                                                            SBR MVP
                                                            • 08-08-13
                                                            • 1961

                                                            #1849
                                                            Hearing other consensus on ATl too. Oak is 10-2 in inter league play but if you gotta fade a pitcher, Hammel is the guy.
                                                            I havent pulled the trigger yet though, BOL
                                                            Comment
                                                            • Alex Vaile
                                                              SBR MVP
                                                              • 04-19-14
                                                              • 3724

                                                              #1850
                                                              First 2 posted plays: (Bases)

                                                              Under 7.5 -125 Cubs vs Mets
                                                              Under 8.5 - 115 Pads vs Tigers

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

                                                                #1851
                                                                3rd and 4th play: ( Dr.M )(Daily Report)

                                                                Play Dodgers - 171
                                                                Dodgers RL +125
                                                                arter= Zack Greinke and H and s:SRA> 1 and s:SHA > 2 and date>= 20100428
                                                                Greinke 19 and 0 this spot. 4 and 0 this season.

                                                                More support:
                                                                starter=’Zack Greinke’ and season>=2011 and H and line<-140 and 12>=s:runs+so:runs>=2
                                                                33 and 1 with this query. 7 and 1 this season
                                                                Last edited by Alex Vaile; 08-15-14, 03:50 PM. Reason: added query
                                                                Comment
                                                                • posey
                                                                  SBR MVP
                                                                  • 05-23-14
                                                                  • 1112

                                                                  #1852
                                                                  To be honest I mistyped it first (I wanted to use tA instead of A) and then only thought WOW. But since the query with the 0.4 gives us two potential picks for today I was quite confused, because first I thought their I made a mistake. Don't know lol.
                                                                  Last edited by posey; 08-15-14, 12:05 PM.
                                                                  Comment
                                                                  • emceeaye
                                                                    SBR Wise Guy
                                                                    • 08-20-13
                                                                    • 704

                                                                    #1853
                                                                    Originally posted by posey
                                                                    To be honest I mistyped it first (I wanted to use tA instead of A) and then only thought WOW. But since the query with the 0.4 gives us two potential picks for today I was quite confused, because first I thought their I made a mistake. Don't know lol.
                                                                    Not getting the logic of this query. Why would the home team win more often when there has been a higher number and average of recent league dog away wins (over 50%).
                                                                    Last edited by emceeaye; 08-15-14, 12:25 PM.
                                                                    Comment
                                                                    • JMon
                                                                      SBR Hall of Famer
                                                                      • 12-11-09
                                                                      • 9800

                                                                      #1854
                                                                      Well here is one pointing to the Braves that is 31-4 SU...Basically playing a home winning team that has dropped their last 12 or more out of 15

                                                                      H and S(L @team and season, N=15)>=12 and WP>50 and month!=6
                                                                      Comment
                                                                      • mdunlap3
                                                                        SBR MVP
                                                                        • 02-18-13
                                                                        • 1847

                                                                        #1855
                                                                        Gotta chime in I love this thread...follow y'all daily. Very much appreciate all of your hard work gentlemen, keep it up!
                                                                        Comment
                                                                        SBR Contests
                                                                        Collapse
                                                                        Top-Rated US Sportsbooks
                                                                        Collapse
                                                                        Working...