Changeset 14808 for trunk/wp-admin/upload.php

Timestamp:

05/22/2010 11:05:35 PM (14 years ago)

Author:

ryan

Message:

Use subquery when finding detached objects. Props filosofo. fixes #13496

File:

• trunk/wp-admin/upload.php (modified) (1 diff)

trunk/wp-admin/upload.php

@@ -21 +21 @@
         wp_die( __('You are not allowed to scan for lost attachments.') );
 
-    $all_posts = implode( ',', $wpdb->get_col("SELECT ID FROM $wpdb->posts WHERE post_type NOT IN ('attachment', '" . join("', '", get_post_types( array( 'public' => false ) ) ) . "')" ) );
-    $lost = $wpdb->get_col("SELECT ID FROM $wpdb->posts WHERE post_type = 'attachment' AND post_parent > '0' and post_parent NOT IN ($all_posts)");
+    $lost = $wpdb->get_col("SELECT ID FROM $wpdb->posts WHERE post_type = 'attachment' AND post_parent > '0' and post_parent NOT IN ( SELECT ID FROM $wpdb->posts WHERE post_type NOT IN ('attachment', '" . join("', '", get_post_types( array( 'public' => false ) ) ) . "') )");
     
     $_GET['detached'] = 1;