Skip to content
SigmaPluginSigmaPlugin
  • Home
  • Plugins
  • Blog
  • Affiliate area
  • Contact
  • About
  • Login
  • Register
Blog

What are WordPress orphan posts meta and how to clean them?

Posted on March 2, 2016September 15, 2020 by Younes JFR.

The post metadata is the information you provide to viewers about each post. This information usually includes the author of the post, when it was written (or posted), and how the author categorized that particular post. In some cases, some post metadata information becomes orphan and do not belong to any post. They are then called orphan post meta and should be cleaned since they are not useful.

You can either use our plugin Advanced Database Cleaner to clean-up these orphan post meta or execute the following SQL code (which is used by the plugin) directly via your phpMyAdmin:

DELETE pm FROM postmeta pm LEFT JOIN posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL

Younes JFR.

Younes Jaafar known as (Younes JFR.), is the Founder of SigmaPlugin.com. I have spent the past 10 years developing websites and plugins for WordPress. Web development is not only a job but also a passion for me and always will be.

What are WordPress trash comments and how to clean them?
What are WordPress orphan relationships and how to clean them?
Recent Posts
  • 14
    Oct
    How to delete a specific table from your WordPress Database 6 Comments
  • 04
    Sep
    Changelog – Advanced Database Cleaner Comments Off on Changelog – Advanced Database Cleaner
  • 09
    Apr
    How to increase your PHP Max Execution Time in case of a timeout error
  • 01
    Mar
    How To Speed Up Your WordPress Website
  • 06
    Feb
    4 Things That May Be Slowing Your WordPress Site Down

Clean up your WP Database

At SigmaPlugin, we focus on developing awesome WordPress plugins. We really love creating tools that help you make wonderful websites :)

Resources

Documentation

FAQ

Blog & news

Terms

Terms & Conditions

Privacy policy

Refund policy

Useful Links

About us

Plugins

Affiliates

Contact & Support

Resources

Documentation

FAQ

Blog & news

Terms

Terms & Conditions

Privacy policy

Refund policy

Useful Links

About us

Plugins

Affiliates

Contact & Support

At SigmaPlugin, we focus on developing awesome WordPress plugins. We really love creating tools that help you make wonderful websites :)

Resources

Documentation

FAQ

Blog & news

Terms

Terms & Conditions

Privacy policy

Refund policy

Useful Links

About us

Plugins

Affiliates

Contact & Support

Copyright 2022 © SigmaPlugin
  • Home page
  • Our plugins
  • Blog
  • Affiliate area
  • Login
  • Register
  • Contact
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it. By clicking “Accept”, you consent to the use of ALL the cookies. Learn more about our privacy policy.
ACCEPT
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non Necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.

Save & Accept