[Koha] Koha report

[Paul A]

At 05:57 AM 11/7/2013 -0500, Leslie A. Markey wrote:
>Hello Koha Community,
>
>Does anyone have a report that gives a list of bib records (by title) that
>have no item records?

Simplistic, but functional:

SELECT biblio.biblionumber AS BibNum, biblio.title AS Title, biblio.author 
AS Author, items.barcode AS Barcode
FROM biblio
RIGHT JOIN biblioitems ON biblio.biblionumber=biblioitems.biblionumber
LEFT JOIN items ON biblio.biblionumber=items.biblionumber
WHERE items.biblionumber IS NULL

Best - Paul

---
Maritime heritage and history, preservation and conservation,
research and education through the written word and the arts.
<http://NavalMarineArchive.com> and <http://UltraMarine.ca>