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

(-)a/installer/data/mysql/updatedatabase.pl (-13 / +23 lines)
Lines 13348-13365 $DBversion = "3.23.00.XXX"; Link Here
13348
if ( CheckVersion($DBversion) ) {
13348
if ( CheckVersion($DBversion) ) {
13349
13349
13350
    $sth = $dbh->prepare(q{
13350
    $sth = $dbh->prepare(q{
13351
     SELECT s.itemnumber, i.itype, b.itemtype FROM
13351
        SELECT s.itemnumber, i.itype, b.itemtype
13352
      ( SELECT DISTINCT itemnumber
13352
        FROM
13353
        FROM statistics
13353
         ( SELECT DISTINCT itemnumber
13354
        WHERE ( type = "return" OR type = "localuse" ) AND itemtype IS NULL ) s
13354
           FROM statistics
13355
      LEFT JOIN
13355
           WHERE ( type = "return" OR type = "localuse" ) AND
13356
      ( SELECT itemnumber,biblionumber, itype
13356
                 itemtype IS NULL
13357
        FROM items ) i
13357
         ) s
13358
      ON (s.itemnumber=i.itemnumber)
13358
        LEFT JOIN
13359
      LEFT JOIN
13359
         ( SELECT itemnumber,biblionumber, itype
13360
      ( SELECT biblionumber, itemtype
13360
             FROM items
13361
        FROM biblioitems ) b
13361
           UNION
13362
      ON (i.biblionumber=b.biblionumber)
13362
           SELECT itemnumber,biblionumber, itype
13363
             FROM deleteditems
13364
         ) i
13365
        ON (s.itemnumber=i.itemnumber)
13366
        LEFT JOIN
13367
         ( SELECT biblionumber, itemtype
13368
             FROM biblioitems
13369
           UNION
13370
           SELECT biblionumber, itemtype
13371
             FROM deletedbiblioitems
13372
         ) b
13373
        ON (i.biblionumber=b.biblionumber);
13363
    });
13374
    });
13364
    $sth->execute();
13375
    $sth->execute();
13365
13376
13366
- 

Return to bug 14598