bulk-delete-terms of taxonomy

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");