if u review my plays for previous years, they all have the above requirements. again this is only for the first month. i do not wager anymore and will not be posting plays. but this is what i used for anybody that would like to follow it. good luck in all that you do
"Thanks for sharing the details.... it will take a day or two to kick in, but I have the query written and ready to go!!"
Did you do anything to the query other than copy it from the query box on the link he provided?
Just curious if you found a way to tweak it.
Also wondering how often the temperature is updated in the database - anyone know? Do we need to check right before gametime, or is in the morning good enough?
That seems like it works. Again, it will list the 2010 games, just a means of making sure it is working, then will show the 2011 games (and later, going forward) at the bottom.
another thought -- in yrs past saturdays were always a struggle for this system (maybe do to larger home crowds) as evidenced below, so u may want to not wager on that day --
Must be more to it than those 4 criteria, or, the list is incomplete.
There were at lot of games that fit prior to 4/9/10. Just curious, trying to get it right. It looks like a moneymaker. Thanks.
"Must be more to it than those 4 criteria, or, the list is incomplete.
There were at lot of games that fit prior to 4/9/10. Just curious, trying to get it right. It looks like a moneymaker. Thanks."
It only shows so many games by default. The older games will drop off the top of the list as new games show up at the bottom, but the cumulative record should be correct.
While according to the query there were 46 games last season, going 29-17, it is only showing 40 in the list.
So, when you say "a lot of games that fit prior ..." not sure if 6 counts as a lot, or do you have more than 46 games for last season?
"last question , were each teams 1st games a pass since #3 says no shutout ? or do we ignore #3 on game 1's ??"
Since it's checking if the prior game was a shutout, and -I THINK- (note the emphasis, I'm not not positive) the default is to NOT go to the prior season, I don't think it will list any game 1s for teams.
If you have an example where it is showing the game 1, let me know and I'll investigate further.