Changeset 727 for trunk/wp-blog-header.php

Timestamp:

01/06/2004 12:44:46 PM (22 years ago)

Author:

saxmatt

Message:

Reduce queries.

File:

• trunk/wp-blog-header.php (modified) (2 diffs)

trunk/wp-blog-header.php

@@ -168 +168 @@
 if ('' != $category_name) {
     $category_name = preg_replace('|[^a-z0-9-/]|', '', $category_name);
+    $tables = ", $tablepost2cat, $tablecategories";
     $join = " LEFT JOIN $tablepost2cat ON ($tableposts.ID = $tablepost2cat.post_id) LEFT JOIN $tablecategories ON ($tablepost2cat.category_id = $tablecategories.cat_ID) ";
     $whichcat = " AND (category_nicename = '$category_name') ";
@@ -320 +321 @@
 $posts = $wpdb->get_results($request);
 
+
+// Get the categories for all the posts
+foreach ($posts as $post) {
+    $post_id_list[] = $post->ID;
+}
+$post_id_list = implode(',', $post_id_list);
+
+$dogs = $wpdb->get_results("SELECT DISTINCT 
+    ID, category_id, cat_name, category_nicename, category_description 
+    FROM $tablecategories, $tablepost2cat, $tableposts 
+    WHERE category_id = cat_ID AND post_id = ID AND post_id IN ($post_id_list)");
+    
+foreach ($dogs as $catt) {
+    $category_cache[$catt->ID][] = $catt;
+}
+
+// Do the same for comment numbers
+
+
 if (1 == count($posts)) {
     if ($p || $name) {