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 = 7035 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] => 405 [name] => Nevada [slug] => nevada [parent] => 194 [count] => 95 [taxonomy] => location ) [2] => stdClass Object ( [term_id] => 407 [name] => New Jersey [slug] => new-jersey [parent] => 194 [count] => 243 [taxonomy] => location ) [3] => stdClass Object ( [term_id] => 414 [name] => Pennsylvania [slug] => pennsylvania [parent] => 194 [count] => 182 [taxonomy] => location ) [4] => stdClass Object ( [term_id] => 1306 [name] => Secaucus [slug] => secaucus-2 [parent] => 407 [count] => 9 [taxonomy] => location ) [5] => stdClass Object ( [term_id] => 1432 [name] => Middletown [slug] => middletown [parent] => 414 [count] => 2 [taxonomy] => location ) [6] => stdClass Object ( [term_id] => 2098 [name] => Henderson [slug] => henderson-2 [parent] => 405 [count] => 6 [taxonomy] => location ) )

Array ( [0] => Secaucus [1] => Middletown [2] => Henderson )