WordPress recount comments

wp-recount-comments.php

<?php
/**
 * Put this file in the root of your WordPress installation.
 * When done remove it!
 */

include 'wp-blog-header.php';

global $wpdb;

$wp_posts = $wpdb->get_results("SELECT ID FROM wp_posts WHERE post_status = 'publish'");

foreach( $wp_posts as $post ) {
  $post_id = $post->ID;
	$comment_count = $wpdb->get_var("SELECT COUNT(*) AS comment_cnt FROM wp_comments WHERE comment_post_ID = '$post_id' AND comment_approved = '1'");
	$wpdb->query("UPDATE wp_posts SET comment_count = '$comment_count' WHERE ID = '$post_id'");
}