[Koha] Report help

[Nicole Engard]

I'm looking for a report that shows items that have holds on them
where there are no other items available at the branch. Available
being checked in and not lost.

I was using this report as a starting point.

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' and i.homebranch=<<Item's
branch|branches>>

Thanks in advance,
Nicole