MLB - Situation Plays - SDQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • JMon
    SBR Hall of Famer
    • 12-11-09
    • 9800

    #2206
    I posted Laa, Det, Laa under, and Cubs. Play at your own risk, especially if you dont understand sdql. The guys may have other plays or plays that contradict mine.
    Comment
    • Alex Vaile
      SBR MVP
      • 04-19-14
      • 3724

      #2207
      Originally posted by tarosill
      A scary query.

      D and starter wins - o:starter wins < -8 and s:W and os:L and oss:W and o:starter rest < 8 and SG < 4 and season > 2011
      2 and 0 today with this. Nice job!
      Comment
      • Alex Vaile
        SBR MVP
        • 04-19-14
        • 3724

        #2208
        Originally posted by Alex Vaile
        Second play: ( Bases or JMon )

        Under 8.5 +105 Athletics vs Astros

        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.3
        Such bulls h t they score 4 in the ninth. I waited and bet this at 9 -120 also but posted play lost.
        Comment
        • Alex Vaile
          SBR MVP
          • 04-19-14
          • 3724

          #2209
          0 and 4 for -5.04 units.
          102 and 84
          +10.66 units
          Glad I hit that yankees and pirates and angels plays from u guys.
          Comment
          • emceeaye
            SBR Wise Guy
            • 08-20-13
            • 704

            #2210
            Originally posted by Alex Vaile
            0 and 4 for -5.04 units.
            102 and 84
            +10.66 units
            Glad I hit that yankees and pirates and angels plays from u guys.
            Alex, thanks for posting good Bases' unders lately overall. Bummer of an Angels game for the under.
            Comment
            • emceeaye
              SBR Wise Guy
              • 08-20-13
              • 704

              #2211
              Rays/Orioles under

              Not sure whose query this is, so forgive me if I didn't give you credit:

              This one has a great record and if you add "LGS" or "SG=4" it looks even better. Also take a look at day=Thursday and although N gets smaller, it looks promising.

              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

              Comment
              • Alex Vaile
                SBR MVP
                • 04-19-14
                • 3724

                #2212
                Originally posted by emceeaye
                Alex, thanks for posting good Bases' unders lately overall. Bummer of an Angels game for the under.
                Yup. They look great on paper but haven't cashed much this week. Had a good run last week I feel today as a good day! Thanks emceeaye!
                Comment
                • Alex Vaile
                  SBR MVP
                  • 04-19-14
                  • 3724

                  #2213
                  First play: ( Bases )

                  Under 7 -110 Braves vs Mets

                  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
                  • mdunlap3
                    SBR MVP
                    • 02-18-13
                    • 1847

                    #2214
                    N/A
                    Last edited by mdunlap3; 08-28-14, 11:06 AM. Reason: query grammar error fix
                    Comment
                    • Alex Vaile
                      SBR MVP
                      • 04-19-14
                      • 3724

                      #2215
                      I still don't understand this query but it just looks so good.
                      I think slickguy made it.


                      D and A and A(W, N=10) > 0.4 and S(W, N=4) >= 2

                      Points to royals, angels, giants, orioles, and astros.
                      Comment
                      • emceeaye
                        SBR Wise Guy
                        • 08-20-13
                        • 704

                        #2216
                        royals su

                        Here's a beauty by b1slick or Jmon:

                        (team=Twins or team=Rangers) and D and oS:W and oS:season=season and season>=2012

                        Add SG=3 and take a look at just team=Twins...
                        Comment
                        • mdunlap3
                          SBR MVP
                          • 02-18-13
                          • 1847

                          #2217
                          N/a
                          Last edited by mdunlap3; 08-28-14, 11:06 AM. Reason: Errors
                          Comment
                          • JMon
                            SBR Hall of Famer
                            • 12-11-09
                            • 9800

                            #2218
                            Originally posted by Alex Vaile
                            I still don't understand this query but it just looks so good.
                            I think slickguy made it.


                            D and A and A(W, N=10) > 0.4 and S(W, N=4) >= 2

                            Points to royals, angels, giants, orioles, and astros.
                            This is the one that part of the query is not predictive. I made reference to this back awhile ago...do not use.
                            Comment
                            • mdunlap3
                              SBR MVP
                              • 02-18-13
                              • 1847

                              #2219
                              N/A again...sorry i keep messing up.
                              Last edited by mdunlap3; 08-28-14, 01:18 PM.
                              Comment
                              • emceeaye
                                SBR Wise Guy
                                • 08-20-13
                                • 704

                                #2220
                                Anyone having trouble with db?
                                Comment
                                • mdunlap3
                                  SBR MVP
                                  • 02-18-13
                                  • 1847

                                  #2221
                                  Originally posted by emceeaye
                                  Anyone having trouble with db?
                                  Yup 502 Bad gateway error here.
                                  Comment
                                  • emceeaye
                                    SBR Wise Guy
                                    • 08-20-13
                                    • 704

                                    #2222
                                    Originally posted by mdunlap3
                                    Yup 502 Bad gateway error here.
                                    Yeah, I'm getting no query box...oh well, so much for lunch break query running
                                    Comment
                                    • emceeaye
                                      SBR Wise Guy
                                      • 08-20-13
                                      • 704

                                      #2223
                                      HyaHya,
                                      Did you happen to run queries and create a list of results for today...they have been helpful as I can cross-reference my results with yours to look for consistencies and conflicting results, which helps to narrow down picks...

                                      Then again if this db keeps acting up until the end of the day, then we won't be able to run anymore queries before game time
                                      Comment
                                      • mdunlap3
                                        SBR MVP
                                        • 02-18-13
                                        • 1847

                                        #2224
                                        Ugh extremely frustrating....
                                        Comment
                                        • JMon
                                          SBR Hall of Famer
                                          • 12-11-09
                                          • 9800

                                          #2225
                                          I remember back several years ago, them selling their db, per sport. But one would have to maintain it going forward. Thus enter matchups, lines, wins/losses,etc. Doesn't sound like a bad idea now.
                                          Comment
                                          • Alex Vaile
                                            SBR MVP
                                            • 04-19-14
                                            • 3724

                                            #2226
                                            BRUCE CHEN IS TRASH. Top 10th line
                                            6 hits 6 runs 2 walks 36 pitches in what was a tie game. Add him to Phil Coke and Bellasario, Tony Sipp on Astros. Just awful.
                                            Comment
                                            • JMon
                                              SBR Hall of Famer
                                              • 12-11-09
                                              • 9800

                                              #2227
                                              Slicker's beauty is active today on the Phillies and Twins. Both would be nice, but only need to catch one for a profit!

                                              SDQL

                                              A and total>7 and p:SII>=4 and p:hits>12 and WP<50 and season=2014 and pp:SII<4
                                              Comment
                                              • JMon
                                                SBR Hall of Famer
                                                • 12-11-09
                                                • 9800

                                                #2228
                                                Play Bos

                                                SDQL

                                                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 and team=Red Sox
                                                Comment
                                                • JMon
                                                  SBR Hall of Famer
                                                  • 12-11-09
                                                  • 9800

                                                  #2229
                                                  Play Milw

                                                  SDQL by bases

                                                  AD and (SG = 1 or SG = 3) and playoffs = 0 and streak > -4 and -8 < o:streak < 6 and -7 < p:margin < 10 and -10 < op:margin < 9 and p:runs < 13 and op:runs != 0 and p:hits > 1 and 3 < op:hits < 15 and op:doubles < 6 and p:triples < 3 and op:triples < 2 and p:SO > 3 and 2 < op:SO < 17 and 3 < p:ground balls < 21 and 2 < op:ground balls < 24 and p:fly balls < 16 and 2 < op:fly balls < 16 and op:BPRA < 9 and 1.5 < p:SIP < 8.1 and 1.9 < op:SIP < 8.5 and 33 < p:SPT < 116 and 48 < op:SPT < 111 and op:SHF < 34 and 27 < p:batters faced < 46 and 28 < op:batters faced < 57 and p:at bats + p:walks < 48 and op:at bats + op:walks < 46 and 0 < p:TLOB < 12 and 0 < op:TLOB < 13 and (14 > site streak > 5 or -1 > site streak > -12) and (1 < o:site streak < 10 or -11 < o:site streak < -5) and (conference = AL or o:conference = NL) and op:RMAX < 8 and op:R1 < 5 and op:R2 < 4 and op:R3 < 3 and p:errors < 3 and op:errors < 4 and os:SHA < 12 and os:SRA < 7 and 0 < os:SWA < 5 and s:SPT > 83 and starter rest < 12 and s:SIP > 4.9 and s:SHF > 21 and s:SSO < 10 and op:BL < 8 and 2 < p:PU < 7 and -39 < tS(margin, N=10) - oS(margin, N=10) < 32 and oS(HR, N=10) > 4 and 3 < tS(HR, N=10) < 19 and oS(doubles, N=10) < 29 and tS(hits, N=10) > 63 and 65 < oS(hits, N=10) < 105 and line < 225 and day != Sunday and oss:SHA < 11 and oss:SHRA < 3 and game number > 24 and tS(margin, N=20) - oS(margin, N=20) < 43 and tS(hits, N=20) - oS(hits, N=20) < 27 and team=Brewers
                                                  Comment
                                                  • JMon
                                                    SBR Hall of Famer
                                                    • 12-11-09
                                                    • 9800

                                                    #2230
                                                    Play Atl under

                                                    SDQL by bases (note space after o:

                                                    H and -7 < ou streak < 2 and -6 < o: ou streak < 2 and SG < 4 and 5 > SGS > 2 and 11.5 > total > 6 and p:hits < 18 and op:hits < 17 and pp:hits < 18 and 3 < ppp:hits < 17 and pppp:hits < 16 and ppppp:hits < 15 and pppppp:hits > 2 and opp:hits < 15 and s:SRA < 5 and 0 < os:SRA < 10 and 2 < s:SHA < 10 and s:SHRA < 2 and os:SHRA < 3 and os:SWA < 7 and s:SSO > 3 and s:SHF < 33 and 16 < os:SHF < 34 and 73 < os:SPT < 110 and 76 < s:SPT < 117 and starter rest < 13 and o:starter rest < 11 and day != Monday and -22.5 < tS(ou margin, N=6) < 10.5 and -15 < oS(ou margin, N=6) < 18.5 and ss:SRA < 6 and ss:SHA > 2 and ss:SSO > 1 and ss:SHF > 19 and oss:SHF < 32 and 4 < s:starter rest < 9 and os:starter rest < 22 and game number < 154 and tS(O, N=10) < 7 and 23 < tS(runs, N=10) < 63 and 36 < tS(hits, N=6) < 65 and 1 < oS(errors, N=10) < 10
                                                    Comment
                                                    • JMon
                                                      SBR Hall of Famer
                                                      • 12-11-09
                                                      • 9800

                                                      #2231
                                                      Play Sea over

                                                      SDQL by bases

                                                      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
                                                      Comment
                                                      • hyahya
                                                        SBR High Roller
                                                        • 03-08-14
                                                        • 165

                                                        #2232
                                                        Originally posted by emceeaye
                                                        HyaHya,
                                                        Did you happen to run queries and create a list of results for today...they have been helpful as I can cross-reference my results with yours to look for consistencies and conflicting results, which helps to narrow down picks...

                                                        Then again if this db keeps acting up until the end of the day, then we won't be able to run anymore queries before game time
                                                        Just saw this EMC, will post my list whenever I have the chance.
                                                        Comment
                                                        • mdunlap3
                                                          SBR MVP
                                                          • 02-18-13
                                                          • 1847

                                                          #2233
                                                          Originally posted by Alex Vaile
                                                          BRUCE CHEN IS TRASH. Top 10th line
                                                          6 hits 6 runs 2 walks 36 pitches in what was a tie game. Add him to Phil Coke and Bellasario, Tony Sipp on Astros. Just awful.
                                                          Ugh...feel your pain man, tough couple of days. Lets make it up this weekend bro.
                                                          Comment
                                                          • b1slickguy
                                                            SBR Posting Legend
                                                            • 11-24-11
                                                            • 11959

                                                            #2234
                                                            Originally posted by Alex Vaile
                                                            BRUCE CHEN IS TRASH. Top 10th line
                                                            6 hits 6 runs 2 walks 36 pitches in what was a tie game. Add him to Phil Coke and Bellasario, Tony Sipp on Astros. Just awful.
                                                            I was watching the game and when I saw Chen on the mound to start the 10th I knew it was over. He's THE weak link in the Royals bullpen. If Hochevar was healthy, Chen would be gone.
                                                            Good luck.
                                                            Comment
                                                            • mdunlap3
                                                              SBR MVP
                                                              • 02-18-13
                                                              • 1847

                                                              #2235
                                                              SDQL by bases-

                                                              Mets under
                                                              Giants under




                                                              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
                                                              • hyahya
                                                                SBR High Roller
                                                                • 03-08-14
                                                                • 165

                                                                #2236
                                                                29 230

                                                                rangers
                                                                cubs

                                                                dodgers

                                                                reds

                                                                bosox

                                                                indians

                                                                37 270

                                                                braves

                                                                38 250

                                                                A's

                                                                yanks

                                                                5.1 1800

                                                                A's

                                                                tigers

                                                                39 200

                                                                indians

                                                                33 350

                                                                rays

                                                                43 150

                                                                angels

                                                                28 570

                                                                rangers
                                                                reds
                                                                bosox

                                                                26 630

                                                                under braves

                                                                29 370

                                                                cubs

                                                                18 75

                                                                cards

                                                                17 1570

                                                                brew

                                                                phils
                                                                dodgers
                                                                reds

                                                                37 165

                                                                under braves

                                                                11 1350

                                                                phils

                                                                dodgers

                                                                31 320

                                                                bosox

                                                                23.5 800

                                                                over nats

                                                                29 500

                                                                angels

                                                                31 530

                                                                under brew

                                                                under phils

                                                                8.3 800

                                                                cards

                                                                21 900

                                                                under braves

                                                                31 400

                                                                cards RL

                                                                royals RL

                                                                mariners RL

                                                                17 70

                                                                cards

                                                                29 430

                                                                giants
                                                                Last edited by hyahya; 08-29-14, 08:54 AM.
                                                                Comment
                                                                • mdunlap3
                                                                  SBR MVP
                                                                  • 02-18-13
                                                                  • 1847

                                                                  #2237
                                                                  SDQL (not sure of source, forgive me)

                                                                  Play Dbacks

                                                                  This query is extremely hot this season.... 21-1 last 22, and 24-7 this season.

                                                                  HF and line < -130 and tS(hits) / tS(at bats) < 0.25 and p:RMAX < 6 and o:STDSERA >= 4.8 and 1 < os:SIP < 9 and o:starter rest < 8 and 0.21 < tS(o:hits, N=18) / tS(o:at bats, N=18) < 0.26 and conference = NL
                                                                  Comment
                                                                  • mdunlap3
                                                                    SBR MVP
                                                                    • 02-18-13
                                                                    • 1847

                                                                    #2238
                                                                    Originally posted by JMon
                                                                    Slicker's beauty is active today on the Phillies and Twins. Both would be nice, but only need to catch one for a profit!

                                                                    SDQL

                                                                    A and total>7 and p:SII>=4 and p:hits>12 and WP<50 and season=2014 and pp:SII<4
                                                                    I don't see Phils coming up on this one, see the Twins though. On it with you man.
                                                                    Comment
                                                                    • b1slickguy
                                                                      SBR Posting Legend
                                                                      • 11-24-11
                                                                      • 11959

                                                                      #2239
                                                                      Originally posted by mdunlap3
                                                                      I don't see Phils coming up on this one, see the Twins though. On it with you man.
                                                                      Total dropped to 7 on the PHI/NYM game.
                                                                      Good luck.
                                                                      Comment
                                                                      • Alex Vaile
                                                                        SBR MVP
                                                                        • 04-19-14
                                                                        • 3724

                                                                        #2240
                                                                        Originally posted by b1slickguy
                                                                        I was watching the game and when I saw Chen on the mound to start the 10th I knew it was over. He's THE weak link in the Royals bullpen. If Hochevar was healthy, Chen would be gone.
                                                                        Good luck.
                                                                        Glad I wasn't the only one! Garbage man that's what they should call him. Or giver, not pitcher!
                                                                        Comment
                                                                        SBR Contests
                                                                        Collapse
                                                                        Top-Rated US Sportsbooks
                                                                        Collapse
                                                                        Working...