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:46pm EDT | |
| TITLE | Get season football defensive stats for one team |
|---|---|
| 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 sub_seasons ss ON ss.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 = 'sub_seasons' AND ss.sub_season_key = '2008_season_regular' /*Specify season key*/ AND t.team_key = 'l.nfl.com-t.29' /*Specify team key*/ |
| DESCRIPTION | Note: Not all columns will be non-NULL. It may depend on your publisher's content set. |
| DBs TESTED | MySQL |
| ADDITIONAL NOTES | |