SportsDB Home
Documentation
Specification
Samples
Query Library
SportsCaster Web Service
Hosted on SourceForge
and licensed under
Creative Commons GNU GPL.
Query Library
| Casey Trauer submitted this query on: December 30, 2009 11:57am EST | |
| TITLE | See the most recent fixtures for a given team |
|---|---|
| SPORTS | ALL SPORTS |
| QUERY | SELECT docs.* FROM documents docs JOIN teams_documents td ON docs.id = td.document_id JOIN teams t ON td.team_id = t.id AND (t.team_key = 'l.nfl.com-t.26') JOIN document_fixtures df ON docs.document_fixture_id = df.id AND df.fixture_key = 'roster' ORDER BY docs.date_time DESC |
| DESCRIPTION | If you want to see the most recent documents processed for a given team, this query will list them in order of most recent first. There are two variables here you can configure: the team key and the fixture key. This example returns all roster documents for the Tampa Bay Buccaneers, for example. You could return news documents or game recaps or boxscores, given the correct fixture key. |
| DBs TESTED | MySQL |
| ADDITIONAL NOTES | |
Comments
on April 08, 2010 6:11pm EDT Chuck Jones wrote:
Metadata: DB Tested: MySQL
Query:
n/a
Query:
n/a
"football"