Changeset 6253 for branches/2.3/wp-includes/taxonomy.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/taxonomy.php (modified) (1 diff)

branches/2.3/wp-includes/taxonomy.php

@@ -1358 +1358 @@
 
     // Get the object and term ids and stick them in a lookup table
-    $results = $wpdb->get_results("SELECT object_id, term_taxonomy_id FROM $wpdb->term_relationships LEFT JOIN $wpdb->posts ON object_id = ID WHERE term_taxonomy_id IN (".join(',', array_keys($term_ids)).") AND post_type = 'post' AND post_status = 'publish'");
+    $results = $wpdb->get_results("SELECT object_id, term_taxonomy_id FROM $wpdb->term_relationships INNER JOIN $wpdb->posts ON object_id = ID WHERE term_taxonomy_id IN (".join(',', array_keys($term_ids)).") AND post_type = 'post' AND post_status = 'publish'");
     foreach ( $results as $row ) {
         $id = $term_ids[$row->term_taxonomy_id];