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%";+------------------------+---------------------+| event_key              | start_date_time     |+------------------------+---------------------+| l.nba.com-2007-e.9960  | 2007-10-16 00:00:00 | | l.nba.com-2007-e.9987  | 2007-10-21 00:00:00 | | l.nba.com-2007-e.10006 | 2007-10-25 00:00:00 | | l.nba.com-2007-e.10020 | 2007-10-27 00:00:00 | | l.nba.com-2007-e.8851  | 2007-11-08 03:00:00 | | l.nba.com-2007-e.8893  | 2007-11-10 03:00:00 | | l.nba.com-2007-e.8916  | 2007-11-11 02:00:00 | | l.nba.com-2007-e.8989  | 2007-11-15 01:00:00 | +------------------------+---------------------+8 rows in set (0.01 sec)