MySQL left join

List unused post meta:

SELECT * FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;

Leave a Reply

Your email address will not be published. Required fields are marked *