WordPress list taxonomies

SELECT *
FROM rdcaa_terms t
LEFT JOIN `rdcaa_term_taxonomy` tt ON tt.term_id = t.term_id
WHERE tt.taxonomy LIKE 'location'