MLB - Situation Plays - SDQL

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

    #596
    Originally posted by BasesLoaded314
    month = 5 and streak = 2 and -2>=o:streak>=-5 and line<-131 and s:SRA<6 and os:SRA!=0 and day!=Wednesday and F






    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
    Thanks. Looks very promising!
    Comment
    • Roadkill86
      SBR High Roller
      • 02-18-13
      • 138

      #597
      A very specific query regarding Cardinals/Reds games involving either of tomorrow night's starters.

      team=Cardinals and o:team=Reds and (starter=Shelby Miller or o:starter=Homer Bailey)
      Comment
      • nbilln
        SBR Rookie
        • 02-05-14
        • 13

        #598
        Looks like Cleveland won against in extra innings.

        Barely any samples, but as a road dog, coming off 2 extra inning games in which a team won the previous extra inning game against the team they are playing again.

        AD and p:XW and pp:X and SG=2
        Occurred earlier this year and the opponent covered RL as well. Last 4 have been loses as well (all covered).
        (could also just do AD and p:X and pp:X and SG=2) still yields decent results.
        Comment
        • posey
          SBR MVP
          • 05-23-14
          • 1112

          #599
          Hey guys. After following and reading the thread for a long time I finally registered to the forums.

          Tigers in a home game against a righthanded starter after they lost the last home game with at least 5 runs difference in a month past April since 2010:
          team=Tigers and p:margin<-6 and H and p:site=home and season>2009 and o:STR and month>4

          SU: 10-1
          (2.82, 90.9%)
          avg line:
          -153.3 / 137.5
          on / against:
          +$890 / -$905
          ROI:
          +53.3% / -81.9%
          RL: 7-4
          (1.32, 63.6%)
          avg line:
          146.2 / -159.5
          on / against:
          +$577 / -$656
          ROI:
          +51.6% / -37.2%
          OU: 4-5-2
          (0.18, 44.4%)
          avg total:
          8.6
          over / under:
          -$140 / +$65
          ROI:
          -11.6% / +5.3%
          Last edited by posey; 05-23-14, 08:18 AM.
          Comment
          • posey
            SBR MVP
            • 05-23-14
            • 1112

            #600
            Rockies on the road against a team from the NL East after a home game in Colorado since 2008:
            team=Rockies and o:division=NL East and A and p:H and season>2007
            SU
            2-11
            (-2.92, 15.4%)
            avg line:
            131.3 / -146.3
            on / against:
            -$867 / +$817
            ROI:
            -62.6% / +41.3%
            RL
            5-8
            (-2.12, 38.5%)
            avg line:
            -129.7 / 117.3
            on / against:
            -$506 / +$460
            ROI:
            -28.2% / +31.3%
            OU
            7-6-0
            (1.69, 53.8%)
            avg total:
            8.2
            over / under:
            +$50 / -$165
            ROI:
            +3.5% / -11.5%
            Last edited by posey; 05-23-14, 09:43 AM.
            Comment
            • posey
              SBR MVP
              • 05-23-14
              • 1112

              #601
              Games with home dogs with a dog line greater than 140 and a game total of less than 8.0 against Clayton Kershaw:
              o:starter=Clayton Kershaw and HD and line>140 and total<8
              SU
              0-9
              (-3.78, 0.0%)
              avg line:
              164.5 / -180.5
              on / against:
              -$900 / +$900
              ROI:
              -100.0% / +54.7%
              RL
              0-9
              (-2.28, 0.0%)
              avg line:
              -103.0 / -105.8
              on / against:
              -$976 / +$930
              ROI:
              -100.0% / +94.7%
              OU
              2-5-2
              (-0.44, 28.6%
              avg total:
              6.7
              over / under:
              -$370 / +$275
              ROI:
              -36.8% / +28.2%
              Comment
              • JMon
                SBR Hall of Famer
                • 12-11-09
                • 9800

                #602
                hey posey...welcome and bol to you and us miners!
                Comment
                • JMon
                  SBR Hall of Famer
                  • 12-11-09
                  • 9800

                  #603
                  This looks rather interesting...there was one big fav of <-200 within the time parameter of this situation and it was King Felix himself, whom lost? Astros????

                  H and tA(runs) <= 4.5 and 5.7 >= o:STDSERA >= 4.7 and o:conference = AL and month = 5 and 2010 <= season and rest = 0 and SG<4
                  Comment
                  • JMon
                    SBR Hall of Famer
                    • 12-11-09
                    • 9800

                    #604
                    Here we want to fade a AL road dog of >=130, with a starting pitcher of 3.5 or better; against a starter who throws more than 6.5 innings per start. enjoy and gl

                    A and line>=130 and STDSERA<=3.50 and t:conference=AL and A(Starter: o: innings pitched@o: starter and season) >6.5 and 2009<=season
                    Comment
                    • green7
                      SBR High Roller
                      • 10-21-10
                      • 190

                      #605
                      teams on a &gt;=3 game losing streak as HFs

                      conference non division opponents as home favs are +EV in series games 2 only.....looking at SD and Tigers.

                      Stronger for AL teams....tough to take a team like the Padres, but may do so anyway.

                      HF and streak <= -3 and not DIV and series game = 2 and C and playoffs = 0
                      Comment
                      • nbilln
                        SBR Rookie
                        • 02-05-14
                        • 13

                        #606
                        Originally posted by green7
                        conference non division opponents as home favs are +EV in series games 2 only.....looking at SD and Tigers.

                        Stronger for AL teams....tough to take a team like the Padres, but may do so anyway.

                        HF and streak <= -3 and not DIV and series game = 2 and C and playoffs = 0
                        maybe fading Edwin Jackson here will help you:


                        A and starter='Edwin Jackson' and s:walks allowed<2
                        fading Jackson on the road after he allows less than 2 walks in the previous outing.
                        surprising results ever since he went to the cubs.
                        EVEN better when you filter it for SG>1 and stays excellent after you filter it with the Cubs winning the previous game.
                        Comment
                        • Alex Vaile
                          SBR MVP
                          • 04-19-14
                          • 3724

                          #607
                          Originally posted by posey
                          Hey guys. After following and reading the thread for a long time I finally registered to the forums.

                          Tigers in a home game against a righthanded starter after they lost the last home game with at least 5 runs difference in a month past April since 2010:
                          team=Tigers and p:margin<-6 and H and p:site=home and season>2009 and o:STR and month>4

                          SU: 10-1
                          (2.82, 90.9%)
                          avg line:
                          -153.3 / 137.5
                          on / against:
                          +$890 / -$905
                          ROI:
                          +53.3% / -81.9%
                          RL: 7-4
                          (1.32, 63.6%)
                          avg line:
                          146.2 / -159.5
                          on / against:
                          +$577 / -$656
                          ROI:
                          +51.6% / -37.2%
                          OU: 4-5-2
                          (0.18, 44.4%)
                          avg total:
                          8.6
                          over / under:
                          -$140 / +$65
                          ROI:
                          -11.6% / +5.3%
                          Thanks for the querys! Cashed!
                          Comment
                          • green7
                            SBR High Roller
                            • 10-21-10
                            • 190

                            #608
                            Interesting query about the Cubs pitcher Jackson....I played it before I saw your submission...nice....don't know how some of you guys have the time to go through all the individual pitching stats, but if it gives you and others winners it's all good.
                            Comment
                            • Alex Vaile
                              SBR MVP
                              • 04-19-14
                              • 3724

                              #609
                              Lots of winners in here thanks everybody!
                              Comment
                              • posey
                                SBR MVP
                                • 05-23-14
                                • 1112

                                #610
                                Originally posted by JMon
                                hey posey...welcome and bol to you and us miners!
                                Thanks! Good results yesterday!
                                Originally posted by green7
                                Interesting query about the Cubs pitcher Jackson....I played it before I saw your submission...nice....don't know how some of you guys have the time to go through all the individual pitching stats, but if it gives you and others winners it's all good.
                                You're welcome.

                                Gonna start grinding the database now.
                                Comment
                                • posey
                                  SBR MVP
                                  • 05-23-14
                                  • 1112

                                  #611
                                  Lets get started with an easy one. The Indians on the road against the Orioles with both teams sending out a righthanded starter:

                                  'team=Indians and o:team=Orioles and A and STR and o:STR'

                                  SU
                                  4-9
                                  (-1.69, 30.8%)
                                  avg line:
                                  -101.4 / -108.6
                                  on / against:
                                  -$545 / +$500
                                  ROI:
                                  -38.7% / +34.4%
                                  RL
                                  4-6
                                  (-1.60, 40.0%)
                                  avg line:
                                  -116.9 / 103.0
                                  on / against:
                                  -$360 / +$284
                                  ROI:
                                  -26.2% / +22.3%
                                  OU
                                  12-0-1
                                  (4.12, 100.0%)
                                  avg total:
                                  9.3
                                  over / under:
                                  +$1,200 / -$1,275
                                  ROI:
                                  +81.1% / -92.7%
                                  Comment
                                  • nbilln
                                    SBR Rookie
                                    • 02-05-14
                                    • 13

                                    #612
                                    H and starter='John Danks' and s:runs allowed>6 and month>4
                                    here's how danks fares after a terrible start past the month of april.
                                    liking the movement on the line as well so might put this in early.

                                    for the TB/BOS game
                                    H and p:WOW and pp:WOW and SG=2 and season>2010
                                    fading a team starting off a series with a Walk off win after their last game was a walk off win
                                    some queries with david price's bounceback games support BOS but not sure if this would be a good play.
                                    Last edited by nbilln; 05-24-14, 03:53 AM.
                                    Comment
                                    • posey
                                      SBR MVP
                                      • 05-23-14
                                      • 1112

                                      #613
                                      Here come 3 queries for 1 bet.

                                      1) The Braves in a 2nd game of a home series in which they won the first game and are favorites with a line between -150 and -120 against a starter with an ERA higher than 3.0 in April, May or June since 2010:

                                      'series game=2 and team=Braves and H and p:W and -150 < line < -120 and 7>month and season>2009 and o:STDSERA>3':

                                      6-0 (3.50, 100.0%) avg line: -139.0 / 129.0 on / against: +$600 / -$600 ROI: +71.7% / -100.0%
                                      5-1 (2.00, 83.3%) avg line: 160.0 / -173.7 on / against: +$706 / -$775 ROI: +117.7% / -74.4%
                                      4-2-0 (1.92, 66.7%) avg total: 7.6 over / under: +$175 / -$255 ROI: +26.9% / -38.1%
                                      2) Mike Minor against the Rockies:
                                      'starter=Mike Minor and o:team=Rockies'

                                      4-0 (3.75, 100.0%) avg line: -151.6 / 137.6 on / against: +$400 / -$400 ROI: +64.3% / -100.0%
                                      2-2 (2.25, 50.0%) avg line: 123.2 / -134.2 on / against: +$57 / -$79 ROI: +14.2% / -14.7%
                                      2-2-0 (1.00, 50.0%) avg total: 8.8 over / under: -$30 / -$25 ROI: -6.7% / -5.7%
                                      3) The Braves hosting the Rockies with the Rockies sending out a righthanded starter with an ERA higher than 4.0 dating back to 2010:
                                      'team=Braves and o:team=Rockies and o:STR and o:STDSERA>4 and season>2009 and H'

                                      8-0 (4.12, 100.0%) avg line: -176.0 / 157.1 on / against: +$800 / -$800 ROI: +55.2% / -100.0%
                                      6-2 (2.62, 75.0%) avg line: 125.2 / -137.0 on / against: +$617 / -$679 ROI: +75.5% / -61.6%
                                      4-4-0 (0.00, 50.0%) avg total: 7.6 over / under: -$40 / -$50 ROI: -4.6% / -5.6%
                                      Last edited by posey; 05-24-14, 03:49 AM.
                                      Comment
                                      • posey
                                        SBR MVP
                                        • 05-23-14
                                        • 1112

                                        #614
                                        Originally posted by nbilln
                                        H and starter='John Danks' and s:runs allowed>6 and month>4
                                        here's how danks fares after a terrible start past the month of april.
                                        liking the movement on the line as well so might put this in early.
                                        Fading Danks today could be backed up using those two:
                                        - starter=John Danks and o:division=AL East and season>2009
                                        - starter=John Danks and o:division=AL East and season>2009 and H
                                        Comment
                                        • nbilln
                                          SBR Rookie
                                          • 02-05-14
                                          • 13

                                          #615
                                          Originally posted by posey
                                          Fading Danks today could be backed up using those two:
                                          - starter=John Danks and o:division=AL East and season>2009
                                          - starter=John Danks and o:division=AL East and season>2009 and H
                                          really loving the yanks in this spot.

                                          team=White Sox and p:HW and pp:HW and SG=3 and line>-150 and season>2010
                                          3-11 (-2.00, 21.4%) avg line: -105.1 / -104.9 on / against: -$960 / +$890 ROI: -59.8% / +55.5%
                                          2-12 (-2.21, 14.3%) avg line: 121.9 / -134.8 on / against: -$1,134 / +$1,094 ROI: -70.1% / +53.6%
                                          7-6-1 (1.46, 53.8%) avg total: 8.5 over / under: +$30 / -$165 ROI: +1.9% / -10.8%
                                          H and starter='John Danks' and p:W and pp:W and SG=3
                                          hes struggled to finish off the sweep at home AND
                                          H and starter='John Danks' and p:WOW
                                          cant keep the team's mojo running.

                                          A and team=Yankees and p:L and pp:L and SG=3 and season>2009 and line<150
                                          Yanks dont like getting swept on the road either.

                                          team=White Sox and p:WOW and season>2009
                                          white sox cant seem to win following a walk off win.
                                          starter='John Danks' and p:WOW and season>2010
                                          looks like Danks cant either.
                                          Comment
                                          • posey
                                            SBR MVP
                                            • 05-23-14
                                            • 1112

                                            #616
                                            Maybe one has thought of backing the Tigers again after yesterday's revenge against the Rangers. I stay away from it.
                                            Continuing yesterday's bet:
                                            The Tigers in a third consecutive home game, in which they won the previous home game against a righthanded starter after they lost the home game before by at least 7 runs:

                                            team=Tigers and pp:margin<-6 and p:H and pp:site=home and season>2009 and po:STR and month>4 and p:W

                                            SU: 2-6 (-1.50, 25.0%) | avg line: -144.0 / 130.7 | on / against: -$671 / +$591 | ROI: -57.5% / +69.1%
                                            RL: 1-6 (-3.50, 14.3%) | avg line: 136.3 / -148.9 | on / against: -$488 / +$456 | ROI: -66.6% / +43.2%
                                            OU: 4-3-0 (1.29, 57.1%) | avg total: 8.3 | over / under: +$75 / -$160 | ROI: +10.1% / -20.1%
                                            Comment
                                            • posey
                                              SBR MVP
                                              • 05-23-14
                                              • 1112

                                              #617
                                              @nbilln:
                                              Look at this:
                                              starter=John Danks and s:SPT>105 and s:margin<-2 and season>2010
                                              Comment
                                              • green7
                                                SBR High Roller
                                                • 10-21-10
                                                • 190

                                                #618
                                                A query that has won 13 straight versus run line and 11-2 last 13 games straight up

                                                playoffs = 0 and streak <= -3 and AD and SG = 2 and DIV and line<150 and p:runs<3 and p:margin=-1
                                                Comment
                                                • posey
                                                  SBR MVP
                                                  • 05-23-14
                                                  • 1112

                                                  #619
                                                  Reds as host against division opponents when favored between -160 and -105 in May since 2011:

                                                  14-2 (2.12, 87.5%) avg line: -132.8 / 122.8 on / against: +$1,130 / -$1,150 ROI: +52.6% / -71.9%
                                                  10-6 (0.62, 62.5%) avg line: 164.1 / -178.7 on / against: +$1,024 / -$1,167 ROI: +64.0% / -40.8%
                                                  10-6-0 (0.75, 62.5%) avg total: 8.0 over / under: +$360 / -$500 ROI: +20.6% / -28.1%
                                                  Cardinals as road dogs in division games in May since 2010:

                                                  2-5 (-0.71, 28.6%) avg line: 108.4 / -118.4 on / against: -$295 / +$275 ROI: -42.1% / +32.7%
                                                  3-4 (0.79, 42.9%) avg line: -191.6 / 175.7 on / against: -$445 / +$384 ROI: -33.2% / +54.9%
                                                  5-2-0 (1.21, 71.4%) avg total: 8.4 over / under: +$270 / -$365 ROI: +35.3% / -47.1%

                                                  Uh the odds have changed in my book. Now the Cards are favored.
                                                  Last edited by posey; 05-24-14, 08:51 AM.
                                                  Comment
                                                  • posey
                                                    SBR MVP
                                                    • 05-23-14
                                                    • 1112

                                                    #620
                                                    Originally posted by green7
                                                    playoffs = 0 and streak <= -3 and AD and SG = 2 and DIV and line<150 and p:runs<3 and p:margin=-1
                                                    I hope that you don't mind me taking your query as an inspiration. Came up with the following:

                                                    Rivals from the same league with both having a negative winning percentage, the away team having lost at least 2, the home team having won at least 1, the away team's away winning percentage being higher than the home team's home winning percentage, the road team being a dog, since 2011 in a month after April:
                                                    8-23 (-1.94, 25.8%) avg line: 119.3 / -129.7 on / against: -$1,392 / +$1,313 ROI: -44.8% / +32.7%
                                                    16-15 (-0.73, 51.6%) avg line: -167.5 / 152.7 on / against: -$866 / +$690 ROI: -16.1% / +20.6%
                                                    17-11-3 (1.08, 60.7%) avg total: 7.7 over / under: +$485 / -$790 ROI: +14.1% / -23.3%
                                                    Comment
                                                    • posey
                                                      SBR MVP
                                                      • 05-23-14
                                                      • 1112

                                                      #621
                                                      Cubs as road dogs in the third game of a series in which they won the first one and lost the second, with a starter who has an ERA higher than 4, dating back to 2010:

                                                      1-10 (-2.18, 9.1%) avg line: 148.5 / -163.5 on / against: -$842 / +$832 ROI: -76.5% / +44.9%
                                                      6-5 (-0.68, 54.5%) avg line: -150.2 / 137.2 on / against: -$73 / +$22 ROI: -4.6% / +2.0%
                                                      4-6-1 (-0.36, 40.0%) avg total: 8.4 over / under: -$280 / +$160 ROI: -22.6% / +13.4%
                                                      Comment
                                                      • JMon
                                                        SBR Hall of Famer
                                                        • 12-11-09
                                                        • 9800

                                                        #622
                                                        anyone else ever experience a slow response time on the Mlb database?
                                                        Comment
                                                        • emceeaye
                                                          SBR Wise Guy
                                                          • 08-20-13
                                                          • 704

                                                          #623
                                                          yes, I am too. Sometimes it's worse than this morning.
                                                          Comment
                                                          • posey
                                                            SBR MVP
                                                            • 05-23-14
                                                            • 1112

                                                            #624
                                                            Yeah me too. Few hours ago it was way faster.
                                                            Comment
                                                            • JMon
                                                              SBR Hall of Famer
                                                              • 12-11-09
                                                              • 9800

                                                              #625
                                                              Originally posted by emceeaye
                                                              yes, I am too. Sometimes it's worse than this morning.
                                                              freakin maddening.. I emailed Joe a couple of times and he says everything is fine. Perhaps if you emailed him too?????
                                                              Comment
                                                              • JMon
                                                                SBR Hall of Famer
                                                                • 12-11-09
                                                                • 9800

                                                                #626
                                                                look to see how the astros do on the road after allowing 6 or more runs in a NGT game. around the 2011 mark
                                                                Comment
                                                                • JMon
                                                                  SBR Hall of Famer
                                                                  • 12-11-09
                                                                  • 9800

                                                                  #627
                                                                  Originally posted by JMon
                                                                  look to see how the astros do on the road after allowing 6 or more runs in a NGT game. around the 2011 mark



                                                                  team=Mariners and H and po:LOB<10 and p:W and SG>1 and o:WP>=30 and 20110507<=date
                                                                  Comment
                                                                  • emceeaye
                                                                    SBR Wise Guy
                                                                    • 08-20-13
                                                                    • 704

                                                                    #628
                                                                    Originally posted by JMon
                                                                    look to see how the astros do on the road after allowing 6 or more runs in a NGT game. around the 2011 mark
                                                                    So...I think you're saying, that query contradicts the one you posted yesterday, right?
                                                                    Last edited by emceeaye; 05-24-14, 10:43 AM.
                                                                    Comment
                                                                    • JMon
                                                                      SBR Hall of Famer
                                                                      • 12-11-09
                                                                      • 9800

                                                                      #629
                                                                      Originally posted by emceeaye
                                                                      So...I think you're saying, that query contradicts the one you posted yesterday, right?
                                                                      indeed...

                                                                      not much action for me today.. like Balt, Laa and Balt ov.
                                                                      Comment
                                                                      • emceeaye
                                                                        SBR Wise Guy
                                                                        • 08-20-13
                                                                        • 704

                                                                        #630
                                                                        from now on I'll email him when the server is slow, which has happened quite a few times over the past few weeks, as long as I know his email Address... I'll check for it.
                                                                        Comment
                                                                        SBR Contests
                                                                        Collapse
                                                                        Top-Rated US Sportsbooks
                                                                        Collapse
                                                                        Working...