[Koha] Report: patrons with recent checkouts

Nicole Engard nengard at gmail.com
Sat Dec 7 03:44:39 NZDT 2013


On Thu, Dec 5, 2013 at 9:28 PM, Chad Roseburg <croseburg at ncrl.org> wrote:

> SELECT count( distinct b.borrowernumber )
> FROM borrowers b
> JOIN old_issues i USING (borrowernumber)
> WHERE b.branchcode = 'WENATCH'
> AND i.issuedate > '2012-12-05';
>


Yes, but it won't include people with things currently checked out - those
people are still in the issues table.  So you might want (and this will
slow it down a bit) to query that table too:

SELECT count( distinct b.borrowernumber )
FROM borrowers b
JOIN (select borrowernumber, issuedate from old_issues union all select
borrowernumber, issuedate from issues) i USING (borrowernumber)
WHERE b.branchcode = 'WENATCH'
AND i.issuedate > '2012-12-05';


More information about the Koha mailing list