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

    Dr M's plays 3 and 0 yesterday.
    5 and 2 overall

  2. #37
    chopperocker
    Hang on baby, cuz life's a BITCH!!!
    chopperocker's Avatar Become A Pro!
    Join Date: 08-16-09
    Posts: 1,784
    Betpoints: 55608

    team=Ravens and 8
    Last edited by chopperocker; 09-17-14 at 10:42 PM.

  3. #38
    Mako-SBR
    Mako-SBR's Avatar Become A Pro!
    Join Date: 10-15-13
    Posts: 492
    Betpoints: 3262

    A few scenarios for you guys to check the validity on via SDQL if you're bored today (or better, at work ha). Haven't gotten a chance to enter/research them myself as I'm on the road:

    S03: Home Team, After Previous Week Thursday Night Football Loss Of 8 Or More Points


    S07: Away Dogs, Division Game, Closes at +10.5 or more Points, Games 1 Through 11 Only


    S10: All +3 to +7 Point Dogs Playing In Non-Division Games Who Lost By 20 Or More Points The Previous Week


    S14: All Away Teams On MNF In Division Games Where The Spread Closes Anywhere Between -8 and +6.5

  4. #39
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Quote Originally Posted by chopperocker View Post
    team=Ravens and 8

    team=Ravens and 8 < t:rest and (2008,1)<=(season,week)

    chopper ...note space before/after <

  5. #40
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Quote Originally Posted by Mako-SBR View Post
    A few scenarios for you guys to check the validity on via SDQL if you're bored today (or better, at work ha). Haven't gotten a chance to enter/research them myself as I'm on the road:

    S03: Home Team, After Previous Week Thursday Night Football Loss Of 8 Or More Points


    S07: Away Dogs, Division Game, Closes at +10.5 or more Points, Games 1 Through 11 Only


    S10: All +3 to +7 Point Dogs Playing In Non-Division Games Who Lost By 20 Or More Points The Previous Week


    S14: All Away Teams On MNF In Division Games Where The Spread Closes Anywhere Between -8 and +6.5
    S03: H and p:day=Thursday and p:margin<=-8

    S07: A and DIV and line>=10.5 and 11>=game number>=1

    S10: 7>=line>=3 and NDIV and p:margin<=-20

    S14: A and day=Monday and DIV and -8< line <6.5

    like a couple here

    note eliminate spaces -8< line <6.5

  6. #41
    emceeaye
    emceeaye's Avatar Become A Pro!
    Join Date: 08-20-13
    Posts: 704
    Betpoints: 2709

    Quote Originally Posted by JMon View Post
    S03: H and p:day=Thursday and p:margin<=-8

    S07: A and DIV and line>=10.5 and 11>=game number>=1

    S10: 7>=line>=3 and NDIV and p:margin<=-20

    S14: A and day=Monday and DIV and -8< line <6.5

    like a couple here

    note eliminate spaces -8< line <6.5
    Thanks!

    Here is Dr. M's query from yesterday on NFL:

    team=Steelers and A and p:AD and po: points>=10 and season>=1999

    Its consistent with the one you posted:
    7>=line>=3 and NDIV and p:margin<=-20
    Last edited by emceeaye; 09-19-14 at 06:05 PM.

  7. #42
    chopperocker
    Hang on baby, cuz life's a BITCH!!!
    chopperocker's Avatar Become A Pro!
    Join Date: 08-16-09
    Posts: 1,784
    Betpoints: 55608

    Quote Originally Posted by JMon View Post
    team=Ravens and 8 < t:rest and (2008,1)<=(season,week)

    chopper ...note space before/after <
    thanx bro!

  8. #43
    chopperocker
    Hang on baby, cuz life's a BITCH!!!
    chopperocker's Avatar Become A Pro!
    Join Date: 08-16-09
    Posts: 1,784
    Betpoints: 55608

    team=Ravens and 8 < t:rest and (2008,1)<=(season,week)

    12-1 su 9-4 ats

    8 < t:rest and (2004,1)<=(season,week) and op:HDW

    27-10 su 27-9-1 ats

    p:FL and p:TO=4 and po:TO=0 and HD

    3-0 suats

    p:FL and p:TO=4 and po:TO=0 and D

    17-7-1 ats

  9. #44
    chopperocker
    Hang on baby, cuz life's a BITCH!!!
    chopperocker's Avatar Become A Pro!
    Join Date: 08-16-09
    Posts: 1,784
    Betpoints: 55608

    p:H and HD and op:A and (2009,1)<=(season,week)

    28-11-2 Over

  10. #45
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Play NYG/HOU OV

    Basically we want to play over with a poor rushing team facing a poor rushing defense.

    SDQL

    tA(RY) <= 70 and 125 >= oA(o:RY) >= 95 and p:RY <= 99 and pp:RY <= 99

  11. #46
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Quote Originally Posted by chopperocker View Post

    8 < t:rest and (2004,1)<=(season,week) and op:HDW
    8 < t:rest and (2004 , 1) <= (season , week) and op:HDW and (line >= 3 or line <= -3.5) and game number > 2

    thanks for sharing chopper! just added a line parameter as it appeared most losses came from the +3 to -3 area. Check out NFC conf as well.

  12. #47
    chopperocker
    Hang on baby, cuz life's a BITCH!!!
    chopperocker's Avatar Become A Pro!
    Join Date: 08-16-09
    Posts: 1,784
    Betpoints: 55608

    Quote Originally Posted by JMon View Post
    8 < t:rest and (2004 , 1) <= (season , week) and op:HDW and (line >= 3 or line <= -3.5) and game number > 2

    thanks for sharing chopper! just added a line parameter as it appeared most losses came from the +3 to -3 area. Check out NFC conf as well.
    excellent! we will keep this one in our back pocket.

  13. #48
    FlyinAir
    SDQL
    FlyinAir's Avatar Become A Pro!
    Join Date: 07-14-14
    Posts: 1,612
    Betpoints: 221

    MONDAY NIGHT FOOTBALL TREND
    The home favorite is 11-2 SU when the total is between 44 and 49 since 2011. 12-3 since 2010 (80%)

    HF and day=Monday and season>=2010 and total>44 and total<49

  14. #49
    nash13
    nash13's Avatar Become A Pro!
    Join Date: 01-21-14
    Posts: 1,122
    Betpoints: 7160

    I have four SDQL circumstances for NFL.

    Sum(ats margin > 0@team and season, N=6) < 2 and WP < 25 and site != p:site
    week > 7 and wins = 0 and line > 5
    AF and p:W and pp:W and ppp:W and conference != o:conference and total < 46

    first one works for ATS and TOT
    second one ATS
    third is for overs

  15. #50
    chopperocker
    Hang on baby, cuz life's a BITCH!!!
    chopperocker's Avatar Become A Pro!
    Join Date: 08-16-09
    Posts: 1,784
    Betpoints: 55608

    op:W and pp:HFL and p:AFL and HF and (1989,1)<=(season,week) 13-3-1 to the Under

  16. #51
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Play over Jets/Bears

    Basically this spot, while limited is in sample but successful, is play over btw two non conference teams coming off games where they covered the spread. Note below other parameters within.

    SDQL

    -4<=line<=4 and not C and p:ATSW and op:ATSW and 47>=total>=43 and season>=1997 and H

    Since 1997 we have seen this spot go....

    O/U: 30-7-0 (8.69, 81.1%)

  17. #52
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Looks like 3-0 in this thread this week gents. Keep it up!

  18. #53
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Quote Originally Posted by nash13 View Post
    I have four SDQL circumstances for NFL.

    Sum(ats margin > 0@team and season, N=6) < 2 and WP < 25 and site != p:site
    week > 7 and wins = 0 and line > 5
    AF and p:W and pp:W and ppp:W and conference != o:conference and total < 46

    first one works for ATS and TOT
    second one ATS
    third is for overs
    Thanks for sharing nash13

  19. #54
    emceeaye
    emceeaye's Avatar Become A Pro!
    Join Date: 08-20-13
    Posts: 704
    Betpoints: 2709

    Quote Originally Posted by JMon View Post
    Play over Jets/Bears

    Basically this spot, while limited is in sample but successful, is play over btw two non conference teams coming off games where they covered the spread. Note below other parameters within.

    SDQL

    -4<=line<=4 and not C and p:ATSW and op:ATSW and 47>=total>=43 and season>=1997 and H

    Since 1997 we have seen this spot go....

    O/U: 30-7-0 (8.69, 81.1%)
    Beautiful!

  20. #55
    hyahya
    hyahya's Avatar Become A Pro!
    Join Date: 03-08-14
    Posts: 165

    HD and p:AW and line<6 and op:HW

  21. #56
    emceeaye
    emceeaye's Avatar Become A Pro!
    Join Date: 08-20-13
    Posts: 704
    Betpoints: 2709

    Quote Originally Posted by hyahya View Post
    HD and p:AW and line<6 and op:HW
    Thanks!

    Add week<=5 to improve record.

  22. #57
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Quote Originally Posted by hyahya View Post
    HD and p:AW and line<6 and op:HW
    love ml %...made some minor adjustments.

    H and p:AW and op:HW and (5.5 >= line >= 1.5 or line >= 8.5) and division!=NFC East

  23. #58
    hyahya
    hyahya's Avatar Become A Pro!
    Join Date: 03-08-14
    Posts: 165

    p:ALF and HF and o:streak>2

  24. #59
    hyahya
    hyahya's Avatar Become A Pro!
    Join Date: 03-08-14
    Posts: 165

    p:AW and HD and line<4 and DIV

  25. #60
    Timmay
    Timmay's Avatar Become A Pro!
    Join Date: 09-09-08
    Posts: 1,301
    Betpoints: 6751

    Quote Originally Posted by hyahya View Post
    p:ALF and HF and o:streak>2

    What does this mean?

  26. #61
    chopperocker
    Hang on baby, cuz life's a BITCH!!!
    chopperocker's Avatar Become A Pro!
    Join Date: 08-16-09
    Posts: 1,784
    Betpoints: 55608

    Quote Originally Posted by Timmay View Post
    What does this mean?
    http://killersports.com/Download/NFL/query_manual.pdf

  27. #62
    hyahya
    hyahya's Avatar Become A Pro!
    Join Date: 03-08-14
    Posts: 165

    p:O and pp:O and op:U and AD and 8>line and season>2003 and total>45

  28. #63
    hyahya
    hyahya's Avatar Become A Pro!
    Join Date: 03-08-14
    Posts: 165

    p:HLF and conference!=o:conference and AD and line<6

  29. #64
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Play Oak, possible ML

    SDQL from KS newsletter

    team=Dolphins and F and oA(TY)/ oA(plays)<4.98 and date>=20031019 and p:line<10

  30. #65
    FortySix
    FortySix's Avatar Become A Pro!
    Join Date: 02-18-14
    Posts: 134
    Betpoints: 2308

    Quote Originally Posted by JMon View Post
    Play Oak, possible ML

    SDQL from KS newsletter

    team=Dolphins and F and oA(TY)/ oA(plays)<4.98 and date>=20031019 and p:line<10
    JMon, are you still playing this line even though the game is in London?

  31. #66
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Quote Originally Posted by FortySix View Post
    JMon, are you still playing this line even though the game is in London?
    Ya I am going to take a shot at it. It doesn't have a site parameter so it does not bring me much concern. bol

  32. #67
    chopperocker
    Hang on baby, cuz life's a BITCH!!!
    chopperocker's Avatar Become A Pro!
    Join Date: 08-16-09
    Posts: 1,784
    Betpoints: 55608

    week+2=tn:week and (1989,1)<=(season,week) and site=home and op:A and opp:A

    8-0 SUATS since '89

  33. #68
    chopperocker
    Hang on baby, cuz life's a BITCH!!!
    chopperocker's Avatar Become A Pro!
    Join Date: 08-16-09
    Posts: 1,784
    Betpoints: 55608

    week<=4 and (2014,1)<=(season,week) and AF

    12-3 to the Over

    rather extreme for a short term small sample, but worth noting.

  34. #69
    emceeaye
    emceeaye's Avatar Become A Pro!
    Join Date: 08-20-13
    Posts: 704
    Betpoints: 2709

    Quote Originally Posted by chopperocker View Post
    week<=4 and (2014,1)<=(season,week) and AF

    12-3 to the Over

    rather extreme for a short term small sample, but worth noting.
    This is nice as it is consistent with results of Dr. M's posted query of the day:

    A and Patriots:Rob Gronkowski: p:receiving touchdowns>0 and p:W and NB

    (Remove space after 2nd colon)

  35. #70
    chopperocker
    Hang on baby, cuz life's a BITCH!!!
    chopperocker's Avatar Become A Pro!
    Join Date: 08-16-09
    Posts: 1,784
    Betpoints: 55608

    week 5 look ahead queries

    tp:week+2=t:week and (1989,1)<=(season,week) and WP>99 and AD

    1-13 SU, 3-11 ATS since '89


    week+2=tn:week and (1989,1)<=(season,week) and site=home and op:A and opp:A

    8-0 SUATS since '89

First 12345 ... Last
Top