Unable to find events

SELECT * FROM `jny_subdomains` WHERE `name` = 'orlando' AND e.is_planned = 0 ORDER BY e.dt LIMIT 0,10