9 Jan
2012
9 Jan
'12
9:31 p.m.
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@nekls.org 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
