Posts from one site are not stored in the same table as posts from another site.
Each blog on a multi site gets an ID and that ID is used to generate a separate set of tables for each site in a multisite installation.
So for example site 1 gets:
wp_posts
where as site 2 gets:
wp_1_posts
and so on:
wp_2_posts
Related Posts:
- Anyone figured out how to use WordPress MultiSite with Domain Mapping & SSL?
- What do I need to do to convert my MultiSite from HTTP to HTTPS?
- WP Multisite development with Mamp Pro and wildcard subdomains, not really working for me
- SSL wildcard issue for wp multisite subdomains
- How to set configuration options for particular sub blogs?
- Perform action on WPMU blog deletion
- Changing Multisite themes on mass
- Organize uploaded media files
- How to upload images manually to wordpress?
- MU domain mapping login issue
- Sitemap Plugin for WordPress Network
- How to make WordPress use new Upload Path settings in Multisite Setup
- WPDB Multiple site’s posts and get featured images
- Using WP CLI to set options in WP Multisite
- Import a regular WordPress blog into a MU installation
- Basic analytics across WordPress Multisite network [closed]
- Ideal WP multisite server setup for up to 1000 sites?
- WordPress 3.8.1 Multisite blog slug problem
- How to make wp-signup.php a 1-step process [closed]
- Why is my multisite installation not showing all the available sites?
- Issue converting single site to multi-site – blogs.dir folder not created
- WP_INSERT_POST issue on WordPress Multisite
- PHP Notices appear when browsing any page in admin, but only for child theme, using code from WP Codex
- How to Rename wp-login.php for Multisite?
- What is the most efficient way to have two “blogs” on one site?
- Preview posts returns 404
- How can I have multiple URLs pointing to single WordPress installation?
- How to exclude a directory from WordPress permalinks in a Multisite environment?
- Redirect subdomain homepage to domain specific page in wordpress multisite
- Make WordPress Search for Both Main Domain and Subdomain
- Does WordPress MultiSite use separate MySql databases?
- Create a network of blogs with WordPress 3
- create new site subsite in wordpress multisite by subscriber user instead of network admin
- Retrieving data from specific multisite blog
- Error 404 on Network Admin and others
- Retrieving multisite blog IDs, somehow failing to foreach them properly
- Network Plugin Creating Pages for Different Subdomains
- Get just subdirectory name from a multisite URL
- Why my deleted url is redirecting to random post?
- Reset a site in multisite
- Problem uploading images
- Multisite – 404 when accessing sub-sites
- Redirect Site Geologically
- WordPress Network admin options page: how to store options and where will they be stored?
- .htaccess rules for blocking bots with an extra condition
- Wrong filepaths and admin page infinite reload after migrating to aws bitnami
- Multisite not using subdomains as hostname in from address when sending emails
- Cookie signed verification failed – wp-saving-post
- Do I need a Multisite? [closed]
- Error: reassigning content to a different user is not supported on multisite
- Run additional service on domain with WordPress Multisite?
- How to host unrelated pages on WordPress domain
- How can I overhaul a live MultiSite network?
- Update configured themes
- Programmatically Add Item to WP Multisite Menus
- metaboxes disappear on saved pages
- Problem with parked domain for my mutisite
- WordPress multisite – What’s the ideal setup for development/staging/production environments?
- WordPress self hosted site asking to login again when used www
- User registration on two sites in same multisite
- Multisite – big hosting package or several hosting packages?
- WordPress network vs Separate installs
- 404 on page 2 multisite
- How many databases do I need?
- How can I append blog_id to … echo [functions-defined-constant]?
- Multisite Subdirectory Site Dashboard redirect loop
- Is it possible to disable html code error auto fixing feature by wordpress 4.9.1?
- WordPress Multisite Add User
- LimitInternalRecursion error
- Some permalinks are not working and show 404
- Should I use Multi Site to achieve different designs for different sections?
- WP MS: How to query over the network
- unable to access network admin of a blog
- WPMU on MySQL limited to 1GB of space?
- WordPress Multisite Permalinks on mapped domain = server 404 error
- Sites network with sub-folders
- Set my own password when registering a multisite user or site
- Efficient way to fetch all archived WPMS blogs
- Manually Moving Posts/Pages/Comments/Tags from WPMU to WP3.0
- Setup another new subdomain root on top of multisite configuration
- WordPress keeps deleting user account for multisite after loggin out i need your help please?
- Change main site / network admin site?
- Language per user role, how can I achieve this?
- Internet explorer not finding right content from multisite
- Change WordPress multisite to sub-folder installation
- Serve theme and plugins assets from correct domain on multi-domain multisite
- How to add a link of “one” website in posts of “second” website in multisite WordPress
- Themes are visible in Network, but invisible in sites
- logging out with/without confirmation – single site, multisite
- No debug log for WP multisite is created
- Multisite different domains mapping error on GGS
- Multisite – each site with it’s own set of users
- WordPress Multisite wp-admin/ redirect loop but adding index.php works fine
- Can WP multisite manage multiple ccTLDs
- Should i use multisite for my business?
- WordPress Multisite redirect loop
- Split a Multisite Into Single WordPress Websites
- WordPress Multisite Subsite WP admin not working
- Multiple WordPress sites on one hosting [closed]
- Redirect to Multisite site 2 if site 1 has a setting