[Koha] New SQL Report - Items Marked Lost/Missing w/ Hold Info

[Cab Vinton]

Developer: Nicole C. Engard, ByWater Solutions
Module: Catalog
Purpose: Finds all items that are marked as lost in some way and shows
if they're on hold.

SELECT i.itemnumber, i.reserves, i.issues, i.datelastseen,
i.dateaccessioned, i.ccode, b.title, b.author, i.itemcallnumber,
i.barcode, v.lib,
IF(h.reservedate IS NULL, '', 'on hold') AS holds
FROM items i
LEFT JOIN biblio b USING (biblionumber)
LEFT JOIN authorised_values v ON (i.itemlost=v.authorised_value)
LEFT JOIN reserves h ON (b.biblionumber=h.biblionumber)
WHERE i.itemlost != 0 AND v.category='LOST'