[Koha] Need reports help

Elaine Bradtke eb at efdss.org
Tue Jun 4 05:39:11 NZST 2013

I have the following report:

SELECT  biblio.biblionumber,biblio.author,biblio.title,biblio.datecreated
FROM items LEFT JOIN biblioitems on
(items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio
on (biblioitems.biblionumber=biblio.biblionumber)   WHERE
items.homebranch='VWML' AND DATE_SUB(CURDATE(),INTERVAL 7 DAY) <=
  ORDER BY biblio.title ASC

But it only returns information if there are item records attached,  what I
really want is a list of everything catalogued.  A lot of our biblios don't
have items attached.
What's the best way to do this?

Elaine Bradtke
Data Wrangler
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

More information about the Koha mailing list