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

Timestamp:

02/05/2007 09:29:39 PM (18 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 = '';