1. #1
    darkghost
    darkghost's Avatar SBR PRO
    Join Date: 09-19-05
    Posts: 1,398
    Betpoints: 11501

    Sdql help

    I got no help in the football forum so reposting here:

    I am looking to see which correlated parlay works best for first half, second half and full game of a college football game. Is it dog and under? Fav and over? Or dog and over?

    Here are the parameters I'm thinking about:
    Cfb, year 2011-2017, week 5-6 only, 1H, dog must be 10+ Points, total must be +14 or less from the point spread

    same for 2H

    for full game, everything is the same except, dogs getting 20+ Points, total must be +20 or less from the point spread.

    Sorry if my post is confusing. It's too damn early for me.

    100 points for the first accurate, working query.

    SBR Founder Join Date: 9/19/2005


  2. #2
    JoeCool20
    DON'T FUKIN CRY ABOUT POKER CHAT POSTS!
    JoeCool20's Avatar SBR PRO
    Join Date: 05-31-18
    Posts: 1,967
    Betpoints: 12

    HUH?
    175 pts

    3-QUESTION
    SBR TRIVIA WINNER 07/11/2019

    175 pts

    3-QUESTION
    SBR TRIVIA WINNER 07/08/2019


  3. #3
    Optional
    Optional's Avatar Moderator
    Join Date: 06-10-10
    Posts: 39,791
    Betpoints: 5916

    Quote Originally Posted by JoeCool20 View Post
    HUH?
    SDQL = Sports Data Query Language

    Have a try here http://sportsdatabase.com/ncaafb/query

    $20
    Angelman
    donation 02/18/2019

    SBR
    Forum
    Mod
    Squad

    SBR Bash
    Punta Cana
    Attendee 2/4/2017


  4. #4
    snapperman2
    Keep bothering on
    snapperman2's Avatar SBR PRO
    Join Date: 08-19-10
    Posts: 2,038
    Betpoints: 7705

    season>=2011 and season<=2017 and week>=5 and week<=6 and line>=20 and total<=(line+20) and ats margin>0

    (Shows number of overs and unders when dog wins.)

    season>=2011 and season<=2017 and week>=5 and week<=6 and line<=-20 and total<(-line+20) and ats margin>0

    (show number of overs and unders when fave wins.)
    Points Awarded:

    darkghost gave snapperman2 100 Betpoint(s) for this post.

    $20
    Angelman
    donation 02/18/2019


  5. #5
    darkghost
    darkghost's Avatar SBR PRO
    Join Date: 09-19-05
    Posts: 1,398
    Betpoints: 11501

    Quote Originally Posted by snapperman2 View Post
    season>=2011 and season<=2017 and week>=5 and week<=6 and line>=20 and total<=(line+20) and ats margin>0

    (Shows number of overs and unders when dog wins.)

    season>=2011 and season<=2017 and week>=5 and week<=6 and line<=-20 and total<(-line+20) and ats margin>0

    (show number of overs and unders when fave wins.)
    Anyway to do 1H and 2H? I think I have the biggest edges there.

    SBR Founder Join Date: 9/19/2005


  6. #6
    QuantumLeap
    Glastonbury Tor at moonlight
    QuantumLeap's Avatar SBR PRO
    Join Date: 08-22-08
    Posts: 5,591
    Betpoints: 1222

    Quote Originally Posted by darkghost View Post
    Anyway to do 1H and 2H? I think I have the biggest edges there.
    They don't have halftime info there. I went as far as to ask the owner/admin and he said no.

    If we could find a place that had that we would do well I think.

Top