Changeset 17652 for trunk/wp-includes/taxonomy.php

Timestamp:

04/18/2011 08:38:59 PM (15 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";
                         }