Changeset 4866

Timestamp:

02/05/2007 09:29:39 PM (20 years ago)

Author:

ryan

Message:

Disambiguate queries. Props mhyk25. fixes #3747

File:

• trunk/wp-includes/query.php (modified) (2 diffs)

trunk/wp-includes/query.php

@@ -795 +795 @@
                         $out_cats = substr($out_cats, 0, -2);
                         if ( strlen($in_cats) > 0 )
-                                $in_cats = " AND category_id IN ($in_cats)";
+                                $in_cats = " AND $wpdb->post2cat.category_id IN ($in_cats)";
                         if ( strlen($out_cats) > 0 ) {
-                                $ids = $wpdb->get_col("SELECT post_id FROM $wpdb->post2cat WHERE category_id IN ($out_cats)");
+                                $ids = $wpdb->get_col("SELECT post_id FROM $wpdb->post2cat WHERE $wpdb->post2cat.category_id IN ($out_cats)");
                                 if ( is_array($ids) && count($ids > 0) ) {
                                         foreach ( $ids as $id )
@@ -804 +804 @@
                                 }
                                 if ( strlen($out_posts) > 0 )
-                                        $out_cats = " AND ID NOT IN ($out_posts)";
+                                        $out_cats = " AND $wpdb->posts.ID NOT IN ($out_posts)";
                                 else
                                         $out_cats = '';