Fix WordPress comment counts (after incomplete import, etc.

fix-comment-counts.php

<?php

// Can drop code into top of {yourtheme}/functions.php and then hit the site.

// Fix comment counts.
$post_types = ['post']; // Set to the post types to fix.
$post_status = ['publish', 'pending', 'draft']; // Set to the post status to fix.

global $wpdb;
$posts = $wpdb->get_results(
	'SELECT ID FROM ' . esc_sql( $wpdb->posts ) . ' WHERE post_type IN ("' . implode( '","', array_map( 'esc_sql', $post_types ) ) . '") AND post_status IN("' . implode( '","', array_map( 'esc_sql', $post_status ) ) . '")'
);

if ( ! empty( $posts ) && is_array( $posts ) ) {
	foreach ( $posts as $post ) {
		wp_update_comment_count_now( $post->ID );
	}
}