RSS Feed
News
Oct
1
Sports Direct content interruption
Posted by Ian Marsman on 01 October 2016 05:38 PM
An issue on one of our servers is interfering with content production for files from Sports Direct. We are working to resolve this. The estimated time to resolve the issue is 2 PM ET.
Read more »



Oct
14
New event ID for postponed BAL/KC MLB playoff game
Posted by Casey Trauer on 14 October 2014 01:42 PM

Monday night's Game 3 of the MLB American League Championship Series between Baltimore and Kansas City was postponed because of rain. The Sports Network has issued a new event key for Tuesday's game. The original event keys for Games 4 and 5 will remain but will have different start dates to match the new schedule.

The new event key is l.mlb.com-2014-e.44572. The postponed event key is l.mlb.com-2014-e.44550.

For SportsDB users, this means that the database will have keys for more than seven games in this series. You may use the original event key to display a postponed date in the schedule. Or you may ignore postponed event rows by filtering them out. Or you may choose to delete the key altogether. Here is a sample query:

DELETE FROM periods WHERE periods.participant_event_id IN (SELECT participants_events.id FROM participants_events JOIN events ON participants_events.event_id = events.id WHERE event_key LIKE 'l.mlb.com-2014-e.44550');
DELETE FROM participants_events WHERE participants_events.event_id IN (SELECT events.id FROM events WHERE event_key LIKE 'l.mlb.com-2014-e.44550');
DELETE FROM affiliations_events WHERE affiliations_events.event_id IN (SELECT events.id FROM events WHERE event_key LIKE 'l.mlb.com-2014-e.44550');
DELETE FROM events_sub_seasons WHERE events_sub_seasons.event_id IN (SELECT events.id FROM events WHERE event_key LIKE 'l.mlb.com-2014-e.44550');
DELETE FROM document_fixtures_events WHERE document_fixtures_events.event_id IN (SELECT events.id FROM events WHERE event_key LIKE 'l.mlb.com-2014-e.44550');
DELETE FROM events_documents WHERE events_documents.event_id IN (SELECT events.id FROM events WHERE event_key LIKE 'l.mlb.com-2014-e.44550');
DELETE FROM events_sub_seasons WHERE events_sub_seasons.event_id IN (SELECT events.id FROM events WHERE event_key LIKE 'l.mlb.com-2014-e.44550');
DELETE FROM events_sub_seasons WHERE events_sub_seasons.event_id IN (SELECT events.id FROM events WHERE event_key LIKE 'l.mlb.com-2014-e.44550');
DELETE FROM person_event_metadata WHERE person_event_metadata.event_idIN (SELECT events.id FROM events WHERE event_key LIKE 'l.mlb.com-2014-e.44550');
DELETE FROM events WHERE event_key LIKE 'l.mlb.com-2014-e.44550';

 


Read more »




Help Desk Software by Kayako Resolve