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'