Untitled

DELETE FROM `wp_terms` WHERE term_id in (SELECT term_id FROM `wp_term_taxonomy` WHERE `taxonomy` LIKE 'state_city' )
DELETE FROM `wp_term_taxonomy` WHERE `taxonomy` LIKE 'state_city'
DELETE FROM `wp_term_taxonomy` WHERE term_id not in (SELECT term_id FROM `wp_terms`) and taxonomy = 'state_city' 
DELETE FROM `wp_terms` WHERE (`slug` LIKE '%-__' OR `slug` LIKE '%-__-2') and term_id in (SELECT term_id FROM `wp_term_taxonomy` where taxonomy = 'state_city')