Bye Week
274 views
Skip to first unread message
SportsGal
Sep 3, 2009, 8:38:33 PM9/3/09
to SportsDataBase
Anyone know how to do a search on teams the week after a bye week, or
the week before?
the week before?
Shaun Hess
Sep 4, 2009, 12:23:56 AM9/4/09
to sportsd...@googlegroups.com
thats an easy one,,,,you should ALSO look to join www.talksport.com, and EXCELLENT sports site ANNNNNNNNNNNd several of those folks on that site are very familiar with the 'TEXT' language of this site,,,
> Date: Thu, 3 Sep 2009 17:38:33 -0700
> Subject: Bye Week
> From: debra...@yahoo.com
> To: sportsd...@googlegroups.com
Joe Meyer
Sep 4, 2009, 1:20:41 AM9/4/09
to sportsd...@googlegroups.com
SportsGal,
The parameter 'week' is useful when querying on byes.
To see how teams do after a bye use the SDQL:
p:week + 2 = week
To see how teams do before a bye use the SDQL:
week + 2 = n:week
To see how teams do when their opponent is off a bye use the SDQL:
op:week + 2 = week
Best wishes,
Joe Meyer
http://SportsDataBase.com
The parameter 'week' is useful when querying on byes.
To see how teams do after a bye use the SDQL:
p:week + 2 = week
To see how teams do before a bye use the SDQL:
week + 2 = n:week
To see how teams do when their opponent is off a bye use the SDQL:
op:week + 2 = week
Best wishes,
Joe Meyer
http://SportsDataBase.com
SportsGal
Sep 4, 2009, 10:23:27 PM9/4/09
to SportsDataBase
Joe,
Wouldn't that query require that I know which week was the bye week? I
was looking for a way to query without knowing when the bye week
occurred for a team or group of teams over a number of seasons.
> > the week before?- Hide quoted text -
>
> - Show quoted text -
Wouldn't that query require that I know which week was the bye week? I
was looking for a way to query without knowing when the bye week
occurred for a team or group of teams over a number of seasons.
>
> - Show quoted text -
Chris Platt
Sep 4, 2009, 10:58:45 PM9/4/09
to sportsd...@googlegroups.com, SportsDataBase
No, using the SDQL Joe provided you will not need to know the bye week.
Sent from mobile device
Sent from mobile device
MLB Winner
Sep 5, 2009, 11:51:49 AM9/5/09
to SportsDataBase
Dear Sports Gal,
Each game in the database has a week number.
When a team plays in weeks 1,2,3,4,5,6 and 8, 9 etc. Their bye was in
week 7. So when the week number of their previous game is only ONE
more than the week number of the game they are currently playing, they
are not off their bye week.
When the week number of their current game is TWO more than the week
number of their previous game, then they are off their bye week.
So...
the SDQL:
week = p:week + 2
which translates as: the week number of the current game is equal to
the week number of the team's previous game plus two, automatically
gets all the bye weeks.
Prety cool, huh?
MLB Winner
On Sep 4, 10:58 pm, "Chris Platt" <CPl...@mdcresearch.com> wrote:
> No, using the SDQL Joe provided you will not need to know the bye week.
>
> Sent from mobile device
>
Each game in the database has a week number.
When a team plays in weeks 1,2,3,4,5,6 and 8, 9 etc. Their bye was in
week 7. So when the week number of their previous game is only ONE
more than the week number of the game they are currently playing, they
are not off their bye week.
When the week number of their current game is TWO more than the week
number of their previous game, then they are off their bye week.
So...
the SDQL:
week = p:week + 2
which translates as: the week number of the current game is equal to
the week number of the team's previous game plus two, automatically
gets all the bye weeks.
Prety cool, huh?
MLB Winner
On Sep 4, 10:58 pm, "Chris Platt" <CPl...@mdcresearch.com> wrote:
> No, using the SDQL Joe provided you will not need to know the bye week.
>
> Sent from mobile device
>
MLB Winner
Sep 5, 2009, 11:56:27 AM9/5/09
to SportsDataBase
AND...
To isolate only the game in which a team has a bye NEXT week, use:
n:week = week +2
That is, the week number of their next game is two more than the week
number of their current game.
MLB winner
To isolate only the game in which a team has a bye NEXT week, use:
n:week = week +2
That is, the week number of their next game is two more than the week
number of their current game.
MLB winner
SportsGal
Sep 5, 2009, 9:48:15 PM9/5/09
to SportsDataBase
Thanks guys for the help. I'm just starting with this 'language' so
sometimes my translation needs help. I can't wait to see how well my
predictions are this season.
> > > >> - Show quoted text -- Hide quoted text -
sometimes my translation needs help. I can't wait to see how well my
predictions are this season.
Reply all
Reply to author
Forward
0 new messages