WordPress.org

Make WordPress Core

Changeset 14808


Ignore:
Timestamp:
05/22/10 23:05:35 (5 years ago)
Author:
ryan
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/wp-admin/upload.php

    r14789 r14808  
    2121        wp_die( __('You are not allowed to scan for lost attachments.') ); 
    2222 
    23     $all_posts = implode( ',', $wpdb->get_col("SELECT ID FROM $wpdb->posts WHERE post_type NOT IN ('attachment', '" . join("', '", get_post_types( array( 'public' => false ) ) ) . "')" ) ); 
    24     $lost = $wpdb->get_col("SELECT ID FROM $wpdb->posts WHERE post_type = 'attachment' AND post_parent > '0' and post_parent NOT IN ($all_posts)"); 
     23    $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 ) ) ) . "') )"); 
    2524     
    2625    $_GET['detached'] = 1; 
Note: See TracChangeset for help on using the changeset viewer.