https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11530 --- Comment #8 from Victor Grousset/tuxayo <victor@tuxayo.net> --- Comment on attachment 176300 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=176300 Bug 11530: Add a use-deleted-items option to totalissues.pl Review of attachment 176300: --> (https://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=11530&attachment=176300) ----------------------------------------------------------------- ::: misc/cronjobs/update_totalissues.pl @@ +113,5 @@

sub process_items { + my $query = + $include_deleted + ? "SELECT all_items.biblionumber, SUM(all_items.issues) FROM (SELECT items.biblionumber,items.issues FROM items UNION ALL SELECT deleteditems.biblionumber, deleteditems.issues FROM deleteditems) all_items GROUP BY all_items.biblionumber;" + : "SELECT items.biblionumber, SUM(items.issues) FROM items GROUP BY items.biblionumber;";

Just a quick glance at code when passing by: some formatting of the SQL is needed: https://wiki.koha-community.org/wiki/Coding_Guidelines#SQL9:_SELECT -- You are receiving this mail because: You are watching all bug changes.