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 = 12750
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] => 419
[name] => Texas
[slug] => texas
[parent] => 194
[count] => 583
[taxonomy] => location
)
[2] => stdClass Object
(
[term_id] => 875
[name] => Grand Prairie
[slug] => grand-prairie
[parent] => 419
[count] => 17
[taxonomy] => location
)
[3] => stdClass Object
(
[term_id] => 1125
[name] => Arlington
[slug] => arlington-2
[parent] => 419
[count] => 15
[taxonomy] => location
)
)
Array
(
[0] =>
Grand Prairie
[1] =>
Arlington
)
2 Locations Grand PrairieArlington
