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