Changeset 6253 for branches/2.3/wp-includes/bookmark.php

Timestamp:

10/15/2007 08:14:56 PM (17 years ago)

Author:

ryan

Message:

Use inner joins instead of left joins for taxonomy. Inner is faster. fixes #5179 for 2.3

File:

• branches/2.3/wp-includes/bookmark.php (modified) (1 diff)

branches/2.3/wp-includes/bookmark.php

@@ -114 +114 @@
     if (!empty($category_query)) {
         $category_query .= ") AND taxonomy = 'link_category'";
-        $join = " LEFT JOIN $wpdb->term_relationships AS tr ON ($wpdb->links.link_id = tr.object_id) LEFT JOIN $wpdb->term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id";
+        $join = " INNER JOIN $wpdb->term_relationships AS tr ON ($wpdb->links.link_id = tr.object_id) INNER JOIN $wpdb->term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id";
     }