WORDPRESS > supprimer les entrées inutilisées ou orphelines de wp_term_relationships

NETTOYER wp_term_relationships

DELETE FROM wp_term_relationships
WHERE object_id NOT IN (SELECT ID FROM wp_posts);

MISE A JOUR DU COMPTAGE DES terms

UPDATE wp_term_taxonomy tt
SET count = (SELECT count(p.ID)
FROM wp_term_relationships tr
LEFT JOIN wp_posts p ON p.ID = tr.object_id
WHERE tr.term_taxonomy_id = tt.term_taxonomy_id);

EFFACER LES terms INUTILISÉS

DELETE wt
FROM wp_terms a
INNER JOIN wp_term_taxonomy b ON a.term_id = b.term_id
WHERE b.count = 0;
DELETE FROM wp_term_relationships
WHERE object_id NOT IN (SELECT ID FROM wp_posts)