SELECT DISTINCT(e.event_key), e.start_date_time 
FROM `stats` s 
    INNER JOIN `events` e 
        ON e.id = s.stat_coverage_id
WHERE 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%";