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