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

(-)a/installer/data/mysql/updatedatabase.pl (-13 / +23 lines)
Lines 12210-12227 $DBversion = "3.23.00.XXX"; Link Here
12210
if ( CheckVersion($DBversion) ) {
12210
if ( CheckVersion($DBversion) ) {
12211
12211
12212
    $sth = $dbh->prepare(q{
12212
    $sth = $dbh->prepare(q{
12213
     SELECT s.itemnumber, i.itype, b.itemtype FROM
12213
        SELECT s.itemnumber, i.itype, b.itemtype
12214
      ( SELECT DISTINCT itemnumber
12214
        FROM
12215
        FROM statistics
12215
         ( SELECT DISTINCT itemnumber
12216
        WHERE ( type = "return" OR type = "localuse" ) AND itemtype IS NULL ) s
12216
           FROM statistics
12217
      LEFT JOIN
12217
           WHERE ( type = "return" OR type = "localuse" ) AND
12218
      ( SELECT itemnumber,biblionumber, itype
12218
                 itemtype IS NULL
12219
        FROM items ) i
12219
         ) s
12220
      ON (s.itemnumber=i.itemnumber)
12220
        LEFT JOIN
12221
      LEFT JOIN
12221
         ( SELECT itemnumber,biblionumber, itype
12222
      ( SELECT biblionumber, itemtype
12222
             FROM items
12223
        FROM biblioitems ) b
12223
           UNION
12224
      ON (i.biblionumber=b.biblionumber)
12224
           SELECT itemnumber,biblionumber, itype
12225
             FROM deleteditems
12226
         ) i
12227
        ON (s.itemnumber=i.itemnumber)
12228
        LEFT JOIN
12229
         ( SELECT biblionumber, itemtype
12230
             FROM biblioitems
12231
           UNION
12232
           SELECT biblionumber, itemtype
12233
             FROM deletedbiblioitems
12234
         ) b
12235
        ON (i.biblionumber=b.biblionumber);
12225
    });
12236
    });
12226
    $sth->execute();
12237
    $sth->execute();
12227
12238
12228
- 

Return to bug 14598