[Koha] SQL Report Update
Cab Vinton
bibliwho at gmail.com
Wed May 22 01:51:05 NZST 2013
* Report edited so that it now works :-)
Non Circulating Items
Developer: Nicole C. Engard, ByWater Solutions
Module: Circulation
Purpose: List items that have never circulated
Status: Complete
SELECT b.title, b.author, i.barcode, i.itemcallnumber
FROM items i
LEFT JOIN biblio b USING (biblionumber)
WHERE i.itemnumber NOT IN (SELECT itemnumber FROM issues WHERE
itemnumber IS NOT NULL)
AND i.itemnumber NOT IN (SELECT itemnumber FROM
old_issues WHERE itemnumber IS NOT NULL)
More information about the Koha
mailing list