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

Timestamp:

05/19/2009 03:25:43 PM (15 years ago)

Author:

ryan

Message:

Lose broken post_status_join. Exclude revisions from post_type = any queries. Props gortsleigh. fixes #8731

File:

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

trunk/wp-includes/query.php

@@ -1583 +1583 @@
         $groupby = '';
         $fields = "$wpdb->posts.*";
-        $post_status_join = false;
         $page = 1;
 
@@ -1959 +1958 @@
                     $post_type = 'any';
                     $q['post_status'] = 'publish';
-                    $post_status_join = true;
                 } else {
                     $whichcat = " AND 0 ";
@@ -2066 +2064 @@
 
         if ( 'any' == $post_type ) {
-            $where .= '';
+            $where .= " AND $wpdb->posts.post_type != 'revision'";
         } elseif ( $this->is_attachment ) {
             $where .= " AND $wpdb->posts.post_type = 'attachment'";
@@ -2111 +2109 @@
                 else
                     $statuswheres[] = "(" . join( ' OR ', $p_status ) . ")";
-            }
-            if ( $post_status_join ) {
-                $join .= " JOIN $wpdb->posts AS p2 ON ($wpdb->posts.post_parent = p2.ID) ";
-                foreach ( $statuswheres as $index => $statuswhere )
-                    $statuswheres[$index] = "($statuswhere OR ($wpdb->posts.post_status = 'inherit' AND " . str_replace($wpdb->posts, 'p2', $statuswhere) . "))";
             }
             foreach ( $statuswheres as $statuswhere )