I’m wondering if you’re actually looking at post revisions. Keep in mind that WordPress creates a revision of a post any time you make a change to it. Each revision stays in the database, however, the way you access it is by going into the post itself and then locating the revision section in the upper right hand corner.
The posts you see might actually not be “orphaned” posts.
I would also recommend you consider doing some WordPress maintenance to clean out older post revisions. I would recommend you look into using WP-Optimize for this (be sure to read the documentation). See if that actually addresses your issue.
Related Posts:
- Count & Display Database Queries
- Hook into $wpdb
- Hook to be used when creating a database table
- Block search SQL from happening
- Trigger Plugin database update after git pull
- Hook directly into query execution
- How to Access wp_usermeta Data Immediately After a New User is Created
- How to update the values when the featured image has changed?
- adding user_id and name to a separate table whenever a user register based on role
- About wp database hooks (error establishing connection)
- What is this JavaScript “require”?
- How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
- get_results using wpdb
- How can I make a WordPress database portable and url independent?
- wpdb->insert multiple record at once
- How to migrate a HTTPS WordPress installation to localhost?
- How to monitor server for error establishing a database connection
- How to create bulk page and content? [closed]
- Default WordPress settings API data sanitization
- Fatal error: Call to undefined function dbDelta()
- Connect to remote database using Localhost install
- remove missing image attachments
- Transient RSS feeds in wp_options not removed automatically?
- Best way to move live site local
- The revisions table in my database is at 70% capacity and growing. What should I do?
- WordPress for a very large website
- How to ensure data consistency in WordPress
- Database location in WordPress
- WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
- WP_list_table bulk_action get edit and delete
- How to display data from custom table in wordpress database?
- How to intercept update_option() before it saves data?
- Change SQL get_results to search for posts with custom term in custom taxonomy
- wpdb query on custom table not working [closed]
- How to diagnose and keep in check encoding issues?
- Add search Value to wp_list_table pagination
- stdObject stored in database. How does one convert it to usable format?
- I have a table I created, how do I make a form for a user to filter the data?
- How to fix unchanged URLs in Database after running serialized search and replace script?
- wp_redirection_404 table has grown to 7GB
- Does WordPress ever need multiple databases?
- Why are no posts showing despite my apparently correct DB restoration?
- Multiple wp_options tables to share content across installs
- Merging two databases without borking it
- Is there a smart way to obtain a list of only some selected user meta data?
- Why does importing copies of the database dump and the document root make WordPress data inconsistent?
- Permit Login if table row exists
- Make an Items attribute searchable (taxonomy using existing attribute)
- How Yoast SEO plugin works with variable %%name%%?
- What would Repair and Optimize WordPress Database do?
- Saving zero as meta value
- Query multiple tables at once?
- INSERT in table row fatal error
- Transferring/Uploading Data from DB to WordPress
- How to convert srcset links from https to http?
- Choosing http or https during manual installation of WordPress and database
- Delete all posts that do NOT have a specific tag
- Changing order of db results when encoding to JSON
- How to transfer from localHost to live but use the already existing database on the server?
- Why does wp_links still exist in the db schema?
- can’t upgrade wordpress or install plugins, it seems to “think” it’s still on a local installation
- How not to display ALL items of a database
- How to get the records from start with A to G in php and mysql
- Link multiple user databases together?
- is it right choose to connect database in template page directly in WordPress site?
- I wanted to Know that how can I give ingore to 0000-00-00 in my config file
- Set a cron job to delete a specific database table table every midnight
- Two separate wordpress installations at one domain
- Is there a way to edit the WP content database in an admin panel or external page?
- Is there any defects for using same database prefix in WordPress for multiple sites?
- Can we store password in without being hashing?
- SQL database import #1046 error
- Get all top categories, then only 3 posts for each
- I would like some help wth an SQL query to link posts with categories
- Error establishing a database connection in wordpress
- Where is the HTML-handler part in the wpdb class?
- next comment id number wordpress
- Counting user’s comments – efficient way?
- Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
- The MySQL Connection could not be established., before it was joomla but i have change it into worpress
- Both VPS and domain changed but Database URL stayed the same and PHPmyadmin inaccessible to change it
- How and when would I implement some code which would take data from one part of the Db and put it in another?
- Backup Restore turns carriage returns to literal strings
- Filtering data and saving query results
- Find/ascertain latest wordpress db from multiple database copies
- Local Content different from Remote Content
- Check if a database is well installed
- save content in to wordpress wp_post table of database
- WordPress + Postgresql
- Author ID mismatch from database
- MySQL Database User: Which Privileges are needed?
- Import Excel (or csv) Table with user-data as subscribers to wordpress
- Automatic add record after refreshing page
- Print output of Table Creation
- Recommended Post Structure for DB Storage
- SQL query : Select a thumbnail for a media
- trying to install wp but i have no clue on hosting and servers [closed]
- What is table `wp_woocommerce_termmeta` for? [closed]
- Showing Error(TAble already exist)
- Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]