SELECT wp_em_events.post_id FROM wp_em_events LEFT JOIN wp_em_locations ON wp_em_locations.location_id=wp_em_events.location_id WHERE (`recurrence`!=1 OR `recurrence` IS NULL) AND ( event_start_date >= CAST('2019-09-20' AS DATE) OR (event_end_date >= CAST('2019-09-20' AS DATE) AND event_end_date != '0000-00-00' AND event_end_date IS NOT NULL)) AND (wp_em_events.post_id IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (184) )) AND (`event_status`=1) AND (`event_private`=0) GROUP BY wp_em_events.post_id ORDER BY event_start_date ASC, event_start_time ASC LIMIT 100 OFFSET 0