Abacus Logistics
5.0
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 = 7134
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] => 402
[name] => Missouri
[slug] => missouri
[parent] => 194
[count] => 105
[taxonomy] => location
)
[2] => stdClass Object
(
[term_id] => 1033
[name] => Mexico
[slug] => mexico-2
[parent] => 402
[count] => 1
[taxonomy] => location
)
)
Array
(
[0] =>
Mexico
)
1 Locations Mexico
