[Koha] Finding biblios with no items

[James Ghiorzi]

Hi Beda,

Here is a SQL statement (for reports) for obtaining null item types (I think that's what your looking for)  I additionally added barcode to the original SQL to make differing copies easier.

SQL:

SELECT  items.barcode,items.dateaccessioned,items.ccode,items.itemcallnumber,items.itype,biblio.author,biblio.title, biblio.copyrightdate 
FROM items 
LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) 
LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)  
WHERE items.itype IS NULL AND items.homebranch='SB'

You will also have to change the Homebranch Field to what ever Homebranch code you use.  Also if this doesn't work take a look at http://wiki.koha-community.org/wiki/SQL_Reports_Library  thats where all the community developed SQL reports are.

Respectfully,

James Ghiorzi
Library Assistant II
San Benito County Free Library
470 Fifth St.
Hollister, CA 95023
(831) 636-4107

________________________________________
From: koha-bounces at lists.katipo.co.nz [koha-bounces at lists.katipo.co.nz] On Behalf Of Beda Szukics [beda at muri-gries.ch]
Sent: Saturday, January 08, 2011 12:28 AM
To: koha at lists.katipo.co.nz
Subject: [Koha] Finding biblios with no items

Hi

Is there a way to find biblios with _no_ items attached?


Beda

_______________________________________________
Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha