View New Posts
1. 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. HUH?
175 pts

3-QUESTION
SBR TRIVIA WINNER 07/11/2019

175 pts

3-QUESTION
SBR TRIVIA WINNER 07/08/2019

3. Originally Posted by JoeCool20
HUH?
SDQL = Sports Data Query Language

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

\$20
Angelman
donation 02/18/2019

SBR
Forum
Mod

SBR Bash
Punta Cana
Attendee 2/4/2017

4. 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. Originally Posted by snapperman2
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. Originally Posted by darkghost
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.