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 |
- |
|
|