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.
Related Posts:
- Exclude posts that only have the ‘Uncategorized’ category [duplicate]
- Importing data from spreadsheet into wordpress DB, along with custom taxonomies and their terms
- get_terms parent for current product only
- deleting terms programmatically
- Adding Multiple Values to a Post Meta Key
- Avoid duplicate post from same Taxonomy
- Set terms in a custom post
- Get posts of ONE taxonomy term of custom post type
- Setting posts_per_page for taxonomy term template
- How to display posts via custom taxonomy terms using checkboxes?
- Loop parent terms {display posts} AND loop child terms {display posts}
- Displaying Results From Custom Taxonomy Query
- How to get all the terms of a post
- Get Posts Under Custom Taxonomy
- When is the ‘post_content_filtered’ column in database cleared by WordPress?
- Separate Database Tables For Different Post Types
- Displaying the category name of a custom post type
- Show WordPress Custom Taxonomy Items Based On a Selected Item From Another Custom Taxonomy
- How can I safely increase the character limit for post passwords?
- How to Group Posts by the First Letter or Number?
- Restore contents of deleted user
- Show Custom Taxonomy Categories, Listing of Posts, and Single Post via AJAX
- Custom Taxonomies Incorrectly Counting Revisions?
- What are terms and taxonomy, how they related to post and how these three are stored in database?
- database columns: post_title vs post_name
- Exporting Data from WordPress into a flat table
- How do I get the slug of a custom taxonomy category of a post?
- Post taxonomy from exif data
- Redirection to taxonomy posts list after post submit.
- Remove custom posts that match taxonomy value
- Instead of submiting an entire post, is there any way to submit a lite-post or a simple message?
- Importing New Posts from Live Site into Local Dev Site
- Manually removing revision post types
- How to store an extra (surrogate) ID when creating a post with wp_insert_post?
- How do I find which articles are missing a featured image in The WordPress database?
- Split WP_POST table based on post types
- Multiples Empty Posts were created and cannot delete them
- Automatically Updating Publish Date Bug
- How to modify post content?
- Display tag image in post using Taxonomy Images plugin index.php
- wp_get_object_terms returns only Uncategorized on first publish
- After database migration, posts not showing up in dashboard
- Posts list in custom taxonomy
- How to Restrict Previous & Next Post Link to Posts of Same Category?
- Transferring WordPress Database – Serialised data
- Emojis replaced by ‘?’ automatically
- Prepending %category% onto default posts fails
- get_adjacent_post by language
- WordPress Local And Live Site
- Remove Custom Post Type Slug and add Custom Taxonomy to Permalink Structure?
- Can’t update old posts 3.5.2
- sql select for post_title and a term name
- wp_posts table: safely remove unused columns to save database storage
- Copy taxonomy terms from one post to another programmatically
- Why my wp_posts data is so huge?
- relating business and products with custom taxonomy?
- WordPress bulk category select when publishing post
- Check if current user has a post and that post has any term/s from a specific custom taxonomy outside the loop
- Move posts from a non-wordpress site to wordpress
- Parent category / child category posts
- Display post number by category
- Unable to differentiate between two categories under custom post type on single.php
- How to select particular month post from table and update the post status using MySQL?
- why the posts queried from sql is more than those showed on the page?
- How to output all taxonomy links from a custom post type in a menu?
- Is there a function to get post info for any publish_status by post ID?
- Geting error in post and category [closed]
- Custom post type and taxonomy page templates
- Your ideas on my though “delete or move all of the posts in a specific category when 3 days are passed”
- How Can I Always Display A Particular Post First Using WP_Query?
- My website is showing today’s date instead of published date since db migration to a new wordpress
- How to setup default value of post_id
- Post not using taxonomy template
- Bulk find & replace on WordPress posts/pages (minus image paths)
- Show post count in custom taxonomy page
- Create/Set Category as Title of Post
- Reusing old post IDs
- Trigger on DB make problem on wordpress?
- Comments are in database, don’t show up in WordPress backend or frontend
- Is there a way to save different data when USER interacts with the same POST?
- How can I stop ‘in use’ message from intermittently blocking my wp_posts table?
- Page with Category Returning 1
- Customizing URL slugs of Custom Post Type and Taxonomy make posts/pages 404
- Clean up customize_changeset in DB
- How can we print out total number of posts filtered by post type and category?
- How do I get a certain set of posts from the database?
- Surrogate ID for posts, is there an alternative field in the posts table?
- Expired Post with More Recent Time Stamp?
- How to list all names and descriptions of a custom taxonomy
- How to display term in archive page?
- I moved my site to another server, wp admin works so does the front page, but posts don’t work
- Can’t seem to replicate permalink structure for localhost development site
- Extra field in wp_post instead of postmeta
- Voting System, database connections?
- Special Query: Title, Terms, Content – %LIKE%
- Is there a maximum amount of pages for a multi-page post?
- How to make category for word post_content
- How to detect if an ACF custom-field is really in use?
- What effect can a large wp_post table have on overall site performance?
- How to make ‘show_option_all’, that comes from wp_list_categoreis, to work with get_categories or with get_terms?