[Koha] Report Help

[Nicole Engard]

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 <marmak3261 at 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;