Some query stuff for CC

[Thomas]

Just looking around a bit and found this at gimmethedog, if I did this right and I think I did, the late game on Sunday has went over the last 6 years

game type=CH and H and start time>=1700 and season>2014

http://gimmethedog.com/NFL?q=%20game...0season%3E2014

5-1suats
6-0 o/u

Rams and over

[Thomas]

Home favs who lost their previous game against opponent and are-7 or less are 4-1 o/u


game type=CH and HF and line<=-7 and P:L

http://gimmethedog.com/NFL?q=%20game...%20and%20P%3AL

any line as a fav 9-3-1 o/u

game type=CH and HF and P:L

http://gimmethedog.com/NFL?q=%20game...%20and%20P%3AL

and if it's the early game any fav line 6-0 o/u

game type=CH and HF and P:L and start time<1700


http://gimmethedog.com/NFL?q=%20game...%20time%3C1700

[Chamblin]

[Riderx]

Thomas,

Be careful with that last one. 2001 is wrong. Already sent a note to Gambrinus earlier this week.

[Thomas]

Thanks John I tried this which I think gets at the right games

game type=CH and season=2001 and week=21 and H

you can drop the game=CH and get the same results

Also I think we've always had problems with 2001, went to the gamebooks and the bear/eagle game was actually week 18 on DIV weekend and the SB was played on week 20 that year

I used to do all my query work with season>2001 because 2002 is the year of the realignment because there was always trouble with 2001

[Thomas]

Ok looks like 2001 is including all the div round games in the CC weekend John and should be an easy fix when Gambrinus sees your heads up

game type=CH and H

http://gimmethedog.com/NFL?q=%20game...3DCH%20and%20H

[Riderx]

Yeah...I included those & week 18 games also. Teams had 2 bye-weeks that year due to the attacks...i.e. week 17 was week 18. He knows & I also mentioned it's no big deal since the season's almost over & we can all work around it...using such as: game number 17 or game number 18 and rest=, etc...

LOL...as I was writing that, the issues were already fixed. Thanks Gambrinus...

[Gambrinus]

Thomas,

Be careful with that last one. 2001 is wrong. Already sent a note to Gambrinus earlier this week.

This is fixed. Thanks for letting me know.

[Riderx]

This is fixed. Thanks for letting me know.

Yep...I saw it afterwards. Massive 'Thank You"...

[Thomas]

Why am I still getting the wrong results when I click through those links

game type=CH and H

http://gimmethedog.com/NFL?q=%20game...3DCH%20and%20H

[Gambrinus]

Why am I still getting the wrong results when I click through those links

game type=CH and H

http://gimmethedog.com/NFL?q=%20game...3DCH%20and%20H

What's wrong?

[bleeker]

What's wrong?

still shows the divisional games for the 2001 season when you specify CH games

[Gambrinus]

OK, I think it's better now:

http://gimmethedog.com/NFL?q=date%2C...20PO%20and%20H

[Thomas]

Thats got it John, thanks if you see this could you make the SB a neutral site please. Bengals are the designated home team I think which is how you have it listed and although this is the Rams Stadium it's still a neutral site same as with the Bucs last year. I'll PM you later if you don't come across this