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 = 7506 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] => 5799 [name] => California [slug] => california [parent] => 194 [count] => 356 [taxonomy] => location ) [2] => stdClass Object ( [term_id] => 5857 [name] => Florida [slug] => florida [parent] => 194 [count] => 194 [taxonomy] => location ) [3] => stdClass Object ( [term_id] => 5894 [name] => Texas [slug] => texas [parent] => 194 [count] => 347 [taxonomy] => location ) [4] => stdClass Object ( [term_id] => 5895 [name] => Houston [slug] => houston [parent] => 5894 [count] => 141 [taxonomy] => location ) [5] => stdClass Object ( [term_id] => 5896 [name] => Los Angeles [slug] => los-angeles [parent] => 5799 [count] => 71 [taxonomy] => location ) [6] => stdClass Object ( [term_id] => 5911 [name] => Nevada [slug] => nevada [parent] => 194 [count] => 59 [taxonomy] => location ) [7] => stdClass Object ( [term_id] => 5912 [name] => Reno [slug] => reno [parent] => 5911 [count] => 17 [taxonomy] => location ) [8] => stdClass Object ( [term_id] => 5918 [name] => Orlando [slug] => orlando [parent] => 5857 [count] => 29 [taxonomy] => location ) [9] => stdClass Object ( [term_id] => 5941 [name] => Washington [slug] => washington [parent] => 194 [count] => 78 [taxonomy] => location ) [10] => stdClass Object ( [term_id] => 5949 [name] => Arkansas [slug] => arkansas [parent] => 194 [count] => 26 [taxonomy] => location ) [11] => stdClass Object ( [term_id] => 5950 [name] => Little Rock [slug] => little-rock [parent] => 5949 [count] => 7 [taxonomy] => location ) [12] => stdClass Object ( [term_id] => 5963 [name] => Dallas [slug] => dallas [parent] => 5894 [count] => 76 [taxonomy] => location ) [13] => stdClass Object ( [term_id] => 5975 [name] => Pennsylvania [slug] => pennsylvania [parent] => 194 [count] => 92 [taxonomy] => location ) [14] => stdClass Object ( [term_id] => 5988 [name] => Jacksonville [slug] => jacksonville [parent] => 5857 [count] => 40 [taxonomy] => location ) [15] => stdClass Object ( [term_id] => 5994 [name] => Philadelphia [slug] => philadelphia [parent] => 5975 [count] => 31 [taxonomy] => location ) [16] => stdClass Object ( [term_id] => 6017 [name] => South Carolina [slug] => south-carolina [parent] => 194 [count] => 63 [taxonomy] => location ) [17] => stdClass Object ( [term_id] => 6018 [name] => Columbia [slug] => columbia [parent] => 6017 [count] => 9 [taxonomy] => location ) [18] => stdClass Object ( [term_id] => 6027 [name] => Missouri [slug] => missouri [parent] => 194 [count] => 72 [taxonomy] => location ) [19] => stdClass Object ( [term_id] => 6031 [name] => Indiana [slug] => indiana [parent] => 194 [count] => 73 [taxonomy] => location ) [20] => stdClass Object ( [term_id] => 6032 [name] => Indianapolis [slug] => indianapolis [parent] => 6031 [count] => 26 [taxonomy] => location ) [21] => stdClass Object ( [term_id] => 6033 [name] => Kansas City [slug] => kansas-city [parent] => 6027 [count] => 28 [taxonomy] => location ) [22] => stdClass Object ( [term_id] => 6159 [name] => Seattle [slug] => seattle [parent] => 5941 [count] => 31 [taxonomy] => location ) [23] => stdClass Object ( [term_id] => 6361 [name] => Kansas [slug] => kansas [parent] => 194 [count] => 29 [taxonomy] => location ) [24] => stdClass Object ( [term_id] => 6707 [name] => Overland Park [slug] => overland-park [parent] => 6361 [count] => 5 [taxonomy] => location ) [25] => stdClass Object ( [term_id] => 6762 [name] => Plainfield [slug] => plainfield [parent] => 6031 [count] => 3 [taxonomy] => location ) [26] => stdClass Object ( [term_id] => 6902 [name] => Independence [slug] => independence [parent] => 6027 [count] => 4 [taxonomy] => location ) )

Array ( [0] => Houston [1] => Los Angeles [2] => Reno [3] => Orlando [4] => Little Rock [5] => Dallas [6] => Jacksonville [7] => Philadelphia [8] => Columbia [9] => Indianapolis [10] => Kansas City [11] => Seattle [12] => Overland Park [13] => Plainfield [14] => Independence )