Changeset 3678 for trunk/wp-includes/template-functions-links.php

Timestamp:

04/02/2006 12:33:10 AM (20 years ago)

Author:

ryan

Message:

Some optimization of the post query. #2604

File:

• trunk/wp-includes/template-functions-links.php (modified) (2 diffs)

trunk/wp-includes/template-functions-links.php

@@ -471 +471 @@
     
     if ( 'posts' == get_query_var('what_to_show') ) {
-        preg_match('#FROM\s(.*)\sGROUP BY#siU', $wp_query->request, $matches);
+        preg_match('#FROM\s(.*)\sORDER BY#siU', $wp_query->request, $matches);
         $fromwhere = $matches[1];
         $numposts = $wpdb->get_var("SELECT COUNT(DISTINCT ID) FROM $fromwhere");
@@ -477 +477 @@
     } else {
         $posts = $wp_query->posts;
-        preg_match('#WHERE\s(.*)\sGROUP BY#siU', $wp_query->request, $matches);
+        preg_match('#WHERE\s(.*)\sORDER BY#siU', $wp_query->request, $matches);
         $where = preg_replace('/( AND )?post_date >= (\'|\")(.*?)(\'|\")( AND post_date <= (\'\")(.*?)(\'\"))?/siU', '', $matches[1]);
         $num_days = $wpdb->query("SELECT DISTINCT post_date FROM $wpdb->posts WHERE $where GROUP BY year(post_date), month(post_date), dayofmonth(post_date)");