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 04, 2008 11:22am EDT | |
| TITLE | Get events from a baseball game |
|---|---|
| SPORTS | Baseball |
| QUERY | SELECT * FROM baseball_event_states, events, baseball_action_plays WHERE events.event_key = 'l.mlb.com-2007-e.FLO20070424' AND baseball_event_states.event_id = events.id AND baseball_action_plays.baseball_event_state_id = baseball_event_states.id |
| DESCRIPTION | Knowing the event key, you can join on the baseball_event_states and baseball_action_plays tables to get a record of the events that occurred in that game. |
| DBs TESTED | MySQL |
| ADDITIONAL NOTES | |