http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10758
--- Comment #8 from mathieu saby <[email protected]> --- Yes, of course, statistics table keeps the itemnumber. I will take a look. I think stats reports page in staff interface do not JOIN on deleteditems, only on items. I would like C4 subs to return the information "this order is / is not link to a deleted biblio". I am not sure it could be done in 1 SQL request, because if I make a "UNION ALL" between biblio and deletedbiblio, I think the resulting temporary table will just have the same fields as biblio and deletedbiblio, without any information about the deleted status of some biblios. Am I wrong? If not, the solution could be to make 2 or 3 requests (one with "select aqorders left join biblio using biblionumber where biblio.biblionumber is not null", the 2d with "select aqorders left join deletedbiblio using biblionumber where deletedbiblio.biblionumber is not null"). I am not a SQL specialist... So what do you think of it? Maybe we could ask koha-devel? Mathieu -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
