Kategorie-Archiv: sinnvolle SQL-Statements für das Wordpressmanagement

Löschen unbenutzter Tags bei WordPress mit Hilfe eines SQL-Statements

DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE taxonomy = ‘post_tag’ AND COUNT <= 1);

DELETE FROM wp_term_relationships WHERE term_taxonomy_id IN (SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE taxonomy = ‘post_tag’ AND COUNT <= 1);

DELETE FROM wp_term_taxonomy WHERE taxonomy = ‘post_tag’ AND COUNT <= 1