Wordpress: cancellare le relazioni orfane nel database

Per fare pulizia in Wordpress...

Prima fai sempre un backup!

DELETE tr.*
FROM   wp_term_relationships AS tr
WHERE  tr.object_id NOT IN (SELECT id FROM wp_posts);

DELETE pm.*
FROM   wp_postmeta AS pm
WHERE  pm.post_id NOT IN (SELECT id FROM wp_posts);