How are terms connected with posts in database?

admin2025-06-05  10

In a multi-site environment, I have a special need to get post terms (on a custom taxonomy) without the expensive operation of "switching blogs".

I thought I might write my own query to get terms for a given post on a given blog.

I'm looking through the three tables:

wp_3_terms
wp_3_term_relationships
wp_3_term_taxonomy

Yet I cannot see where there is a connection to post_id in any of these.

So the question:

How do terms link with a given post in the database? If I can know that, I can do the rest.

In a multi-site environment, I have a special need to get post terms (on a custom taxonomy) without the expensive operation of "switching blogs".

I thought I might write my own query to get terms for a given post on a given blog.

I'm looking through the three tables:

wp_3_terms
wp_3_term_relationships
wp_3_term_taxonomy

Yet I cannot see where there is a connection to post_id in any of these.

So the question:

How do terms link with a given post in the database? If I can know that, I can do the rest.

Share Improve this question edited May 27, 2014 at 8:18 Pieter Goosen 55.5k23 gold badges117 silver badges211 bronze badges asked May 26, 2014 at 22:13 user1915665user1915665 5591 gold badge6 silver badges15 bronze badges
Add a comment  | 

1 Answer 1

Reset to default 4

The posts are related to taxonomies (taxonomy/tag) in the wp_3_term_relationships table, where the object_id column is the post's id, and the term_taxonomy_id is the taxonomy/tag id.

Depending on what you want to accomplish, the solution might be to create the same taxonomies at each blog. This way the tax_query should work as normal.

转载请注明原文地址:http://conceptsofalgorithm.com/Algorithm/1749122532a316556.html

最新回复(0)