Database cleaning

delete-tax.php

DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE taxonomy IN ( 'unwanted_tax_1', 'unwanted_tax_2' ) );
DELETE FROM wp_term_relationships WHERE term_taxonomy_id IN (SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE taxonomy IN ( 'unwanted_tax_1', 'unwanted_tax_2' ) );
DELETE FROM wp_term_taxonomy WHERE taxonomy IN ( 'unwanted_tax_1', 'unwanted_tax_2' );

dots.sql

SELECT * FROM wp_users WHERE LENGTH(user_email) - LENGTH(REPLACE(user_email, '.', ''))  > 4;

missing-usermeta.sql

DELETE FROM wp_usermeta WHERE user_id NOT IN (SELECT ID FROM wp_users);

nocaps.sql

DELETE FROM wp_users WHERE ID NOT IN ( SELECT user_id FROM wp_usermeta WHERE meta_key = 'wp_capabilities' )

select-domains.sql

SELECT domain, COUNT(domain) as count FROM wp_users GROUP BY domain ORDER BY count DESC;

suspicious.sql

DELETE FROM wp_users WHERE
user_email LIKE '%buy%' OR
user_email LIKE '%weight%' OR
user_email LIKE '%guide%' OR
user_email LIKE '%money%' OR
user_email LIKE '%fashion%' OR
user_email LIKE '%cheats%' OR
user_email LIKE '%finance%' OR
user_email LIKE '%marijuana%' OR
user_email LIKE '%cialis%' OR
user_email LIKE '%viagra%';

tax-list.sql

SELECT DISTINCT(taxonomy) FROM wp_term_taxonomy;

temporary.sql

DELETE FROM wp_users WHERE user_email LIKE "%zippymail.info%" OR user_email LIKE "%mailinator.com%" // etc.; 

user-domain.php

$users = $wpdb->get_results( "SELECT ID, user_email FROM wp_users" );
foreach( $users as $user ) {
	$domain = substr( strrchr ( $user->user_email, "@" ), 1 );
	$wpdb->update(
		'wp_users',
		array( 'domain' => $domain ),
		array( 'ID', $user->ID ),
		array( '%s' ),
		array( '%d' )
	);
}

usermeta-list.sql

SELECT DISTINCT(meta_key) FROM wp_usermeta LIMIT 0, 500;

users-empty.sql

DELETE FROM wp_users WHERE user_email = '' OR user_login = '' OR user_password = '';