Changeset 12116

Timestamp:

10/27/2009 03:51:58 PM (16 years ago)

Author:

ryan

Message:

Remove slow left join pending better solution. see #4529

File:

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

trunk/wp-includes/comment.php

@@ -767 +767 @@
         return $count;
 
-    $where = 'WHERE ';
-    if( $post_id > 0 )
-        $where .= $wpdb->prepare( "c.comment_post_ID = %d AND ", $post_id );
-    $where .= "p.post_status <> 'trash'";
-
-    $count = $wpdb->get_results( "SELECT comment_approved, COUNT( * ) AS num_comments FROM {$wpdb->comments} c LEFT JOIN {$wpdb->posts} p ON c.comment_post_ID = p.ID {$where} GROUP BY comment_approved", ARRAY_A );
+    $where = '';
+    if ( $post_id > 0 )
+        $where = $wpdb->prepare( "comment_post_ID = %d AND ", $post_id );
+
+    $count = $wpdb->get_results( "SELECT comment_approved, COUNT( * ) AS num_comments FROM {$wpdb->comments} {$where} GROUP BY comment_approved", ARRAY_A );
 
     $total = 0;