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 = 15816 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] => 5915 [name] => British Columbia [slug] => british-columbia [parent] => 193 [count] => 73 [taxonomy] => location ) [2] => stdClass Object ( [term_id] => 5920 [name] => Saskatchewan [slug] => saskatchewan [parent] => 193 [count] => 15 [taxonomy] => location ) [3] => stdClass Object ( [term_id] => 6065 [name] => Langley Township [slug] => langley-township [parent] => 5915 [count] => 3 [taxonomy] => location ) [4] => stdClass Object ( [term_id] => 6145 [name] => Alberta [slug] => alberta [parent] => 193 [count] => 48 [taxonomy] => location ) [5] => stdClass Object ( [term_id] => 6146 [name] => Calgary [slug] => calgary [parent] => 6145 [count] => 35 [taxonomy] => location ) [6] => stdClass Object ( [term_id] => 6271 [name] => Edmonton [slug] => edmonton [parent] => 6145 [count] => 19 [taxonomy] => location ) [7] => stdClass Object ( [term_id] => 7373 [name] => Regina [slug] => regina [parent] => 5920 [count] => 11 [taxonomy] => location ) )

Array ( [0] => Langley Township [1] => Calgary [2] => Edmonton [3] => Regina )