Sdql help

[darkghost]

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.

[JoeCool20]

HUH?

[Optional]

HUH?

SDQL = Sports Data Query Language

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

[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.)

[darkghost]

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.

[QuantumLeap]

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.