[Koha] Reporting biblios with no items

Beda Szukics beda at kollegium-sarnen.ch
Thu Feb 11 02:20:31 NZDT 2016


Hello

The following report:

SELECT biblio.biblionumber, biblio.title
  FROM biblio
  LEFT JOIN items ON biblio.biblionumber = items.biblionumber
  WHERE items.itemnumber IS NULL

shows all the biblios with no item. Is there a possibility to expand it
so it doesn't show all the _analytic_ records (Sadly those show up too
and I want to have a list with all the records witch have no holding
information at all).

Beda


More information about the Koha mailing list