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

(-)a/installer/data/mysql/updatedatabase.pl (-2 / +1 lines)
Lines 12081-12087 if ( CheckVersion($DBversion) ) { Link Here
12081
     SELECT s.itemnumber, i.itype, b.itemtype FROM
12081
     SELECT s.itemnumber, i.itype, b.itemtype FROM
12082
      ( SELECT DISTINCT itemnumber
12082
      ( SELECT DISTINCT itemnumber
12083
        FROM statistics
12083
        FROM statistics
12084
        WHERE type="return" AND itemtype IS NULL ) s
12084
        WHERE ( type = "return" OR type = "localuse" ) AND itemtype IS NULL ) s
12085
      LEFT JOIN
12085
      LEFT JOIN
12086
      ( SELECT itemnumber,biblionumber, itype
12086
      ( SELECT itemnumber,biblionumber, itype
12087
        FROM items ) i
12087
        FROM items ) i
12088
- 

Return to bug 14598