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

Timestamp:

11/28/2005 09:44:56 AM (20 years ago)

Author:

matt

Message:

No need to do those big fancy joins.

File:

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

trunk/wp-includes/functions.php

@@ -1278 +1278 @@
         $post_ids = implode(',', $post_ids);
 
-    $dogs = $wpdb->get_results("SELECT DISTINCT
-    post_id, cat_ID FROM $wpdb->categories, $wpdb->post2cat
-    WHERE category_id = cat_ID AND post_id IN ($post_ids)");
+    $dogs = $wpdb->get_results("SELECT post_id, category_id FROM $wpdb->post2cat WHERE post_id IN ($post_ids)");
 
     if ( empty($dogs) )
@@ -1286 +1284 @@
         
     foreach ($dogs as $catt)
-        $category_cache[$catt->post_id][$catt->cat_ID] = &get_category($catt->cat_ID);
+        $category_cache[$catt->post_id][$catt->category_id] = &get_category($catt->category_id);
 }