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"

on March 08, 2019 10:22pm EST LauraCab wrote:
Metadata: DB Tested: n/a
Query:
look at this  cialis soft 20mg   - best place to buy cialis

"look at this cialis soft 20mg - best place to buy cialis"

on March 09, 2019 7:40am EST KiteNosse wrote:
Metadata: DB Tested: n/a
Query:
Significant site. Literate articles. Thanks to author. Conserve your website as a favorite

"Significant site. Literate articles. Thanks to author. Conserve your website as a favorite"

on March 09, 2019 7:40am EST Kiteoxype wrote:
Metadata: DB Tested: n/a
Query:
Great site. Literate articles. Thanks to author. Conserve your website as a favorite

"Great site. Literate articles. Thanks to author. Conserve your website as a favorite"

on March 09, 2019 7:40am EST KiteUndeni wrote:
Metadata: DB Tested: n/a
Query:
Tremendous site. Literate articles. Thanks to author. Salvage your website as a favorite

"Tremendous site. Literate articles. Thanks to author. Salvage your website as a favorite"

on March 09, 2019 8:06pm EST MaryNosse wrote:
Metadata: DB Tested: n/a
Query:
Mammoth site. Literate articles. Thanks to author. Salvage your website as a favorite

"Mammoth site. Literate articles. Thanks to author. Salvage your website as a favorite"

on March 09, 2019 8:06pm EST Maryoxype wrote:
Metadata: DB Tested: n/a
Query:
Great site. Literate articles. Thanks to author. Prevent your website as a favorite

"Great site. Literate articles. Thanks to author. Prevent your website as a favorite"

on March 09, 2019 8:06pm EST MaryUndeni wrote:
Metadata: DB Tested: n/a
Query:
Tremendous site. Literate articles. Thanks to author. Save your website as a favorite

"Tremendous site. Literate articles. Thanks to author. Save your website as a favorite"