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

(-)a/installer/data/mysql/updatedatabase.pl (-2 / +1 lines)
Lines 12213-12219 if ( CheckVersion($DBversion) ) { Link Here
12213
     SELECT s.itemnumber, i.itype, b.itemtype FROM
12213
     SELECT s.itemnumber, i.itype, b.itemtype FROM
12214
      ( SELECT DISTINCT itemnumber
12214
      ( SELECT DISTINCT itemnumber
12215
        FROM statistics
12215
        FROM statistics
12216
        WHERE type="return" AND itemtype IS NULL ) s
12216
        WHERE ( type = "return" OR type = "localuse" ) AND itemtype IS NULL ) s
12217
      LEFT JOIN
12217
      LEFT JOIN
12218
      ( SELECT itemnumber,biblionumber, itype
12218
      ( SELECT itemnumber,biblionumber, itype
12219
        FROM items ) i
12219
        FROM items ) i
12220
- 

Return to bug 14598