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?
- Can posts have parents?
- Where is the old post permalink slug stored?
- Separate Database Tables For Different Post Types
- Different post sort order within different categories
- Displaying the category name of a custom post type
- Passing a hardcoded page/post ID into `get_post`
- MySQL Query to Retrieve Category from wp_posts
- Elegant way to include only published posts with get_objects_in_term()?
- 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
- Moving WordPress to new server: no posts found
- Convert IPTC keywords to blog post tags
- 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
- Sanitizing `wp_editor();` Values for Database, Edit, and Display
- Exporting Data from WordPress into a flat table
- How do I get the slug of a custom taxonomy category of a post?
- Insert posts in two tables
- Post taxonomy from exif data
- Redirection to taxonomy posts list after post submit.
- Remove custom posts that match taxonomy value
- Using Custom Posts with Metaboxes and Drop-downs
- 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
- Does an action fire when adding a tag via the “Tags” meta box?
- How can I add a meta-box to the posts editor containing all items of a custom taxonomy as checkbox?
- disable column on post and user list
- Manually removing revision post types
- How much of my site can I recover from public_html?
- Get taxonomy terms only of the WP_Query current posts
- Reset/Reorder posts ID in the MySQL wp_posts table
- 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
- Most recent post from another database
- What structure should post_content have in the database?
- Multiples Empty Posts were created and cannot delete them
- Automatically Updating Publish Date Bug
- Get posts by name and taxonomy term
- How to delete all the content of a wordpress site without deleting the Post and pages?
- How to display data in archive page?
- Extracting post categories
- How to modify post content?
- Pass data between pages
- Choose whether to automatically add a taxonomy with the same name as the post
- Display tag image in post using Taxonomy Images plugin index.php
- wp_get_object_terms returns only Uncategorized on first publish
- How to bulk-untag multiple posts?
- Force the “Choose from the most used tags” meta box section to always be expanded
- 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?
- Get Posts Under Custom Taxonomy
- Transferring WordPress Database – Serialised data
- Emojis replaced by ‘?’ automatically
- Prepending %category% onto default posts fails
- get_adjacent_post by language
- Duplicate Custom Post Type and Taxonomy Slug
- WordPress Local And Live Site
- Remove Custom Post Type Slug and add Custom Taxonomy to Permalink Structure?
- How can I setup a relationship using categories in WordPress?
- Can’t update old posts 3.5.2
- sql select for post_title and a term name
- How can I hide tags on a child-category page, if that tag has not been used?
- Copy post to separate database with “add_action(….)”
- 404 error on default post type and default taxonomy fronted page
- When open add new post or page WordPress add post with ID=0 continuously [closed]
- wp_posts table: safely remove unused columns to save database storage
- Anyone know why wordpress converts some html entities to their numeric equivalents?
- Remove a shortcode from all WordPress posts
- What do these phpMyAdmin errors mean on my WordPress databaes?
- What does wp_term_taxonomy.parent reference?
- What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
- How do I insert a post with custom post type and relate it to a custom taxonomy?
- why there are so many posts whoes post_type is revision? will these records waste too much database space?
- outputting posts’ taxonomies: cant get ‘get_the_taxonomies’ working
- Delete all drafts?
- Copy taxonomy terms from one post to another programmatically
- Is it possible to use WP_Query to only pull posts with attachments?
- Get posts and include taxonomy term
- Why my wp_posts data is so huge?