Unable to find events

SELECT * FROM jny_subdomains WHERE name = 'nyc' AND e.is_planned = 0 AND e.dt >= '2019-08-1' AND e.dt < ('2019-08-1' + interval 1 month) ORDER BY e.dt LIMIT 0,20