marilisaC

private function upgrade_4_3_4() {
    global $wpdb;
 
    //delete wrong duplicated attachments
    $wpdb->query( "DELETE FROM {$wpdb->prefix}icl_translations WHERE `element_id` IN ( SELECT ID FROM {$wpdb->prefix}posts WHERE `guid` LIKE '%attachment_id%' ) " );
    $wpdb->query( "DELETE FROM {$wpdb->prefix}postmeta WHERE `post_id` IN ( SELECT ID FROM {$wpdb->prefix}posts WHERE `guid` LIKE '%attachment_id%' ) " );
    $wpdb->query( "DELETE FROM {$wpdb->prefix}posts WHERE `guid` LIKE '%attachment_id%'" );

private function upgrade_4_3_4() {
        global $wpdb;
  
        $affected_ids = $wpdb->get_col( "SELECT ID FROM {$wpdb->prefix}posts AS p LEFT JOIN {$wpdb->prefix}postmeta AS pm ON p.ID = pm.post_id WHERE p.`guid` LIKE '%attachment_id%' AND pm.meta_key = '_wp_attached_file' AND pm.meta_value = ''" );
        $affected_ids = join( ',', $affected_ids );
        //delete wrong duplicated attachments
        $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->prefix}icl_translations WHERE `element_id` IN ( %s )", $affected_ids ) );
        $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->prefix}postmeta WHERE `post_id` IN ( %s ) " , $affected_ids ) );
        $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->prefix}posts WHERE `ID` IN ( %s ) ", $affected_ids ) ) ;
  
    }