[QUOTE=joelshitshow;31762]Hey Prof Meyer, what is the SDQL for this?[/QUOTE]
What I would do is set the week number of the teams eighth previous game plus eight equal to the current week number.
For example, if the team had a bye in week 3 and it was week 12, they would be playing their ninth game in as many weeks.
So the SDQL is:
pppppppp:week + 8 = week
This SDQL will give the results of teams when they had a game in each of the previous eight weeks. Not elegant, but it gets the job done.
Prof M.