Retrieve Upcoming Event Categories (The Events Calendar)

SELECT DISTINCT wp_terms.term_id, wp_terms.name
FROM wp_terms

JOIN wp_term_relationships ON wp_term_relationships.term_taxonomy_id = wp_terms.term_id
JOIN wp_postmeta ON wp_postmeta.post_id = wp_term_relationships.object_id
JOIN wp_term_taxonomy ON wp_term_taxonomy.term_id = wp_terms.term_id

WHERE wp_postmeta.meta_key = '_EventStartDate'
AND wp_postmeta.meta_value > NOW()
AND wp_term_taxonomy.taxonomy = 'tribe_events_cat';