WP Fast Spam Removal
<?php
/* Fast Spam Removal */
global $wpdb;
$spam_comments_id_arr = $wpdb->get_col( "SELECT comment_id FROM {$wpdb->comments} WHERE comment_approved='spam' OR comment_approved='trash'" ) ;
if ( !empty( $spam_comments_id_arr ) ) {
$spam_comments_ids = implode( ', ', array_map('intval', $spam_comments_id_arr) );
$wpdb->query("DELETE FROM {$wpdb->comments} WHERE comment_id IN ( $spam_comments_ids )");
$wpdb->query("DELETE FROM {$wpdb->commentmeta} WHERE comment_id IN ( $spam_comments_ids )");
$wpdb->query( "OPTIMIZE TABLE $wpdb->comments" );
$wpdb->query( "OPTIMIZE TABLE $wpdb->commentmeta" );
}
echo 'complete';