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 = 1314 AND tt.taxonomy = 'location' Array ( [0] => stdClass Object ( [term_id] => 193 [name] => Canada [slug] => canada [parent] => 162 [count] => 582 [taxonomy] => location ) [1] => stdClass Object ( [term_id] => 194 [name] => United States [slug] => united-states [parent] => 162 [count] => 3656 [taxonomy] => location ) [2] => stdClass Object ( [term_id] => 196 [name] => Toronto, ON [slug] => toronto [parent] => 432 [count] => 1 [taxonomy] => location ) [3] => stdClass Object ( [term_id] => 198 [name] => Vancouver, BC [slug] => vancouver [parent] => 431 [count] => 1 [taxonomy] => location ) [4] => stdClass Object ( [term_id] => 200 [name] => Los Angeles, CA [slug] => los-angeles [parent] => 375 [count] => 1 [taxonomy] => location ) [5] => stdClass Object ( [term_id] => 547 [name] => Dallas, TX [slug] => dallas [parent] => 419 [count] => 2 [taxonomy] => location ) [6] => stdClass Object ( [term_id] => 692 [name] => Secaucus, NJ [slug] => secaucus [parent] => 407 [count] => 1 [taxonomy] => location ) [7] => stdClass Object ( [term_id] => 9207 [name] => United States [slug] => united-states [parent] => 0 [count] => 1 [taxonomy] => location ) [8] => stdClass Object ( [term_id] => 9208 [name] => California [slug] => california [parent] => 9207 [count] => 1 [taxonomy] => location ) [9] => stdClass Object ( [term_id] => 9209 [name] => Gardena [slug] => gardena [parent] => 9208 [count] => 1 [taxonomy] => location ) [10] => stdClass Object ( [term_id] => 9210 [name] => Canada [slug] => canada [parent] => 0 [count] => 1 [taxonomy] => location ) [11] => stdClass Object ( [term_id] => 9211 [name] => Ontario [slug] => ontario [parent] => 9210 [count] => 1 [taxonomy] => location ) [12] => stdClass Object ( [term_id] => 9212 [name] => North York [slug] => north-york [parent] => 9211 [count] => 1 [taxonomy] => location ) [13] => stdClass Object ( [term_id] => 9213 [name] => British Columbia [slug] => british-columbia [parent] => 9210 [count] => 1 [taxonomy] => location ) [14] => stdClass Object ( [term_id] => 9214 [name] => Richmond [slug] => richmond [parent] => 9213 [count] => 1 [taxonomy] => location ) [15] => stdClass Object ( [term_id] => 9215 [name] => Scarborough [slug] => scarborough [parent] => 9211 [count] => 1 [taxonomy] => location ) [16] => stdClass Object ( [term_id] => 9216 [name] => New Jersey [slug] => new-jersey [parent] => 9207 [count] => 1 [taxonomy] => location ) [17] => stdClass Object ( [term_id] => 9217 [name] => Secaucus [slug] => secaucus [parent] => 9216 [count] => 1 [taxonomy] => location ) [18] => stdClass Object ( [term_id] => 9218 [name] => Texas [slug] => texas [parent] => 9207 [count] => 1 [taxonomy] => location ) [19] => stdClass Object ( [term_id] => 9219 [name] => Dallas [slug] => dallas [parent] => 9218 [count] => 1 [taxonomy] => location ) )

Array ( [0] => Gardena [1] => North York [2] => Richmond [3] => Scarborough [4] => Secaucus [5] => Dallas )