Question : WP DELETE UNUSED TAGS
Answered by : enrico-bisco
DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE count = 0 );
DELETE FROM wp_term_taxonomy WHERE term_id not IN (SELECT term_id FROM wp_terms);
DELETE FROM wp_term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy);
Source : https://wpdatatables.com/wordpress-database-cleanup/ | Last Update : Thu, 07 Apr 22