Thanks a bunch! This appears to work.  I'll post this to the wiki in
your name so that you get credit for the work and so that others can
benefit from this.

Nicole

2011/8/17 Msgr. Marion J. Makarewicz <marmak3...@att.net>:
> SELECT b.title, b.author, b.copyrightdate, i.itemcallnumber,
>
> i.barcode, i.datelastborrowed, i.issues as totalcheckouts,
>
> i.dateaccessioned
>
> FROM items i
>
> LEFT JOIN issues
>
> USING (itemnumber)
>
> LEFT JOIN biblio b
>
> USING (biblionumber)
>
> WHERE i.itemnumber NOT IN (SELECT issues.itemnumber FROM issues) AND
> YEAR(NOW())-YEAR(i.datelastborrowed) > 5
>
> UNION SELECT b.title, b.author, b.copyrightdate, i.itemcallnumber,
>
> i.barcode, i.datelastborrowed, i.issues as totalcheckouts,
>
> i.dateaccessioned
>
> FROM items i
>
> LEFT JOIN issues
>
> USING (itemnumber)
>
> LEFT JOIN biblio b
>
> USING (biblionumber)
>
> WHERE i.itemnumber NOT IN (SELECT old_issues.itemnumber FROM old_issues) AND
> YEAR(NOW())-YEAR(i.datelastborrowed) > 5;
_______________________________________________
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Reply via email to