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';

"Adds event key for game."

on September 19, 2012 5:02am EDT joan wrote:
Metadata: DB Tested: ALL DATABASES
Query:
n/a

"for studies"

on June 17, 2017 7:07am EDT KelAugmen wrote:
Metadata: DB Tested: n/a
Query:
Viagra Generique Livraison 24h  Buy Levitra Forum Levitra En Streaming Cialis Achat En Ligne Canada  Dapoxetine Drug Propecia Traductor

"Viagra Generique Livraison 24h Buy Levitra Forum Levitra En Streaming Cialis Achat En Ligne Canada Dapoxetine Drug Propecia Traductor"