WordPress.org

Make WordPress Core


Ignore:
Timestamp:
10/11/2007 05:43:49 PM (13 years ago)
Author:
ryan
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/wp-includes/bookmark.php

    r6173 r6224  
    113113    if (!empty($category_query)) {
    114114        $category_query .= ") AND taxonomy = 'link_category'";
    115         $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";
     115        $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";
    116116    }
    117117
Note: See TracChangeset for help on using the changeset viewer.