Changeset 8738 for trunk/wp-includes/query.php

Timestamp:

08/26/2008 07:18:58 PM (17 years ago)

Author:

ryan

Message:

Use a subquery in categorynot_in query if the DB version supports it. Props pedrop. fixes #7599

File:

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

trunk/wp-includes/query.php

@@ -1047 +1047 @@
 
         if ( !empty($q['category__not_in']) ) {
-            $ids = get_objects_in_term($q['category__not_in'], 'category');
-            if ( is_wp_error( $ids ) )
-                return $ids;
-            if ( is_array($ids) && count($ids > 0) ) {
-                $out_posts = "'" . implode("', '", $ids) . "'";
-                $whichcat .= " AND $wpdb->posts.ID NOT IN ($out_posts)";
+            if ( $wpdb->supports_subqueries() ) {
+                $cat_string = "'" . implode("', '", $q['category__not_in']) . "'";
+                $whichcat .= " AND $wpdb->posts.ID NOT IN (SELECT $wpdb->term_relationships.object_id FROM $wpdb->term_relationships WHERE $wpdb->term_relationships.term_taxonomy_id IN ($cat_string) )";
+            } else {
+                $ids = get_objects_in_term($q['category__not_in'], 'category');
+                if ( is_wp_error( $ids ) )
+                    return $ids;
+                if ( is_array($ids) && count($ids > 0) ) {
+                    $out_posts = "'" . implode("', '", $ids) . "'";
+                    $whichcat .= " AND $wpdb->posts.ID NOT IN ($out_posts)";
+                }
             }
         }