How to update wp_posts with just the returned comment count from wp_comments (SQL GROUP BY)

The easy way is to just write PHP to go through all the posts and call wp_update_comment_count() on each post ID.

Related Posts:

  1. What do these phpMyAdmin errors mean on my WordPress databaes?
  2. Allow variable amount of comments before pagination
  3. MySQL Query to Retrieve Category from wp_posts
  4. SQL Query for getting all posts in their latest revised state
  5. get comments and get posts in loop
  6. Manually delete post from database
  7. modify all posts of a category to “no comments allowed”
  8. How can I allow editors to leave comments on posts that have not yet been published?
  9. How to force update all posts after import
  10. One comment per user email per post
  11. Can’t show comments count per post outside loop
  12. Only display posts with comments
  13. Comments enabled, but disabled at the same time
  14. Comments not showing in custom post type – WordPress
  15. How to output comments number of a post per day?
  16. Enable commenting on front-end preview page for pending posts
  17. Hide comments awaiting moderation from user who submitted the comments
  18. Query All users that has post
  19. Can’t publish new posts
  20. Display posts with comments closed, with pagination?
  21. Why is WordPress redirecting users to random posts after commenting?
  22. How to get most recent commented post above new submitted post in WordPress?
  23. Reset/Reorder posts ID in the MySQL wp_posts table
  24. how to find user ids of all commenters in a post
  25. Diplay comment date on WP_Post_Comments_List_Table
  26. How do I find which articles are missing a featured image in The WordPress database?
  27. Posts vs. Pages
  28. How to allow logged in users to post anonymously
  29. wp_insert_post – duration
  30. Query get post,how to add comment box
  31. Enable Comments Box On Custom Post Type
  32. Turn On Comments On Custom Post Types in Directory Theme
  33. Emojis replaced by ‘?’ automatically
  34. Showing author page if user has no post
  35. Customizing Comments on Posts
  36. Custom order for Mysql array
  37. What do comments with […] mean?
  38. Remove a shortcode from all WordPress posts
  39. Internal post link creates comments on its own
  40. What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
  41. How to get posts and comments amount per hour, per year and per month?
  42. Show comment number per author per day
  43. Get all comments of author’s posts
  44. Delete post results in “Cannot delete or update a parent row: a foreign key constraint fails”
  45. SQL Command for restoring trashed comments
  46. How do you change the comment count in the back end posts list, to reflect unapproved comments, rather than all comments?
  47. Inner join overrides Advanced Custom Fields plugin’s get_field [closed]
  48. Hide comments and posts posted by other user
  49. Let both the admin and post author update comment meta
  50. update image path with words starting uppercase to lowercase chars
  51. How to style archive post titles… but only those posts who have comments?
  52. Database hacked – random posts are modified
  53. Need to change all links in page content but not in post content
  54. Can’t update WordPress Page if post_content is Empty
  55. Is it advisable to use $post->comment_count instead of get_comments_number( $post_id )
  56. Restore woocommerce orders
  57. How does WP decide how to display a page
  58. How to select particular month post from table and update the post status using MySQL?
  59. Display on page every post in blog WITH comments
  60. Showing recent post of category in page
  61. Can WordPress handle following functionalities?
  62. get last post’s link with SQL query
  63. How to get post id of last approved comment?
  64. query for filtering published posts?
  65. How to implement a WordPress comments function?
  66. Deleting post tags removes categories
  67. Return records between two meta datetimes saved as strings
  68. WP query taxonomy optimization
  69. Count the total views of all user posts published
  70. how to show comments only author which send own posts in wordpress
  71. Shortcode for Comments and Comment Boxes in Post Loop
  72. Merge get_comments & get_posts into a single query
  73. MYSQL: Create SQL query to search for string and replace
  74. Remove the URL author of post on all comments
  75. WordPress MySQL Search and replace with wildcard?
  76. WordPress weird behaviour on comments
  77. Comments are in database, don’t show up in WordPress backend or frontend
  78. No comments allowed
  79. Add postmeta to all blog posts
  80. ‘posts’ table should not store the absolute image path
  81. Dev and prod on the same database- dev version active for IOS
  82. SQL trigger failes with post_content
  83. How to enable comments meta box for other author posts?
  84. Comments as part of a post
  85. Some comment box wordpress in 1 post [closed]
  86. 3rd Party Login in wordpress
  87. SQL query to remove first image in all posts
  88. Apply comment to different post (not the current post) [duplicate]
  89. How can I get a comment ID on Submit?
  90. Delete junk text from all the post using my sql command
  91. Get first comment link on the post itself
  92. FIND and REPLACE wp_posts AND IGNORE custom post type mysql query
  93. Display the first post’s comments of category in comments.php template
  94. 2 tick boxes appearing below comments
  95. How to display a certain template element only for posts published within certain time range?
  96. How to create a post based on data in a table?
  97. How can I show the positive and negative comments for a same post separately?
  98. How does WordPress add the comments and comment form to posts
  99. Simple shortcode to check if a user has commented on a certain post
  100. Undefined Function Fatal Error with Shortcode [closed]