Thanks, Chris. So, correct to say that a report like the one below would not be affected by patrons deleted via Koha? Checkouts by Item Type SELECT items.itype AS Collection, COUNT( statistics.itemnumber ) AS Count FROM statistics LEFT JOIN items ON (statistics.itemnumber = items.itemnumber) WHERE date(statistics.datetime) between '2009-01-01' and '2009-12-31' AND statistics.type IN ('issue','renew') GROUP BY items.itype (Hmm ... in looking at this, maybe it needs to be revised to take into account deleted items?) Cheers, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH
And this time with an actual useful reply. If you delete them via Koha you will be fine. They end up in the deletedborrowers table which you can query over, using a join or union. If you delete them in the db, then that info is gone.
Statistics will still be in the statistics table but you will no longer be able to find the borrower with your query to get things like categorycode etc.