1. #1051
    b1slickguy
    WDKYWMYAK
    b1slickguy's Avatar SBR PRO
    Join Date: 11-24-11
    Posts: 11,072
    Betpoints: 28935

    Quote Originally Posted by Alex Vaile View Post
    Play Under 7 even D-Backs vs Mariners

    team=Diamondbacks and A and os:QS and p:W and date>=20140507

    (SDQG )

    Under 18 and 0 in this situation
    I'm with you on this under.
    Good luck.


    team=Mariners and p:H and p:RMAX<=1 and season>=2014

  2. #1052
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Quote Originally Posted by b1slickguy View Post
    I'm with you on this under.
    Good luck.


    team=Mariners and p:H and p:RMAX<=1 and season>=2014
    What a query!! Let's get it.

  3. #1053
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Giants - 146

    A and line>135 and p:BL=0 and pp:BL=0 and SG=20130423

    ( Dr.M )
    ROI % 13

    Same query as yesterday let's play it again now 18-1 this season
    Last edited by Alex Vaile; 07-28-15 at 07:22 PM.

  4. #1054
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Today's results: 2-4 - 2.56 units
    Season to date : 264-245 + 14.62 units

    Mets under and Cards under winners and Giants, Angels under, Twins, and Arizona under losers. I really thought Twins would win that after scoring 4 in 8th to tie but nope.

  5. #1055
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Under 7.5 -115 Reds vs Cardinals
    Play Under 7 + 110 Brewers vs Giants
    Play Under 8.5 + 100 White Sox vs Red Sox

    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)

    ( Bases )
    ROI % 29

  6. #1056
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Twins + 116

    s:SRA < 2 and 5 > ss:SRA > 0 and sss:SRA < 4 and ssss:SRA < 6 and 0 < sssss:SRA < 8 and os:SRA < 5 and SG < 4 and day != Tuesday and day != Thursday and 4 < starter rest < 10 and o:starter rest < 11 and 161 > game number > 27 and line > -165 and 2 > p:margin > -9 and 11.2 > tA(hits, N=10) > 6.7 and 6.2 < oA(hits, N=10) < 11.3 and STDSWHIP > .948 and ss:SPT > 67 and 40 < oss:SPT < 113 and tA(doubles, N=10) < 2.5 and tA(errors, N=10) > .1 and .3 < oA(BPRA, N=10) < 2.6 and tA(BPRA, N=10) < 2.8

    ( Bases )
    ROI % 27

  7. #1057
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Under 7 - 120 Athletics 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 and team=Dodgers

    (JMon)
    ROI % 34

    This is a solid under query but I added dodgers and it got a little nicer.

  8. #1058
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Today's results: 2-3 - 1.2 units
    Season to date : 266-248 + 13.42 units

    Cards under and Giants under winners and Red Sox Under, Twins and Dodger under losers

  9. #1059
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Nationals vs Marlins Under 6.5 - 102
    Play Rockies vs Cardinals Under 7 - 110

    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)

    ( Bases )
    ROI % 29

  10. #1060
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Indians vs Athletics Under 7 - 115

    4 < so:R1 < 9 and s:SRA < 10 and s:SPT < 110 and starter rest < 40 and s:SHRA < 3 and SG != 3 and (game number > 118 or game number < 107) and os:SRA < 7 and os:SHA > 2 and os:SSO < 10 and os:SHRA < 3 and ou streak > -3

    ( emceeaye )
    ROI % 40

    and

    H and total<=7 and STDSERA<=3.5 and t:conference=AL and s:SWA<=1 and ss:SWA<=1 and 2009<=season

    ( ???)
    ROI % 29

  11. #1061
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Brewers + 127

    (s:SRA + ss:SRA)=3 and A and (month= 5 or month =7) and os:SRA<6 and oss:SRA>2 and line>-184

    (Bases)
    ROI % 17

    And
    (s:SRA + ss:SRA) = 3 and A and (month = 5 or month = 7) and os:SRA < 6 and oss:SRA > 2 and line > -184 and p:hits > 5 and pp:hits > 6 and (op:hits + opp:hits + oppp:hits) > 14

    (Bases)
    ROI % 27

  12. #1062
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Today's results: 2-2 - .1 units
    Season to date : 268-250 + 13.32 units

    Indians under and Nats under winners and Cards under and Brewers shit bullpen losers. Starter gives up 0 through 7 and they lost.

  13. #1063
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Under 6.5 + 105 Nats vs Mets

    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 % 17
    Last edited by Alex Vaile; 08-01-15 at 01:20 AM.

  14. #1064
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Twins - 113

    H and 100>=line>-290 and month=7 and 12>total>5.5 and day!=Monday and day!=Tuesday and n:series game!=2 and series games>2 and start time<2210 and rest=0 and conference=o:conference and p:margin>-6 and p:hits>3 and p:errors<2 and op:errors<3

    ( PCG )
    ROI % 9

  15. #1065
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Marlins - 111

    (s:SRA + ss:SRA)=3 and A and (month= 5 or month =7) and os:SRA<6 and oss:SRA>2 and line>-184

    ( Bases )
    ROI % 17

    And

    (s:SRA + ss:SRA) = 3 and A and (month = 5 or month = 7) and os:SRA < 6 and oss:SRA > 2 and line > -184 and p:hits > 5 and pp:hits > 6 and (op:hits + opp:hits + oppp:hits) > 14

    ( Bases )
    ROI % 26

  16. #1066
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Over 8.5 - 118 Giants vs Rangers
    Play Over 8 - 112 Diamondbacks vs Astros

    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

  17. #1067
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Under 7.5 +107 Cubs vs Brewers
    Play Under 7.5 + 101 Padres vs Marlins
    Play Under 8.5 - 110 Yankees vs White Sox

    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)

    ( Bases )
    ROI % 29

  18. #1068
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Rays vs Red Sox Under 8.5 + 105

    team=Rays and AD and o:WP =20150503
    (SDQG )

    0 and 13 over under in this spot

  19. #1069
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Today's results : 4-5 - 1.22 units
    Season to date: 272-255 + 12.1 units

    Mets Under, Giants over , Dbacks over, Cubs under winners and White Sox under, Red Sox under, Padres Under gave up 5 in 11th, Twins and Marlins losers.

  20. #1070
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Blue Jays - 125

    starter=Mark Buehrle and HF and o:team=Royals
    16-2 su

    starter=Mark Buehrle and HF and p:W and pp:W and DAY

    AD and tS(o:hits-starter hits + o:walks - starter walks) / tS(9-starter innings pitched) <= 1.15 and line <= 150 and month < 9 and rest < 2

    ( Bking )
    ROI % 9

    Fade last query

  21. #1071
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Red Sox - 110

    league = o:league and WP < 50 and o:WP < 50 and streak <= -2 and o:streak >= 1 and AWP > o:HWP and AD and season > 2010 and month > 4

    ( Bases )
    ROI % 26

  22. #1072
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Over 8 -118 Giants vs Rangers
    Play Over 6 -117 Angels vs Dodgers
    Play Over 7.5 -102 Dbacks vs Astros

    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

  23. #1073
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Athletics + 100

    180 >= line >= 100 and tA(runs) <= 4.2 and o:STDSERA <= 3.5 and o:conference = AL and (p:runs + po:runs) <= 3 and 2009 <= season and o:rest = 0 and total > 6.5

    ( JMon )
    ROI % 42

  24. #1074
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Over 8 -105 Cubs vs Brewers

    team=Brewers and D and p:HL and p:LOB>16 and date>=20090905

    (SDQG )

    19 and 0 over/ under in this spot

  25. #1075
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Today's results: 4-3 + .53 units
    Season to date : 276-258 + 12.63 units

    Giants over, Astros over, Athletics and Red Sox winners and Brewers over, Jays and Dodger over losers.

  26. #1076
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Sunday's plays:

    Play Twins + 113

    p:errors = 0 and op:errors = 1 and (H or SG > 1) and SG < 5 and SGS > 2 and SGS - SG < 3 and (H or day != Saturday) and ((H and -215 < line < 142) or (A and -200 < line < 175)) and (conference = AL or o:conference = NL) and op:HR < 3 and p:runs > 2 and p:margin > -2 and 12 > pp:margin > -9 and streak < 5 and -7 < o:streak < 3 and p:SO < 14 and game number > 13 and -21 < tS(margin, N=10) < 29 and -30 < oS(margin, N=10) < 26 and s:SHA > 1 and s:SWA < 6 and s:SSO < 11 and s:SIP > 1.9 and s:SHF > 21 and s:SPT < 121 and 4 < starter rest < 17 and os:SRA < 7 and os:SWA < 6 and 20 < os:SHF < 33 and os:SIP < 8.1 and o:starter rest < 10 and op:runs < 9 and opp:runs < 13 and oppp:runs < 11 and oS(runs, N=10) > 21 and tS(HR, N=10) < 19 and tS(walks, N=10) > 16 and 42 < tS(SO, N=10) < 86 and site streak > -10 and o:site streak > -8 and op:SII < 5 and p:RMAX > 1 and oss:SHF > 13 and oss:SPT > 73 and -5 < tS(W, N=10) - oS(W, N=10) < 6 and -8 < tS(errors, N=10) - oS(errors, N=10) < 6 and opp:RMAX < 5

    ( Bases )
    ROI % 25

  27. #1077
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Under 6 - 115 Padres vs Marlins

    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)

    ( Bases )
    ROI % 29

  28. #1078
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Blue Jays - 140
    Play Royals RL - 155
    Play Blue Jays Under 8.5 + 100

    team=Royals and AD and p:W and pp:L and SG=SGS and DAY

    team=Blue Jays and HF and and p:L and pp:W and SG=SGS

    H and -8 > (starter wins - starter losses + o:starter losses - o:starter wins) > -14 and day != Wednesday and day != Thursday and day != Friday and 6 > s:SRA > 0 and p:hits < 13 and total > 6.5 and (1.4 > STDSWHIP>1.1 or tA(runs) > 4.8)

    ( Bases )
    ROI % 26

  29. #1079
    inZane
    inZane's Avatar Become A Pro!
    Join Date: 11-13-13
    Posts: 1,206
    Betpoints: 4906

    Quote Originally Posted by Alex Vaile View Post
    Play Blue Jays - 140
    Play Royals RL - 155
    Play Blue Jays Under 8.5 + 100

    team=Royals and AD and p:W and pp:L and SG=SGS and DAY

    team=Blue Jays and HF and and p:L and pp:W and SG=SGS

    H and -8 > (starter wins - starter losses + o:starter losses - o:starter wins) > -14 and day != Wednesday and day != Thursday and day != Friday and 6 > s:SRA > 0 and p:hits < 13 and total > 6.5 and (1.4 > STDSWHIP>1.1 or tA(runs) > 4.8)

    ( Bases )
    ROI % 26
    So by playing both sides of the same game, you're basically banking on a one run Toronto win to make any money. Good luck Alex, I like the under, but I'm not gonna try that other option.

  30. #1080
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Quote Originally Posted by inZane View Post
    So by playing both sides of the same game, you're basically banking on a one run Toronto win to make any money. Good luck Alex, I like the under, but I'm not gonna try that other option.
    Ya it didn't turn out exactly like I planned but close. I should have in hindsight played side and total.

  31. #1081
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Today's results: 2-3 - 1.7 units
    Season to date : 278-261 + 10.93 units

    Jays and Jays under winners and got burned bad on miami under (5 runs in 9th) and twins late and Royals RL losers.

    This week was a struggle in comparison to last week. 6 unit loss in the week. On to the next one...

  32. #1082
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Mets - 110

    DIV and D and p:W and 40<=o:WP<48

    ROI % 10

    Play Mets vs Marlins Under 7.5 - 105

    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)

    ( Bases )
    ROI % 29
    Last edited by Alex Vaile; 08-03-15 at 12:32 PM.

  33. #1083
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Brewers + 104

    s:SO > 9 and s:W and A and season > 2005 and -185<=line<=100 and conference = o:conference and starter rest < 10 and rest = 0 and SG<3 and month<9 and 10>=total>=7

    ( JMon )
    ROI % 25

  34. #1084
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Play Cubs +123

    s:SIP = 8 and 0 < s:SRA < 3 and s:SSO > 3 and 0 < s:SWA < 5 and s:SHF < 34 and starter rest < 7 and 3 < s:SHA < 6 and (A or day != Saturday) and (A or SG < 4) and line < 147 and 2 < p:hits < 16 and op:margin > -9 and game number < 154

    ( Bases )
    ROI % 25

  35. #1085
    Alex Vaile
    Alex Vaile's Avatar Become A Pro!
    Join Date: 04-19-14
    Posts: 3,724
    Betpoints: 933

    Today's results : 1-2 - 1.05 units
    Season to date : 279-263 + 9.08 units

    Mets winners Mets Under and Brewers losers.
    Cubs postponed

First ... 28293031323334 ... Last
Top