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 2:07pm EDT | |
| TITLE | Get the most recent state of a baseball game |
|---|---|
| SPORTS | Baseball |
| QUERY | SELECT * FROM baseball_event_states, events WHERE events.event_key = 'l.mlb.com-2007-e.DUB20070508' AND baseball_event_states.event_id = events.id AND baseball_event_states.current_state = 1 |
| DESCRIPTION | Whenever you are looking at a baseball event, any record with a current_state of 1 is the most recent, while 0 represents past events. |
| DBs TESTED | MySQL |
| ADDITIONAL NOTES | |