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: March 31, 2008 4:22pm EDT | |
| TITLE | Get event data for a baseball game |
|---|---|
| SPORTS | Baseball |
| QUERY | SELECT events.event_key, events.start_date_time, events.event_status, baseball_event_states.inning_value, baseball_event_states.inning_half, baseball_event_states.outs, baseball_event_states.runner_on_first, baseball_event_states.runner_on_second, baseball_event_states.runner_on_third FROM events, baseball_event_states WHERE events.event_key = 'l.mlb.com-2007-e.KCA20070424' AND baseball_event_states.event_id = events.id |
| DESCRIPTION | Should give you a nice list of every event in a game, broken down into inning, top or bottom, outs and runners on base |
| DBs TESTED | MySQL |
| ADDITIONAL NOTES | To get events only from an game if it is in progress, add the following to the end of the query: AND baseball_event_states.current_state = 1 |