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: March 01, 2012 4:49pm EST | |
| TITLE | Basketball period and clock information |
|---|---|
| SPORTS | Basketball |
| QUERY | SELECT e.event_status, bes.period_value, bes.period_time_remaining FROM events as e JOIN basketball_event_states bes ON bes.event_id = e.id WHERE bes.current_state = 1 and context = 'event-play'; |
| DESCRIPTION | Event status will be pre-event, mid-event, intermission, post-event. Also possible: delayed, postponed. |
| DBs TESTED | MySQL |
| ADDITIONAL NOTES | |
Comments
on March 08, 2012 11:49am EST Casey Trauer wrote:
Metadata: DB Tested: MySQL
Query:
SELECT e.event_status, bes.period_value, bes.period_time_remaining
FROM events as e
JOIN basketball_event_states bes ON bes.event_id = e.id
WHERE bes.current_state = 1
AND context = 'event-play'
AND e.event_key = 'l.nba.com-2012-e.21011';
Query:
SELECT e.event_status, bes.period_value, bes.period_time_remaining
FROM events as e
JOIN basketball_event_states bes ON bes.event_id = e.id
WHERE bes.current_state = 1
AND context = 'event-play'
AND e.event_key = 'l.nba.com-2012-e.21011';
"Adds event key for game."
on September 19, 2012 5:02am EDT joan wrote:
Metadata: DB Tested: ALL DATABASES
Query:
n/a
Query:
n/a
"for studies"