Miscellany

SELECT DISTINCT(e.event_key), e.start_date_time FROM `stats` s     INNER JOIN `events` e         ON e.id = s.stat_coverage_idWHERE s.stat_coverage_type = "events"      AND s.stat_holder_id = (SELECT `id` FROM `persons` WHERE `person_key` = "l.nba.com-p.1164" LIMIT 1)       AND s.stat_holder_type = "persons"       AND e.event_key LIKE "l.nba.com-2007%";