[Koha] Query for report on items catalogue in a date.

Paul paul.a at aandc.org
Wed Aug 28 02:25:59 NZST 2013

At 04:41 AM 8/27/2013 -0700, Akin Adigun \(Akinomatics\) wrote:
>I want the title, author, barcode for all items catalogue in a date or 
>range of date

AS Title, biblio.author AS Author,
items.barcode AS Barcode
FROM items
LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber)
DATE(items.dateaccessioned) BETWEEN <<Accessioned BETWEEN (yyyy-mm-dd)>> 
AND <<and (yyyy-mm-dd)>>;

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>

More information about the Koha mailing list