Changeset 10424

Timestamp:

01/23/2009 10:40:37 PM (15 years ago)

Author:

ryan

Message:

Don't use order and limit for count query. see #7415

File:

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

trunk/wp-admin/includes/template.php

@@ -1970 +1970 @@
             comment_content LIKE ('%$s%') ) AND
             $approved
-            $typesql
-            $orderby";
+            $typesql";
     } else {
-        $query = "FROM $wpdb->comments USE INDEX (comment_date_gmt) WHERE $approved $post $typesql $orderby";
-    }
-
-    $comments = $wpdb->get_results("SELECT * $query");
+        $query = "FROM $wpdb->comments USE INDEX (comment_date_gmt) WHERE $approved $post $typesql";
+    }
+
+    $comments = $wpdb->get_results("SELECT * $query $orderby");
     if ( '' === $total )
         $total = $wpdb->get_var("SELECT COUNT(comment_ID) $query");