View | Details | Raw Unified | Return to bug 20485
Collapse All | Expand All

(-)a/misc/export_records.pl (-16 / +25 lines)
Lines 143-163 $timestamp = ($timestamp) ? output_pref({ dt => dt_from_string($timestamp), date Link Here
143
143
144
if ( $record_type eq 'bibs' ) {
144
if ( $record_type eq 'bibs' ) {
145
    if ( $timestamp ) {
145
    if ( $timestamp ) {
146
        push @record_ids, $_->{biblionumber} for @{
146
        if (!$dont_export_items) {
147
            $dbh->selectall_arrayref(q| (
147
            push @record_ids, $_->{biblionumber} for @{
148
                SELECT biblio_metadata.biblionumber
148
                $dbh->selectall_arrayref(q| (
149
                FROM biblio_metadata
149
                    SELECT biblio_metadata.biblionumber
150
                  LEFT JOIN items USING(biblionumber)
150
                    FROM biblio_metadata
151
                WHERE biblio_metadata.timestamp >= ?
151
                      LEFT JOIN items USING(biblionumber)
152
                  OR items.timestamp >= ?
152
                    WHERE biblio_metadata.timestamp >= ?
153
            ) UNION (
153
                      OR items.timestamp >= ?
154
                SELECT biblio_metadata.biblionumber
154
                ) UNION (
155
                FROM biblio_metadata
155
                    SELECT biblio_metadata.biblionumber
156
                  LEFT JOIN deleteditems USING(biblionumber)
156
                    FROM biblio_metadata
157
                WHERE biblio_metadata.timestamp >= ?
157
                      LEFT JOIN deleteditems USING(biblionumber)
158
                  OR deleteditems.timestamp >= ?
158
                    WHERE biblio_metadata.timestamp >= ?
159
            ) |, { Slice => {} }, ( $timestamp ) x 4 );
159
                      OR deleteditems.timestamp >= ?
160
        };
160
                ) |, { Slice => {} }, ( $timestamp ) x 4 );
161
            };
162
        } else {
163
            push @record_ids, $_->{biblionumber} for @{
164
                $dbh->selectall_arrayref(q| (
165
                    SELECT biblio_metadata.biblionumber
166
                    FROM biblio_metadata
167
                    WHERE biblio_metadata.timestamp >= ?
168
                ) |, { Slice => {} }, $timestamp );
169
            };
170
        }
161
    } else {
171
    } else {
162
        my $conditions = {
172
        my $conditions = {
163
            ( $starting_biblionumber or $ending_biblionumber )
173
            ( $starting_biblionumber or $ending_biblionumber )
164
- 

Return to bug 20485