Hi everybody,
We are using 16.11.04 Koha version and I need to have a list of all my Lost
documents, so I am running the following report:
SELECT i.itemnumber, b.title, b.author, i.itemcallnumber,
i.barcode, v.lib
FROM items i
LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)
LEFT JOIN authorised_values v ON (i.itemlost=v.authorised_value)
WHERE i.itemlost != 0 AND v.category='LOST'
However this is a little incomplete, because I need also the information
about the *Edition Statement*, *Publisher Name *and the *Date of
Publication *to appear in the results. We use Unimarc and the fields I also
need to show up in the results are:
205 a (Edition Statement)
210 c (Publisher Name)
210 d (Date of Publication).
Can anyone help me with this SQL query?
Many thanks in advance
Vanda
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
