mmilosheski · August 20, 2018 10:58
diff --git a/bulk-delete-terms of taxonomy b/bulk-delete-terms of taxonomy
 $wpdb->query( "DELETE relations.*, taxes.*, terms.*
 FROM $wpdb->term_relationships AS relations
 INNER JOIN $wpdb->term_taxonomy AS taxes
 ON relations.term_taxonomy_id=taxes.term_taxonomy_id
 INNER JOIN $wpdb->terms AS terms
 ON taxes.term_id=terms.term_id
 WHERE object_id IN (SELECT ID FROM $wpdb->posts WHERE post_type='baby-names-lists')");

 $wpdb->query( "DELETE FROM `$wpdb->termmeta`
 WHERE 
 	`term_id` in ( 
 		SELECT `term_id`
 		FROM `$wpdb->term_taxonomy`
 		WHERE `taxonomy` in ('baby-names') 
 	)");
 $wpdb->query( "DELETE FROM `$wpdb->terms`  
 WHERE 
 	`term_id` in ( 
 		SELECT `term_id`
 		FROM `$wpdb->term_taxonomy`
 		WHERE `taxonomy` in ('baby-names') 
 	)");

 $wpdb->query( "DELETE FROM `$wpdb->term_taxonomy` WHERE `taxonomy` in ('baby-names')");
 $wpdb->query( "DELETE meta FROM $wpdb->termmeta meta LEFT JOIN $wpdb->terms terms ON terms.term_id = meta.term_id WHERE terms.term_id IS NULL");