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: April 07, 2009 5:54pm EDT | |
| TITLE | Get football defensive stats for one team for one event |
|---|---|
| SPORTS | American Football |
| QUERY | SELECT dn.first_name, dn.last_name, afsd.* FROM stats s JOIN american_football_defensive_stats afsd ON afsd.id = s.stat_repository_id JOIN teams t ON t.id = s.stat_holder_id JOIN display_names dn ON t.id = dn.entity_id JOIN events e ON e.id = s.stat_coverage_id WHERE s.stat_repository_type = 'american_football_defensive_stats' AND s.stat_holder_type = 'teams' AND dn.entity_type = 'teams' AND s.stat_coverage_type = 'events' AND e.event_key = 'l.nfl.com-2008-e.2624' AND t.team_key = 'l.nfl.com-t.29'; |
| DESCRIPTION | Not all columns will be non-NULL. It may depend on your publisher's content set. |
| DBs TESTED | MySQL |
| ADDITIONAL NOTES | |