|
Lines 12213-12219
if ( CheckVersion($DBversion) ) {
Link Here
|
| 12213 |
SELECT s.itemnumber, i.itype, b.itemtype FROM |
12213 |
SELECT s.itemnumber, i.itype, b.itemtype FROM |
| 12214 |
( SELECT DISTINCT itemnumber |
12214 |
( SELECT DISTINCT itemnumber |
| 12215 |
FROM statistics |
12215 |
FROM statistics |
| 12216 |
WHERE type="return" AND itemtype IS NULL ) s |
12216 |
WHERE ( type = "return" OR type = "localuse" ) AND itemtype IS NULL ) s |
| 12217 |
LEFT JOIN |
12217 |
LEFT JOIN |
| 12218 |
( SELECT itemnumber,biblionumber, itype |
12218 |
( SELECT itemnumber,biblionumber, itype |
| 12219 |
FROM items ) i |
12219 |
FROM items ) i |
| 12220 |
- |
|
|