[Koha-devel] Active borrowers report
Liz Rea
lrea at nekls.org
Mon Jan 9 22:31:24 CET 2012
And you know what, that one isn't in the report library so I added it for you. :)
You can see it here:
http://wiki.koha-community.org/wiki/SQL_Reports_Library#Active_Patrons
Thanks!
Liz Rea
lrea at nekls.org
-------------- next part --------------
A non-text attachment was scrubbed...
Name: email_signature.jpeg
Type: image/jpeg
Size: 4862 bytes
Desc: not available
URL: </pipermail/koha-devel/attachments/20120109/0dbbb98c/attachment.jpeg>
-------------- next part --------------
On Jan 9, 2012, at 2:36 PM, Mike Hafen wrote:
> SELECT YEAR(issuedate), MONTH(issuedate), categorycode, COUNT(DISTINCT borrowernumber)
> FROM (
> SELECT issuedate, borrowernumber FROM old_issues
> UNION ALL
> SELECT issuedate, borrowernumber FROM issues
> ) AS all_issues
> LEFT JOIN borrowers USING (borrowernumber)
> GROUP BY YEAR(issuedate), MONTH(issuedate), categorycode
More information about the Koha-devel
mailing list