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

(-)a/misc/export_records.pl (-7 / +6 lines)
Lines 104-119 if ( $record_type eq 'bibs' ) { Link Here
104
    if ( $timestamp ) {
104
    if ( $timestamp ) {
105
        push @record_ids, $_->{biblionumber} for @{
105
        push @record_ids, $_->{biblionumber} for @{
106
            $dbh->selectall_arrayref(q| (
106
            $dbh->selectall_arrayref(q| (
107
                SELECT biblionumber
107
                SELECT biblio_metadata.biblionumber
108
                FROM biblioitems
108
                FROM biblio_metadata
109
                  LEFT JOIN items USING(biblionumber)
109
                  LEFT JOIN items USING(biblionumber)
110
                WHERE biblioitems.timestamp >= ?
110
                WHERE biblio_metadata.timestamp >= ?
111
                  OR items.timestamp >= ?
111
                  OR items.timestamp >= ?
112
            ) UNION (
112
            ) UNION (
113
                SELECT biblionumber
113
                SELECT biblio_metadata.biblionumber
114
                FROM biblioitems
114
                FROM biblio_metadata
115
                  LEFT JOIN deleteditems USING(biblionumber)
115
                  LEFT JOIN deleteditems USING(biblionumber)
116
                WHERE biblioitems.timestamp >= ?
116
                WHERE biblio_metadata.timestamp >= ?
117
                  OR deleteditems.timestamp >= ?
117
                  OR deleteditems.timestamp >= ?
118
            ) |, { Slice => {} }, ( $timestamp ) x 4 );
118
            ) |, { Slice => {} }, ( $timestamp ) x 4 );
119
        };
119
        };
120
- 

Return to bug 19730