SELECT
t.term_id,
t.name,
t.slug,
tt.parent,
tt.count,
tt.taxonomy
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tr.object_id = 14080
AND tt.taxonomy = 'location'
Array
(
[0] => stdClass Object
(
[term_id] => 194
[name] => United States
[slug] => united-states
[parent] => 162
[count] => 3656
[taxonomy] => location
)
[1] => stdClass Object
(
[term_id] => 383
[name] => Colorado
[slug] => colorado
[parent] => 194
[count] => 108
[taxonomy] => location
)
[2] => stdClass Object
(
[term_id] => 629
[name] => Denver
[slug] => denver
[parent] => 383
[count] => 65
[taxonomy] => location
)
)
Array
(
[0] =>
Denver
)
1 Locations Denver
