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

(-)a/installer/data/mysql/updatedatabase.pl (-2 / +1 lines)
Lines 11676-11682 if ( CheckVersion($DBversion) ) { Link Here
11676
     SELECT s.itemnumber, i.itype, b.itemtype FROM
11676
     SELECT s.itemnumber, i.itype, b.itemtype FROM
11677
      ( SELECT DISTINCT itemnumber
11677
      ( SELECT DISTINCT itemnumber
11678
        FROM statistics
11678
        FROM statistics
11679
        WHERE type="return" AND itemtype IS NULL ) s
11679
        WHERE ( type = "return" OR type = "localuse" ) AND itemtype IS NULL ) s
11680
      LEFT JOIN
11680
      LEFT JOIN
11681
      ( SELECT itemnumber,biblionumber, itype
11681
      ( SELECT itemnumber,biblionumber, itype
11682
        FROM items ) i
11682
        FROM items ) i
11683
- 

Return to bug 14598