[Koha] Interesting report request

[Nicole Engard]

On Mon, Mar 31, 2014 at 11:33 AM, Katelyn Browne <kbrowne at ccpcs.org> wrote:
> SELECT borrowernumber, GROUP_CONCAT(items.itemcallnumber, " ( ",
> biblio.title, ") ") AS booklist
> FROM (SELECT borrowernumber
> FROM statistics
> WHERE date(statistics.datetime) BETWEEN <<Returned between (YYYY-MM-DD)>>
> AND <<and (YYYY-MM-DD)>>
>       AND statistics.type='return'
> GROUP BY borrowernumber) whoreturned
> LEFT JOIN issues USING (borrowernumber)
> LEFT JOIN items USING (itemnumber)
> LEFT JOIN biblio USING (biblionumber)
> WHERE date(issues.date_due) BETWEEN <<Due between (YYYY-MM-DD)>> AND <<and
> (YYYY-MM-DD)>>
> GROUP BY borrowernumber


Thanks!! I'll give it a whirl.