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

(-)a/installer/data/mysql/updatedatabase.pl (-2 / +1 lines)
Lines 13351-13357 if ( CheckVersion($DBversion) ) { Link Here
13351
     SELECT s.itemnumber, i.itype, b.itemtype FROM
13351
     SELECT s.itemnumber, i.itype, b.itemtype FROM
13352
      ( SELECT DISTINCT itemnumber
13352
      ( SELECT DISTINCT itemnumber
13353
        FROM statistics
13353
        FROM statistics
13354
        WHERE type="return" AND itemtype IS NULL ) s
13354
        WHERE ( type = "return" OR type = "localuse" ) AND itemtype IS NULL ) s
13355
      LEFT JOIN
13355
      LEFT JOIN
13356
      ( SELECT itemnumber,biblionumber, itype
13356
      ( SELECT itemnumber,biblionumber, itype
13357
        FROM items ) i
13357
        FROM items ) i
13358
- 

Return to bug 14598