Quickmail
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 = 7748
AND tt.taxonomy = 'location'
Array
(
[0] => stdClass Object
(
[term_id] => 191
[name] => Australia
[slug] => australia
[parent] => 190
[count] => 548
[taxonomy] => location
)
[1] => stdClass Object
(
[term_id] => 5956
[name] => Western Australia
[slug] => western-australia
[parent] => 0
[count] => 53
[taxonomy] => location
)
[2] => stdClass Object
(
[term_id] => 7016
[name] => Kenwick
[slug] => kenwick
[parent] => 5956
[count] => 2
[taxonomy] => location
)
)
Array
(
)
