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: September 01, 2009 3:23pm EDT | |
| TITLE | Return injury documents related to an NFL game |
|---|---|
| SPORTS | American Football |
| QUERY | SELECT d. *, dc.sportsml FROM documents d JOIN events_documents ed ON d.id = ed.document_id JOIN EVENTS e ON ed.event_id = e.id JOIN document_fixtures df ON d.document_fixture_id = df.id JOIN document_contents dc ON dc.document_id = d.id WHERE e.event_key = 'l.nfl.com-2009-e.3124' AND df.fixture_key = 'event-injuries'; |
| DESCRIPTION | This will show all injury files related to a given NFL game. The sportsml column will show you the path of the xml file in your archive folder if you are using FeedFetcherDeluxe. |
| DBs TESTED | MySQL |
| ADDITIONAL NOTES | This query, modified, can also return other documents related to a given event for any sport. |