Changeset 3104 for trunk/wp-includes/functions.php

Timestamp:

11/16/2005 06:29:36 AM (20 years ago)

Author:

ryan

Message:

Add comment_count to the posts table. Props donncha. fixes #1860

File:

• trunk/wp-includes/functions.php (modified) (1 diff)

trunk/wp-includes/functions.php

@@ -1307 +1307 @@
 
     // Do the same for comment numbers
-    $comment_counts = $wpdb->get_results("SELECT comment_post_ID, COUNT( comment_ID ) AS ccount
-    FROM $wpdb->comments
-    WHERE comment_post_ID IN ($post_id_list)
-    AND comment_approved = '1'
-    GROUP BY comment_post_ID");
+    $comment_counts = $wpdb->get_results( "SELECT ID as comment_post_ID, comment_count as ccount FROM $wpdb->posts WHERE ID in ($post_id_list)" );
 
     if ( $comment_counts ) {