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 = 7532 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] => 5845 [name] => Ohio [slug] => ohio [parent] => 194 [count] => 111 [taxonomy] => location ) [2] => stdClass Object ( [term_id] => 5861 [name] => Georgia [slug] => georgia [parent] => 194 [count] => 165 [taxonomy] => location ) [3] => stdClass Object ( [term_id] => 5975 [name] => Pennsylvania [slug] => pennsylvania [parent] => 194 [count] => 92 [taxonomy] => location ) [4] => stdClass Object ( [term_id] => 6090 [name] => Cincinnati [slug] => cincinnati [parent] => 5845 [count] => 23 [taxonomy] => location ) [5] => stdClass Object ( [term_id] => 6131 [name] => Maine [slug] => maine [parent] => 194 [count] => 8 [taxonomy] => location ) [6] => stdClass Object ( [term_id] => 6357 [name] => Monroe [slug] => monroe [parent] => 5845 [count] => 2 [taxonomy] => location ) [7] => stdClass Object ( [term_id] => 6641 [name] => West Chester [slug] => west-chester [parent] => 5845 [count] => 7 [taxonomy] => location ) [8] => stdClass Object ( [term_id] => 6649 [name] => Portland [slug] => portland [parent] => 6131 [count] => 4 [taxonomy] => location ) [9] => stdClass Object ( [term_id] => 7174 [name] => McDonough [slug] => mcdonough [parent] => 5861 [count] => 4 [taxonomy] => location ) [10] => stdClass Object ( [term_id] => 8276 [name] => Jessup [slug] => jessup [parent] => 5975 [count] => 1 [taxonomy] => location ) [11] => stdClass Object ( [term_id] => 8277 [name] => Norwood [slug] => norwood [parent] => 5845 [count] => 1 [taxonomy] => location ) )

Array ( [0] => Cincinnati [1] => Monroe [2] => West Chester [3] => Portland [4] => McDonough [5] => Jessup [6] => Norwood )