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 = 6979 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] => 375 [name] => California [slug] => california [parent] => 194 [count] => 708 [taxonomy] => location ) [2] => stdClass Object ( [term_id] => 377 [name] => Alabama [slug] => alabama [parent] => 194 [count] => 88 [taxonomy] => location ) [3] => stdClass Object ( [term_id] => 389 [name] => Idaho [slug] => idaho [parent] => 194 [count] => 38 [taxonomy] => location ) [4] => stdClass Object ( [term_id] => 395 [name] => Louisiana [slug] => louisiana [parent] => 194 [count] => 58 [taxonomy] => location ) [5] => stdClass Object ( [term_id] => 402 [name] => Missouri [slug] => missouri [parent] => 194 [count] => 105 [taxonomy] => location ) [6] => stdClass Object ( [term_id] => 407 [name] => New Jersey [slug] => new-jersey [parent] => 194 [count] => 243 [taxonomy] => location ) [7] => stdClass Object ( [term_id] => 408 [name] => New Mexico [slug] => new-mexico [parent] => 194 [count] => 22 [taxonomy] => location ) [8] => stdClass Object ( [term_id] => 418 [name] => Tennessee [slug] => tennessee [parent] => 194 [count] => 153 [taxonomy] => location ) [9] => stdClass Object ( [term_id] => 419 [name] => Texas [slug] => texas [parent] => 194 [count] => 583 [taxonomy] => location ) [10] => stdClass Object ( [term_id] => 420 [name] => Utah [slug] => utah [parent] => 194 [count] => 108 [taxonomy] => location ) [11] => stdClass Object ( [term_id] => 819 [name] => Kansas City [slug] => kansas-city-2 [parent] => 402 [count] => 50 [taxonomy] => location ) [12] => stdClass Object ( [term_id] => 841 [name] => Washington [slug] => washington-2 [parent] => 194 [count] => 131 [taxonomy] => location ) [13] => stdClass Object ( [term_id] => 961 [name] => Amarillo [slug] => amarillo [parent] => 419 [count] => 15 [taxonomy] => location ) [14] => stdClass Object ( [term_id] => 979 [name] => Lubbock [slug] => lubbock [parent] => 419 [count] => 13 [taxonomy] => location ) [15] => stdClass Object ( [term_id] => 1017 [name] => Ogden [slug] => ogden [parent] => 420 [count] => 8 [taxonomy] => location ) [16] => stdClass Object ( [term_id] => 1077 [name] => Fife [slug] => fife [parent] => 841 [count] => 8 [taxonomy] => location ) [17] => stdClass Object ( [term_id] => 1093 [name] => Houma [slug] => houma [parent] => 395 [count] => 3 [taxonomy] => location ) [18] => stdClass Object ( [term_id] => 1097 [name] => Midland [slug] => midland [parent] => 419 [count] => 10 [taxonomy] => location ) [19] => stdClass Object ( [term_id] => 1101 [name] => Odessa [slug] => odessa [parent] => 419 [count] => 5 [taxonomy] => location ) [20] => stdClass Object ( [term_id] => 1328 [name] => Humble [slug] => humble [parent] => 419 [count] => 9 [taxonomy] => location ) [21] => stdClass Object ( [term_id] => 1959 [name] => Wood-Ridge [slug] => wood-ridge [parent] => 407 [count] => 3 [taxonomy] => location ) [22] => stdClass Object ( [term_id] => 1965 [name] => Calera [slug] => calera [parent] => 377 [count] => 2 [taxonomy] => location ) [23] => stdClass Object ( [term_id] => 1975 [name] => Post Falls [slug] => post-falls [parent] => 389 [count] => 2 [taxonomy] => location ) [24] => stdClass Object ( [term_id] => 2010 [name] => Montebello [slug] => montebello [parent] => 375 [count] => 5 [taxonomy] => location ) [25] => stdClass Object ( [term_id] => 2444 [name] => Lebanon [slug] => lebanon [parent] => 418 [count] => 11 [taxonomy] => location ) [26] => stdClass Object ( [term_id] => 2819 [name] => Centralia [slug] => centralia [parent] => 841 [count] => 3 [taxonomy] => location ) [27] => stdClass Object ( [term_id] => 2820 [name] => Coeur d'Alene [slug] => coeur-dalene [parent] => 389 [count] => 2 [taxonomy] => location ) [28] => stdClass Object ( [term_id] => 5664 [name] => Hobbs [slug] => hobbs [parent] => 408 [count] => 1 [taxonomy] => location ) )

Array ( [0] => Kansas City [1] => Amarillo [2] => Lubbock [3] => Ogden [4] => Fife [5] => Houma [6] => Midland [7] => Odessa [8] => Humble [9] => Wood-Ridge [10] => Calera [11] => Post Falls [12] => Montebello [13] => Lebanon [14] => Centralia [15] => Coeur d'Alene [16] => Hobbs )