Changeset 17652

Timestamp:

04/18/2011 08:38:59 PM (13 years ago)

Author:

ryan

Message:

More efficient term intersection query. Props tigertech. see #16706

File:

• trunk/wp-includes/taxonomy.php (modified) (1 diff)

trunk/wp-includes/taxonomy.php

@@ -695 +695 @@
                 $terms = implode( ',', $terms );
 
-                $where[] = "$primary_table.$primary_id_column IN (
-                    SELECT object_id
+                $where[] = "(
+                    SELECT COUNT(1)
                     FROM $wpdb->term_relationships
                     WHERE term_taxonomy_id IN ($terms)
-                    GROUP BY object_id HAVING COUNT(object_id) = $num_terms
-                )";
+                    AND object_id = $primary_table.$primary_id_column
+                ) = $num_terms";
             }