SportsDB Home
Documentation
Specification
Samples
Query Library
SportsCaster Web Service
Hosted on SourceForge
and licensed under
Creative Commons GNU GPL.
Query Library
| Chris Hartjes submitted this query on: April 01, 2008 2:22pm EDT | |
| TITLE | Get all errors by teams in a specific game |
|---|---|
| SPORTS | Baseball |
| QUERY | SELECT events.event_key, teams.team_key, baseball_defensive_stats.errors FROM stats, events, baseball_defensive_stats, teams WHERE stats.stat_repository_type = 'baseball_defensive_stats' AND stats.stat_repository_id = baseball_defensive_stats.id AND events.event_key = 'l.mlb.com-2007-e.TEX200707220' AND stats.stat_coverage_id = events.id AND stats.stat_holder_type = 'teams' AND teams.id = stats.stat_holder_id |
| DESCRIPTION | Given the event key for a baseball game, you can get all sorts of offense, defensive and pitching stats |
| DBs TESTED | MySQL |
| ADDITIONAL NOTES | |